| Author |
Message
|
| manojsu |
 Posted: Fri Aug 11, 2006 7:02 am Post subject: Database Exception Error |
 |
|
Centurion
Joined: 19 Jul 2006
Posts: 147
Location: Bangalore
|
When me trying to insert into the database, getting following exception thrown..
Text = [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
But when do a RDB file import its perfect, and also DSN is testing perfectly for the oracle server |
|
| Back to top |
|
 |
| jefflowrey |
| Posted: Fri Aug 11, 2006 7:24 am Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
Are you using the wrong Oracle driver?
_________________
I am *not* the model of the modern major general. |
|
| Back to top |
|
|
| mgk |
| Posted: Fri Aug 11, 2006 12:15 pm Post subject: |
|
|
Padawan
Joined: 31 Jul 2003
Posts: 1642
|
Hi,
Did you specify the DSN in the System tab rather than the User tab?
Regards,
_________________
MGK
The postings I make on this site are my own and don't necessarily represent IBM's positions, strategies or opinions. |
|
| Back to top |
|
|
| manojsu |
| Posted: Sat Aug 12, 2006 1:22 am Post subject: |
|
|
Centurion
Joined: 19 Jul 2006
Posts: 147
Location: Bangalore
|
| I have created a DSN using MQ data direct, and have created it in the system DSN, when trying to import the rdb file, its working well, but when inseting into database, throwing error |
|
| Back to top |
|
|
| madi |
| Posted: Mon Aug 14, 2006 9:18 am Post subject: |
|
|
Chevalier
Joined: 17 Jan 2006
Posts: 475
|
|
| Back to top |
|
|
| JT |
| Posted: Mon Aug 14, 2006 4:49 pm Post subject: |
|
|
Padawan
Joined: 27 Mar 2003
Posts: 1564
Location: Hartford, CT.
|
| Using SQLPLUS, check the results of the insert instruction outside of WMB. |
|
| Back to top |
|
|
| manojsu |
| Posted: Mon Aug 14, 2006 10:41 pm Post subject: |
|
|
Centurion
Joined: 19 Jul 2006
Posts: 147
Location: Bangalore
|
I am able to insert using the sqlplus, but not via MB,
"Text = [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified " |
|
| Back to top |
|
|
| mgk |
| Posted: Tue Aug 15, 2006 4:53 am Post subject: |
|
|
Padawan
Joined: 31 Jul 2003
Posts: 1642
|
Oracle is a tested and supported DB. There must be something different in your setup that is stopping this from working. I suggest you raise a PMR if you are still having problems.
However, it may be that the version of Oracle you are using is not supported with the particular version of MB that you are using. Could you post the versions (including CSDs) of the Broker and Oracle that you are using?
Regards,
_________________
MGK
The postings I make on this site are my own and don't necessarily represent IBM's positions, strategies or opinions. |
|
| Back to top |
|
|
| jefflowrey |
| Posted: Tue Aug 15, 2006 5:04 am Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
I think this is something more basic.
Did you stop & start the broker after defining the ODBC DSN?
Are you running the broker on the same machine as the Toolkit?
Does the broker service user have permission on the database? Or did you run mqsisetdbparms for the DSN?
_________________
I am *not* the model of the modern major general. |
|
| Back to top |
|
|
| srailkar |
| Posted: Tue Aug 15, 2006 5:04 am Post subject: |
|
|
Apprentice
Joined: 01 Jun 2005
Posts: 37
|
I have a similiar problem:
The messageflow is able to connect to local SQL Server Database and do insert, however when it is trying to do lookup into a REMOTE SQLServer Database it give error:
2006-08-11 07:50:41.394809 5088 RecoverableException BIP2488E: ('.GetPolicy.CHECKPOLICY', '33.4') Error detected whilst executing the SQL statement ''SET Environment.Variables.XML.DBROW[ ] = (SELECT COLUMN(0) AS POLICY, COLUMN(1) AS EFFYR, COLUMN(2) AS EFFMO, COLUMN(3) AS EFFDA, COLUMN(4) AS EXPYR, COLUMN(5) AS EXPMO, COLUMN(6) AS EXPDA, COLUMN(7) AS MOD, COLUMN( AS BRANCH FROM DATABASE(, POLICYNUMBER));''.
The message broker detected an error whilst executing the given statement. An exception has been thrown to cut short the SQL program.
See the following messages for details of the error.
2006-08-11 07:50:41.394824 5088 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.
2006-08-11 07:50:41.394840 5088 DatabaseException BIP2322E: Database error: SQL State ''IM002''; Native Error Code '0'; Error Text ''[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified''.
I am running at MQ 6.0.1 and WBIMB at 6.0.0.2
Is your database remote?
IBM Experts: where can I check for the parameters set via mqsisetdbparms in the Broker environment?
Thanks
Shobha |
|
| Back to top |
|
|
| manojsu |
| Posted: Tue Aug 15, 2006 6:51 am Post subject: |
|
|
Centurion
Joined: 19 Jul 2006
Posts: 147
Location: Bangalore
|
Did you stop & start the broker after defining the ODBC DSN?
i have restarted the broker as well as configmgr
Are you running the broker on the same machine as the Toolkit?
yes, both the things are on the same system.
Does the broker service user have permission on the database? Or did you run mqsisetdbparms for the DSN?
The broker iuser is the super user, and he has permission oon the databse equivalent to sysdba, and To cross check it i have run setdbparams too.
Now I 've installed the server in my system, and its wirking fine,when trying to insert into remote the problemstill persists. |
|
| Back to top |
|
|
| jefflowrey |
| Posted: Tue Aug 15, 2006 6:57 am Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
You should enable ODBC tracing and see what happens.
Or use the SQLServer tracing facilities to watch what happens on that side.
_________________
I am *not* the model of the modern major general. |
|
| Back to top |
|
|
| nathanw |
| Posted: Tue Aug 15, 2006 7:05 am Post subject: |
|
|
Knight
Joined: 14 Jul 2004
Posts: 550
|
| May be not applicable but is the Oracle listener defined / running? |
|
| Back to top |
|
|
| manojsu |
| Posted: Tue Aug 15, 2006 8:06 pm Post subject: |
|
|
Centurion
Joined: 19 Jul 2006
Posts: 147
Location: Bangalore
|
| i am not very sure of the oracle tracing and the SQL tracing as well, the oracle listener is running, as me able to import the rdb defn files, and may be the conectivity is also happening as the flow is gettingsuccesfully deployed |
|
| Back to top |
|
|
| jefflowrey |
| Posted: Wed Aug 16, 2006 1:52 am Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
I guess I got confused by srailkar, so ignore what I said about SQLServer.
There is a section in the troubleshooting documentation that tells you how to enable ODBC tracing. It will help you debug this.
_________________
I am *not* the model of the modern major general. |
|
| Back to top |
|
|
|
|
