AIA MDM Product: Catalog Publication from PIM via ODI throws error: ORA-31011: XML parsing failed ... LPX-00216: Invalid Character 253 (0xfd)..." (Doc ID 1388994.1)

Last updated on OCTOBER 04, 2016

Applies to:

Oracle Product Master Data Management Integration Base Pack - Version 11.1 and later
Information in this document applies to any platform.

Symptoms

Publication Product data (a User Defined Attribute = UDA) out of Product Information Management (PIM) of Oracle Product Hub 11.1, using the ODI job, started via PIM Web Service "PIMWebServices-ICC/ItemCatalogServiceSoapHttpPort" returned following error:

ODI session id = 105510
ODI Error Message = Agent didn't execute this command:
No ODI Output XML found!
End of Generating payload for session id = 2504
javax.xml.bind.JAXBException: unexpected error in Unmarshalling.

 
The ODI log (10.1.3.5 version used for this PIM release) delivered following error traces:

... PM(DwgCmdExecutionThread): SnpsQuery.updateExecStatement : prepare request :
insert into EGO.EGO_PUB_WS_FLAT_RECS ( SESSION_ID, ODI_SESSION_ID, ENTITY_TYPE, SEQUENCE_ID, PARENT_SEQUENCE_ID, PK1_VALUE, REF1_VALUE, REF2_VALUE,
VALUE, CREATION_DATE )
  select 2525, 146510, 'ValuesetValue', EGO_PUB_WS_FLAT_RECS_S.NEXTVAL, EGO_PUB_WS_FLAT_RECS.SEQUENCE_ID,
EGO_VALUE_SET_VALUES_V.FLEX_VALUE_ID, EGO_VALUE_SET_VALUES_V.VALUE_SET_ID, EGO_VALUE_SET_VALUES_V.VALIDATION_TYPE,
XMLForest( EGO_VALUE_SET_VALUES_V.VALUE_SET_ID,
EGO_VALUE_SET_VALUES_V.VALUE_SET_NAME, EGO_VALUE_SET_VALUES_V.FLEX_VALUE_ID, EGO_VALUE_SET_VALUES_V.SEQUENCE, EGO_VALUE_SET_VALUES_V.INTERNAL_NAME,
EGO_VALUE_SET_VALUES_V.ENABLED_CODE, TO_CHAR(EGO_VALUE_SET_VALUES_V.START_DATE,'yyyy-mm-dd HH:MI:SS') START_DATE, TO_CHAR(EGO_VALUE_SET_VALUES_V.END_DATE,'yyyy-mm-dd HH:MI:SS')
END_DATE ).getclobval(), SYSDATE from EGO.EGO_PUB_WS_FLAT_RECS EGO_PUB_WS_FLAT_RECS, APPS.EGO_VALUE_SET_VALUES_V EGO_VALUE_SET_VALUES_V where
(1=1) And (EGO_VALUE_SET_VALUES_V.VALUE_SET_ID=EGO_PUB_WS_FLAT_RECS.PK1_VALUE) And (EGO_PUB_WS_FLAT_RECS.SESSION_ID = 2525 AND EGO_PUB_WS_FLAT_RECS.ODI_SESSION_ID = 146510 AND
EGO_PUB_WS_FLAT_RECS.ENTITY_TYPE = 'Valueset' AND EGO_PUB_WS_FLAT_RECS.REF1_VALUE = 'UDA')

1... PM(DwgCmdExecutionThread): SnpSessTask.treatSqlException : 31011 : 99999 : java.sql.SQLException: ORA-31011: XML parsing failed
ORA-19202: Error occurred in XML processing
LPX-00216: invalid character 253 (0xFD)
Error at line 1
ORA-06512: at "SYS.XMLTYPE", line 138

java.sql.SQLException: ORA-31011: XML parsing failed
ORA-19202: Error occurred in XML processing
LPX-00216: invalid character 253 (0xFD)
Error at line 1
ORA-06512: at "SYS.XMLTYPE", line 138

at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:125) ...



Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms