Error while sending message.

[former_member201987]

Hello Experts,

We are sending a message to third party through JDBC adapter type.

But are facing the below mentioned error as seen in sxmb_moni.

<?xml version="1.0" encoding="UTF-8" standalone="yes" ?>

- <!-- Call Adapter -->

- <SAP:Error xmlns:SAP="http://sap.com/xi/XI/Message/30" xmlns:SOAP="http://schemas.xmlsoap.org/soap/envelope/" SOAP:mustUnderstand="1">

<SAP:Category>XIAdapterFramework</SAP:Category>

<SAP:Code area="MESSAGE">GENERAL</SAP:Code>

<SAP:P1 />

<SAP:P2 />

<SAP:P3 />

<SAP:P4 />

<SAP:AdditionalText>com.sap.engine.interfaces.messaging.api.exception.MessagingException: Could not insert message e8895c10-90b5-11de-ba53-36d2afd1680e(INBOUND) into database. Reason: java.sql.SQLException: ORA-00904: "DSR_PASSPORT": invalid identifier</SAP:AdditionalText>

<SAP:Stack />

<SAP:Retry>M</SAP:Retry>

</SAP:Error>

Please help!

Thanks in advance,

~Suraj

[Former Member]

Hi Suraj,

You tried to execute an SQL statement that included an invalid column name or the column name is missing, thts why its throwing ORA-00904: (invalid column name) error....chk "DSR_PASSPORT" column name.

The options to resolve this Oracle error are:

Rewrite your SQL to include a valid column name. To be a valid column name the following criteria must be met:

The column name must begin with a letter.

The column name can not be longer than 30 characters.

The column name must be made up of alphanumeric characters or the following special characters: $, _, and #. If the column name uses any other characters, it must be enclosed in double quotation marks.

The column name can not be a reserved word.

Hope this help u...

Regds,

Pinangshuk.

[Former Member]

Hi,

your data inside ORA-00904:

for tag DSR_PASSPORT is invalid.

Check your payload and match with valid one.

Regards,

Sumit Gupta

[Shabarish_Nair]

this is usually due to an invalid or missing column name - http://ora-00904.ora-code.com/

DSR_PASSPORT

is this a valid field?