ASG
IBM
Zystems
Cressida
Icon
Netflexity
 
  MQSeries.net
Search  Search       Tech Exchange      Education      Certifications      Library      Info Center      SupportPacs      LinkedIn  Search  Search                                                                   FAQ  FAQ   Usergroups  Usergroups
 
Register  ::  Log in Log in to check your private messages
 
RSS Feed - WebSphere MQ Support RSS Feed - Message Broker Support

MQSeries.net Forum Index » IBM MQ Installation/Configuration Support » XA dll not found but it is not true

Post new topic  Reply to topic
 XA dll not found but it is not true « View previous topic :: View next topic » 
Author Message
lium
PostPosted: Fri Jan 17, 2014 8:47 am    Post subject: XA dll not found but it is not true Reply with quote

Disciple

Joined: 17 Jul 2002
Posts: 184

I am able to configure the xa for oracle successfully with the dll which I created by myself.

However, I also would like to the test the broker shipped dll such as ukora24.dll and ukora26.dll.

I put them both under the

C:\IBM\WebSphere MQ\exits>dir
Volume in drive C has no label.
Volume Serial Number is E0E8-D7AA

Directory of C:\IBM\WebSphere MQ\exits

01/17/2014 03:31 PM <DIR> .
01/17/2014 03:31 PM <DIR> ..
11/14/2013 03:41 AM <DIR> Installation1
01/04/2014 05:19 PM 7,680 oraswit32.dll
01/17/2014 03:31 PM 1,667,072 ukora24.dll
06/20/2013 01:57 AM 1,812,880 ukora26.dll
3 File(s) 3,487,632 bytes
3 Dir(s) 51,470,131,200 bytes free

The oraswit32.dll is working well now.

However, once I changed the qm.ini from oraswit32 to ukora24.dll, I will get such error as following:



1/17/2014 16:16:28 - Process(1996.1) User(michael.liu) Program(amqzxma0.exe)
Host(WIN-JFFTF45GEQM) Installation(Installation1)
VRMF(7.5.0.2) QMgr(BHQM)

AMQ6174: The library 'C:\IBM\WebSphere MQ\exits\ukora26.dll' was not found.

EXPLANATION:
The dynamically loadable library 'C:\IBM\WebSphere MQ\exits\ukora26.dll' was
not found.
ACTION:
Check that the file exists and is either fully qualified or is in the
appropriate directory.
-------------------------------------------------------------------------------
1/17/2014 16:16:28 - Process(1996.1) User(michael.liu) Program(amqzxma0.exe)
Host(WIN-JFFTF45GEQM) Installation(Installation1)
VRMF(7.5.0.2) QMgr(BHQM)

AMQ7622: WebSphere MQ could not load the XA switch load file for resource
manager 'OracleXA'.

EXPLANATION:
An error has occurred loading XA switch file ukora26. If the error occurred
during startup then the queue manager will terminate. At all other times the
queue manager will continue without this resource manager meaning that it will
no longer be able to participate in global transactions. The queue manager will
also retry the load of the switch file at regular intervals so that the
resource manager will be able to participate again should the load problem be
resolved.
ACTION:
Look for a previous message outlining the reason for the load failure. Message
AMQ6175 is issued if the load failed because of a system error. If this is the
case then follow the guidance given in message AMQ6175 to resolve the problem.
In the absence of prior messages or FFST information related to this problem
check that the name of the switch load file is correct and that it is present
in a directory from which it can be dynamically loaded by the queue manager.
The easiest method of doing this is to define the switch load file as a
fully-qualified name. Note that if the queue manager is still running it will
need to be restarted in order that any changes made to its configuration data
can be picked up.



The error is about:

AMQ6174: The library 'C:\IBM\WebSphere MQ\exits\ukora26.dll' was not found.


However, this is for sure not true.

C:\IBM\WebSphere MQ\exits>dir "C:\IBM\WebSphere MQ\exits\ukora26.dll"
Volume in drive C has no label.
Volume Serial Number is E0E8-D7AA

