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 » request urgent BIP 2393 E

Post new topic  Reply to topic
 request urgent BIP 2393 E « View previous topic :: View next topic » 
Author Message
giridhararm
PostPosted: Tue Feb 21, 2012 9:27 am    Post subject: request urgent BIP 2393 E Reply with quote

Apprentice

Joined: 22 Apr 2009
Posts: 28

HI there

i installed db2 mQ AND MB8 IN VMWARE

AM GETTING BELOW ERROR

( MB8BROKER.X ) Message backed out to a queue; node 'ESQL_Create_Customer_Account.ESQL_BOOKSTORE_CCA_IN'.

Node 'ESQL_Create_Customer_Account.ESQL_BOOKSTORE_CCA_IN' has received a message which has previously been backed out one or more times because of a processing error in the main path of the message flow. The failure terminal is not attached, so the message broker is putting the message directly to the requeue or dead letter backout queue associated with this node. The MQMD 'backoutCount' of the message now equals the 'backoutThreshold' defined for the WebSphere MQ input queue.

Examine previous messages and the message flow to determine why the message is being backed out. Correct this situation if possible.

( MB8BROKER.X ) Message backed out to a queue; node 'ESQL_Create_Customer_Account.ESQL_BOOKSTORE_CCA_IN'.

Node 'ESQL_Create_Customer_Account.ESQL_BOOKSTORE_CCA_IN' has received a message which has previously been backed out one or more times because of a processing error in the main path of the message flow. The failure terminal is not attached, so the message broker is putting the message directly to the requeue or dead letter backout queue associated with this node. The MQMD 'backoutCount' of the message now equals the 'backoutThreshold' defined for the WebSphere MQ input queue.

Examine previous messages and the message flow to determine why the message is being backed out. Correct this situation if possible.

MB8BROKER.X ) Database error: ODBC return code '-1' from data source ''BSTOREDB'' using ODBC driver manager ''odbc32.dll''.

The broker received an error when processing a database operation. The ODBC return code was '-1'. See the following messages for information obtained from the database about this error.

Use the following messages to determine the cause of the error. Typical problems are an incorrect data source, or table names. Correct either the database or the broker configuration.

( MB8BROKER.X ) Error detected whilst processing a message in node 'ESQL_Create_Customer_Account.Database'.

The message broker detected an error whilst processing a message in node 'ESQL_Create_Customer_Account.Database'. An exception has been thrown to cut short the processing of the message.

See the following messages for details of the error.


( MB8BROKER.X ) Exception condition detected on input node 'ESQL_Create_Customer_Account.ESQL_BOOKSTORE_CCA_IN'.

The input node 'ESQL_Create_Customer_Account.ESQL_BOOKSTORE_CCA_IN' detected an error whilst processing a message. The message flow has been rolled-back and, if the message was being processed in a unit of work, it will remain on the input queue to be processed again. Following messages will indicate the cause of this exception.
Back to top
View user's profile Send private message Send e-mail
smdavies99
PostPosted: Tue Feb 21, 2012 9:34 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.

Code:

MB8BROKER.X ) Database error: ODBC return code '-1' from data source ''BSTOREDB'' using ODBC driver manager ''odbc32.dll''.

The broker received an error when processing a database operation. The ODBC return code was '-1'. See the following messages for information obtained from the database about this error.


So have you looked at all the numerous other posts in this forum that has this very same error?

If you have, have you checked that you have configured it all correctly?
_________________
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
Vitor
PostPosted: Tue Feb 21, 2012 9:34 am    Post subject: Re: request urgent BIP 2393 E Reply with quote

Grand High Poobah

Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA

giridhararm wrote:
i installed db2 mQ AND MB8 IN VMWARE


Congratulations. What versions of WMQ & DB2?

giridhararm wrote:
MB8BROKER.X ) Database error: ODBC return code '-1' from data source ''BSTOREDB'' using ODBC driver manager ''odbc32.dll''.


I'd check that the ODBC is working through non-WMB tools, then think about an ODBC trace to trap any additional details.
_________________
Honesty is the best policy.
Insanity is the best defence.
Back to top
View user's profile Send private message
giridhararm
PostPosted: Tue Feb 21, 2012 9:44 am    Post subject: Reply with quote

Apprentice

Joined: 22 Apr 2009
Posts: 28

AM NEW TO MB

I ISNTALLED DB2 9 AND MB8 and i used defualt configuration

