| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| Connection problem from flow to SQL Server DB |
« View previous topic :: View next topic » |
| Author |
Message
|
| brokerman111 |
 Posted: Mon Jun 15, 2009 12:17 am Post subject: Connection problem from flow to SQL Server DB |
 |
|
Newbie
Joined: 18 May 2009
Posts: 3
|
Hi,
I have Message broker 6.0, running on Linux. I have also SQL Server 2005 Express, running on Windows XP. I have some problems in reconnecting to DB from flow. Please find below couple of scenarios.
Scenario #1
1. xml file is written to QUEUE1.IN with rfhutil.
2. SQL Server is running.
3. Mainflow#1 reads the message from QUEUE1.IN and inserts data in SQL Server DB.
4. Works OK.
Scenario #2
1. xml file is written to QUEUE1.IN with rfhutil.
2. SQL Server is NOT running.
3. Mainflow#1 reads the message from QUEUE1.IN and could not insert data in SQL Server DB. Mainflow#1 writes the message in queue RETRY1.IN.
4. Works OK so far.
5. Now I start SQL Server.
6. Mainflow#2 has a TimeoutNotification -node as a first node, which is configured to run every 120sec. MQGet -node reads messages from queue RETRY1.IN
7. Insert to DB fails (see error below). If I now use rfhutil to write a new message QUEUE1.IN and the Mainflow#1 reads it, everything works ok (insert to DB is ok).
8. If I restart the Mainflow#2, then DB insert works OK from the flow, which is described at item 6.
Error text at item 7:
| Code: |
2009-06-11 14:08:35.344177~74106720 DatabaseException BIP2321E: Database error: ODBC return code '-1'.
The message broker encountered an error whilst executing a database operation. The ODBC return code was '-1'. See the following messages for information obtained from the database pertaining to this error.
Use the following messages to determine the cause of the error. This is likely to be such things as incorrect datasource or table names. Then correct either the database or message broker configuration. |
Datasource or table names are ok, cause code is not touched when running these scenarios.
Has someone encountered this kind of behaviour? Has anyone any ideas?
Thanks!
BR,
--
P.V. |
|
| 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
|
|
|
|
