Error in JDBC Receiver Adapter

[Former Member]

Hi Experts,

I got this error while doing a IDOC to JDBC scenario.

The error message as follows

Message processing failed. Cause: com.sap.engine.interfaces.messaging.api.exception.MessagingException: Error processing request in sax parser: Error when executing statement for table/stored proc. 'DBTAAG20' (structure 'TABLE'): com.ibm.db2.jcc.b.eo: DB2 SQL Error: SQLCODE=-204, SQLSTATE=42704, SQLERRMC=AG20DBT1.DBTAAG20, DRIVER=3.53.95

IDOC is going to DB2

table name is DBTVAG20.WOS

For database connection

Will appreciate your guide on which area should i check on this error.

Rgds

FNG

[former_member207622 · Accepted solution]

Hi Freddy

It seems problem with your receiver jdbc structure in mapping . please check these discussions

http://www.riyaz.net/blog/jdbc-adapter-configuration/technology/1200/

regards

Ninad

[Former Member]

Hi Guys,

Thanks for the advice.

I have managed to resolve the issue. There is some mapping to the target table structure.

[Former Member]

Hi Freddy,

The error points that DBTVAG20.WOS is not pointed. It is pointing to DB2. Please check this in the mapping level.

Thanks,

[Former Member]

Hi,

Error when executing statement for table/stored proc. 'DBTAAG20' (structure 'TABLE'):

DBTVAG20.WOS

Error indicates your table name is different. Check the table name in mapping leavel.

Regards,

Prakasu.M

[Former Member]

Hi

some addtional information to the DB2

The db2 is divided into 4 qualifiers,

each qualifier represent a instance.

DBTVAG20 as test region (T region)

DBUVAG20 as development region (U region)

DBSVAG20 as QA region (S region)

DBPVAG20 as Production (P region)

That mean the table name for eg. WOS will be DBTVAG20.WOS

I have defined a contant DBTVAG20.WOS to the dbtableName.