| Author |
Message
|
| EricCox |
 Posted: Tue Jan 15, 2013 9:27 am Post subject: WMB 7.0 and WMB 8.0 on Same AIX 7.1 Not Working |
 |
|
Master
Joined: 08 Apr 2011
Posts: 292
|
To all,
We have WMB 7.0 and WMB 8.0 Installed and configured on the same AIX 7.1 machine.
WMB 7.0 runs with its own user and .profile and WMB 8.0 runs with its own user and .profile.
WMB 7.0 Message Flows that call ODBC Data Sources are working fine.
WMB 8.0 Message Flows that call ODBC Data Source *ARE NOT* working.
Does anyone have any insight into this situation? Presently we have a PMR open with IBM. IBM seems to be stumped at the present time. Has anyone encountered this situation, have any ideas what to look for, or knows how to solve this?
Thanks very much for your assistance,
Eric |
|
| Back to top |
|
 |
| visasimbu |
| Posted: Tue Jan 15, 2013 9:32 am Post subject: Re: WMB 7.0 and WMB 8.0 on Same AIX 7.1 Not Working |
|
|
Disciple
Joined: 06 Nov 2009
Posts: 171
|
| EricCox wrote: |
WMB 8.0 Message Flows that call ODBC Data Source *ARE NOT* working.
|
Eric, Could you please elaborate the above statement ? |
|
| Back to top |
|
|
| lancelotlinc |
| Posted: Tue Jan 15, 2013 9:33 am Post subject: |
|
|
Jedi Knight
Joined: 22 Mar 2010
Posts: 4941
Location: Bloomington, IL USA
|
Thats a good test case.
Did you check the pathing in both the environment and the classpath loaders to be sure that the correct database client jars are being loaded in the exact same order for both WMB versions?
_________________
http://leanpub.com/IIB_Tips_and_Tricks
Save $20: Coupon Code: MQSERIES_READER |
|
| Back to top |
|
|
| mqjeff |
| Posted: Tue Jan 15, 2013 9:33 am Post subject: |
|
|
Grand Master
Joined: 25 Jun 2008
Posts: 17447
|
The usual things - make sure the odbc.ini is correct, make sure the correct mqsidbparms has been issued for the correct user correctly, test the connection using mqsicvp...
take service trace, see if there's anything that looks like it might be a reason for the odbc to fail.
Take an odbc trace, see if your DBAs can shed any light.
Take a network trace, see if that shows anything.
Install a full client for the db in question on the broker machine, see if you can connect from that.
Confirm that there's no firewall/network policy on the machine that prevents the broker service user from making network connections... |
|
| Back to top |
|
|
| mqjeff |
| Posted: Tue Jan 15, 2013 9:34 am Post subject: |
|
|
Grand Master
Joined: 25 Jun 2008
Posts: 17447
|
| lancelotlinc wrote: |
Thats a good test case.
Did you check the pathing in both the environment and the classpath loaders to be sure that the correct database client jars are being loaded in the exact same order for both WMB versions? |
You wouldn't use JAR files for ODBC... |
|
| Back to top |
|
|
| Vitor |
| Posted: Tue Jan 15, 2013 9:36 am Post subject: Re: WMB 7.0 and WMB 8.0 on Same AIX 7.1 Not Working |
|
|
Grand High Poobah
Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA
|
| EricCox wrote: |
| WMB 8.0 Message Flows that call ODBC Data Source *ARE NOT* working. |
Not working how? Connection errors? Null result sets? Screaming monkeys exploding from the back of the machine?
What does the ODBC trace say?
_________________
Honesty is the best policy.
Insanity is the best defence. |
|
| Back to top |
|
|
| lancelotlinc |
| Posted: Tue Jan 15, 2013 9:37 am Post subject: |
|
|
Jedi Knight
Joined: 22 Mar 2010
Posts: 4941
Location: Bloomington, IL USA
|
| mqjeff wrote: |
| lancelotlinc wrote: |
Thats a good test case.
Did you check the pathing in both the environment and the classpath loaders to be sure that the correct database client jars are being loaded in the exact same order for both WMB versions? |
You wouldn't use JAR files for ODBC... |
The client software may under the covers. If the pathing points to a 32-bit version of the client, but WMB expects a 64-bit version, the environment pathing would need to be corrected.
_________________
http://leanpub.com/IIB_Tips_and_Tricks
Save $20: Coupon Code: MQSERIES_READER |
|
| Back to top |
|
|
| mqjeff |
| Posted: Tue Jan 15, 2013 9:41 am Post subject: |
|
|
Grand Master
Joined: 25 Jun 2008
Posts: 17447
|
| lancelotlinc wrote: |
| mqjeff wrote: |
| lancelotlinc wrote: |
Thats a good test case.
Did you check the pathing in both the environment and the classpath loaders to be sure that the correct database client jars are being loaded in the exact same order for both WMB versions? |
You wouldn't use JAR files for ODBC... |
The client software may under the covers. If the pathing points to a 32-bit version of the client, but WMB expects a 64-bit version, the environment pathing would need to be corrected. |
So you're suggesting that a reasonable database client developer would choose to spin up an entirely separate JVM just to run JDBC code behind the scenes of an ODBC API that is designed to be called from C?
Really? |
|
| Back to top |
|
|
| lancelotlinc |
| Posted: Tue Jan 15, 2013 9:46 am Post subject: |
|
|
Jedi Knight
Joined: 22 Mar 2010
Posts: 4941
Location: Bloomington, IL USA
|
| mqjeff wrote: |
| lancelotlinc wrote: |
| mqjeff wrote: |
| lancelotlinc wrote: |
Thats a good test case.
Did you check the pathing in both the environment and the classpath loaders to be sure that the correct database client jars are being loaded in the exact same order for both WMB versions? |
You wouldn't use JAR files for ODBC... |
The client software may under the covers. If the pathing points to a 32-bit version of the client, but WMB expects a 64-bit version, the environment pathing would need to be corrected. |
So you're suggesting that a reasonable database client developer would choose to spin up an entirely separate JVM just to run JDBC code behind the scenes of an ODBC API that is designed to be called from C?
Really? |
I am suggesting one place to look is the environment to be sure that the pathing is set correctly. His V7 broker may have correct pathing to the right driver. His V8 broker may also have correct pathing but something else gets there first based on the environment settings.
Oracle has an ODBC driver that uses Java jars to construct wire protocol. If I find a reference to it, I'll post the link.
_________________
http://leanpub.com/IIB_Tips_and_Tricks
Save $20: Coupon Code: MQSERIES_READER |
|
| Back to top |
|
|
| EricCox |
| Posted: Tue Jan 15, 2013 9:55 am Post subject: Access Request in Progress and Exact Error |
|
|
Master
Joined: 08 Apr 2011
Posts: 292
|
I am in the progress of getting access to the system to assist in this kind of troubleshooting.
I've also asked the admin for the exact error message. If and when i get it I'll post here.
The admin states that it appears the environment variables are not being recognized by broker and the call to the driver fails. That is all I know at this time. |
|
| Back to top |
|
|
| Vitor |
| Posted: Tue Jan 15, 2013 10:29 am Post subject: Re: Access Request in Progress and Exact Error |
|
|
Grand High Poobah
Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA
|
| EricCox wrote: |
| The admin states that it appears the environment variables are not being recognized by broker and the call to the driver fails. That is all I know at this time. |
What environment variables? The only one that should be in play here is the ODBCINI which identifies where the configuration is stored. That contains the path to the driver needed for a given ODBC.
_________________
Honesty is the best policy.
Insanity is the best defence. |
|
| Back to top |
|
|
| marko.pitkanen |
| Posted: Tue Jan 15, 2013 12:49 pm Post subject: |
|
|
Chevalier
Joined: 23 Jul 2008
Posts: 440
Location: Jamsa, Finland
|
| mqjeff wrote: |
| The usual things - make sure the odbc.ini is correct |
Check that both versions uses their own odbc.ini and the template is copied from corresponding version's directory.
--
Marko |
|
| Back to top |
|
|
| fjb_saper |
| Posted: Tue Jan 15, 2013 12:59 pm Post subject: |
|
|
Grand High Poobah
Joined: 18 Nov 2003
Posts: 20756
Location: LI,NY
|
You may also want to check that the configurable services needed have been deployed to the new broker.
You can have everything working fine but missing the setup of the configurable services will have your flow fail. 
_________________
MQ & Broker admin |
|
| Back to top |
|
|
| EricCox |
| Posted: Tue Jan 15, 2013 1:02 pm Post subject: Thanks |
|
|
Master
Joined: 08 Apr 2011
Posts: 292
|
I'll try all this when I get access tomorrow. They are all sound suggestions.
Thanks |
|
| Back to top |
|
|
|
|
