| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| IBM WMB v8.0.0.4 - DSN issue |
« View previous topic :: View next topic » |
| Author |
Message
|
| gabrielj |
 Posted: Tue Jun 21, 2016 12:02 am Post subject: IBM WMB v8.0.0.4 - DSN issue |
 |
|
Novice
Joined: 16 Nov 2014
Posts: 23
Location: Muscut,Perth,Sydney,Bangalore,Hydrabad,Coimbatore
|
Dear All Expert,
We have IBM WMB v8.0.0.4 installed on HP-UX Box.
and one of the DSN definition as below.
[INSIGHTDB]
Driver=/WMB/IBM/mqsi/7.0/ODBC/V6.0/lib/UKmsss24.so
Description=DataDirect 5.3 64bit SQL Server Wire Protocol
Address=xx.xx.xx.xx,yyyy
AnsiNPW=Yes
Database=insight
QuotedId=No
ColumnSizeAsCharacter=1
We have an compute node which serves response for 3 services and default DSN set as "INSIGHTDB". Two services are using default DSN and 1 service is using Database.{Schema}.xxx notation to access the DB.
INSIGHTDB was shutdown by DBA without notifying the Development team 10 days back. we have restarted broker several times for other reasons and the service which not using default DSN also working fine. From Today(Restarted Broker today as well) onward we are getting DSN related error for that service.
Can you anybody provide the clear picture, why this issue is happening?. |
|
| Back to top |
|
 |
