Article - CS142974
Error "ORA-06502: PL/SQL: numeric or value error: character string buffer too small" when publishing ECN
Modified: 27-Jul-2018
Applies To
- Windchill Enterprise Systems Integration 9.1 to 11.1
Description
- Error *PL/SQL: numeric or value error: character string buffer too small* when publishing ECN
- Debug log files not found at specified file path location
- The error log snippet from TIBCO Process Archive log:
YYYY MON DD hh:mm:ss:xxx ZZZ -0400 BW.Oracle_Apps-Process_Archive ESI [BW-User] - ,23,IMO:IMO,4,2,3,51121,
successfully received reply message from Oracle for change part,0000000XXX,,-1,,,
YYYY MON DD hh:mm:ss:xxx ZZZ -0400 BW.Oracle_Apps-Process_Archive ESI [BW-User] - ,23,CONMEDORADEV, IMO:IMO,5,2,0,01100,
validation of data failed while publishing a Part to Oracle,0000000XXX,,,,
java.sql.SQLException:[tibcosoftwareinc][Oracle JDBC Driver][Oracle]ORA-06502: PL/SQL: numeric or value error: character string buffer too small
ORA-06512: at "APPS.PK_TIB_OPENITEM_IMPORT", line 3854
ORA-20001: Oracle error -20001: ORA-20001: Oracle error -2074: ORA-02074: cannot SET NLS in a distributed transaction
has been detected in fnd_global.set_nls.set_parameter('NLS_LANGUAGE','AMERICAN').
has been detected in fnd_global.set_nls.
ORA-06512: at "APPS.PK_TIB_OPENITEM_IMPORT", line 4248
ORA-06512: at line 1
This is a printer-friendly version of Article 142974 and may be out of date. For the latest version click CS142974