| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| mqsireportproperties error |
« View previous topic :: View next topic » |
| Author |
Message
|
| cvag |
 Posted: Tue Nov 29, 2011 7:14 am Post subject: mqsireportproperties error |
 |
|
Centurion
Joined: 17 Mar 2008
Posts: 127
|
Hi,
Am getting an error while using the mqsireportproperties inorder to find out the httplistener ports for different execution groups.
I have a broker (Broker 6.1 fixpack 9) running on AIX.
I could able to get the results(properties) when executing the below command
mqsireportproperties <Brokername> -o HTTPConnector -b httplistener -a --- but am not sure this is displaying one one port even (-a) refers to all properties and having two execution groups in a single broker.
But when giving the specific execution group flag and its name to the mqsi command it is throwing an error
Command: mqsireportproperties <Brokername> -o HTTPConnector -b httplistener -e <executiongroup name>
Error:
======
BIP2393E: Database error: ODBC return code '-1' from data source ''ESBBKP0''.
The broker received an error when executing a database operation. The ODBC return code was '-1'. See the following messages for information obtained from the database about this error.
Use the following messages to determine the cause of the error. Typical causes are incorrect data source or table names. Correct either the database or the broker configuration.
BIP2322E: Database error: SQL State ''IM002''; Native Error Code '0'; Error Text ''[DataDirect][ODBC lib] System information file not found. Please check the ODBCINI environment variable.''.
The error has the following diagnostic information: SQL State ''IM002'' SQL Native Error Code '0' SQL Error Text ''[DataDirect][ODBC lib] System information file not found. Please check the ODBCINI environment variable.''
This message may be accompanied by other messages describing the effect on the message broker itself. Use the reason identified in this message with the accompanying messages to determine the cause of the error.
BIP8040E: Unable to connect to the database.
The database cannot be accessed with the specified user Id and password pair.
- Check that the database is running.
- On Windows, check that an ODBC connection has been created.
- On systems that use $ODBCINI, check that the file pointed to by $ODBCINI has been correctly updated.
- Use mqsichangebroker brokername -a xxx to set the password to the correct value and try again.
Use mqsichangeconfigmgr configmgr -a xxx to set the password to the correct value and try again.
- Check that the database has an adequate number of database connections available for use.
And i see the all the broker components are up.
Do we need to set the classpath ODBC.ini path to the mqsiprofile?
Suggestion pls.
Thanks in Advance. |
|
| Back to top |
|
 |
| fjb_saper |
| Posted: Tue Nov 29, 2011 8:49 pm Post subject: |
|
|
Grand High Poobah
Joined: 18 Nov 2003
Posts: 20756
Location: LI,NY
|
You need to set the ODBCINI environment variable. The value there will point to your active ODBC.ini file.
I would have expected that this is already set in your mqsiprofile... Did you tamper with it? Remember to use a different user for a different level of the broker as the overlapping values of environment variables if multiple mqsiprofiles are sourced will clash.
Have fun 
_________________
MQ & Broker admin |
|
| Back to top |
|
|
| cvag |
| Posted: Wed Nov 30, 2011 2:31 am Post subject: |
|
|
Centurion
Joined: 17 Mar 2008
Posts: 127
|
Thanks fjb,
But this error is occuring not only for mqsireportproperties and also for the commands like 'mqsilist <Brokername>' .
Can you please clarify me the questions
The strange thing i have is.
mqsireportproperties <Brokername> -o HTTPConnector -b httplistener -a ------> giving output
mqsireportproperties <Brokername> -o HTTPConnector -b httplistener -e <executiongroup name> --------> not working throwing ODBC the above error
Whats the difference between them..?
I checked the mqsiprofile have all the paths set for java, mq, and odbc.
And i looked for the .profile in the /home/user/.profile.
No path was set for anything as the .profile is specific to users.
Do i need to set environment paths and export for java, mq and odbc(lib and odbc.ini) ? for resolving the odbc error.
If possible can you please paste the .profile variables what parameters i need to set?
Thanks in Advance. |
|
| Back to top |
|
|
| cvag |
| Posted: Wed Nov 30, 2011 3:14 am Post subject: |
|
|
Centurion
Joined: 17 Mar 2008
Posts: 127
|
Hi fjb,
Thanks for your earlier response,
In my analysis,
mqsireportproperties <Brokername> -o HTTPConnector -b httplistener -a command is just displaying the results, whereas
mqsireportproperties <Brokername> -o HTTPConnector -b httplistener -e <executiongroup name> this command is not able execute, the reason i find is am logging into the server with my user credentails instead of su user credentials.
Sorry for my mistake
So the mqsireportproperties with execution group flag is failing as the broker EG stored in the database and my command is trying to access or connect to broker DB for getting the EG info.
Please add some more point or correct me if my analysis is wrong. |
|
| Back to top |
|
|
| fjb_saper |
| Posted: Wed Nov 30, 2011 9:04 am Post subject: |
|
|
Grand High Poobah
Joined: 18 Nov 2003
Posts: 20756
Location: LI,NY
|
The analysis appears correct...
_________________
MQ & Broker admin |
|
| 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
|
|
|
|
