| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| intermittent Connection dead issues IIB to Oracle DB |
« View previous topic :: View next topic » |
| Author |
Message
|
| akill |
 Posted: Mon Dec 02, 2019 12:03 am Post subject: intermittent Connection dead issues IIB to Oracle DB |
 |
|
Novice
Joined: 26 Jun 2017
Posts: 16
|
Hi all,
We are getting intermittent Connection dead issues while connecting to oracle DB.
Below are the inputs from concern teams:
Notwork Team : Firewall terminates the idle connection for every 1 hr.And they are not recommending to increase the this value.
DB Team : They don't terminate any connections
Below are my flows:
1."HTTPIn-->Compute(DB Calls)-->HTTPReply-->MQOutput"
2.MQInput-->Compute(DB Calls)--HTTPRequest-->Compute(DB calls)
Message to the second flow will come from first flow using MQ Nodes.and i am interacting withe same DB in both the flows.
In my case , If we leave the flow idle and hit after 60 mins , the first hit coming after 60 mins is failing(The very first DB call in the second flow is getting failed with connection dead . and it is taking ~15 mins to give that error). Below is the Log.
| Quote: |
2019-11-25 12:21:16.939078 4707 UserTrace BIP12080I: Preparing a database statement for ''DSN''.
2019-11-25 12:21:16.939432 4707 UserTrace BIP12081I: Prepared a database statement for ''DSN''.
2019-11-25 12:36:44.994948 4707 UserTrace BIP12074I: Executing a database statement for ''DSN''.
2019-11-25 12:36:44.996716 4707 UserTrace BIP12077W: Failed to execute a database statement for ''DSN''.
2019-11-25 12:36:45.000900 4707 UserTrace BIP2231E: Error detected whilst processing a message in node 'com.rbl.integrations.RBL_ACC_OPEN_RET_CIF_ADD.ACCOPN.CIF.CREATE'.
2019-11-25 12:36:45.000936 4707 RecoverableException BIP2230E: Error detected whilst processing a message in node 'com.rbl.integrations.RBL_ACC_OPEN_RET_CIF_ADD.IdentifyCustomer'.
2019-11-25 12:36:45.000952 4707 RecoverableException BIP2488E: ('com.integrations.IdentifyCustomer_Compute.Main', '12.4') Error detected whilst executing the SQL statement ''PROPAGATE TO TERMINAL 'out1' FINALIZE DEFAULT DELETE DEFAULT;''.
2019-11-25 12:36:45.000964 4707 RecoverableException BIP2230E: Error detected whilst processing a message in node 'com.rbl.integrations.RBL_ACC_OPEN_RET_CIF_ADD.RequestMapping'.
2019-11-25 12:36:45.000992 4707 RecoverableException BIP2488E: ('com.integrations.IdentifyCustomer_Compute.Main', '6.3') Error detected whilst executing the SQL statement ''UPDATE Database.DETAILS AS AOCD SET YN = 'I' WHERE AOCD.DETAILS.AOCD_ID = Environment.variable.REFNO AND AOCD.DETAILS.CUST_PRIORITY = Environment.variable.custPriority;''.
2019-11-25 12:36:45.001012 4707 DatabaseException BIP2321E: Database error: ODBC return code '-1' using ODBC driver manager ''/opt/IBM/iib-10.0.0.7/ie02/lib/libodbcinterface.so''.
2019-11-25 12:36:45.001024 4707 DatabaseException BIP2322E: Database error: SQL State ''08S01''; Native Error Code '-4'; Error Text ''[IBM][ODBC Oracle Wire Protocol driver][Oracle]Connection Dead.''. |
Have two questions:
1.What causing the issue
2.how come we are getting connection issue in the second flow why not in the first flow as we are interacting the same DB.
3.Why is it taking 15 mins to throw the error ?
FYI we're using IIB 10.0.0.7.
Thanks in advance. |
|
| Back to top |
|
 |
| bruce2359 |
| Posted: Mon Dec 02, 2019 7:27 am Post subject: |
|
|
Poobah
Joined: 05 Jan 2008
Posts: 9486
Location: US: west coast, almost. Otherwise, enroute.
|
Please don’t double post.
Locked as a duplicate.
_________________
I like deadlines. I like to wave as they pass by.
ב''ה
Lex Orandi, Lex Credendi, Lex Vivendi. As we Worship, So we Believe, So we Live. |
|
| 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
|
|
|
|
