| Author |
Message
|
| Jenney |
 Posted: Thu Feb 21, 2008 12:12 pm Post subject: Broker unable to connect to DB |
 |
|
Voyager
Joined: 25 Apr 2007
Posts: 83
Location: Melbourne
|
Hi,
We have Brk V6, Orable DB on AIX each seperately installed. I am able to set the broker db connection to the DB and Broker is running fine.
i have a message flow which access DB, i have set the mqsisetdbparms cmd and set another user with same DSN as of Broker and diff password to access DB. When i run the flow, i am getting following error .
| Quote: |
<ErrorCode>2322</ErrorCode>
<ErrorDetail>Child SQL exception</ErrorDetail>
<SeverityLevel>3</SeverityLevel>
<NodeSource></NodeSource>
<ErrorDescription>[DataDirect][ODBC Oracle driver][Oracle]ORA-00942: table or view does not exist </ErrorDescription> |
I am able to connect & run sql statements through sql plus from Brk server. I don't understand why through broker flow i am getting that error.
Any idea will be a great help
Thanks
Jen |
|
| Back to top |
|
 |
| jefflowrey |
| Posted: Thu Feb 21, 2008 12:23 pm Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
When you change the user with Oracle you are changing the default Schema, as well.
So you may need to fully address the database, table, or view, by including the Schema that they are defined under, rather than leaving it default.
_________________
I am *not* the model of the modern major general. |
|
| Back to top |
|
|
| Jenney |
| Posted: Thu Feb 21, 2008 12:39 pm Post subject: |
|
|
Voyager
Joined: 25 Apr 2007
Posts: 83
Location: Melbourne
|
this is my sql statement, here i am specifying the schema name and tabel name, on compute node i am specifying the data source name. I guess it should work with all these information 
| Quote: |
SET Environment.Variables.ErrorDesc[] = SELECT P.ERR_DETAIL, P.RETRY_THRESHOLD, P.TIMEDELAYINTERVAL
FROM Database.mySchema.myTable AS P WHERE P.ERR_CD = errorCode; |
|
|
| Back to top |
|
|
| jefflowrey |
| Posted: Thu Feb 21, 2008 12:57 pm Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
What does your Oracle DB say?
_________________
I am *not* the model of the modern major general. |
|
| Back to top |
|
|
| Jenney |
| Posted: Thu Feb 21, 2008 1:07 pm Post subject: |
|
|
Voyager
Joined: 25 Apr 2007
Posts: 83
Location: Melbourne
|
| Oracle DBA says if they can run the command through sql plus, with the given user and password then they are all set from their side. |
|
| Back to top |
|
|
| jefflowrey |
| Posted: Thu Feb 21, 2008 1:14 pm Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
| Jenney wrote: |
| Oracle DBA says if they can run the command through sql plus, with the given user and password then they are all set from their side. |
Sure, but they might also be willing to examine their error log and see what Oracle says about why Broker is failing.
If they were actually providing support to development teams.
_________________
I am *not* the model of the modern major general. |
|
| Back to top |
|
|
|
|
