| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| String data, right truncated error but DB insert succes |
« View previous topic :: View next topic » |
| Author |
Message
|
| Cody18 |
 Posted: Wed Aug 17, 2016 7:24 pm Post subject: String data, right truncated error but DB insert succes |
 |
|
Newbie
Joined: 08 Sep 2015
Posts: 9
|
Hi All,
When executing one of our flows, that involve inserting values into a Database, We notice this error in the logs -
| Code: |
<exceptionList>
<RecoverableException File="/build/slot1/S000_P/src/DataFlowEngine/MessageServices/ImbDataFlowNode.cpp"
Line="1239"
Function="ImbDataFlowNode::createExceptionList"
Type="ComIbmComputeNode"
Name="ReceivePaperForm_receivePaperForm#FCMComposite_1_23"
Label="ReceivePaperForm_receivePaperForm.StoreMedicalConditionsToDB"
Catalog="BIPmsgs"
Severity="3"
Number="2230"
Text="Node throwing exception">
<Insert Type="14" Text="ReceivePaperForm_receivePaperForm.StoreMedicalConditionsToDB"></Insert>
<RecoverableException File="/build/slot1/S000_P/src/DataFlowEngine/ImbRdl/ImbRdlStatementGroup.cpp"
Line="770"
Function="SqlStatementGroup::execute"
Type=""
Name=""
Label=""
Catalog="BIPmsgs"
Severity="3"
Number="2488"
Text="Error detected, rethrowing">
<Insert Type="5" Text=".StoreMedicalConditionsToMedicalDB_Compute.Main"></Insert>
<Insert Type="5" Text="24.5"></Insert>
<Insert Type="5" Text="insertAssmtResCondSql VALUES(Environment.Variables.assessmentResID, Code, Description, CURRENT_TIMESTAMP);">
</Insert>
<DatabaseException File="/build/slot1/S000_P/src/DataFlowEngine/MessageServices/ImbOdbc.cpp"
Line="3563"
Function="ImbOdbcStatement::checkRcInner"
Type=""
Name=""
Label=""
Catalog="BIPmsgs"
Severity="3"
Number="2321"
Text="Root SQL exception">
<Insert Type="2" Text="-1"></Insert>
<Insert Type="14" Text="/opt/ibm/mqsi/iib-10.0.0.1/ie02/lib/libodbcinterface.so"></Insert>
<DatabaseException File="/build/slot1/S000_P/src/DataFlowEngine/MessageServices/ImbOdbc.cpp"
Line="3772"
Function="ImbOdbcStatement::checkRcInner"
Type=""
Name=""
Label=""
Catalog="BIPmsgs"
Severity="3"
Number="2322"
Text="Child SQL exception">
<Insert Type="5" Text="22001"></Insert>
<Insert Type="2" Text="0"></Insert>
<Insert Type="5" Text="[IBM][ODBC Oracle Wire Protocol driver]String data, right truncated. Error in parameter 2.">
</Insert>
</DatabaseException>
</DatabaseException>
</RecoverableException>
</RecoverableException>
</exceptionList>
|
However, the Database has been successfully inserted with the required values. So there is no issue with the DB entries.
This issue seems to be intermittent and does not occur at all time.
There have been some PMR's around this, which seem to have been resolved as a part of veriosn 7 and higher for DataDirect Oracle ODBC Driver. Since we are using IIB 10.0.0.1 version, the DataDirect Driver version is positively 7.
Any other things I might have to check for this issue?
Thanks |
|
| Back to top |
|
 |
| fjb_saper |
| Posted: Wed Aug 17, 2016 9:48 pm Post subject: |
|
|
Grand High Poobah
Joined: 18 Nov 2003
Posts: 20696
Location: LI,NY
|
Are you sure your Code parameter is valid all the time.
According to your Exception list Oracle did not like parameter 2 which is Code.
Any chance it might be of the wrong type, an unauthorized value, a null value?
A trace should show what value was being passed...
Have fun 
_________________
MQ & Broker admin |
|
| Back to top |
|
|
| Cody18 |
| Posted: Mon Aug 22, 2016 10:18 pm Post subject: |
|
|
Newbie
Joined: 08 Sep 2015
Posts: 9
|
Just received the trace. Had the wrong request with me.
like you said.. it dint like my parameter 2  |
|
| Back to top |
|
|
|
|
|
| |
|
Page 1 of 1 |
|
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
|
|
|
|
