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 » Oracle Dead Connection

Post new topic  Reply to topic Goto page 1, 2  Next
 Oracle Dead Connection « View previous topic :: View next topic » 
Author Message
nelson
PostPosted: Tue May 24, 2016 5:18 am    Post subject: Oracle Dead Connection Reply with quote

Partisan

Joined: 02 Oct 2012
Posts: 313
Hi all,

We are getting this errors:

Code:
May 23 09:51:49 AIX_SQA user:err|error IIB[15335610]: IBM Integration Bus v9002
(yyy) [Thread 36496] (Msg 3/4) BIP2322E: Database error
: SQL State '08S01'; Native Error Code '-4'; Error Text '[unixODBC][IBM][ODBC Or
acle Wire Protocol driver][Oracle]Connection Dead.'.
May 23 09:51:49 AIX_SQA user:err|error IIB[15335610]: IBM Integration Bus v9002
(yyy) [Thread 36496] (Msg 3/4) BIP2322E: Database error
: SQL State '08S01'; Native Error Code '-3114'; Error Text '[unixODBC][IBM][ODBC
 Oracle Wire Protocol driver][Oracle]ORA-03114: not connected to ORACLE'.


After checking the option Connect before flow starts in the compute nodes.

Working on IIB 9.0.0.2 on AIX against an Oracle 11g.

Do any of you know of a workaround to solve this issue?

Thanks in advace
Back to top
View user's profile Send private message
maurito
PostPosted: Tue May 24, 2016 5:32 am    Post subject: Re: Oracle Dead Connection Reply with quote

Partisan

Joined: 17 Apr 2014
Posts: 358
nelson wrote:
Hi all,

We are getting this errors:

Code:
May 23 09:51:49 AIX_SQA user:err|error IIB[15335610]: IBM Integration Bus v9002
(yyy) [Thread 36496] (Msg 3/4) BIP2322E: Database error
: SQL State '08S01'; Native Error Code '-4'; Error Text '[unixODBC][IBM][ODBC Or
acle Wire Protocol driver][Oracle]Connection Dead.'.
May 23 09:51:49 AIX_SQA user:err|error IIB[15335610]: IBM Integration Bus v9002
(yyy) [Thread 36496] (Msg 3/4) BIP2322E: Database error
: SQL State '08S01'; Native Error Code '-3114'; Error Text '[unixODBC][IBM][ODBC
 Oracle Wire Protocol driver][Oracle]ORA-03114: not connected to ORACLE'.


After checking the option Connect before flow starts in the compute nodes.

Working on IIB 9.0.0.2 on AIX against an Oracle 11g.

Do any of you know of a workaround to solve this issue?

Thanks in advace

Have you specified the WorkArounds parameter in your ODBC definition?
Back to top
View user's profile Send private message
mqjeff
PostPosted: Tue May 24, 2016 5:34 am    Post subject: Reply with quote

Grand Master

Joined: 25 Jun 2008
Posts: 17447
Have you run mqsicvp ?
_________________
chmod -R ugo-wx /
Back to top
View user's profile Send private message
nelson
PostPosted: Tue May 24, 2016 5:55 am    Post subject: Re: Oracle Dead Connection Reply with quote

Partisan

Joined: 02 Oct 2012
Posts: 313
maurito wrote:
nelson wrote:
Hi all,

We are getting this errors:

Code:
May 23 09:51:49 AIX_SQA user:err|error IIB[15335610]: IBM Integration Bus v9002
(yyy) [Thread 36496] (Msg 3/4) BIP2322E: Database error
: SQL State '08S01'; Native Error Code '-4'; Error Text '[unixODBC][IBM][ODBC Or
acle Wire Protocol driver][Oracle]Connection Dead.'.
May 23 09:51:49 AIX_SQA user:err|error IIB[15335610]: IBM Integration Bus v9002
(yyy) [Thread 36496] (Msg 3/4) BIP2322E: Database error
: SQL State '08S01'; Native Error Code '-3114'; Error Text '[unixODBC][IBM][ODBC
 Oracle Wire Protocol driver][Oracle]ORA-03114: not connected to ORACLE'.