i run all this commands i dont know where going wrong

mqsireload MB8BROKER -e x


mqsicvp MB8BROKER -n BSTREDB


mqsicvp MB8BROKER –n BSTREDB –u db2admin –p db2admin


mqsiservice MB8BROKER -r DataSourceName=BSTREDB
Back to top
View user's profile Send private message Send e-mail
giridhararm
PostPosted: Tue Feb 21, 2012 9:45 am    Post subject: Reply with quote

Apprentice

Joined: 22 Apr 2009
Posts: 28

my os is win xp
Back to top
View user's profile Send private message Send e-mail
smdavies99
PostPosted: Tue Feb 21, 2012 9:52 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.

Why did you use a

mqsisetdbparms

command?

Methinks you might need some training perhaps?
_________________
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
Vitor
PostPosted: Tue Feb 21, 2012 9:53 am    Post subject: Reply with quote

Grand High Poobah

Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA

giridhararm wrote:
mqsicvp MB8BROKER -n BSTREDB


mqsicvp MB8BROKER –n BSTREDB –u db2admin –p db2admin


What were the results of these commands? If they worked you need an ODBC trace to work out what's wrong with the query the ESQL is using. If the first one didn't but the second one did you need an mqsisetdbparms command as well. I'll hazard a guess (if both worked) that it's one of the sample flows & the database you're using is incorrectly set up.

giridhararm wrote:
mqsiservice MB8BROKER -r DataSourceName=BSTREDB


Why this? That could break something that was working.
_________________
Honesty is the best policy.
Insanity is the best defence.


Last edited by Vitor on Tue Feb 21, 2012 9:55 am; edited 1 time in total
Back to top
View user's profile Send private message
giridhararm
PostPosted: Tue Feb 21, 2012 9:53 am    Post subject: Reply with quote

Apprentice

Joined: 22 Apr 2009
Posts: 28

yes i am learning on by own pls help me
Back to top
View user's profile Send private message Send e-mail
giridhararm
PostPosted: Tue Feb 21, 2012 9:55 am    Post subject: Reply with quote

Apprentice

Joined: 22 Apr 2009
Posts: 28

SWORD 512
SWORD * 0x0012F0EC

mqsicvp MB8BROK a00-c18 EXIT SQLErrorW with return code 0 (SQL_SUCCESS)
HENV 00000000
HDBC 00C115E8
HSTMT 00000000
WCHAR * 0x0012ED48 (NYI)
SDWORD * 0x0012F148 (0)
WCHAR * 0x0012E948 [ 91] "[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified"
SWORD 512
SWORD * 0x0012F0EC (91)
Back to top
View user's profile Send private message Send e-mail
Vitor
PostPosted: Tue Feb 21, 2012 10:02 am    Post subject: Reply with quote

Grand High Poobah

Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA

giridhararm wrote:
yes i am learning on by own pls help me


That's a road filled with pain, suffering and misery.
_________________
Honesty is the best policy.
Insanity is the best defence.
Back to top
View user's profile Send private message
Vitor
PostPosted: Tue Feb 21, 2012 10:03 am    Post subject: Reply with quote

Grand High Poobah

Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA

giridhararm wrote:
[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified"


That would appear to be the problem.

Check where & how you've defined the ODBC connection.
_________________
Honesty is the best policy.
Insanity is the best defence.
Back to top
View user's profile Send private message
giridhararm
PostPosted: Tue Feb 21, 2012 10:19 am    Post subject: Reply with quote

Apprentice

Joined: 22 Apr 2009
Posts: 28

thks all

i found it solved the issue its odbc problem
Back to top
View user's profile Send private message Send e-mail
lancelotlinc
PostPosted: Tue Feb 21, 2012 11:01 am    Post subject: Reply with quote

Jedi Knight

Joined: 22 Mar 2010
Posts: 4941
Location: Bloomington, IL USA

Vitor wrote:
giridhararm wrote:
yes i am learning on by own pls help me


That's a road filled with pain, suffering and misery.


If you have not taken the training class, and you have no mentor, and you choose not to use Google to search the Infocentre, please don't post questions in this forum.

http://www-304.ibm.com/jct03001c/services/learning/ites.wss/us/en?pageType=course_description&courseCode=WM663
_________________
http://leanpub.com/IIB_Tips_and_Tricks
Save $20: Coupon Code: MQSERIES_READER
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 » request urgent BIP 2393 E
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.