Error in Converting EDIFACT to XML using B2B add-On in 7.31

[mateen_popatia]

Hi Experts,

Our EDIFACT UNH details is - UNH+K02305+PHBEST:2::PH

We are getting below error while trying to convert EDIFACT into XML message in integrationCockpit.

java.lang.RuntimeException: Error in conversion of PHBEST/-Edifact-Document at character 327 to XML: java.lang.UnsupportedOperationException: Check for ruleset for PHBEST/ failed: Failed to set the parameter 3 of the statement >>SELECT COUNT(*) FROM B2B_EDI_CTRL_MSG WHERE CTRL_KEY = ? AND MESSAGETYPE = ? AND MESSAGEVERSION = ?<<: Cannot assign an empty string to a parameter with JDBC type >>VARCHAR<<.

Please suggest.

[Dimitri · Accepted solution]

Hi Mateen,

SAP ships content with the B2B add-on. Did you load that content into the tables of the Intregration Cockpit -> EDI content manager?

Seems that the system does not know your message type and version

Kind regards

Dimitri

[marksmyth]

Hello Mateen,

Is this part of an ICO scenario? Check the note 1741722 MessagingException:OpenSQLException when sending message. Try making a dummy change in the Directory to reactivate the object.

Regards

Mark