Error: Could not insert message (INBOUND) into database in JDBC scenario

[Former Member]

Hello Experts,

We have implemented an IDoc- JDBC scenario on PI 7.1.On sending an IDoc DEBMAS it gives the following error in SXMB_moni of PI.

com.sap.engine.interfaces.messaging.api.exception.MessagingException: Could not insert message 167088e0-92c5-11de-c968-36d2afd1680e(INBOUND) into database. Reason: java.sql.SQLException: ORA-00904: "DSR_PASSPORT": invalid identifier

Kindly advice.

Thanks in advance,

Elizabeth.

[Former Member]

Thanks All, This helped.

[Former Member]

if you have add that filed into the database then stop and start the channel from the RWB

If you like to see how PI runtime trying to insert the data use the below option in Advance mode of receiver JDBC adapter

logSQLstatement true

then you can see the query formed in PI ...

the saem query will be executed in JDBC database...

HTH

Rajesh

[Shabarish_Nair]

>

> Hello Experts,
> 
> We have implemented an IDoc- JDBC scenario on PI 7.1.On sending an IDoc DEBMAS it gives the following error in SXMB_moni of PI.
> 
> com.sap.engine.interfaces.messaging.api.exception.MessagingException: Could not insert message 167088e0-92c5-11de-c968-36d2afd1680e(INBOUND) into database. Reason: java.sql.SQLException: ORA-00904: "DSR_PASSPORT": invalid identifier
> 
> Kindly advice.
> 
> Thanks in advance,
> Elizabeth.

please check if DSR_PASSPORT is a valid field in the table or is it missing .

Description of ORA-00904 error;

ORA-00904: string: invalid identifier

Cause: The column name entered is either missing or invalid.

Action: Enter a valid column name. A valid column name must begin with a letter, be less than or equal to 30 characters, and consist of only alphanumeric characters and the special characters $, _, and #. If it contains other characters, then it must be enclosed in double quotation marks. It may not be a reserved word.