After checking the option Connect before flow starts in the compute nodes.

Working on IIB 9.0.0.2 on AIX against an Oracle 11g.

Do any of you know of a workaround to solve this issue?

Thanks in advace

Have you specified the WorkArounds parameter in your ODBC definition?


Yes:

Code:
WorkArounds=536870912
Back to top
View user's profile Send private message
nelson
PostPosted: Tue May 24, 2016 5:59 am    Post subject: Reply with quote

Partisan

Joined: 02 Oct 2012
Posts: 313
mqjeff wrote:
Have you run mqsicvp ?


Yes, the connections were working fine. This problem occurs in flows with that property enabled that previously were disabled.

It seems that the connection expires somewhere...

The DB people say that the connections are not configured to expire.

I'm also curious why the flow does not detect that the connection is no alive and tries to reconnect without reporting an error.

Thank in advance for your comments.
Back to top
View user's profile Send private message
maurito
PostPosted: Tue May 24, 2016 6:03 am    Post subject: Reply with quote

Partisan

Joined: 17 Apr 2014
Posts: 358
it is probably worth upgrading to 9.0.0.5
Back to top
View user's profile Send private message
nelson
PostPosted: Tue May 24, 2016 6:26 am    Post subject: Reply with quote

Partisan

Joined: 02 Oct 2012
Posts: 313
maurito wrote:
it is probably worth upgrading to 9.0.0.5


Yes... but... could be necessary to set a keepalive somewhere to keep the connection alive?

Have any of you tested this scenario, against an Oracle DB?

Thanks in advance.
Back to top
View user's profile Send private message
mqjeff
PostPosted: Tue May 24, 2016 7:46 am    Post subject: Reply with quote

Grand Master

Joined: 25 Jun 2008
Posts: 17447
In general, broker db connections don't automatically retry without an error.

They throw an error, mark the connection bad, and wait for a retry at the application/flow/whatever level.

It does seem odd that trying to establish a connection before the flows start, rather than after they start, would cause an issue.

A service trace of a small flow that doesn't really do anything (MQInput->Compute) might provide some input.
_________________
chmod -R ugo-wx /
Back to top
View user's profile Send private message
maurito
PostPosted: Tue May 24, 2016 8:43 am    Post subject: Reply with quote

Partisan

Joined: 17 Apr 2014
Posts: 358
nelson wrote:
maurito wrote:
it is probably worth upgrading to 9.0.0.5


Yes... but... could be necessary to set a keepalive somewhere to keep the connection alive?

Have any of you tested this scenario, against an Oracle DB?

Thanks in advance.

I am currently running v9.0.0.5 with Oracle and SQLServer. I always specify connect before the flow start and have had no issues, but I am on Windows. Last year I was at a customer , AIX and Oracle, no issues there either, v9 but can't remember fix pack.
Back to top
View user's profile Send private message
nelson
PostPosted: Tue May 24, 2016 8:55 am    Post subject: Reply with quote

Partisan

Joined: 02 Oct 2012
Posts: 313
maurito wrote:
nelson wrote:
maurito wrote:
it is probably worth upgrading to 9.0.0.5


Yes... but... could be necessary to set a keepalive somewhere to keep the connection alive?

Have any of you tested this scenario, against an Oracle DB?

Thanks in advance.

I am currently running v9.0.0.5 with Oracle and SQLServer. I always specify connect before the flow start and have had no issues, but I am on Windows. Last year I was at a customer , AIX and Oracle, no issues there either, v9 but can't remember fix pack.


Have you edited the default Oracle ODBC stanza or added a property?

Kind regards.
Back to top
View user's profile Send private message
maurito
PostPosted: Tue May 24, 2016 9:37 am    Post subject: Reply with quote

Partisan

Joined: 17 Apr 2014
Posts: 358
Edited the Oracle stanza to specify the database properties.
Back to top
View user's profile Send private message
maurito
PostPosted: Tue May 24, 2016 9:51 am    Post subject: Reply with quote

Partisan

