call adapter error

[shabbir_mohmad]

Hi ,

I am getting below error in SXMB_MONI.

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

- <!--

 Call Adapter 

-->

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

<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 00505691-7d1b-1ee5-9caf-d94415ffcfd0(INBOUND) into database. Reason: com.sap.sql.exception.OpenSQLException: ORA-01400: cannot insert NULL into ("SAPPIADB"."BC_MSG"."VERS_NBR") OpenSQLExceptionCategories: []</SAP:AdditionalText>

<SAP:Stack />

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

</SAP:Error>

This is happening for all scenario messages not to specific scenario. please put your thoughts.

Regards,

SPMD

[shabbir_mohmad · Accepted solution]

Hi ,

Problem is resolved.

DBA guys did something called 'table re org'. procedure and now everything looks fine.

Regards,

Shabbir.

[iaki_vila]

Hi Sp,

Go to the DB schema and check if the VERS_NBR field on BC_MSG table accepts null value. The problem could be in the DB itself, and the field could be defined like NOT NULL.

Regards.

[shabbir_mohmad]

Hi Vila,

Thanks for the response.

I have checked for ORA-01400 error, which also shows this could be issue while inserting null value.

But this is not specific to any interface and for some of the failed messages, I have checked for the payload which seems valid.

Note: There are some other messages (SOAP) which are processed successfully at same time.

What this is actually trying to insert into BC_MSG

What is the use of field VERS_NBR

If it doesn't accept the null value, then how do I fix this issue.

Regards,

SP

[former_member186851]

Hello Sp,

Your trying insert in SAP Hana DB?

Its not able to insert null values.

[shabbir_mohmad]

Hi Raghuraman,

It is a ORACLE DB with release 11.2.0.4.0