ASG
IBM
Zystems
Cressida
Icon
Netflexity
 
  MQSeries.net
Search  Search       Tech Exchange      Education      Certifications      Library      Info Center      SupportPacs      LinkedIn  Search  Search                                                                   FAQ  FAQ   Usergroups  Usergroups
 
Register  ::  Log in Log in to check your private messages
 
RSS Feed - WebSphere MQ Support RSS Feed - Message Broker Support

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » Connection Dead issue while connecting to oracle database.

Post new topic  Reply to topic
 Connection Dead issue while connecting to oracle database. « View previous topic :: View next topic » 
Author Message
sukhi
PostPosted: Mon Jan 16, 2017 9:44 pm    Post subject: Connection Dead issue while connecting to oracle database. Reply with quote

Novice

Joined: 22 Nov 2016
Posts: 18
Hello Gentle Men,

IIB version 9.0.0.2

I am facing connection dead issue while connecting to the ODBC datasource.
(calling database procedure to fetch records from DB)

Application is not working for 2 to 3 minutes then started working

below is the steps followed to figure out the issue.
1)There is no interruption on network firewall to connect with database
2)this issue is occurred on daily basis and there is no database migration happening.

we are very close to go live/production.
please help ......
Back to top
View user's profile Send private message
adubya
PostPosted: Mon Jan 16, 2017 11:57 pm    Post subject: Reply with quote

Partisan

Joined: 25 Aug 2011
Posts: 377
Location: GU12, UK
Presumably you're getting some IIB and/or Oracle errors ? Post them up here, without those we can't help.
_________________
Independent Middleware Consultant
andy@knownentity.com
Back to top
View user's profile Send private message Send e-mail
sukhi
PostPosted: Tue Jan 17, 2017 12:03 am    Post subject: Reply with quote

Novice

Joined: 22 Nov 2016
Posts: 18
hi Adubya,
below is the trace log

