error in adapter engine
Its a support issue.There is a MDM(file) to ORACLE(jdbc) scenario where i find error in adapter engine(audit log).
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.
Chirumamilla Sukarna replied
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...