Directory of C:\IBM\WebSphere MQ\exits

06/20/2013 01:57 AM 1,812,880 ukora26.dll
1 File(s) 1,812,880 bytes
0 Dir(s) 51,470,131,200 bytes free


Could anybody tell me why?


I am also wondering if this is because even though the file is there, however, if the dll is not qualified and not loadable, then the MQ will also yield the "not found" error?


Thanks,
Back to top
View user's profile Send private message
smdavies99
PostPosted: Fri Jan 17, 2014 9:57 am    Post subject: Reply with quote

Jedi Council

Joined: 10 Feb 2003
Posts: 6076
Location: Somewhere over the Rainbow this side of Never-never land.

Could it be that the .dll files that the ukora.dll calls are not on your java classpath (or some other) path?
_________________
WMQ User since 1999
MQSI/WBI/WMB/'Thingy' User since 2002
Linux user since 1995

Every time you reinvent the wheel the more square it gets (anon). If in doubt think and investigate before you ask silly questions.
Back to top
View user's profile Send private message
lium
PostPosted: Fri Jan 17, 2014 10:04 am    Post subject: Reply with quote

Disciple

Joined: 17 Jul 2002
Posts: 184

It is not that case.
Please check what I posted at very beginning, all 3 dll files are under the same directory exits.
If I change the name to be oraswit32, then it works, if you use ukora24 or ukora26, then it will say not found
Back to top
View user's profile Send private message
lium
PostPosted: Fri Jan 17, 2014 11:30 am    Post subject: Reply with quote

Disciple

Joined: 17 Jul 2002
Posts: 184

If I specify the full path, then it works.

I could not figure out why the different files under the same folder, one has to specify the full path, but the other does not have to

Anyway, it works
Back to top
View user's profile Send private message
lium
PostPosted: Fri Jan 17, 2014 11:38 am    Post subject: Reply with quote

Disciple

Joined: 17 Jul 2002
Posts: 184

Sorry, as a correction, it still does not work.

What it worked was the full path for the oraswit32.dll.
Once I specified the ukora24.dll, then it will run into the same problem, complaining it is not found
Back to top
View user's profile Send private message
fjb_saper
PostPosted: Fri Jan 17, 2014 5:58 pm    Post subject: Reply with quote

Grand High Poobah

Joined: 18 Nov 2003
Posts: 20756
Location: LI,NY

lium wrote:
Sorry, as a correction, it still does not work.

What it worked was the full path for the oraswit32.dll.
Once I specified the ukora24.dll, then it will run into the same problem, complaining it is not found


Well AFAIK the oraswit32.dll comes with the odbc (under <mqinstall>\java\lib\odbc). So obviously it is to be used for the XA bindings in the qm stanza...

ukora24.dll is the generic oracle wire driver for creating the connections, using he wire protocol...

Nothing to do with XA...

Have fun
_________________
MQ & Broker admin
Back to top
View user's profile Send private message Send e-mail
lium
PostPosted: Sun Jan 19, 2014 6:24 am    Post subject: Reply with quote

Disciple

Joined: 17 Jul 2002
Posts: 184

Right now, I am able to start teh queue manager, it seems working well:


ORACLE XA: Version 11.2.0.1.0. RM name = 'Oracle_XA'.


141916.3404:4736.4736.257:
xaoopen: xa_info=Oracle_XA+DB=ORCL+SQLNET=ORCL+Acc=P/prodeval/password+SesTm=100+threads=true+DbgFl=0x7+LogDir=C:\\IBM\\WebSphere MQ\\errors,rmid=257,flags=0x0


141916.3404:4736.4736.257:
xaolgn_help: version#: 185597952 banner: Oracle Database 11g Release 11.1.0.0.0 - Production



141916.3404:4736.4736.257:
xaolgn: sqlxrc/sqlxss completed


141916.3404:4736.4736.257:
xaolgn: return XA_OK


141916.3404:4736.4736.257:
xaoopen: xaolgn completed


141916.3404:4736.4736.257:
xaoopen: return 0


