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 » Execution Group restarts due to error code : BIP2197E

Post new topic  Reply to topic
 Execution Group restarts due to error code : BIP2197E « View previous topic :: View next topic » 
Author Message
7207165620
PostPosted: Wed Feb 11, 2015 5:10 am    Post subject: Execution Group restarts due to error code : BIP2197E Reply with quote

Apprentice

Joined: 11 Apr 2013
Posts: 37
Hi Folks,
We are facing a serious issue on production server. We are getting below error repeatedly on user log.

Feb 11 14:34:17 IIBPROD01 IIB[30808]: IBM Integration Bus v9002 (BROKER.EG) [Thread 30994] (Msg 1/1) BIP2197E: A parsing error occurred when processing a message for data capture store 'DataCaptureStore'. The error was 'ImbOdbcConnection::checkRcInner() reported 'Root SQL exception' with values... '-1' ''/opt/ibm/IE02/2.0.1/lib/libodbcinterface.so'' Nested Item{ ImbOdbcConnection::checkRcInner() reported 'Child SQL exception' with values... ''27'' '-3114' ''[unixODBC][IBM][ODBC 20101 driver][Oracle]11605'' }'.
Feb 11 14:34:17 IIBPROD01 IIB[30808]: IBM Integration Bus v9002 (BROKER.EG) [Thread 30994] (Msg 1/1) BIP2157I: A recorded message has been backed out to the backout queue 'SYSTEM.BROKER.DC.BACKOUT'
Feb 11 14:46:54 IIBPROD01 IIB[30808]: IBM Integration Bus v9002 (BROKER.EG) [Thread 31000] (Msg 1/3) BIP2196E: A database error occurred when processing a message for the data capture store 'DataCaptureStore'.
Feb 11 14:46:54 IIBPROD01 IIB[30808]: IBM Integration Bus v9002 (BROKER.EG) [Thread 31000] (Msg 2/3) BIP2321E: Database error: ODBC return code '-1' using ODBC driver manager '/opt/ibm/IE02/2.0.1/lib/libodbcinterface.so'.
Feb 11 14:46:54 IIBPROD01 IIB[30808]: IBM Integration Bus v9002 (BROKER.EG) [Thread 31000] (Msg 1/1) BIP2157I: A recorded message has been backed out to the backout queue 'SYSTEM.BROKER.DC.BACKOUT'

and EG is restarting sometimes with below:

Feb 11 14:55:20 IIBPROD01 IIB[31431]: IBM Integration Bus v9002 (BROKER) [Thread 31482] (Msg 1/1) BIP2060W: The broker has detected that the Execution Group EG, process ID 30808, has shutdown.
Feb 11 14:55:21 IIBPROD01 IIB[16430]: IBM Integration Bus v9002 (BROKER.EG) [Thread 16430] (Msg 1/1) BIP2208I: Execution group (64) started:

We have configured event monitoring for data recording purpose( for web admin UI) through DataCaptureStore and DataCaptureSource.

Let me know for any input.

Kindly suggest.

Thanks
Back to top
View user's profile Send private message
smdavies99
PostPosted: Wed Feb 11, 2015 6:09 am    Post subject: Reply with quote

Jedi Council

Joined: 10 Feb 2003
Posts: 6076
Location: Somewhere over the Rainbow this side of Never-never land.
If this is on a Production server then asking for help here is the wrong thing to do. We have our real jobs to do.

Raise a Sev 1 PMR with IBM
_________________
WMQ User since 1999
MQSI/WBI/WMB/'Thingy' User since 2002
Linux user since 1995

Every time you reinvent the wheel the more square it gets (anon). If in doubt think and investigate before you ask silly questions.
Back to top
View user's profile Send private message
fjb_saper
PostPosted: Wed Feb 11, 2015 6:09 am    Post subject: Re: Execution Group restarts due to error code : BIP2197E Reply with quote

Grand High Poobah

Joined: 18 Nov 2003
Posts: 20756
Location: LI,NY
7207165620 wrote:
Hi Folks,
We are facing a serious issue on production server. We are getting below error repeatedly on user log.

Feb 11 14:34:17 IIBPROD01 IIB[30808]: IBM Integration Bus v9002 (BROKER.EG) [Thread 30994] (Msg 1/1) BIP2197E: A parsing error occurred when processing a message for data capture store 'DataCaptureStore'. The error was 'ImbOdbcConnection::checkRcInner() reported 'Root SQL exception' with values... '-1' ''/opt/ibm/IE02/2.0.1/lib/libodbcinterface.so'' Nested Item{ ImbOdbcConnection::checkRcInner() reported 'Child SQL exception' with values... ''27'' '-3114' ''[unixODBC][IBM][ODBC 20101 driver][Oracle]11605'' }'.

Feb 11 14:46:54 IIBPROD01 IIB[30808]: IBM Integration Bus v9002 (BROKER.EG) [Thread 31000] (Msg 2/3) BIP2321E: Database error: ODBC return code '-1' using ODBC driver manager '/opt/ibm/IE02/2.0.1/lib/libodbcinterface.so'.

So did you determine what the Oracle exception is?
This is what I got with google:
Quote:

Oracle Error: DRG-11605
Error Description:
URL store: document specified by string not found

Error Cause:
The document can not be found on the host specified.

Action:
Check URL.




_________________
MQ & Broker admin
Back to top
View user's profile Send private message Send e-mail
Display posts from previous:   
Post new topic  Reply to topic Page 1 of 1

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » Execution Group restarts due to error code : BIP2197E
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.