| Author |
Message
|
| Zappa |
 Posted: Mon Feb 06, 2006 3:23 am Post subject: BIP8146E: Creating WMB6 broker |
 |
|
Acolyte
Joined: 06 Oct 2005
Posts: 55
Location: UK
|
Hi,
Hope someone can help on this one - I'm getting;
BIP8146E: Unable to retrieve the SQL primitives supported by the Database.
When creating a WMB6 broker, I have seen the NLSPATH issues on IBM support and this forum so I have changed this to include:
/opt/IBM/mqsi/6.0/merant/locale/en_US/LC_MESSAGES/%N
All the WMB6 profile is being set prior to the mqsicreatebroker command.
But still get the same error.
Strange thing is  I had created a version 6 broker which was working OK on this server before and then deleted it.
The database has a new schema. I can't see any errors in the user.log or odbc trace.
There is a working version 2.1 on this server in coexistence.
AIX 5.3.0.0, Oracle 9.2, MQ5.3.11 |
|
| Back to top |
|
 |
| JT |
| Posted: Mon Feb 06, 2006 6:39 am Post subject: |
|
|
Padawan
Joined: 27 Mar 2003
Posts: 1564
Location: Hartford, CT.
|
| Are the LC_ALL, LANG and ORACLE environment variables also set to their proper values ? |
|
| Back to top |
|
|
| Zappa |
| Posted: Mon Feb 06, 2006 8:10 am Post subject: |
|
|
Acolyte
Joined: 06 Oct 2005
Posts: 55
Location: UK
|
| I believe so - well I've compared them to a server that I can create a version 6 broker on and they all appear to be the same and correct. |
|
| Back to top |
|
|
| jefflowrey |
| Posted: Mon Feb 06, 2006 8:22 am Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
Are you using the Merant ODBC drivers in your ODBC.INI, or the Oracle drivers?
_________________
I am *not* the model of the modern major general. |
|
| Back to top |
|
|
| Zappa |
| Posted: Mon Feb 06, 2006 8:24 am Post subject: |
|
|
Acolyte
Joined: 06 Oct 2005
Posts: 55
Location: UK
|
Driver=/opt/IBM/mqsi/6.0/merant/lib/UKor820.so
is in the .odbc.ini |
|
| Back to top |
|
|
| Zappa |
| Posted: Mon Feb 06, 2006 8:30 am Post subject: |
|
|
Acolyte
Joined: 06 Oct 2005
Posts: 55
Location: UK
|
Did I say that there weren't any errors is on odbc trace - well I was lying... 
EXIT SQLGetTypeInfo with return code -1 (SQL_ERROR)
0x30f0e3d8
-98 <unknown> |
|
| Back to top |
|
|
| Zappa |
| Posted: Fri Mar 10, 2006 2:49 am Post subject: |
|
|
Acolyte
Joined: 06 Oct 2005
Posts: 55
Location: UK
|
| Turns out that there was a missing '=' char in the TraceDll line of the .odbc.ini file. |
|
| Back to top |
|
|
| PieterV |
| Posted: Fri Jul 14, 2006 12:24 am Post subject: |
|
|
Disciple
Joined: 04 Jan 2006
Posts: 164
Location: Belgium
|
i just had the same problem
turned out that my .odbc.ini was incorrect due to the fact that i used the default values for the trace options. in other words, the trace options in the .odbc.ini were not filled in.
so thx Zappa, i've could have searched on it for a long time without your tip. |
|
| Back to top |
|
|
|
|
