| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| Database error: SQL State '78'; Native Error Code '0' |
« View previous topic :: View next topic » |
| Author |
Message
|
| chargie |
 Posted: Thu Sep 21, 2006 9:08 pm Post subject: Database error: SQL State '78'; Native Error Code '0' |
 |
|
Novice
Joined: 21 Sep 2006
Posts: 10
|
First I describe my environment:
Machine A: WebSphere Message Broker Toolkit 6.0.0.1, Windows XP
Machine B: WebSphere Message Broker 6.0, MQ 6.0, DB2 V8.1 (only used for broker database), RAC 6.0, RH EL AS 3.0
Machine C: DB2 V8.2 (database used in Database node of message flow), Linux
I've copied a odbc.ini from message broker installing directory/merant to /var/mqsi/odbc/.odbc.ini, and added two datasource, one for broker database, one for user database. Before this I've cataloged the user database on machine B.
I successfully created queue manager, configuration manager and broker, and also successfully connected to configuration manager from toolkit on machine A. I deployed a message flow within which there is a database node, and ESQL code is inserting data into database which is actually on machine C.
But once I put message into MQInput node, alwasy I got failed, and the system log in /var/log/messages said that
Database error: SQL State '78'; Native Error Code '0'; Error Text '523 76'. (whole messages can be found in the end)
I've searched MQSeries.net and found a similar one, in which people pointed out this link http://knowledgebase.datadirect.com/kbase.nsf/SupportLink+Online/2464618PF
I did exactly everything mentioned in it...
I am gonna try to delete whold bunch of things and try to do them once again, but before that I wonder anyone here have met similar situation before, who might give me some clue what the hell is the reason...
system log
----------------------------------------------------------------------------
Sep 21 11:03:45 gwpcwps WebSphere Broker v6000[17870]: (WMB_BROKER.default)[166812592]BIP2628E: Exception condition detected on input node 'com.ibm.sgl.git.ogrd.poc.tlog.TLog2DB.MQInput'. : WMB_BROKER.0a1144cb-0d01-0000-0080-c0e43dc47333: /build/S000_P/src/DataFlowEngine/ImbCommonInputNode.cpp: 1013: ImbCommonInputNode::run: ComIbmMQInputNode: com/ibm/sgl/git/ogrd/poc/tlog/TLog2DB#FCMComposite_1_1
Sep 21 11:03:45 gwpcwps WebSphere Broker v6000[17870]: (WMB_BROKER.default)[166812592]BIP2230E: Error detected whilst processing a message in node 'com.ibm.sgl.git.ogrd.poc.tlog.TLog2DB.Database'. : WMB_BROKER.0a1144cb-0d01-0000-0080-c0e43dc47333: /build/S000_P/src/DataFlowEngine/ImbDatabaseNode.cpp: 295: ImbDatabaseNode::evaluate: ComIbmDatabaseNode: com/ibm/sgl/git/ogrd/poc/tlog/TLog2DB#FCMComposite_1_2
Sep 21 11:03:45 gwpcwps WebSphere Broker v6000[17870]: (WMB_BROKER.default)[166812592]BIP2321E: Database error: ODBC return code '-1'. : WMB_BROKER.0a1144cb-0d01-0000-0080-c0e43dc47333: /build/S000_P/src/DataFlowEngine/ImbOdbc.cpp: 232: ImbOdbcHandle::checkRcInner: :
Sep 21 11:03:45 gwpcwps WebSphere Broker v6000[17870]: (WMB_BROKER.default)[166812592]BIP2322E: Database error: SQL State '78'; Native Error Code '0'; Error Text '523 76'. : WMB_BROKER.0a1144cb-0d01-0000-0080-c0e43dc47333: /build/S000_P/src/DataFlowEngine/ImbOdbc.cpp: 360: ImbOdbcHandle::checkRcInner: :
Sep 21 11:03:46 gwpcwps WebSphere Broker v6000[17870]: (WMB_BROKER.default)[166812592]BIP2648E: Message backed out to a queue; node 'com.ibm.sgl.git.ogrd.poc.tlog.TLog2DB.MQInput'. : WMB_BROKER.0a1144cb-0d01-0000-0080-c0e43dc47333: /build/S000_P/src/DataFlowEngine/ImbMqInputNode.cpp: 1819: ImbCommonInputNode::eligibleForBackout: ComIbmMQInputNode: com/ibm/sgl/git/ogrd/poc/tlog/TLog2DB#FCMComposite_1_1 |
|
| Back to top |
|
 |
| chargie |
| Posted: Fri Sep 22, 2006 10:16 pm Post subject: Let me simply me problem |
|
|
Novice
Joined: 21 Sep 2006
Posts: 10
|
Seems my problem is desribed too complicated...
Well, this morning, I redo every step. there are some steps I think might be related to the problem.
I logon as root, copy sample odbc.ini file to /var/mqsi/odbc, and add two stanzas for broker database and user database
Still logon as root, modify the /etc/profile and export ODBCINI=/var/mqsi/odbc/odbc.ini in it.
Then change to user git, which belongs to both mqm and mqbrkrs groups, first I run mqsiprofile script, then I try to create borker, the problem comes out "unable to connect to database", and the error message is exactly same as the one I am trying to use database node in message flow.
All for sudden, i remember mqsiprofile change the ODBCINI variable to /var/mqsi/odbc/.odbc.ini, then I copy odbc.ini to .odbc.ini in the same direclty (I also changed both these two files' permission to mqm:mqbrkrs implied in Info Center), this time creating broker is successful.
So I conclude my question:
1. In terminal, we can manually define the ODBCINI variable to a file I've already modified, but for the broker deployed remotely (deploy from machine A to machine B), where it's gonna go to fine ODBCINI? is it /var/mqsi/odbc/.odbc.ini?
2. In info center of Message Broker, odbc.ini is supposed to be changed to mqm:mqbrkrs file permission, what does this exactly mean, change the owner to mqm and group to mqbrkrs?
Any help or hint will be very appreciated  |
|
| Back to top |
|
|
| jefflowrey |
| Posted: Sat Sep 23, 2006 4:00 am Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
The odbc file pointed to by the environment in mqsiprofile is going to be the one that is used always.
Every broker command you run - mqsistart, etc.- should always be done with mqsiprofile being sourced into the environment first.
And yes, mqm:mqbrkrs file permission means "chown mqm:mqbrkrs /var/mqsi/odbc/.odbc.ini"
Or "chown mqm /var/mqsi/odbc/.odbc.ini" followed by "chgrp mqbrkrs /var/mqsi/odbc/.odbc.ini".
_________________
I am *not* the model of the modern major general. |
|
| Back to top |
|
|
| chargie |
| Posted: Sun Sep 24, 2006 4:32 am Post subject: got it |
|
|
Novice
Joined: 21 Sep 2006
Posts: 10
|
thanks, yesterday I succesfully turned on the ODBC trace. (actually I tried before, but failed, maybe file permission problem)
from that I found some clue, seems the message flow is still using a datasource name which I've changed. Because this message is developed by other and he is using a different datasource.
It's really wired, means what I've changed in toolkit workbench did not actually affect the database node and message flow which is deployed several times.
I am trying to create a whole new message flow with new database node in which I define the datasource for my scenario.
Let's see what's gonna happen |
|
| Back to top |
|
|
| jefflowrey |
| Posted: Sun Sep 24, 2006 5:03 am Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
If you have turned off "build automatically", then when you go to re-add a flow to your BAR file, the old version will still be picked up.
_________________
I am *not* the model of the modern major general. |
|
| 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
|
|
|
|
