Error while updating table XI_AF_SVC_ID_MAP

[former_member592638]

Hello Experts,

In a JDBC to SucessFactor scenario, we are getting below error.

com.sap.aii.af.lib.util.UtilException: Failed to set the parameter 2 of the statement >>INSERT INTO XI_AF_SVC_ID_MAP (MSG_ID1, MSG_ID2, PERSIST_UNTIL, DUP_CNT) VALUES (?, ?, ?, ?)<<: Cannot assign a >>java.lang.String<< object of length 235 to a parameter with JDBC type >>VARCHAR(127)<<.

It is updating the data in SF and this error seems to be generated while updating table XI_AF_SVC_ID_MAP which resides in Java stack.

Could you help with issue and explain, how this table gets updated. If there is a way to change length MSG_ID2 to less than 127?

[apu_das2]

Hi Hemant,

You are trying to put a string of length 235 in the field MSG_ID2 whereas this field support max length of 127 characters.

Thanks,

Apu

[former_member592638]

yes, i got that but how do i control that? I don't know, how this table gets updated and what values it is using while inserting in the table.