Joined: 17 Apr 2014
Posts: 358
PS: the best thing you can do is get an ODBC trace of the attempt to connect
Back to top
View user's profile Send private message
akil
PostPosted: Sat May 28, 2016 9:26 pm    Post subject: Reply with quote

Partisan

Joined: 27 May 2014
Posts: 338
Location: Mumbai
Either the database or a firewall between the ESB and the database is killing of idle/inactive connections:

You could either get the idle time out increases or
You could write a timer based flow that issues a query every x minutes to avoid leaving the connection idle

Unlike app servers , the iib does not have a 'dead connection query' method to check a connection before returning it to the flow , so you will get occasional errors of these kinds
_________________
Regards
Back to top
View user's profile Send private message Visit poster's website
nelson
PostPosted: Thu Jun 02, 2016 8:03 am    Post subject: Reply with quote

Partisan

Joined: 02 Oct 2012
Posts: 313
maurito wrote:
PS: the best thing you can do is get an ODBC trace of the attempt to connect


Thanks maurito.

The ODBC is kind of complex to read and for non database experts (me included) could get a little confused.

The first event we get is this (previously don't have any attempt, 5 seconds before operations from another execution group...):

Code:
[ODBC][16253182][26989][2016-06-02 07:22:10.201][SQLExecute.c][344]
      Exit:[SQL_SUCCESS_WITH_INFO]
      DIAG [HY000] [IBM][ODBC Oracle Wire Protocol driver][Oracle]Network Operation Timed Out.

[ODBC][16253182][26989][2016-06-02 07:22:10.202][SQLNumResultCols.c][152]
      Entry:           
         Statement = 1426ba910           
         Column Count = 1253ad64c
[ODBC][16253182][26989][2016-06-02 07:22:10.202][SQLNumResultCols.c][244]
      Exit:[SQL_SUCCESS]               
         Count = 1253ad64c -> 65
[ODBC][16253182][26989][2016-06-02 07:22:10.202][SQLDescribeCol.c][243]
      Entry:           
         Statement = 1426ba910           
         Column Number = 1           
         Column Name = 1253ad990           
         Buffer Length = 200           
         Name Length = 1253ad656           
         Data Type = 1253ad654           
         Column Size = 1253ad730           
         Decimal Digits = 1253ad652           
         Nullable = 1253ad650


Then a lot of entries like this (for every column):

Code:
[ODBC][16253182][26989][2016-06-02 07:22:10.202][SQLDescribeCol.c][493]
      Exit:[SQL_SUCCESS]               
         Column Name = [MY_COLUMN_NAME]               
         Data Type = 1253ad654 -> 12               
         Column Size = 1253ad730 -> 3               
         Decimal Digits = 1253ad652 -> 0               
         Nullable = 1253ad650 -> 1
[ODBC][16253182][26989][2016-06-02 07:22:10.202][SQLColAttribute.c][286]
      Entry:           
         Statement = 1426ba910           
         Column Number = 2           
         Field Identifier = SQL_DESC_OCTET_LENGTH           
         Character Attr = 0           
         Buffer Length = 0           
         String Length = 0           
         Numeric Attribute = 1253ad740
[ODBC][16253182][26989][2016-06-02 07:22:10.202][SQLColAttribute.c][657]
      Exit:[SQL_SUCCESS]
[ODBC][16253182][26989][2016-06-02 07:22:10.202][SQLDescribeCol.c][243]
      Entry:           
         Statement = 1426ba910           
         Column Number = 3           
         Column Name = 1253ad990           
         Buffer Length = 200           
         Name Length = 1253ad656           
         Data Type = 1253ad654           
         Column Size = 1253ad730           
         Decimal Digits = 1253ad652           
         Nullable = 1253ad650


Then a lot of this entries (seems like the column types):

Code:
[ODBC][16253182][26989][2016-06-02 07:22:10.211][SQLBindCol.c][225]
      Entry:           
         Statement = 1426ba910           
         Column Number = 1           
         Target Type = -8 SQL_WCHAR           
         Target Value = 12378bd98           
         Buffer Length = 24           
         StrLen Or Ind = 12378bd90
[ODBC][16253182][26989][2016-06-02 07:22:10.211][SQLBindCol.c][329]
      Exit:[SQL_SUCCESS]


Then this:

Code:
[ODBC][16253182][26989][2016-06-02 07:22:10.216][SQLBindCol.c][329]
      Exit:[SQL_SUCCESS]
[ODBC][16253182][26989][2016-06-02 07:22:10.216][SQLSetStmtAttr.c][258]
      Entry:           
         Statement = 1426ba910           
         Attribute = SQL_ATTR_ROW_BIND_TYPE           
         Value = 32f0           
         StrLen = 0
[ODBC][16253182][26989][2016-06-02 07:22:10.216][SQLSetStmtAttr.c][880]
      Exit:[SQL_SUCCESS]
[ODBC][16253182][26989][2016-06-02 07:22:10.216][SQLSetStmtAttr.c][258]
      Entry:           
         Statement = 1426ba910           
         Attribute = SQL_ATTR_ROW_ARRAY_SIZE           
         Value = 20           
         StrLen = 0
[ODBC][16253182][26989][2016-06-02 07:22:10.216][SQLSetStmtAttr.c][880]
      Exit:[SQL_SUCCESS]
[ODBC][16253182][26989][2016-06-02 07:22:10.216][SQLSetStmtAttr.c][258]
      Entry:           
         Statement = 1426ba910           
         Attribute = SQL_ATTR_ROWS_FETCHED_PTR           
         Value = 120c83610           
         StrLen = 0
[ODBC][16253182][26989][2016-06-02 07:22:10.216][SQLSetStmtAttr.c][880]
      Exit:[SQL_SUCCESS]
[ODBC][16253182][26989][2016-06-02 07:22:10.216][SQLSetStmtAttr.c][258]
      Entry:           
         Statement = 1426ba910           
         Attribute = SQL_ATTR_ROW_STATUS_PTR           
         Value = 13aa0c890           
         StrLen = 0
[ODBC][16253182][26989][2016-06-02 07:22:10.216][SQLSetStmtAttr.c][880]
      Exit:[SQL_SUCCESS]
[ODBC][16253182][26989][2016-06-02 07:22:10.216][SQLFetchScroll.c][155]
      Entry:           
         Statement = 1426ba910           
         Fetch Orentation = 1           
         Fetch Offset = 0
[ODBC][16253182][26989][2016-06-02 07:22:10.216][SQLFetchScroll.c][342]
      Exit:[SQL_SUCCESS]


And then a lot of this entries:

Code:
[ODBC][16253182][26989][2016-06-02 07:22:10.216][SQLColAttribute.c][286]
      Entry:           
         Statement = 1426ba910           
         Column Number = 1           
         Field Identifier = SQL_DESC_LABEL           
         Character Attr = 1253ad9e0           
         Buffer Length = 144           
         String Length = 1253ad9b6           
         Numeric Attribute = 0
[ODBC][16253182][26989][2016-06-02 07:22:10.216][SQLColAttribute.c][657]
      Exit:[SQL_SUCCESS]


Then the error suddenly appears:

Code:
[ODBC][16253182][26989][2016-06-02 07:22:10.222][SQLColAttribute.c][657]
      Exit:[SQL_SUCCESS]
[ODBC][16253182][26989][2016-06-02 07:22:10.222][SQLFetchScroll.c][155]
      Entry:           
         Statement = 1426ba910           
         Fetch Orentation = 1           
         Fetch Offset = 0
[ODBC][16253182][26989][2016-06-02 07:22:10.222][SQLFetchScroll.c][342]
      Exit:[SQL_NO_DATA]
[ODBC][16253182][26989][2016-06-02 07:22:10.222][SQLFreeStmt.c][140]
      Entry:           
         Statement = 1426ba910           
         Option = 2
[ODBC][16253182][26989][2016-06-02 07:22:10.222][SQLFreeStmt.c][246]
      Exit:[SQL_SUCCESS]
[ODBC][16253182][26989][2016-06-02 07:22:10.222][SQLFreeStmt.c][140]
      Entry:           
         Statement = 1426ba910           
         Option = 0
[ODBC][16253182][26989][2016-06-02 07:22:10.222][SQLFreeStmt.c][246]
      Exit:[SQL_ERROR]
[ODBC][16253182][26989][2016-06-02 07:22:10.223][SQLTransact.c][181]
      Entry:               
         Environment = 0               
         Connection = 13d776370               
         Completion Type = 0
[ODBC][16253182][26989][2016-06-02 07:22:10.223][SQLTransact.c][366]
      Exit:[SQL_ERROR]
      DIAG [08S01] [IBM][ODBC Oracle Wire Protocol driver][Oracle]ORA-03114: not connected to ORACLE

      DIAG [08S01] [IBM][ODBC Oracle Wire Protocol driver][Oracle]Connection Dead.

[ODBC][16253182][26989][2016-06-02 07:22:10.223][SQLError.c][430]
      Entry:               
         Connection = 13d776370               
         SQLState = 1253b12c8               
         Native = 1253b12c4               
         Message Text = 122932fd0               
         Buffer Length = 1024               
         Text Len Ptr = 1253b12a4
[ODBC][16253182][26989][2016-06-02 07:22:10.223][SQLError.c][467]
      Exit:[SQL_SUCCESS]                   
         SQLState = 08S01                   
         Native = 1253b12c4 -> -4                   
         Message Text = [[unixODBC][IBM][ODBC Oracle Wire Protocol driver][Oracle]Connection Dead.]
[ODBC][16253182][26989][2016-06-02 07:22:10.223][SQLError.c][430]
      Entry:               
         Connection = 13d776370               
         SQLState = 1253b12c8               
         Native = 1253b12c4               
         Message Text = 122932fd0               
         Buffer Length = 1024               
         Text Len Ptr = 1253b12a4
[ODBC][16253182][26989][2016-06-02 07:22:10.223][SQLError.c][467]
      Exit:[SQL_SUCCESS]                   
         SQLState = 08S01                   
         Native = 1253b12c4 -> -3114                   
         Message Text = [[unixODBC][IBM][ODBC Oracle Wire Protocol driver][Oracle]ORA-03114: not connected to ORACLE]
[ODBC][16253182][26989][2016-06-02 07:22:10.223][SQLError.c][430]
      Entry:               
         Connection = 13d776370               
         SQLState = 1253b12c8               
         Native = 1253b12c4               
         Message Text = 122932fd0               
         Buffer Length = 1024               
         Text Len Ptr = 1253b12a4
[ODBC][16253182][26989][2016-06-02 07:22:10.223][SQLError.c][467]
      Exit:[SQL_NO_DATA]
[ODBC][16253182][26989][2016-06-02 07:22:10.223][SQLFreeStmt.c][140]
      Entry:           
         Statement = 1426ba910           
         Option = 1
[ODBC][16253182][26989][2016-06-02 07:22:10.223][SQLFreeHandle.c][378]
      Entry:
         Handle Type = 3
         Input Handle = 1426ba910
[ODBC][16253182][26989][2016-06-02 07:22:10.224][SQLFreeHandle.c][480]
      Exit:[SQL_SUCCESS]
[ODBC][16253182][26989][2016-06-02 07:22:10.224][SQLTransact.c][181]
      Entry:               
         Environment = 0               
         Connection = 13d776370               
         Completion Type = 0
[ODBC][16253182][26989][2016-06-02 07:22:10.224][SQLTransact.c][366]
      Exit:[SQL_ERROR]
      DIAG [08S01] [IBM][ODBC Oracle Wire Protocol driver][Oracle]ORA-03114: not connected to ORACLE

[ODBC][16253182][26989][2016-06-02 07:22:10.224][SQLError.c][430]
      Entry:               
         Connection = 13d776370               
         SQLState = 1253b0420               
         Native = 1253b0428               
         Message Text = 117c7b370               
         Buffer Length = 1024               
         Text Len Ptr = 1253b0416
[ODBC][16253182][26989][2016-06-02 07:22:10.224][SQLError.c][467]
      Exit:[SQL_SUCCESS]                   
         SQLState = 08S01                   
         Native = 1253b0428 -> -3114                   
         Message Text = [[unixODBC][IBM][ODBC Oracle Wire Protocol driver][Oracle]ORA-03114: not connected to ORACLE]


An then, after that it seems like a re connection:

Code:

[ODBC][16253182][26989][2016-06-02 07:22:10.224][SQLError.c][430]
      Entry:               
         Connection = 13d776370               
         SQLState = 1253b0420               
         Native = 1253b0428               
         Message Text = 117c7b370               
         Buffer Length = 1024               
         Text Len Ptr = 1253b0416
[ODBC][16253182][26989][2016-06-02 07:22:10.224][SQLError.c][467]
      Exit:[SQL_NO_DATA]
[ODBC][16253182][26989][2016-06-02 07:22:10.224][SQLDisconnect.c][204]
      Entry:           
         Connection = 13d776370
[ODBC][16253182][26989][2016-06-02 07:22:10.225][SQLDisconnect.c][341]
      Exit:[SQL_SUCCESS]
[ODBC][16253182][26989][2016-06-02 07:22:10.225][SQLFreeHandle.c][279]
      Entry:
         Handle Type = 2
         Input Handle = 13d776370
[ODBC][16253182][26989][2016-06-02 07:22:10.225][SQLFreeHandle.c][330]
      Exit:[SQL_SUCCESS]
[ODBC][16253182][26989][2016-06-02 07:22:11.241][SQLAllocHandle.c][364]
      Entry:
         Handle Type = 2
         Input Handle = 13c859a10
[ODBC][16253182][26989][2016-06-02 07:22:11.241][SQLAllocHandle.c][482]
      Exit:[SQL_SUCCESS]
         Output Handle = 117cc23d0
[ODBC][16253182][26989][2016-06-02 07:22:11.241][SQLSetConnectAttr.c][321]
      Entry:           
         Connection = 117cc23d0           
         Attribute = SQL_ATTR_AUTOCOMMIT           
         Value = 0           
         StrLen = 0
[ODBC][16253182][26989][2016-06-02 07:22:11.241][SQLSetConnectAttr.c][504]
      Exit:[SQL_SUCCESS]
[ODBC][16253182][26989][2016-06-02 07:22:11.241][SQLSetConnectAttr.c][321]
      Entry:           
         Connection = 117cc23d0           
         Attribute = 2535           
         Value = 0           
         StrLen = 0
[ODBC][16253182][26989][2016-06-02 07:22:11.241][SQLSetConnectAttr.c][504]
      Exit:[SQL_SUCCESS]
[ODBC][16253182][26989][2016-06-02 07:22:11.241][SQLConnect.c][3621]
      Entry:           
         Connection = 117cc23d0           
         Server Name = [MYDATASOURCENAME][length = 12 (SQL_NTS)]           
         User Name = [MYUSERNAME][length = 11 (SQL_NTS)]           
         Authentication = [*************][length = 13 (SQL_NTS)]
      UNICODE Using encoding ASCII 'ISO8859-1' and UNICODE 'UCS-2BE'

[ODBC][16253182][26989][2016-06-02 07:22:11.727][SQLConnect.c][4195]
      Exit:[SQL_SUCCESS]
[ODBC][16253182][26989][2016-06-02 07:22:11.727][SQLSetConnectAttr.c][321]
      Entry:           
         Connection = 117cc23d0           
         Attribute = SQL_ATTR_AUTOCOMMIT           
         Value = 0           
         StrLen = 0
[ODBC][16253182][26989][2016-06-02 07:22:11.727][SQLSetConnectAttr.c][675]
      Exit:[SQL_SUCCESS]
[ODBC][16253182][26989][2016-06-02 07:22:11.727][SQLGetInfo.c][546]
      Entry:           
         Connection = 117cc23d0           
         Info Type = SQL_DBMS_NAME (17)           
         Info Value = 1253b0c78           
         Buffer Length = 64           
         StrLen = 1253b0c50
[ODBC][16253182][26989][2016-06-02 07:22:11.727][SQLGetInfo.c][609]
      Exit:[SQL_SUCCESS]
[ODBC][16253182][26989][2016-06-02 07:22:11.727][SQLSetConnectOption.c][262]
      Entry:           
         Connection = 117cc23d0           
         Option = 1041           
         Value = 39800972
[ODBC][16253182][26989][2016-06-02 07:22:11.727][SQLSetConnectOption.c][525]
      Exit:[SQL_SUCCESS]
[ODBC][16253182][26989][2016-06-02 07:22:11.727][SQLSetConnectOption.c][262]
      Entry:           
         Connection = 117cc23d0           
         Option = 1042           
         Value = 39800984
[ODBC][16253182][26989][2016-06-02 07:22:11.727][SQLSetConnectOption.c][525]
      Exit:[SQL_SUCCESS]
[ODBC][16253182][26989][2016-06-02 07:22:11.727][SQLSetConnectAttr.c][321]
      Entry:           
         Connection = 117cc23d0           
         Attribute = 1061           
         Value = 2           
         StrLen = 0
[ODBC][16253182][26989][2016-06-02 07:22:11.727][SQLSetConnectAttr.c][675]
      Exit:[SQL_SUCCESS]
[ODBC][16253182][26989][2016-06-02 07:22:11.729][SQLAllocHandle.c][529]
      Entry:
         Handle Type = 3
         Input Handle = 117cc23d0
[ODBC][16253182][26989][2016-06-02 07:22:11.729][SQLAllocHandle.c][1064]
      Exit:[SQL_SUCCESS]
         Output Handle = 122939010
[ODBC][16253182][26989][2016-06-02 07:22:11.729][SQLFreeStmt.c][140]
      Entry:           
         Statement = 122939010           
         Option = 0
[ODBC][16253182][26989][2016-06-02 07:22:11.729][SQLFreeStmt.c][246]
      Exit:[SQL_SUCCESS]
[ODBC][16253182][26989][2016-06-02 07:22:11.729][SQLPrepare.c][192]
      Entry:           
         Statement = 122939010           
         SQL = [select * from table(MYSCHEMA.MYFUNCTION(?,?,?));][length = 69 (SQL_NTS)]
[ODBC][16253182][26989][2016-06-02 07:22:11.731][SQLPrepare.c][367]
      Exit:[SQL_SUCCESS]
[ODBC][16253182][26989][2016-06-02 07:22:11.731][SQLDescribeParam.c][181]
      Entry:           
         Statement = 122939010           
         Parameter Number = 1           
         SQL Type = 1253adf84           
         Param Def = 1253adfe0           
         Scale = 1253adf82           
         Nullable = 1253adf80
[ODBC][16253182][26989][2016-06-02 07:22:11.731][SQLDescribeParam.c][331]
      Exit:[SQL_SUCCESS]               
         SQL Type = 1253ac71c               
         Param Def = 1253ac800               
         Scale = 1253ac8e4     


I'm reading this http://www-01.ibm.com/support/docview.wss?uid=swg21471232:

Quote:
Problem(Abstract)
The following error may be seen in your Initiate hub engine logs:

ERROR ODBC [08S01] [DataDirect][ODBC Oracle Wire Protocol driver][Oracle]Connection Dead. (DBError=-4)
Resolving the problem
This error is commonly due to exhausting Oracle resources. Have your DBA review workload reports and alert logs.


I'm starting to think that in fact this could be a resource database problem, because the connection seems to be open and then suddenly the error appears.

I know this is heavy to read. But, does this information gives you some light on where to dig or where the root problem is?

Any comment is very appreciated.

Kind regards.

Last edited by nelson on Thu Jun 02, 2016 10:33 am; edited 1 time in total
Back to top
View user's profile Send private message
mqjeff
PostPosted: Thu Jun 02, 2016 8:07 am    Post subject: Reply with quote

Grand Master

Joined: 25 Jun 2008
Posts: 17447
It does sound like a problem on the database side of things... unless there's any indication of a network problem on the broker runtime machine.
_________________
chmod -R ugo-wx /
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic  Reply to topic Goto page 1, 2  Next Page 1 of 2

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » Oracle Dead Connection
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.