| Author |
Message
|
| sbellala22 |
 Posted: Thu Jul 28, 2011 10:45 pm Post subject: Wisdom JDBC Connector suddenly stopped in between the flow |
 |
|
Novice
Joined: 20 Apr 2010
Posts: 17
|
Wisdom JDBC Connector suddenly stopped in between the flow in Production with the below exception. And every time we are trying to restarting the JDBC Connector in Production and its effecting the Business.
we are getting below exception in wisdom connector logs::
| Code: |
[MsgID: 39005] [Mesg: Exiting setCopyAttributes()] ]
[Time: 2011/07/28 08:38:57.366] [System: ConnectorAgent] [SS: WisdomJDBCConnector] [Thread: WT=1 (#975986809)] [Type: Trace] [Mesg: :[Type: Warning] [MsgID: 37017] [Mesg: Entering method execSP()] ]
[Time: 2011/07/28 08:38:57.448] [System: ConnectorAgent] [SS: WisdomJDBCConnector] [Thread: WT=1 (#975986809)] [Type: Error] [MsgID: 37010] [Mesg: Stored Procedure Execution Failed: java.sql.SQLException: Io exception: Connection reset]
[Time: 2011/07/28 08:38:57.449] [System: ConnectorAgent] [SS: WisdomJDBCConnector] [Thread: WT=1 (#975986809)] [Type: Error] [MsgID: 37005] [Mesg: DBManager Operation Failed]
[Time: 2011/07/28 08:38:57.449] [System: ConnectorAgent] [SS: WisdomJDBCConnector] [Thread: WT=1 (#975986809)] [Type: Error] [MsgID: 35015] [Mesg: Retrieve Operation failed on the BusinessObject DB_INS_WBI_REQUEST_PROC]
[Time: 2011/07/28 08:38:57.449] [System: ConnectorAgent] [SS: WisdomJDBCConnector] [Thread: WT=1 (#975986809)] [Type: Trace] [Mesg: :<StartHeader>
<Version = 3.0>
<EndHeader>
<StartBO:DB_INS_WBI_REQUEST_PROC>
BusinessObject = DB_INS_WBI_REQUEST_PROC
Verb = Retrieve
Locale = en_US
PORDERNUMBER = 000000
PWBIREQUESTID = 0
RetrieveSP = CxIgnore
ObjectEventId = CxCommon.BusinessObject@54a39200
<EndBO:DB_INS_WBI_REQUEST_PROC>]
[Time: 2011/07/28 08:38:57.449] [System: ConnectorAgent] [SS: WisdomJDBCConnector] [Thread: WT=1 (#975986809)] [Type: Error] [MsgID: 35022] [Mesg: Rollback failed on retrieve java.sql.SQLException: Io exception: There is no process to read data written to a pipe..]
[Time: 2011/07/28 08:38:57.449] [System: ConnectorAgent] [SS: WisdomJDBCConnector] [Thread: WT=1 (#975986809)] [Type: Trace] [Mesg: :[Type: Warning] [MsgID: 34012] [Mesg: Entering method releaseConnection.] ]
[Time: 2011/07/28 08:38:57.449] [System: ConnectorAgent] [SS: WisdomJDBCConnector] [Thread: WT=1 (#975986809)] [Type: Trace] [Mesg: :[Type: Warning] [MsgID: 34013] [Mesg: Exiting method releaseConnection.] ]
[Time: 2011/07/28 08:38:57.452] [System: ConnectorAgent] [SS: WisdomJDBCConnector] [Thread: WT=1 (#975986809)] [Type: Error] [MsgID: 10556] [Mesg: Message key 10556 :: /opt/IBM/IPTVWebSphereAdapters/connectors/messages/CwConnectorAgentMessages.txt does not contain the text for this message.]
[Time: 2011/07/28 08:38:57.452] [System: ConnectorAgent] [SS: WisdomJDBCConnector] [Thread: WT=1 (#975986809)] [Type: Trace] [Mesg: :
com.crossworlds.cwconnectorapi.exceptions.VerbProcessingFailedException: [Type: Error] [MsgID: 37010] [Mesg: Stored Procedure Execution Failed: java.sql.SQLException: Io exception: Connection reset]
at com.crossworlds.connectors.JDBC.JDBCBOhandler.doVerbFor(JDBCBOhandler.java:1275)
at com.crossworlds.cwconnectorapi.CWConnectorBOHandler.doVerbFor(CWConnectorBOHandler.java:127)
at CxCommon.BusinessObject.doVerbFor(BusinessObject.java(Compiled Code))
at AppSide_Connector.BusObjJavaInterface.DoVerbFor(BusObjJavaInterface.java:255)
at AppSide_Connector.AppCalls.DoVerbFor(AppCalls.java:266)
at AppSide_Connector.AgentBusinessObjectManager.DoVerbFor(AgentBusinessObjectManager.java:1777)
at CxCommon.Messaging.IIOP.IDLAgent.IpostBusObj(IDLAgent.java:217)
at IdlStubs.IConnAgentPOA._invoke(IConnAgentPOA.java(Compiled Code))]
at com.ibm.rmi.poa.GenericPOAServerSC.dispatchToServant(GenericPOAServerSC.java(Compiled Code))
[Time: 2011/07/28 08:38:57.452] [System: ConnectorAgent] [SS: WisdomJDBCConnector] [Thread: WT=1 (#975986809)] [Type: Trace] [Mesg: :[9543] DoVerbFor cookie=Tue Jul 26 22:46:53 AST 2011 rc=-1 rtnObj.status=-1 rtnObj.message=[Type: Error] [MsgID: 37010] [Mesg: Stored Procedure Execution Failed: java.sql.SQLException: Io exception: Connection reset] ]
[Time: 2011/07/28 08:39:16.566] [System: ConnectorAgent] [SS: WisdomJDBCConnector] [Thread: appPolling (#976855161)] [Type: Trace] [Mesg: :[Type: Trace] [MsgID: 17008] [Mesg: Polling every 30000 milliseconds.] ] |
*******************************************
And more over i am mention below connection properties in database connection pool::
Max connect retries :: 10
max Connections :: 100
Connection retry interval :: 60
Can any one please respond and provide any suggestion to resolve this issue |
|
| Back to top |
|
 |
| mqjeff |
| Posted: Fri Jul 29, 2011 4:48 am Post subject: |
|
|
Grand Master
Joined: 25 Jun 2008
Posts: 17447
|
| "connection reset" means either the network dropped the connection or the jdbc server dropped the connection. |
|
| Back to top |
|
|
| sbellala22 |
| Posted: Sun Aug 07, 2011 11:17 pm Post subject: |
|
|
Novice
Joined: 20 Apr 2010
Posts: 17
|
| Ok for Resolving this issue , weather we need to change JDBC Connector Specific Properties. |
|
| Back to top |
|
|
| sbellala22 |
| Posted: Wed Aug 10, 2011 3:08 am Post subject: |
|
|
Novice
Joined: 20 Apr 2010
Posts: 17
|
This is my JDBC Connector versions in Production.
TbsJDBC Connector 2.3.0
WisdomJDBC Connector 2.3.0
WBI Adapters Framework 2.6.0.11
For Resolving this issue weather we need any fix packs required. |
|
| Back to top |
|
|
| sbellala22 |
| Posted: Sun Aug 28, 2011 8:54 pm Post subject: |
|
|
Novice
Joined: 20 Apr 2010
Posts: 17
|
For resolving this issue need to change any connector specific Properties or Need to upgrade the adapter and framework fix packs.
Its Production Issue , Can any one suggest how to fix this issue.
Its very Urgent
Thanks |
|
| Back to top |
|
|
| Vitor |
| Posted: Mon Aug 29, 2011 4:24 am Post subject: |
|
|
Grand High Poobah
Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA
|
| sbellala22 wrote: |
Its Production Issue ,
...
Its very Urgent |
Then raise a PMR. You'll get a faster and more authoratative response than you will here.
_________________
Honesty is the best policy.
Insanity is the best defence. |
|
| Back to top |
|
|
| fjb_saper |
| Posted: Mon Aug 29, 2011 5:46 am Post subject: |
|
|
Grand High Poobah
Joined: 18 Nov 2003
Posts: 20756
Location: LI,NY
|
Did the DB password being used by the jdbc connection change recently in production? 
_________________
MQ & Broker admin |
|
| Back to top |
|
|
| sbellala1984 |
| Posted: Mon Sep 12, 2011 1:10 am Post subject: |
|
|
Newbie
Joined: 02 Sep 2011
Posts: 2
|
| No we didn't change DB Passwords |
|
| Back to top |
|
|
| sbellala1984 |
| Posted: Mon Sep 12, 2011 1:12 am Post subject: |
|
|
Newbie
Joined: 02 Sep 2011
Posts: 2
|
Can you please any one help me to how to raise PMR.
Provide me the steps to how to raise PMR. |
|
| Back to top |
|
|
| Vitor |
| Posted: Mon Sep 12, 2011 4:26 am Post subject: |
|
|
Grand High Poobah
Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA
|
| sbellala1984 wrote: |
Can you please any one help me to how to raise PMR.
Provide me the steps to how to raise PMR. |
Speak to whoever runs the IBM account on your site. They'll have the contact details, plus all the other material you'll need to identify yourself as a licensed customer.
_________________
Honesty is the best policy.
Insanity is the best defence. |
|
| Back to top |
|
|
|
|
