| Author |
Message
|
| nmaddisetti |
 Posted: Wed Jul 22, 2009 2:57 pm Post subject: Driver issue |
 |
|
Centurion
Joined: 06 Oct 2004
Posts: 145
|
Hi All,
i am facing following issue.
And it is comming some times only with some flows.
We searched through the forum but no luck with any reason.
Child SQL exceptioncom.pnc.mb.HCA_TaskReport_MsgFlow_TASK_INFO_INSERTION.Main. 4.3. logDBSessionEntryExit(TASK_REPORT_FLOW, TASK_REPORT_DESC);. Root SQL exception. -1. HCADS. Child SQL exception. 21. -1. [IBM][ODBC 20101 driver][20101]13119. Caught exception and rethrowing. Error detected, rethrowing. Root SQL exception. Child SQL exception.
Can any one point me in right direction
We are using WMB 6.1.0.3.
OS:Sun Solaries.
Thanks,
Venkat. |
|
| Back to top |
|
 |
| broker_new |
| Posted: Wed Jul 22, 2009 3:14 pm Post subject: |
|
|
Yatiri
Joined: 30 Nov 2006
Posts: 614
Location: Washington DC
|
| What database are you trying to connect? 32 bit? post $ODBCINI o/p and DSN entry in the $ODBCINI |
|
| Back to top |
|
|
| WMBDEV1 |
| Posted: Wed Jul 22, 2009 11:40 pm Post subject: |
|
|
Sentinel
Joined: 05 Mar 2009
Posts: 888
Location: UK
|
As the problem is intermittant I guess running a user trace may be difficult.... Can you insert a trace node to show the exception tree?
You dont describe the flow but if its MQ are these messages being backed out?
An overview of the flow will be helpful |
|
| Back to top |
|
|
| nmaddisetti |
| Posted: Thu Jul 23, 2009 6:41 am Post subject: |
|
|
Centurion
Joined: 06 Oct 2004
Posts: 145
|
| Quote: |
| What database are you trying to connect? 32 bit? post $ODBCINI o/p and DSN entry in the $ODBCINI |
Our database is oracle and 62 bit
[HCADB09T]
Driver=/opt/IBM/mqsi/6.1.0.3/ODBC64/V5.3/lib/UKora23.so
Description=DataDirect 5.3 64bit Oracle Wire Protocol
#HostName=<Your Oracle Server Machine Name>
#PortNumber=<Port on which Oracle is listening on HostName>
#SID=<Your Oracle SID>
ServerName=HCADB09T
TNSNamesFile=/var/opt/oracle/tnsnames.ora
CatalogOptions=0
EnableStaticCursorsForLongData=0
ApplicationUsingThreads=1
EnableDescribeParam=1
OptimizePrepare=1
WorkArounds=536870912
ProcedureRetResults=1
ColumnSizeAsCharacter=1 |
|
| Back to top |
|
|
| nmaddisetti |
| Posted: Thu Jul 23, 2009 6:42 am Post subject: |
|
|
Centurion
Joined: 06 Oct 2004
Posts: 145
|
| Quote: |
You dont describe the flow but if its MQ are these messages being backed out?
|
The flows in which we see error are Q based and file based as i said it is not one flow many flows are giving error so in brief.
some times error is comming while executing select query some times with database package call one more thing i observed is select query or package call is the first database statement and one more thing i want to say is it is comming in TEST environement only but not in QA.
based on the info can you please point me where to look for fixing the problem. |
|
| Back to top |
|
|
| broker_new |
| Posted: Thu Jul 23, 2009 7:09 am Post subject: |
|
|
Yatiri
Joined: 30 Nov 2006
Posts: 614
Location: Washington DC
|
Firstly,
You dont need to set the tnsnames.ora as you have the driver for oracle (only 64 bit). you have to set it if you would like to use the 32 bit driver as it needs the oracle client.That means it should look something like this
[HCADB09T]
Driver=/opt/IBM/mqsi/6.1.0.3/ODBC64/V5.3/lib/UKora23.so
Description=DataDirect 5.3 64bit Oracle Wire Protocol
HostName=<Your Oracle Server Machine Name>
PortNumber=<Port on which Oracle is listening on HostName>
SID=<Your Oracle SID>
ServerName=HCADB09T
#TNSNamesFile=/var/opt/oracle/tnsnames.ora
CatalogOptions=0
EnableStaticCursorsForLongData=0
ApplicationUsingThreads=1
EnableDescribeParam=1
OptimizePrepare=1
WorkArounds=536870912
ProcedureRetResults=1
ColumnSizeAsCharacter=1 |
|
| Back to top |
|
|
| WMBDEV1 |
| Posted: Thu Jul 23, 2009 7:42 am Post subject: |
|
|
Sentinel
Joined: 05 Mar 2009
Posts: 888
Location: UK
|
| nmaddisetti wrote: |
based on the info can you please point me where to look for fixing the problem. |
Obtaining the full exception list will help as this may contain more info than what we have atm. Try putting a trace node in on the catch terminal outputting ${ExceptionList} |
|
| Back to top |
|
|
| nmaddisetti |
| Posted: Thu Jul 23, 2009 8:18 am Post subject: |
|
|
Centurion
Joined: 06 Oct 2004
Posts: 145
|
| Quote: |
Can you insert a trace node to show the exception tree?
|
I dont have a chance to put trace nodes in many flows at this point because this exception is not consistant with one flow but luckly i have trace node node in one of our flow in catch path and exception is as follows:
And I am not able to paste complete ExceptionList it is not allowing so i pasting in multiple replys please follow |
|
| Back to top |
|
|
| nmaddisetti |
| Posted: Thu Jul 23, 2009 8:19 am Post subject: |
|
|
Centurion
Joined: 06 Oct 2004
Posts: 145
|
-----------------------------------------
( ['MQROOT' : 0x11bc736b0]
(0x01000000:Name):RecoverableException = (
(0x03000000:NameValue):File = '/build/S610_P/src/DataFlowEngine/ImbComputeNode.cpp' (CHARACTER)
(0x03000000:NameValue):Line = 464 (INTEGER)
(0x03000000:NameValue):Function = 'ImbComputeNode::evaluate' (CHARACTER)
(0x03000000:NameValue):Type = 'ComIbmComputeNode' (CHARACTER)
(0x03000000:NameValue):Name = 'TEST_Ack_997_MsgFlow#FCMComposite_1_2' (CHARACTER)
(0x03000000:NameValue):Label = 'TEST_Ack_997_MsgFlow.TEST_FILE_INFO' (CHARACTER)
(0x03000000:NameValue):Catalog = 'BIPv610' (CHARACTER)
(0x03000000:NameValue):Severity = 3 (INTEGER)
(0x03000000:NameValue):Number = 2230 (INTEGER)
(0x03000000:NameValue):Text = 'Caught exception and rethrowing' (CHARACTER)
(0x01000000:Name ):RecoverableException = (
(0x03000000:NameValue):File = '/build/S610_P/src/DataFlowEngine/ImbRdl/ImbRdlStatementGroup.cpp' (CHARACTER)
(0x03000000:NameValue):Line = 586 (INTEGER)
(0x03000000:NameValue):Function = 'SqlStatementGroup::execute' (CHARACTER)
(0x03000000:NameValue):Type = 'ComIbmComputeNode' (CHARACTER)
(0x03000000:NameValue):Name = 'TEST_Ack_997_MsgFlow#FCMComposite_1_2' (CHARACTER)
(0x03000000:NameValue):Label = 'TEST_Ack_997_MsgFlow.TEST_FILE_INFO' (CHARACTER)
(0x03000000:NameValue):Catalog = 'BIPv610' (CHARACTER)
(0x03000000:NameValue):Severity = 3 (INTEGER)
(0x03000000:NameValue):Number = 2488 (INTEGER)
(0x03000000:NameValue):Text = 'Error detected, rethrowing' (CHARACTER)
(0x01000000:Name ):Insert = (
(0x03000000:NameValue):Type = 5 (INTEGER)
(0x03000000:NameValue):Text = '.TEST_Ack_997_MsgFlow_Compute.Main' (CHARACTER)
)
(0x01000000:Name ):Insert = (
(0x03000000:NameValue):Type = 5 (INTEGER)
(0x03000000:NameValue):Text = '30.4' (CHARACTER) |
|
| Back to top |
|
|
| jbanoop |
| Posted: Thu Jul 23, 2009 8:21 am Post subject: |
|
|
Chevalier
Joined: 17 Sep 2005
Posts: 401
Location: SC
|
| Have you thought of opening a PMR ? |
|
| Back to top |
|
|
| nmaddisetti |
| Posted: Thu Jul 23, 2009 8:40 am Post subject: |
|
|
Centurion
Joined: 06 Oct 2004
Posts: 145
|
No,not yet.
We need to give some proper reason behind the issue before we ask Client to open a PMR.
And I am not able to past remaining Exception list it is giving this error all the time with exception text:
Service Temporarily Unavailable
The server is temporarily unable to service your request due to maintenance downtime or capacity problems. Please try again later.
| Quote: |
| #TNSNamesFile=/var/opt/oracle/tnsnames.ora |
will this help us in resolving our problem |
|
| Back to top |
|
|
| WMBDEV1 |
| Posted: Thu Jul 23, 2009 9:30 am Post subject: |
|
|
Sentinel
Joined: 05 Mar 2009
Posts: 888
Location: UK
|
| nmaddisetti wrote: |
We need to give some proper reason behind the issue before we ask Client to open a PMR.
|
"I cant solve this on my own and it doesnt hurt to have IBM help while I continue my investigations" that normally does it.
Are you able to post the deepest parts of the exception list if not all of it? |
|
| Back to top |
|
|
| nmaddisetti |
| Posted: Thu Jul 23, 2009 9:32 am Post subject: |
|
|
Centurion
Joined: 06 Oct 2004
Posts: 145
|
(0x01000000:Name ):DatabaseException = (
(0x03000000:NameValue):File = '/build/S610_P/src/DataFlowEngine/ImbOdbc.cpp' (CHARACTER)
(0x03000000:NameValue):Line = 323 (INTEGER)
(0x03000000:NameValue):Function = 'ImbOdbcHandle::checkRcInner' (CHARACTER)
(0x03000000:NameValue):Type = '' (CHARACTER)
(0x03000000:NameValue):Name = '' (CHARACTER)
(0x03000000:NameValue):Label = '' (CHARACTER)
(0x03000000:NameValue):Catalog = 'BIPv610' (CHARACTER)
(0x03000000:NameValue):Severity = 3 (INTEGER)
(0x03000000:NameValue):Number = 2393 (INTEGER)
(0x03000000:NameValue):Text = 'Root SQL exception' (CHARACTER)
(0x01000000:Name ):Insert = (
(0x03000000:NameValue):Type = 2 (INTEGER)
(0x03000000:NameValue):Text = '-1' (CHARACTER)
)
(0x01000000:Name ):Insert = (
(0x03000000:NameValue):Type = 5 (INTEGER)
(0x03000000:NameValue):Text = 'TESTDS' (CHARACTER)
)
(0x01000000:Name ):DatabaseException = (
(0x03000000:NameValue):File = '/build/S610_P/src/DataFlowEngine/ImbOdbc.cpp' (CHARACTER)
(0x03000000:NameValue):Line = 438 (INTEGER)
(0x03000000:NameValue):Function = 'ImbOdbcHandle::checkRcInner' (CHARACTER)
(0x03000000:NameValue):Type = '' (CHARACTER)
(0x03000000:NameValue):Name = '' (CHARACTER)
(0x03000000:NameValue):Label = '' (CHARACTER)
(0x03000000:NameValue):Catalog = 'BIPv610' (CHARACTER)
(0x03000000:NameValue):Severity = 3 (INTEGER)
(0x03000000:NameValue):Number = 2322 (INTEGER)
(0x03000000:NameValue):Text = 'Child SQL exception' (CHARACTER)
(0x01000000:Name ):Insert = (
(0x03000000:NameValue):Type = 5 (INTEGER)
(0x03000000:NameValue):Text = '21' (CHARACTER)
)
(0x01000000:Name ):Insert = (
(0x03000000:NameValue):Type = 2 (INTEGER)
(0x03000000:NameValue):Text = '-1' (CHARACTER)
)
(0x01000000:Name ):Insert = (
(0x03000000:NameValue):Type = 5 (INTEGER)
(0x03000000:NameValue):Text = '[IBM][ODBC 20101 driver][20101]13119' (CHARACTER)
)
)
)
)
)
) |
|
| Back to top |
|
|
| WMBDEV1 |
| Posted: Thu Jul 23, 2009 9:39 am Post subject: |
|
|
Sentinel
Joined: 05 Mar 2009
Posts: 888
Location: UK
|
|
| Back to top |
|
|
| broker_new |
| Posted: Thu Jul 30, 2009 6:50 pm Post subject: |
|
|
Yatiri
Joined: 30 Nov 2006
Posts: 614
Location: Washington DC
|
| Hey nmaddisetti have you found any solution for it? Please post it for us |
|
| Back to top |
|
|
|
|
