Troubleshooting
Problem
OCI-21500 errors are Oracle internal errors and can occur for many reasons, some known and some as yet unknown. This particular one occurred under the following conditions. Jobs utilising the Oracle Connector with a reject link attempt to insert a row with a clob that should reject due to Foreign Key constraint not met, abort with OCI-21500: internal error code. Check the symptoms to see if ths particular OCI-21500 internal error corresponds to the failure you are seeing..
Symptom
Jobs utilising the Oracle Connector with a reject link - Attempts to insert a row with a clob that should reject due to Foreign Key constraint not met, abort with OCI-21500: internal error code, arguments: [17112], [0x000B0DEB8], [],[], [], [], [], []
Cause
The issue was reported to Oracle with a reproducible test case, Oracle reproduced and assigned bug id 13636295
If you have an oracle support account you can view details at
https://support.oracle.com/CSP/main/article?cmd=show&type=BUG&id=13636295&productFamily=Oracle
Environment
Oracle 11.2.0.2 and 11.2.0.3
Diagnosing The Problem
In addition to the error message a stack trace taken from a core file generated at this time shows
gdb $APT_ORCHHOME/bin/osh core.11888
(gdb) bt
#0 0x00002b38b3c23cad in raise () from /lib64/libpthread.so.0
#1 0x00002aaaac7d56b2 in skgesigOSCrash () from
/u01/app/oracle/product/11.2.0.2/ic_1/libclntsh.so.10.1
#2 0x00002aaaaca73705 in kpeDbgSignalHandler () from
/u01/app/oracle/product/11.2.0.2/ic_1/libclntsh.so.10.1
#3 0x00002aaaac7d58c2 in skgesig_sigactionHandler () from
/u01/app/oracle/product/11.2.0.2/ic_1/libclntsh.so.10.1
#4 <signal handler called>
#5 0x00002aaaacceb873 in kpuhhfre () from
/u01/app/oracle/product/11.2.0.2/ic_1/libclntsh.so.10.1
#6 0x00002aaaaccff5cb in kpuexec () from
/u01/app/oracle/product/11.2.0.2/ic_1/libclntsh.so.10.1
#7 0x00002aaaaccfdb45 in OCIStmtExecute () from
/u01/app/oracle/product/11.2.0.2/ic_1/libclntsh.so.10.1
#8 0x00002aaaaaba40e6 in CC_OraOCIWrapper::OraOCIStmtExecute(OCISvcCtx*,
OCIStmt*, OCIError*, unsigned int, unsigned int, OCISnapshot const*,
OCISnapshot*, unsigned int) () from
/u01/IBM/InformationServer/Server/DSComponents/bin/libccora10g.so
#9 0x00002aaaaab27062 in CC_OraStatement::executeInsert(int) () from
/u01/IBM/InformationServer/Server/DSComponents/bin/libccora10g.so
#10 0x00002aaaaab27b6d in CC_OraStatement::execute(int) () from
/u01/IBM/InformationServer/Server/DSComponents/bin/libccora10g.so
#11 0x00002aaaaab3d3dc in CC_OraRecordDataSetConsumer::execute() () from
/u01/IBM/InformationServer/Server/DSComponents/bin/libccora10g.so
#12 0x00002aaaaab3d6d0 in
CC_OraRecordDataSetConsumer::processOneTopLevelDataItem(int) ()
from /u01/IBM/InformationServer/Server/DSComponents/bin/libccora10g.so
#13 0x00002aaaaab3c55d in
CC_RecordDataSetConsumer::consumeOneTopLevelDataItem() () from
/u01/IBM/InformationServer/Server/DSComponents/bin/libccora10g.so
#14 0x00002aaaaab2941b in
CC_DataSetConsumer_consumeOneTopLevelDataItem(_CC_DATASETCONSUMER*,
int*) ()
from /u01/IBM/InformationServer/Server/DSComponents/bin/libccora10g.so
#15 0x00002b38b68491dd in
CC_DataSetConsumer::consumeOneTopLevelDataItem() () from
/u01/IBM/InformationServer/Server/PXEngine/lib/libfcl.so
#16 0x00002b38b6864358 in
CC_DataSetHandler::processOneTopLevelDataItem() () from
/u01/IBM/InformationServer/Server/PXEngine/lib/libfcl.so
#17 0x00002b38b65a6d34 in PXBridgeOp::doTarget() () from
/u01/IBM/InformationServer/Server/PXEngine/lib/pxbridge.so
#18 0x00002b38b65ae0ff in PXBridgeOp::runLocally() () from
/u01/IBM/InformationServer/Server/PXEngine/lib/pxbridge.so
#19 0x00002b38b31a1068 in APT_OperatorRep::run() () from
/u01/IBM/InformationServer/Server/PXEngine/lib/liborchx86_64.so
#20 0x00002b38b352dfab in APT_SC::Operator::runLocally(unsigned int) ()
from /u01/IBM/InformationServer/Server/PXEngine/lib/liborchx86_64.so
#21 0x00002b38b34eb13b in
APT_ProcessManager::executePlayer(APT_ScoreProcess*) () from
/u01/IBM/InformationServer/Server/PXEngine/lib/liborchx86_64.so
#22 0x00002b38b34e9706 in executeStep(APT_PMMessageHeader const*) ()
from /u01/IBM/InformationServer/Server/PXEngine/lib/liborchx86_64.so
#23 0x00002b38b34b2881 in
APT_PMcontrolServiceTableClass::dispatch(APT_PMMessageHeader const*)
const ()
from /u01/IBM/InformationServer/Server/PXEngine/lib/liborchx86_64.so
#24 0x00002b38b34c0b29 in APT_PMMessagePort::dispatch() () from
/u01/IBM/InformationServer/Server/PXEngine/lib/liborchx86_64.so
#25 0x00002b38b34c1d8e in APT_PMMessagePort::poll(double) () from
/u01/IBM/InformationServer/Server/PXEngine/lib/liborchx86_64.so
#26 0x00002b38b34c2cb8 in APT_PMdispatchLoop() () from
/u01/IBM/InformationServer/Server/PXEngine/lib/liborchx86_64.so
#27 0x00002b38b34e67da in APT_ProcessManager::playerMain(void*) () from
/u01/IBM/InformationServer/Server/PXEngine/lib/liborchx86_64.so
#28 0x00002b38b34d4224 in APT_PMPlayer::APT_PMPlayer(void (*)(void*),
void*) () from
/u01/IBM/InformationServer/Server/PXEngine/lib/liborchx86_64.so
#29 0x00002b38b34e559b in startPlayerSvc(APT_PMMessageHeader const*) ()
from /u01/IBM/InformationServer/Server/PXEngine/lib/liborchx86_64.so
#30 0x00002b38b34b2881 in
APT_PMcontrolServiceTableClass::dispatch(APT_PMMessageHeader const*)
const ()
from /u01/IBM/InformationServer/Server/PXEngine/lib/liborchx86_64.so
#31 0x00002b38b34c0b29 in APT_PMMessagePort::dispatch() () from
/u01/IBM/InformationServer/Server/PXEngine/lib/liborchx86_64.so
#32 0x00002b38b34c1d8e in APT_PMMessagePort::poll(double) () from
/u01/IBM/InformationServer/Server/PXEngine/lib/liborchx86_64.so
#33 0x00002b38b34c2cb8 in APT_PMdispatchLoop() () from
/u01/IBM/InformationServer/Server/PXEngine/lib/liborchx86_64.so
#34 0x00002b38b34ed5a2 in APT_PMsectionLeaderMain() () from
/u01/IBM/InformationServer/Server/PXEngine/lib/liborchx86_64.so
#35 0x00002b38b34e302a in APT_SharedMain(int, char**, int (*)(int,
char**)) () from
/u01/IBM/InformationServer/Server/PXEngine/lib/liborchx86_64.so
#36 0x00002b38b47ca304 in __libc_start_main () from /lib64/libc.so.6
#37 0x0000000000404df9 in ?? ()
#38 0x00007fff22751ea8 in ?? ()
#39 0x0000000000000000 in ?? ()
Resolving The Problem
Please contact Oracle Support to acquire fix for Oracle bug id 13636295
[{"Product":{"code":"SSVSEF","label":"IBM InfoSphere DataStage"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"Not Applicable","Platform":[{"code":"PF010","label":"HP-UX"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"},{"code":"PF002","label":"AIX"}],"Version":"9.1;8.5;11.5;11.3","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Was this topic helpful?
Document Information
Modified date:
16 June 2018
UID
swg21586244