<RecoverableException>
<File>F:\build\slot1\S900_P\src\DataFlowEngine\SQLNodeLibrary\ImbComputeNode.cpp</File>
<Line>497</Line>
<Function>ImbComputeNode::evaluate</Function>
<Type>ComIbmComputeNode</Type>
<Name>com/rbl/realtimealert/RealTimeAlert#FCMComposite_1_6</Name>
<Label>com.rbl.realtimealert.RealTimeAlert.RTABuildResponse</Label>
<Catalog>BIPmsgs</Catalog>
<Severity>3</Severity>
<Number>2230</Number>
<Text>Caught exception and rethrowing</Text>
<Insert>
<Type>14</Type>
<Text>com.rbl.realtimealert.RealTimeAlert.RTABuildResponse</Text>
</Insert>
<RecoverableException>
<File>F:\build\slot1\S900_P\src\DataFlowEngine\ImbRdl\ImbRdlStatementGroup.cpp</File>
<Line>666</Line>
<Function>SqlStatementGroup::execute</Function>
<Type>ImbESQLManager</Type>
<Name>ImbESQLManager</Name>
<Label>ImbESQLManager</Label>
<Catalog>BIPmsgs</Catalog>
<Severity>3</Severity>
<Number>2488</Number>
<Text>Error detected, rethrowing</Text>
<Insert>
<Type>5</Type>
<Text>com.rbl.realtimealert.RTABuildResponse.Main</Text>
</Insert>
<Insert>
<Type>5</Type>
<Text>45.4</Text>
</Insert>
<Insert>
<Type>5</Type>
<Text>PROPAGATE TO TERMINAL 'out1' FINALIZE DEFAULT DELETE DEFAULT;</Text>
</Insert>
<RecoverableException>
<File>F:\build\slot1\S900_P\src\DataFlowEngine\SQLNodeLibrary\ImbComputeNode.cpp</File>
<Line>497</Line>
<Function>ImbComputeNode::evaluate</Function>
<Type>ComIbmComputeNode</Type>
<Name>com/rbl/realtimealert/RealTimeAlert#FCMComposite_1_20.com/rbl/realtimealert/SF_CustomError#FCMComposite_1_1</Name>
<Label>com.rbl.realtimealert.RealTimeAlert.com/rbl/realtimealert/SF_CustomError.CustomError</Label>
<Catalog>BIPmsgs</Catalog>
<Severity>3</Severity>
<Number>2230</Number>
<Text>Caught exception and rethrowing</Text>
<Insert>
<Type>14</Type>
<Text>com.rbl.realtimealert.RealTimeAlert.com/rbl/realtimealert/SF_CustomError.CustomError</Text>
</Insert>
<RecoverableException>
<File>F:\build\slot1\S900_P\src\DataFlowEngine\ImbRdl\ImbRdlStatementGroup.cpp</File>
<Line>666</Line>
<Function>SqlStatementGroup::execute</Function>
<Type>ImbESQLManager</Type>
<Name>ImbESQLManager</Name>
<Label>ImbESQLManager</Label>
<Catalog>BIPmsgs</Catalog>
<Severity>3</Severity>
<Number>2488</Number>
<Text>Error detected, rethrowing</Text>
<Insert>
<Type>5</Type>
<Text>com.rbl.realtimealert.CustomError.Main</Text>
</Insert>
<Insert>
<Type>5</Type>
<Text>36.13</Text>
</Insert>
<Insert>
<Type>5</Type>
<Text>DBGenericAuditError(SRCERRORDESC, SERVICERQID, CHANNELID, SRCERRORCODE, ErrorCode, ErrorDesc, AUDITDS, AUDITSCHEMA);</Text>
</Insert>
<RecoverableException>
<File>F:\build\slot1\S900_P\src\DataFlowEngine\ImbRdl\ImbRdlRoutine.cpp</File>
<Line>1222</Line>
<Function>SqlRoutine::invoke</Function>
<Type>ImbESQLManager</Type>
<Name>ImbESQLManager</Name>
<Label>ImbESQLManager</Label>
<Catalog>BIPmsgs</Catalog>
<Severity>3</Severity>
<Number>2934</Number>
<Text>Error occured in procedure</Text>
<Insert>
<Type>5</Type>
<Text>DBGenericAuditError</Text>
</Insert>
<RecoverableException>
<File>F:\build\slot1\S900_P\src\DataFlowEngine\ImbRdl\ImbRdlStatementGroup.cpp</File>
<Line>666</Line>
<Function>SqlStatementGroup::execute</Function>
<Type>ImbESQLManager</Type>
<Name>ImbESQLManager</Name>
<Label>ImbESQLManager</Label>
<Catalog>BIPmsgs</Catalog>
<Severity>3</Severity>
<Number>2488</Number>
<Text>Error detected, rethrowing</Text>
<Insert>
<Type>5</Type>
<Text>com.ebanking.www.DBGenericAuditError</Text>
</Insert>
<Insert>
<Type>5</Type>
<Text>4.2</Text>
</Insert>
<Insert>
<Type>5</Type>
<Text>proc_AuditGenericError(pi_SRC_ERROR_DESC, pi_SRC_SERVICERQID, pi_DST_CHANNELID, pi_SRC_ERROR_CODE, pi_DEST_USR_ERR_CODE, pi_DEST_USR_ERR_DESC) IN Database.{AUDITDS}.{AUDITSCHEMA};</Text>
</Insert>
<RecoverableException>
<File>F:\build\slot1\S900_P\src\DataFlowEngine\ImbRdl\ImbRdlRoutine.cpp</File>
<Line>1351</Line>
<Function>SqlRoutine::invoke</Function>
<Type>ImbESQLManager</Type>
<Name>ImbESQLManager</Name>
<Label>ImbESQLManager</Label>
<Catalog>BIPmsgs</Catalog>
<Severity>3</Severity>
<Number>2934</Number>
<Text>Error occured in procedure</Text>
<Insert>
<Type>5</Type>
<Text>proc_AuditGenericError</Text>
</Insert>
<DatabaseException>
<File>F:\build\slot1\S900_P\src\DataFlowEngine\MessageServices\ImbOdbc.cpp</File>
<Line>3246</Line>
<Function>ImbOdbcStatement::checkRcInner</Function>
<Type></Type>
<Name></Name>
<Label></Label>
<Catalog>BIPmsgs</Catalog>
<Severity>3</Severity>
<Number>2321</Number>
<Text>Root SQL exception</Text>
<Insert>
<Type>2</Type>
<Text>-1</Text>
</Insert>
<Insert>
<Type>14</Type>
<Text>odbc32.dll</Text>
</Insert>
<DatabaseException>
<File>F:\build\slot1\S900_P\src\DataFlowEngine\MessageServices\ImbOdbc.cpp</File>
<Line>3424</Line>
<Function>ImbOdbcStatement::checkRcInner</Function>
<Type></Type>
<Name></Name>
<Label></Label>
<Catalog>BIPmsgs</Catalog>
<Severity>3</Severity>
<Number>2322</Number>
<Text>Child SQL exception</Text>
<Insert>
<Type>5</Type>
<Text>08S01</Text>
</Insert>
<Insert>
<Type>2</Type>
<Text>-4</Text>
</Insert>
<Insert>
<Type>5</Type>
<Text>[IBM][ODBC Oracle Wire Protocol driver][Oracle]Connection Dead.</Text>
</Insert>
</DatabaseException>
</DatabaseException>
</RecoverableException>
</RecoverableException>
</RecoverableException>
</RecoverableException>
</RecoverableException>
</RecoverableException>
</RecoverableException>
Back to top
View user's profile Send private message
adubya
PostPosted: Tue Jan 17, 2017 12:07 am    Post subject: Reply with quote

Partisan

Joined: 25 Aug 2011
Posts: 377
Location: GU12, UK
http://www-01.ibm.com/support/docview.wss?uid=swg21471862

Have you checked the firewall setting with the network team ? Sounds like a firewall is closing down connections.
_________________
Independent Middleware Consultant
andy@knownentity.com
Back to top
View user's profile Send private message Send e-mail
sukhi
PostPosted: Tue Jan 17, 2017 12:50 am    Post subject: Reply with quote

Novice

Joined: 22 Nov 2016
Posts: 18
Hi Adubya,
have raised the same with network team

but there are multiple schemas on the same database which are used by other applications(except wmb/iib) , there is no such issue is occurred.
Back to top
View user's profile Send private message
mqjeff
PostPosted: Tue Jan 17, 2017 5:05 am    Post subject: Reply with quote

Grand Master

Joined: 25 Jun 2008
Posts: 17447
Also check with your DB team. They may be dropping the connection because of where IIB is coming from or what user or how many records or how long the connection is staying open or or or...
_________________
chmod -R ugo-wx /
Back to top
View user's profile Send private message
sukhi
PostPosted: Wed Jan 18, 2017 12:21 am    Post subject: Reply with quote

Novice

Joined: 22 Nov 2016
Posts: 18
Hi Thanks ,
we have found solution for the same
there is a setting configured in firewall as one hour for session timeout and now changing it with 24 hours for database connection.

now i am just observing if any issue is occurred post this change

Regards
Sukhendra
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic  Reply to topic Page 1 of 1

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » Connection Dead issue while connecting to oracle database.
Jump to:  



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
Protected by Anti-Spam ACP
  
 


Theme by Dustin Baccetti
Powered by phpBB © 2001, 2002 phpBB Group

Copyright © MQSeries.net. All rights reserved.