Author |
Message
|
reddy_kal |
Posted: Wed Dec 06, 2006 1:29 pm Post subject: BIP8081 and BIP8069' |
|
|
Acolyte
Joined: 04 Nov 2002 Posts: 73
|
Hello,
Getting the following error when I am trying to create Message Broker
"BIP8081 An exception was caught while processing the response message for the command, 'Unable to format an ImbException message for output, ImbException message number is BIP8069'."
My Env looks ok. I can do mqsilist successfully.
Did anyone come across this error before?
Thanx
-Reddy |
|
Back to top |
|
 |
wschutz |
Posted: Wed Dec 06, 2006 1:45 pm Post subject: |
|
|
 Jedi Knight
Joined: 02 Jun 2005 Posts: 3316 Location: IBM (retired)
|
|
Back to top |
|
 |
reddy_kal |
Posted: Thu Dec 07, 2006 7:32 am Post subject: |
|
|
Acolyte
Joined: 04 Nov 2002 Posts: 73
|
Hello,
Thanx for the link. But it didn't help. The Env looks ok. I can do mqsilist.
After executing the message broker creation command, even though it is giving error, if I do mqsilist I am able to see Broker and the QueueManager. But If I go to Broker database, I don't see any tables created.
I checked .odbc.ini file. It looks ok. The permission of Oracle Home directory and underneath it is also 755.
Thanks
-Reddy |
|
Back to top |
|
 |
jefflowrey |
Posted: Thu Dec 07, 2006 7:34 am Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002 Posts: 19981
|
What is the full output of the mqsicreatebroker command?
Is it otherwise possible to establish a database connection from the broker machine? _________________ I am *not* the model of the modern major general. |
|
Back to top |
|
 |
reddy_kal |
Posted: Thu Dec 07, 2006 7:40 am Post subject: |
|
|
Acolyte
Joined: 04 Nov 2002 Posts: 73
|
This is the message I am getting
> mqsicreatebroker AB300Q001 -i eimb -a eimb$123 -q AH300Q001 -n eiaq -u eimb -p admin -P 7081
BIP8081 An exception was caught while processing the response message for the command, 'Unable to format an ImbException message for output, ImbException message number is BIP8069'.
I am able to tnsping and sqlplus to the database.
Thanks
-Reddy |
|
Back to top |
|
 |
jefflowrey |
Posted: Thu Dec 07, 2006 7:43 am Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002 Posts: 19981
|
did you include oraenv in your profile? _________________ I am *not* the model of the modern major general. |
|
Back to top |
|
 |
reddy_kal |
Posted: Thu Dec 07, 2006 8:19 am Post subject: |
|
|
Acolyte
Joined: 04 Nov 2002 Posts: 73
|
Hello,
Yes the oracle env is setup. I can do tnsping and sqlplus to the database for this user id.
-Reddy |
|
Back to top |
|
 |
jefflowrey |
Posted: Thu Dec 07, 2006 8:32 am Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002 Posts: 19981
|
That's really not what I meant.
Does the shell profile for the broker service user include an invocation or sourcing of the 'oraenv' file?
There are also a number of PATH, LIBPATH and etc. settings that need to be made for Broker. You should go to the Info Center and review every page in the "Connecting to the databases" section, and double-check everything.
You can also consider enabling ODBC tracing, to see if this helps. _________________ I am *not* the model of the modern major general. |
|
Back to top |
|
 |
reddy_kal |
Posted: Thu Dec 07, 2006 10:30 am Post subject: |
|
|
Acolyte
Joined: 04 Nov 2002 Posts: 73
|
Hello,
We included the Oracle librarry path in the .profile of Broker Service user id.
After I execute the Broker creating command, Even though I get error, when I do mqsilist it shows me good output. I don't see any tables created in the Broker database. And when I start the the Broker, I see bipservice process but not bipbroker process.
Not sure where could be wrong.
> mqsilist
BIP8099I: Broker: AB300Q001 - AH300Q001
BIP8071I: Successful command completion.
-Reddy |
|
Back to top |
|
 |
jefflowrey |
Posted: Thu Dec 07, 2006 10:36 am Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002 Posts: 19981
|
What's wrong is that the mqsicreatebroker command is not able to successfully create the broker database tables.
I repeat that simply including the Oracle library path in the .profile is NOT sufficient. There is a command that comes with oracle called "oraenv". It needs to be part of the profile as well, if you are using Oracle as the broker database.
I repeat that you should go to the Information Center, and review *all* of the pages in the section on connecting to databases, and make sure that your environment is complete.
Being able to run sqlplus and tnsping is a very good start, but it is *not*, alas, sufficient. _________________ I am *not* the model of the modern major general. |
|
Back to top |
|
 |
|