PostRTC throws ORA-01400: cannot insert NULL into ;table; (agent hang).
Article ID: KB0089374
Updated On:
| Products | Versions |
|---|---|
| TIBCO BusinessEvents Enterprise Edition | - |
| Not Applicable | - |
Description
Description:
PostRTC throws ORA-01400: cannot insert NULL into <table> (agent hang).
Symptoms:
PostRTC reports errors. The SQL will be executed in a endless loop and the agent hang.
<timestamp> <agentname> Warning [inference-class$DBWriter.Thread.<threadnum>] - [jdbcstore] SaveTransaction failed - nested error. Error=ORA-01400: cannot insert NULL into ("<beuser>"."<tablename>"."ID$")
Cause:
CR BE-18846, error occurs when you try to assign a null concept as child array to a parent
Example:
parent.childs[i] = null
PostRTC throws ORA-01400: cannot insert NULL into <table> (agent hang).
Symptoms:
PostRTC reports errors. The SQL will be executed in a endless loop and the agent hang.
<timestamp> <agentname> Warning [inference-class$DBWriter.Thread.<threadnum>] - [jdbcstore] SaveTransaction failed - nested error. Error=ORA-01400: cannot insert NULL into ("<beuser>"."<tablename>"."ID$")
Cause:
CR BE-18846, error occurs when you try to assign a null concept as child array to a parent
Example:
parent.childs[i] = null
Issue/Introduction
PostRTC throws ORA-01400: cannot insert NULL into ;table; (agent hang).
Resolution
Before assign a child to a parent (in XSLT mapper too), validate if the parent is null.
Example:
if (child !=null)
parent.childs[i] = child;
else
System.debugOut("Child is empty - not added to parent");
Example:
if (child !=null)
parent.childs[i] = child;
else
System.debugOut("Child is empty - not added to parent");
Feedback
Yes
No
Powered by