141916.3404:4736.4736.257:
xaorecover: rmid=257, flags=0x1000000


141916.3404:4736.4736.257:
xaorecover: xids=0x18f7c8, count=5, rmid=257, flags=0x1000000


141916.3404:4736.4736.257:
xaofetch: fetchcb->xaorfrfs=2


141916.3404:4736.4736.257:
OCIStmtPrepare: Attempting


141916.3404:4736.4736.257:
OCIStmtPrepare: Succeeded


141916.3404:4736.4736.257:
OCIStmtExecute: Attempting


141916.3404:4736.4736.257:
OCIStmtExecute: Succeeded


141916.3404:4736.4736.257:
OCIStmtFetch: Attempting


141916.3404:4736.4736.257:
xaofetch: fetchcb->xaorfrfs=2


141916.3404:4736.4736.257:
OCIStmtPrepare: Attempting


141916.3404:4736.4736.257:
OCIStmtPrepare: Succeeded


141916.3404:4736.4736.257:
OCIStmtExecute: Attempting


141916.3404:4736.4736.257:
OCIStmtExecute: Succeeded


141916.3404:4736.4736.257:
OCIStmtFetch: Attempting


141916.3404:4736.4736.257:
xaoclrfb: cno=0, rmptr=0xd99ee0


141916.3404:4736.4736.257:
xaoclrfb: cno=0, rmptr=0xd99ee0


141916.3404:4736.4736.257:
xaoclrec: return (void)


141916.3404:4736.4736.257:
xaorecover: rtn 0


141916.3404:4736.4736.257:
xaoclose: xa_info=, rmid=257, flags=0x0


141916.3404:4736.4736.257:
OCIServerDetach: Attempting


141916.3404:4736.4736.257:
OCIServerDetach: Succeeded


141916.3404:4736.4736.257:
xaoclose: rtn 0


However, when I started the broker, from teh trace file, it has error as:

2014-01-19 14:20:08.758500 3600 Error BIP2633W: Warning when starting transaction coordinated by WebSphere MQ; MQBEGIN failed: MQCC=1; MQRC=2122; node 'StaffTransactionHandler.STAFFIN'.
The message flow attribute 'coordinatedTransaction' was specified as 'yes'. However, when the broker attempted to start the coordinated transaction in node 'StaffTransactionHandler.STAFFIN', the MQBEGIN function returned a warning as indicated by the WebSphere MQ reason code. The message flow continues, but the transaction may not be being coordinated as expected, and this may cause subsequent errors or unpredictable results.
Check the WebSphere MQ completion and reason codes in the WebSphere MQ Application Programming Reference manual to establish the cause of the error, taking any appropriate action. It may be necessary to restart the message broker after you have performed this recovery action.
2014-01-19 14:20:08.758543 3600 UserTrace BIP11514W: Warning when starting coordinated transaction. Reason code ''2122''.
Warning when starting transaction coordinated by WebSphere MQ The message flow ''StaffTransactionHandler'' continues, but the transaction may not be being coordinated as expected, and this may cause subsequent errors or unpredictable results.



And it keeps generating

-------------------------------------------------------------------------------
1/19/2014 14:23:36 - Process(4892.4) User(Administrator) Program(taFlowEngine.exe)
Host(WIN-JFFTF45GEQM) Installation(Installation1)
VRMF(7.5.0.2) QMgr(BHQM)

AMQ6174: The library 'C:\IBM\WebSphere MQ\exits64\oraswit.dll' was not found.

EXPLANATION:
The dynamically loadable library 'C:\IBM\WebSphere MQ\exits64\oraswit.dll' was
not found.
ACTION:
Check that the file exists and is either fully qualified or is in the
appropriate directory.
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic  Reply to topic Page 1 of 1

MQSeries.net Forum Index » IBM MQ Installation/Configuration Support » XA dll not found but it is not true
Jump to:  



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
Protected by Anti-Spam ACP
 
 


Theme by Dustin Baccetti
Powered by phpBB © 2001, 2002 phpBB Group

Copyright © MQSeries.net. All rights reserved.