| maurito |
| Posted: Tue Jun 21, 2016 12:38 am Post subject: Re: IBM WMB v8.0.0.4 - DSN issue |
|
|
Partisan
Joined: 17 Apr 2014
Posts: 358
|
| gabrielj wrote: |
Dear All Expert,
We have IBM WMB v8.0.0.4 installed on HP-UX Box.
and one of the DSN definition as below.
[INSIGHTDB]
Driver=/WMB/IBM/mqsi/7.0/ODBC/V6.0/lib/UKmsss24.so
Description=DataDirect 5.3 64bit SQL Server Wire Protocol
Address=xx.xx.xx.xx,yyyy
AnsiNPW=Yes
Database=insight
QuotedId=No
ColumnSizeAsCharacter=1
We have an compute node which serves response for 3 services and default DSN set as "INSIGHTDB". Two services are using default DSN and 1 service is using Database.{Schema}.xxx notation to access the DB.
INSIGHTDB was shutdown by DBA without notifying the Development team 10 days back. we have restarted broker several times for other reasons and the service which not using default DSN also working fine. From Today(Restarted Broker today as well) onward we are getting DSN related error for that service.
Can you anybody provide the clear picture, why this issue is happening?. |
If you do not specify the errors you are getting, then it is anyone's guess. Normally error messages give you an indication of the problem. |
|
| Back to top |
|
|
| gabrielj |
| Posted: Tue Jun 21, 2016 12:58 am Post subject: |
|
|
Novice
Joined: 16 Nov 2014
Posts: 23
Location: Muscut,Perth,Sydney,Bangalore,Hydrabad,Coimbatore
|
Thanks maurito
Forget to attach the Error Messages.
<DatabaseException><File>/build/slot1/S800_P/src/DataFlowEngine/ImbOdbc.cpp</File><Line>2260</Line><Function>ImbOdbcConnection::checkRcInner</Function><Type></Type><Name></Name><Label></Label><Catalog>BIPmsgs</Catalog><Severity>3</Severity><Number>2393</Number><Text>Root SQL exception</Text><Insert><Type>2</Type><Text>-1</Text></Insert><Insert><Type>5</Type><Text>INSIGHTDB</Text></Insert><Insert><Type>14</Type><Text>/opt/ibm/IE02/2.0.0/lib/libodbcinterface.so</Text></Insert><DatabaseException><File>/build/slot1/S800_P/src/DataFlowEngine/ImbOdbc.cpp</File><Line>2446</Line><Function>ImbOdbcConnection::checkRcInner</Function><Type></Type><Name></Name><Label></Label><Catalog>BIPmsgs</Catalog><Severity>3</Severity><Number>2322</Number><Text>Child SQL exception</Text><Insert><Type>5</Type><Text>08001</Text></Insert><Insert><Type>2</Type><Text>11</Text></Insert><Insert><Type>5</Type><Text>[unixODBC][IBM][ODBC SQL Server Driver][libssclient24]General network error. Check your network documentation.</Text></Insert></DatabaseException><DatabaseException><File>/build/slot1/S800_P/src/DataFlowEngine/ImbOdbc.cpp</File><Line>2446</Line><Function>ImbOdbcConnection::checkRcInner</Function><Type></Type><Name></Name><Label></Label><Catalog>BIPmsgs</Catalog><Severity>3</Severity><Number>2322</Number><Text>Child SQL exception</Text><Insert><Type>5</Type><Text>01000</Text></Insert><Insert><Type>2</Type><Text>11</Text></Insert><Insert><Type>5</Type><Text>[unixODBC][IBM][ODBC SQL Server Driver][libssclient24]ConnectionOpen (()).</Text></Insert></DatabaseException></DatabaseException>
Here my question is
Why this is not happening for earlier broker restart? is there any DSN cache issue? |
|
| Back to top |
|
|
| maurito |
| Posted: Tue Jun 21, 2016 1:02 am Post subject: |
|
|
Partisan
Joined: 17 Apr 2014
Posts: 358
|
| gabrielj wrote: |
Thanks maurito
Forget to attach the Error Messages.
<DatabaseException><File>/build/slot1/S800_P/src/DataFlowEngine/ImbOdbc.cpp</File><Line>2260</Line><Function>ImbOdbcConnection::checkRcInner</Function><Type></Type><Name></Name><Label></Label><Catalog>BIPmsgs</Catalog><Severity>3</Severity><Number>2393</Number><Text>Root SQL exception</Text><Insert><Type>2</Type><Text>-1</Text></Insert><Insert><Type>5</Type><Text>INSIGHTDB</Text></Insert><Insert><Type>14</Type><Text>/opt/ibm/IE02/2.0.0/lib/libodbcinterface.so</Text></Insert><DatabaseException><File>/build/slot1/S800_P/src/DataFlowEngine/ImbOdbc.cpp</File><Line>2446</Line><Function>ImbOdbcConnection::checkRcInner</Function><Type></Type><Name></Name><Label></Label><Catalog>BIPmsgs</Catalog><Severity>3</Severity><Number>2322</Number><Text>Child SQL exception</Text><Insert><Type>5</Type><Text>08001</Text></Insert><Insert><Type>2</Type><Text>11</Text></Insert><Insert><Type>5</Type><Text>[unixODBC][IBM][ODBC SQL Server Driver][libssclient24]General network error. Check your network documentation.</Text></Insert></DatabaseException><DatabaseException><File>/build/slot1/S800_P/src/DataFlowEngine/ImbOdbc.cpp</File><Line>2446</Line><Function>ImbOdbcConnection::checkRcInner</Function><Type></Type><Name></Name><Label></Label><Catalog>BIPmsgs</Catalog><Severity>3</Severity><Number>2322</Number><Text>Child SQL exception</Text><Insert><Type>5</Type><Text>01000</Text></Insert><Insert><Type>2</Type><Text>11</Text></Insert><Insert><Type>5</Type><Text>[unixODBC][IBM][ODBC SQL Server Driver][libssclient24]ConnectionOpen (()).</Text></Insert></DatabaseException></DatabaseException>
Here my question is
Why this is not happening for earlier broker restart? is there any DSN cache issue? |
I hope you realise what you have added as a "message" is unreadable. If you want help, please take the time to post something that is well formatted and legible.
Use Code tags wherever possible. Attach messages from syslog or the windows event log.
Run with a user trace and append the relevant part of it, ie. where the error messages are.
Use mqsicvp to test database connectivity. |
|
| 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
|
|
|
|
