DB Outbound Protocol : Need help to format my Sql Insert req

[Ga]

Hi,

I want tu use ‘Database Outbound’ Protocol to save inbound ADT messages in our QDXLOG Table Schema in ‘chmdw’ Database.

I use a xlate to translate and send values from Inbound ADT HL7 msg thru Outbound QDXLOG Table Schema.

My Oracle Sql  request is functionnal if I push values directly inside my insert.

But when I tried to pass in Outbound parameters from QDXLOG table, I receive that error msg :

Running DB Write action failed.

Mar 28, 2014 1:37:50 PM com.lawson.cloverleaf.dbprotocol.CDBUtils execSQLStatementForDbWrite

SEVERE: ORA-01400: cannot insert NULL into (“DEVEAI”.”QDXLOG”.”QDXNOM”)

No documentation about that in Cloverleaf 6.0, so, I need help to format my Sql Insert request. If it is possible, to give to me an example of how to format

my Sql request (the exact syntax please).

For example, if I want to put inside of QDXLOG.QDXNOM field the value from the xlate field , how can I do it ?

In my inbound HL7 message, the value to send is ‘ADT’.

Thanks in advance.

My Sql Insert request in Database Outbound Protocol Properties is :

INSERT INTO QDXLOG

(QDXLOG.QDXLOGID, QDXLOG.QDXLOGDHRE, QDXLOG.ISEPURE, QDXLOG.QDXNOM, QDXLOG.PROVENANCE, QDXLOG.DESTINATION, QDXLOG.SITE,

QDXLOG.DOSSIER, QDXLOG.VISITE, QDXLOG.SERVICE, QDXLOG.CODEDETX, QDXLOG.CODEDETXHL7, QDXLOG.MESSAGE, QDXLOG.MESSAGEID)

VALUES (QDXLOGID.nextval, sysdate, ‘1’, , ‘1’, ‘1’,  ‘1’,  ‘1’,  ‘1’,  ‘1’, ‘1’,  ‘1’,  ‘1’, null)

Topic

[Rob Abbott]

Some suggestions –

Increase engine output to see the debug output

Put single quotes around if the value is VARCHAR

Double-check what is coming out of translation to make sure the field is populated with data ‘ADT’ — the error message says you’re trying to insert a null value in that column

Open a case with support for assistance

Rob Abbott
Cloverleaf Emeritus

[Ga]

Hi Rob,

I did what you suggest and nothing change.

My xlate is good beacuse i have tested it with Testing tool. I think the reason of my problem is because Cloverleaf don’t pass the value from xlate to my Oracle Sql request ‘Values parameter’. I will open a case for assistance as you said.

Thanks

Here my xlate test result :

Please Wait ……

Command Issued: hcixlttest -n -a  -e windows-1252 -d 2 -f eof AdtLCSic2Database_A28_A29_A31.xlt /opt/qdx6.0/cis6.0/integrator/site_adt_d/exec/processes/process1_adt/A31ADTBendossrdat

Command output:

MESSAGE 1

  QDXLOG^QDXLOGID: nm ><

QDXLOG^QDXLOGDHRE: ch ><

   QDXLOG^ISEPURE: ch >N<

    QDXLOG^QDXNOM: ch >ADT<

QDXLOG^PROVENANCE: ch >Syst

[Author]

Replies