| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| BIP2228E: error |
« View previous topic :: View next topic » |
| Author |
Message
|
| leo> |
 Posted: Fri Oct 14, 2005 2:38 pm Post subject: BIP2228E: error |
 |
|
Apprentice
Joined: 06 Oct 2004
Posts: 42
|
Hi,
We are using MQS1 V2.1 with CSD 08. We recently moved from CSD04 to CSD08. One of our EG is restarting automatically producing the following error message:
| Code: |
BIP2228E: Severe error: /build/S210_P/src/CommonServices/Unix/ImbAbend.cpp 478 signal received Abend file: /var/wmqi/errors/TSTMQS02.DV_EMPLOY.10123.28.abend action: abort
|
This is occuring after the CSD update, no changes have been done to the flow.
I am trying to read a CLOB field from a bunch of records in an oracle table and concatenate each of the CLOB field value to a CHARACTER variable named Msg.
| Code: |
Set Msg = '<?xml version="1.0"?><ImportRequest xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="e:\temp\imp_schema_BP_561.xsd"><ProcessingInstructions userName="" password=""></ProcessingInstructions><ImportObjects>';
Set SelectQuery = 'Select T.UNIQUEID, T.XML_MESSAGE from EMPLOY_BUFFER T where T.DATETIME_SENT is NULL
and ROWNUM<=? and T.INTERFACE_ID=?';
Set OutputLocalEnvironment."XML"."Record"[] = PASSTHRU(SelectQuery,3000,InterfaceName);
DECLARE REF1 REFERENCE TO OutputLocalEnvironment."XML"."Record"[1];
While LASTMOVE(REF1) do
IF(REF1.XML_MESSAGE <> '') THEN
Set Msg = Msg||REF1.XML_MESSAGE;
END IF;
Set UniqueID = CAST( CAST(REF1.UNIQUEID AS DECIMAL) AS CHAR);
Set UpdateQuery = 'Update EMPLOY_BUFFER T set T.DATETIME_SENT = sysdate where T.INTERFACE_ID =? and T.UNIQUEID = ?';
PASSTHRU(UpdateQuery,InterfaceName,UniqueID);
Set I = I + 1; -- for traversing through UniqueId array
MOVE REF1 NEXTSIBLING;
Set J = J + 1;
end while; --}
Set Msg = Msg||'</ImportObjects></ImportRequest>';
Propagate;
|
Any idea what could be the reason for this error?
Below is the stack dump:
| Code: |
abend record for pid 10123 tid 28 time in seconds since 01/01/1970: 1129327892
File: /build/S210_P/src/CommonServices/Unix/ImbAbend.cpp
Line: 478
Function: signal received
---- Inserts ----
10
@(#) 1.28.1.6 CommonServices/Unix/ImbAbend.cpp, CommonServices, S210, S210-CSD08 04/09/13 18:40:11 [11/18/04 12:34:47]
-543658224
-----------------
----------------------------- Stack dump for current thread ( 28)
(0xfec41cb8+0x01a0) malloc (0x1978, 0x67206469, 0xfecbc008, 0x1978, 0xed1a60, 0x0) in /usr/lib/libc.so.1
(0xfec41cb8+0x020) malloc (0x1978, 0x14bd4, 0x2b, 0x2b, 0x2b, 0x0) in /usr/lib/libc.so.1
(0xff05547c+0x02c) __1c2n6FI_pv_ (0x1978, 0xff06a054, 0xff055568, 0xff06a5e8, 0x40, 0x0) in /opt/nnsy/SAP-3_9/bin/libCrun.so.1
(0xff0d2d0c+0x01ec) __1cPImbConverterCPPJtoUnicode6Mpkcibc_nNImbStringBase4CHnDstdLchar_traits4CH__iSibL___ (0xed0ea8, 0x0, 0x
df9874a0, 0xcbc, 0x0, 0x0) in /opt/wmqi/lib/libCommonServices.so
(0xfef9a528+0x0144) __1cXImbOdbcDynamicResultSetPvalueFromBuffer6Mipkci_nIImbValue__ (0xff24c070, 0xfeff3019, 0xff24c060, 0xed
0ea8, 0xcbc, 0xdf987da0) in /opt/wmqi/lib/libMessageServices.so
(0xfef99c50+0x03e0) __1cXImbOdbcDynamicResultSetIgetValue6Mi_nIImbValue__ (0x2, 0xfeff2fdb, 0xff24c060, 0xff005960, 0x20000, 0
xff24c060) in /opt/wmqi/lib/libMessageServices.so
(0xfc0c23c8+0x0348) __1cbASqlDbStmtEvalRowResultBaseGassign6MrnKImbMessageLWriteCursor_brknNImbStringBase4CHnDstdLchar_traits4
CH__iSibL___v_ (0xfc3feef2, 0xfc3fee7c, 0xfc3feea5, 0xfc3fef58, 0xfc3fef15, 0x2) in /opt/wmqi/lib/libImbRdl.so
(0xfc0bf6f8+0x0858) contact admin
char_traits4CH__iSibL___v_ (0xff24c070, 0x0, 0xdf98861c, 0x1, 0xfc3fe71f, 0x0) in /opt/wmqi/lib/libImbRdl.so
(0xfc0bd800+0x0388) __1cNSqlAssignmentPassignToMessage6kMrnOSqlEvalEnviron__v_ (0x0, 0xdf989a10, 0xfc46c2b4, 0xff24c060, 0xdf9
88590, 0x0) in /opt/wmqi/lib/libImbRdl.so
(0xfc0bbae0+0x056c) __1cNSqlAssignmentHexecute6kMrnOSqlEvalEnviron__v_ (0xff24c060, 0xdf988914, 0xff24c070, 0x1, 0xdf9888b8, 0
xdf988a00) in /opt/wmqi/lib/libImbRdl.so
(0xfc29e280+0x088) __1cRSqlStatementGroupHexecute6kMrnOSqlEvalEnviron__v_ (0xd47a6c, 0xd4696c, 0xfc43966c, 0xfc46c2b4, 0xdf988
aa8, 0xdf988d48) in /opt/wmqi/lib/libImbRdl.so
(0xfc31eeb4+0x0534) __1cVSqlWhileStatementBaseHexecute6kMrnOSqlEvalEnviron__v_ (0xd46950, 0x597e8, 0xff24c070, 0x3800, 0x3b88,
0xe45e50) in /opt/wmqi/lib/libImbRdl.so
(0xfc29e280+0x088) __1cRSqlStatementGroupHexecute6kMrnOSqlEvalEnviron__v_ (0xd37638, 0xd36d44, 0xfc43966c, 0xfc46c2b4, 0xdf988
fc0, 0x0) in /opt/wmqi/lib/libImbRdl.so
(0xfc31eeb4+0x0534) __1cVSqlWhileStatementBaseHexecute6kMrnOSqlEvalEnviron__v_ (0xd36d28, 0x597e8, 0xff24c070, 0x3800, 0x3b88,
0x0) in /opt/wmqi/lib/libImbRdl.so
(0xfc29e280+0x088) __1cRSqlStatementGroupHexecute6kMrnOSqlEvalEnviron__v_ (0xb4d2a8, 0xb4c9d0, 0xfc43966c, 0xfc46c2b4, 0xdf989
c20, 0x0) in /opt/wmqi/lib/libImbRdl.so
(0xfc0ee630+0x06bc) __1cTSqlComputeInterfaceIevaluate6MrknSImbMessageAssembly_r1_nIImbValue__ (0xff24c060, 0xdf989acc, 0xdf989
9ec, 0x9a22f0, 0x9a22f0, 0xffffffff) in /opt/wmqi/lib/libImbRdl.so
(0xeb1cbe1c+0x02fc) __1cOImbComputeNodeIevaluate6MrknSImbMessageAssembly_pknTImbDataFlowTerminal__rnPImbDataFlowNode__ (0xff24
c070, 0xeb20d198, 0xeb222928, 0xff24c060, 0xfefed926, 0xff24c060) in /opt/wmqi/lil/imbdfsql.lil
(0xfedb63c0+0x01ac) __1cTImbDataFlowTerminalIevaluate6MrknSImbMessageAssembly__r0_ (0xfee86774, 0xff24c060, 0x333, 0xe23efc, 0
xd22bf8, 0xfeff1723) in /opt/wmqi/lib/libDataFlowDLL.so
(0xfedb62ec+0x074) __1cTImbDataFlowTerminalJpropagate6MrknSImbMessageAssembly__r0_ (0xd22fa8, 0xdf98ade8, 0xff005960, 0xdf98a4
2c, 0xe23efc, 0xd22f78) in /opt/wmqi/lib/libDataFlowDLL.so
(0xeb47b520+0x02cb0) __1cOImbMqInputNodeJreadQdDueue6MpnLImbOsThread__v_ (0x1c, 0x1c, 0x1c, 0x1c, 0xeb781a58, 0xe23db8) in /op
t/wmqi/lil/imbdfmqm.lil
(0xeb4a3c08+0x064) __1cOImbMqInputNodeKParametersDrun6MpnLImbOsThread__i_ (0xbfcbe0, 0xd1fe88, 0xdf98bb88, 0x0, 0x0, 0xdf98bb8
8) in /opt/wmqi/lil/imbdfmqm.lil
(0xff184404+0x044) __1cbBImbThreadPoolThreadFunctionDrun6MpnLImbOsThread__v_ (0xdf98bbe4, 0xd1fe88, 0xc4653600, 0xa, 0x0, 0x0)
in /opt/wmqi/lib/libCommonServices.so
(0xff17cea8+0x038) __1cLImbOsThreadJthreadRun6M_L_ (0xd1fe88, 0x0, 0x0, 0x0, 0x0, 0x0) in /opt/wmqi/lib/libCommonServices.so
(0xff17cf14+0x038) __1cLImbOsThreadPthreadBootStrap6Fpv_I_ (0xff225e5b, 0xf8cb5d38, 0x0, 0x5, 0x1, 0xfe401000) in /opt/wmqi/li
b/libCommonServices.so
(0xfeedaef8+0x0124) _getfp (0xd1fe88, 0x0, 0x0, 0x0, 0x0, 0x0) in /usr/lib/libthread.so.1
----------------------------------------------------------------------
|
Please help...
thanks
_________________
IBM Certified System Administrator - Websphere MQ V5.3 |
|
| Back to top |
|
 |
| jefflowrey |
| Posted: Fri Oct 14, 2005 6:03 pm Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
Did you upgrade the Control Center machines as well to CSD8?
Did you "rebuild" your flows after that upgrade?
Did you redeploy your flows after that?
_________________
I am *not* the model of the modern major general. |
|
| Back to top |
|
|
| leo> |
| Posted: Sat Oct 15, 2005 6:41 am Post subject: |
|
|
Apprentice
Joined: 06 Oct 2004
Posts: 42
|
1) Yes, we applied CSD8 on the control center machines as well
2) I dont understand what you mean by "rebuild". The flow is not changed, and it was running alright on CSD4.
3) We did not redeploy as flow did not change.
Please let me know if I'm missing anything here... Any suggestions is greatly appreciated...
regards
_________________
IBM Certified System Administrator - Websphere MQ V5.3 |
|
| Back to top |
|
|
| jefflowrey |
| Posted: Sat Oct 15, 2005 6:49 am Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
Try reopening the flow in the Control Center, checking it back in, and then redeploying it.
_________________
I am *not* the model of the modern major general. |
|
| Back to top |
|
|
| leo> |
| Posted: Mon Oct 17, 2005 4:48 am Post subject: |
|
|
Apprentice
Joined: 06 Oct 2004
Posts: 42
|
Checked out the flow, checked it back in, and did a complete assignments deploy on the EG. Still it does'nt seem to help..
Could anything else be wrong? Please help...
_________________
IBM Certified System Administrator - Websphere MQ V5.3 |
|
| Back to top |
|
|
| leo> |
| Posted: Mon Oct 17, 2005 5:15 pm Post subject: |
|
|
Apprentice
Joined: 06 Oct 2004
Posts: 42
|
Hi Folks,
Still struggling with this issue.... While doing a debug, found that it is abending exactly when the PASSTHRU function is called.
| Code: |
Set SelectQuery = 'Select T.UNIQUEID, T.XML_MESSAGE from EMPLOY_BUFFER T where T.DATETIME_SENT is NULL
and ROWNUM<=? and T.INTERFACE_ID=?';
Set OutputLocalEnvironment."XML"."Record"[] = PASSTHRU(SelectQuery,3000,InterfaceName); |
I removed PASSTHRU and used a select query directly. Still no use..
I checked the length of the data being returned in the CLOB field. It varies between 1200 to 4600 characters. While searching in the IBM site for issues with CLOB data type, found a page that specifies to set an environment variable if CLOB being returned is more than 3998 characters//
| Code: |
| export MQSI_ORACLE_LOB_TYPE='CLOB'; |
Even this does'nt help. Am I setting the environment variable properly? (I tried setting the value CLOB with out quotes too)
I thought this flow (which reads from the database) could be failing if the previous flow writing to the database writes any junk characters.. So I modified the flow that writes to the database and connected the compute node to a MQOutput node to check the data being written to the databaseThe data seems to be plain ascii..
Really struggling here... Please help with your suggestions...
thanks
_________________
IBM Certified System Administrator - Websphere MQ V5.3 |
|
| Back to top |
|
|
| jefflowrey |
| Posted: Mon Oct 17, 2005 5:21 pm Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
I hate to suggest this, but it could be an issue with the driver for Oracle.
You might need to roll back to CSD7 and try again.
Certainly you should open a PMR with IBM.
_________________
I am *not* the model of the modern major general. |
|
| Back to top |
|
|
| leo> |
| Posted: Mon Oct 17, 2005 5:49 pm Post subject: |
|
|
Apprentice
Joined: 06 Oct 2004
Posts: 42
|
Thank you so much, really appreciate it..
Is this a known issue in CSD8? Could you provide me any links, if you have, confirming this..? The reason I ask this is, I got to convince my tech lead to open a PMR.
_________________
IBM Certified System Administrator - Websphere MQ V5.3 |
|
| Back to top |
|
|
| leo> |
| Posted: Mon Oct 17, 2005 6:52 pm Post subject: |
|
|
Apprentice
Joined: 06 Oct 2004
Posts: 42
|
The Readme file for CSD7 and CSD8 says to update SwitchFile parameter in qm.ini file, when connecting to oracle on/from a SOLARIS machine. When I checked the qm.ini file, we have not configured any parameters related to XA (XAResourceManager and SwitchFile). However in the flow, we have set Transaction Mode=Yes in the MQInput node. Could this be a reason for this issue...?
_________________
IBM Certified System Administrator - Websphere MQ V5.3 |
|
| 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
|
|
|
|
