cancel
Showing results for 
Search instead for 
Did you mean: 

error in adapter engine

Former Member
0 Kudos

Hi Friends,

Its a support issue.There is a MDM(file) to ORACLE(jdbc) scenario where i find error in adapter engine(audit log).

Error-->

unable to execute statement for table or stored procedure 'VALUE_MAPPING'(structure 'statement')due to java.sql.SQL Exception

JDBC message processing failed;reason Error processing request in sax parser: Error when executing statement for table/stored proc. "value_mapping"(structure 'statement').

MP: Exception caught with cause com.sap.aii.af.ra.ms.api.RecoverableException:Error processing request in sax parser

-


Plz help me how to troubeshoot the issue.

thanks,

Suresh

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

check the source value in the payload that is given to the value mapping and find the target value for the in value mapping table. may be there is a problem with that...if not.. then check the value mapping details given in IR match to ID or not...

Answers (2)

Answers (2)

former_member187563
Contributor
0 Kudos

hi,

there is some problem in your query.you might not have mapped the correct query to your target side or if you have included query in your jdbc adapter that might be probelamatic.

you can check that

regards,

ujjwal kumar

Former Member
0 Kudos