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 Interchange Server + Adapters » Wisdom JDBC Connector suddenly stopped in between the flow

Post new topic  Reply to topic
 Wisdom JDBC Connector suddenly stopped in between the flow « View previous topic :: View next topic » 
Author Message
sbellala22
PostPosted: Thu Jul 28, 2011 10:45 pm    Post subject: Wisdom JDBC Connector suddenly stopped in between the flow Reply with quote

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
View user's profile Send private message
mqjeff
PostPosted: Fri Jul 29, 2011 4:48 am    Post subject: Reply with quote

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
View user's profile Send private message
sbellala22
PostPosted: Sun Aug 07, 2011 11:17 pm    Post subject: Reply with quote

Novice

Joined: 20 Apr 2010
Posts: 17

Ok for Resolving this issue , weather we need to change JDBC Connector Specific Properties.
Back to top
View user's profile Send private message
sbellala22
PostPosted: Wed Aug 10, 2011 3:08 am    Post subject: Reply with quote

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
View user's profile Send private message
sbellala22
PostPosted: Sun Aug 28, 2011 8:54 pm    Post subject: Reply with quote

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
View user's profile Send private message
Vitor
PostPosted: Mon Aug 29, 2011 4:24 am    Post subject: Reply with quote

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
View user's profile Send private message
fjb_saper
PostPosted: Mon Aug 29, 2011 5:46 am    Post subject: Reply with quote

Grand High Poobah

Joined: 18 Nov 2003
Posts: 20696
Location: LI,NY

Did the DB password being used by the jdbc connection change recently in production?
_________________
MQ & Broker admin
Back to top
View user's profile Send private message Send e-mail
sbellala1984
PostPosted: Mon Sep 12, 2011 1:10 am    Post subject: Reply with quote

Newbie

Joined: 02 Sep 2011
Posts: 2

No we didn't change DB Passwords
Back to top
View user's profile Send private message
sbellala1984
PostPosted: Mon Sep 12, 2011 1:12 am    Post subject: Reply with quote

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
View user's profile Send private message
Vitor
PostPosted: Mon Sep 12, 2011 4:26 am    Post subject: Reply with quote

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
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 Interchange Server + Adapters » Wisdom JDBC Connector suddenly stopped in between the flow
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.