E1: QUEUE MQ Series -When Outbound is Triggered, it Fails with "Can't get an EXCLUSIVE lock on TAM spec file "/u01/oracle/jdedwardsppack/e910/DV910/spec/glbltbl.xdb". Another process may be using it." (Doc ID 2027745.1)

Last updated on SEPTEMBER 07, 2016

Applies to:

JD Edwards EnterpriseOne Adapter for MQ Series - Version 8.98 and later
Information in this document applies to any platform.

Symptoms

Platform: Unix

Issue 1:
---------
In the MQSI kernel start, it initializes the kernel successfully and monitors INBOUND queue successfully, but whenever outbound get triggered from E1, the following error occurs.

Error - MQSI Kernel Error log:

----------

23134454/1 MAIN_THREAD                           Tue Jun 30 13:52:21.939242    jdetamio.c1032
    Can't get an EXCLUSIVE lock on TAM spec file "/u01/oracle/jdedwardsppack/e910/DV910/spec/glbltbl.xdb". Another process may be using it.

23134454/1 MAIN_THREAD                           Tue Jun 30 13:52:21.939268    jdetamio.c1611
    Can't Get TAM Index File HEADER Guard Lock

23134454/1 MAIN_THREAD                           Tue Jun 30 13:52:21.939328    jdetam.c729
    TAMInitX: Can't create TAM_INFO (/u01/oracle/jdedwardsppack/e910/DV910/spec/glbltbl.xdb)

23134454/1 MAIN_THREAD                           Tue Jun 30 13:52:21.939390    jdetama.c650
    JDESPEC0000027 - TAM init failed!

23134454/1 MAIN_THREAD                           Tue Jun 30 13:52:21.939434    specopen.c2633
    jdeSpecOpenLocal completed in error - JDESPECRESULT_FAILED.

23134454/1 MAIN_THREAD                           Tue Jun 30 13:52:21.942383    jdetamio.c1032
    Can't get an EXCLUSIVE lock on TAM spec file "/u01/oracle/jdedwardsppack/e910/system/bin32/./jdekrnl.xdb". Another process may be using it.

23134454/1 MAIN_THREAD                           Tue Jun 30 13:52:21.942403    jdetamio.c1611
    Can't Get TAM Index File HEADER Guard Lock

23134454/1 MAIN_THREAD                           Tue Jun 30 13:52:21.942426    jdetam.c729
    TAMInitX: Can't create TAM_INFO (/u01/oracle/jdedwardsppack/e910/system/bin32/./jdekrnl.xdb)

23134454/1 MAIN_THREAD                           Tue Jun 30 13:52:21.942462    jdetama.c650
    JDESPEC0000027 - TAM init failed!

23134454/1 MAIN_THREAD                           Tue Jun 30 13:52:21.942484    specopen.c1288
    openRemoteTAM() - Failed to open the TAM file /u01/oracle/jdedwardsppack/e910/system/bin32/./jdekrnl.ddb using the API SEInitTAMWithLock.  TAM flag word = 1.

23134454/1 MAIN_THREAD                           Tue Jun 30 13:52:21.942514    specopen.c2633
    jdeSpecOpenRemote completed in error - JDESPECRESULT_FAILED.

23134454/1 MAIN_THREAD                           Tue Jun 30 13:52:21.942535    jdb_rst.c1517
    JDB9990310 - Unable to open JDEKRNL specs.

 

 

Error - MQSI Kernel debug:

---------
Jun 30 13:52:21.939239 jdetamio.c1032 - 23134454/1 MAIN_THREAD Can't get an EXCLUSIVE lock on TAM spec file "/u01/oracle/jdedwardsppack/e910/DV910/spec/glbltbl.xdb". Another process may be using it.
Jun 30 13:52:21.939265 jdetamio.c1611 - 23134454/1 MAIN_THREAD Can't Get TAM Index File HEADER Guard Lock
Jun 30 13:52:21.939324 jdetam.c729 - 23134454/1 MAIN_THREAD TAMInitX: Can't create TAM_INFO (/u01/oracle/jdedwardsppack/e910/DV910/spec/glbltbl.xdb)
Jun 30 13:52:21.939353 jdetama.c484 - 23134454/1 MAIN_THREAD JDETAMA:entering INTUnlockTam with pTamLock:[301900b8],pTamLock->hIPCTamLock:[301910c8],pTamLock->szLockName:/u01/oracle/jdedwardsppack/e910/DV910/spec/glbltbl.ddb
Jun 30 13:52:21.939360 jdetama.c488 - 23134454/1 MAIN_THREAD JDETAMA:entering INTUnlockTam nReaders 1
Jun 30 13:52:21.939368 jdetama.c510 - 23134454/1 MAIN_THREAD UNLOCK: Total READ locks after operation: 0
Jun 30 13:52:21.939372 jdetama.c511 - 23134454/1 MAIN_THREAD JDETAMA:exited INTUNLockTam with pTamLock:[301900b8].
Jun 30 13:52:21.939387 jdetama.c650 - 23134454/1 MAIN_THREAD JDESPEC0000027 - TAM init failed!
Jun 30 13:52:21.939414 specopen.c1584 - 23134454/1 MAIN_THREAD SpecEncapsulation : Close completed.
Jun 30 13:52:21.939428 specopen.c2632 - 23134454/1 MAIN_THREAD SpecEncapsulation : jdeSpecOpenLocal completed in error - JDESPECRESULT_FAILED.
Jun 30 13:52:21.939432 specopen.c2633 - 23134454/1 MAIN_THREAD jdeSpecOpenLocal completed in error - JDESPECRESULT_FAILED.
Jun 30 13:52:21.942281 specopen.c2134 - 23134454/1 MAIN_THREAD Opening up remote metadata repository. Type - JDESPECTYPE_JDEKRNL, Path - /u01/oracle/jdedwardsppack/e910/system/bin32/.
Jun 30 13:52:21.942294 jdetama.c282 - 23134454/1 MAIN_THREAD JDETAMA:Entering INTWorkWithTamLockList for action 0
Jun 30 13:52:21.942298 jdetama.c330 - 23134454/1 MAIN_THREAD JDETAMA:Exited INTWorkWithTamLockList for action 0
Jun 30 13:52:21.942316 jdetama.c393 - 23134454/1 MAIN_THREAD JDETAMA:Creating IPC SWMR handle:[3018ff58]with name:au01aoracleajdedwardsppackae910asystemabin32a.ajdekrnl.ddb
Jun 30 13:52:21.942320 jdetama.c400 - 23134454/1 MAIN_THREAD JDETAMA:INTGetTamLockHandle got pTamLock:[301918b8],pTamLock->hIPCTamLock:[3018ff58].
Jun 30 13:52:21.942323 jdetama.c611 - 23134454/1 MAIN_THREAD Locking /u01/oracle/jdedwardsppack/e910/system/bin32/./jdekrnl.ddb in READ mode.
Jun 30 13:52:21.942328 jdetama.c410 - 23134454/1 MAIN_THREAD JDETAMA:entering INTLockTam with pTamLock:[301918b8],pTamLock->hIPCTamLock:[3018ff58],pTamLock->szLockName:/u01/oracle/jdedwardsppack/e910/system/bin32/./jdekrnl.ddb, type:1
Jun 30 13:52:21.942333 jdetama.c418 - 23134454/1 MAIN_THREAD JDETAMA:entering INTLockTam for read lock,nReaders 0
Jun 30 13:52:21.942340 jdetama.c439 - 23134454/1 MAIN_THREAD LOCK: Total READ locks after operation: 1
Jun 30 13:52:21.942355 jdetama.c473 - 23134454/1 MAIN_THREAD JDETAMA:exited INTLockTam with pTamLock:[301918b8],pTamLock->hIPCTamLock:[3018ff58], type:1, numReaders=1.
Jun 30 13:52:21.942381 jdetamio.c1032 - 23134454/1 MAIN_THREAD Can't get an EXCLUSIVE lock on TAM spec file "/u01/oracle/jdedwardsppack/e910/system/bin32/./jdekrnl.xdb". Another process may be using it.
Jun 30 13:52:21.942401 jdetamio.c1611 - 23134454/1 MAIN_THREAD Can't Get TAM Index File HEADER Guard Lock
Jun 30 13:52:21.942424 jdetam.c729 - 23134454/1 MAIN_THREAD TAMInitX: Can't create TAM_INFO (/u01/oracle/jdedwardsppack/e910/system/bin32/./jdekrnl.xdb)
Jun 30 13:52:21.942444 jdetama.c484 - 23134454/1 MAIN_THREAD JDETAMA:entering INTUnlockTam with pTamLock:[301918b8],pTamLock->hIPCTamLock:[3018ff58],pTamLock->szLockName:/u01/oracle/jdedwardsppack/e910/system/bin32/./jdekrnl.ddb
Jun 30 13:52:21.942449 jdetama.c488 - 23134454/1 MAIN_THREAD JDETAMA:entering INTUnlockTam nReaders 1
Jun 30 13:52:21.942455 jdetama.c510 - 23134454/1 MAIN_THREAD UNLOCK: Total READ locks after operation: 0
Jun 30 13:52:21.942458 jdetama.c511 - 23134454/1 MAIN_THREAD JDETAMA:exited INTUNLockTam with pTamLock:[301918b8].
Jun 30 13:52:21.942460 jdetama.c650 - 23134454/1 MAIN_THREAD JDESPEC0000027 - TAM init failed!
Jun 30 13:52:21.942481 specopen.c1288 - 23134454/1 MAIN_THREAD openRemoteTAM() - Failed to open the TAM file /u01/oracle/jdedwardsppack/e910/system/bin32/./jdekrnl.ddb using the API SEInitTAMWithLock. TAM flag word = 1.
Jun 30 13:52:21.942502 specopen.c1584 - 23134454/1 MAIN_THREAD SpecEncapsulation : Close completed.
Jun 30 13:52:21.942507 specopen.c2632 - 23134454/1 MAIN_THREAD SpecEncapsulation : jdeSpecOpenRemote completed in error - JDESPECRESULT_FAILED.
Jun 30 13:52:21.942509 specopen.c2633 - 23134454/1 MAIN_THREAD jdeSpecOpenRemote completed in error - JDESPECRESULT_FAILED.
Jun 30 13:52:21.942533 jdb_rst.c1517 - 23134454/1 MAIN_THREAD JDB9990310 - Unable to open JDEKRNL specs.
Jun 30 13:52:21.942555 jdb_ctl.c6907 - 23134454/1 MAIN_THREAD Entering JDB_FreeUser (UserHandle 3018bcb8)
Jun 30 13:52:21.942567 jdb_ctl.c10908 - 23134454/1 MAIN_THREAD Decremented huser count to 0
Jun 30 13:52:21.942570 jdb_ctl.c7305 - 23134454/1 MAIN_THREAD Exiting JDB_FreeUser with Success(UserHandle 3018bcb8)
Jun 30 13:52:21.942584 jdecsec.c211 - 23134454/1 MAIN_THREAD Try to validate user by password
Jun 30 13:52:21.943568 jdecsec.c1586 - 23134454/1 MAIN_THREAD Try to validate user by sending message to security server
Jun 30 13:52:21.943719 jdecsec.c1772 - 23134454/1 MAIN_THREAD Try to send the message to security server ENTJDMQD01
Jun 30 13:52:21.953432 jdecsec.c2485 - 23134454/1 MAIN_THREAD SendSecSrvrRequest: s->status returned by server-0
Jun 30 13:52:21.953442 jdecsec.c266 - 23134454/1 MAIN_THREAD Success validate user JDE by password
Jun 30 13:52:21.953452 jdecsec.c362 - 23134454/1 MAIN_THREAD Try to fetch proxy info from cache
Jun 30 13:52:21.953475 jdb_ctl.c6143 - 23134454/1 MAIN_THREAD Entering JDB_InitUser with (AUTO commit mode)
Jun 30 13:52:21.953488 jdb_tm.c65 - 23134454/1 MAIN_THREAD Entering JDB_BeginTransaction (UserHandle 30193758)
Jun 30 13:52:21.953498 jdb_tm.c89 - 23134454/1 MAIN_THREAD Exiting JDB_BeginTransaction with Success (UserHandle 30193758)
Jun 30 13:52:21.953512 jdb_ctl.c10897 - 23134454/1 MAIN_THREAD Incremented huser count to 1
Jun 30 13:52:21.953516 jdb_ctl.c6152 - 23134454/1 MAIN_THREAD Exiting JDB_InitUser with Success (UserHandle 30193758)
Jun 30 13:52:21.953519 jdb_ctl.c6143 - 23134454/1 MAIN_THREAD Entering JDB_InitUser with (AUTO commit mode)
Jun 30 13:52:21.953530 jdb_tm.c65 - 23134454/1 MAIN_THREAD Entering JDB_BeginTransaction (UserHandle 30194438)
Jun 30 13:52:21.953538 jdb_tm.c89 - 23134454/1 MAIN_THREAD Exiting JDB_BeginTransaction with Success (UserHandle 30194438)
Jun 30 13:52:21.953543 jdb_ctl.c10897 - 23134454/1 MAIN_THREAD Incremented huser count to 2
Jun 30 13:52:21.953546 jdb_ctl.c6152 - 23134454/1 MAIN_THREAD Exiting JDB_InitUser with Success (UserHandle 30194438)
Jun 30 13:52:21.956512 jdb_rq1.c1169 - 23134454/1 MAIN_THREAD Entering JDB_OpenTable(Table = F986101)
Jun 30 13:52:21.956575 specopen.c2127 - 23134454/1 MAIN_THREAD Opening up local metadata repository. Type - JDESPECTYPE_GLBLTBL.
Jun 30 13:52:21.956594 jdetama.c282 - 23134454/1 MAIN_THREAD JDETAMA:Entering INTWorkWithTamLockList for action 0
Jun 30 13:52:21.956599 jdetama.c330 - 23134454/1 MAIN_THREAD JDETAMA:Exited INTWorkWithTamLockList for action 0
Jun 30 13:52:21.956603 jdetama.c400 - 23134454/1 MAIN_THREAD JDETAMA:INTGetTamLockHandle got pTamLock:[301900b8],pTamLock->hIPCTamLock:[301910c8].
Jun 30 13:52:21.956607 jdetama.c611 - 23134454/1 MAIN_THREAD Locking /u01/oracle/jdedwardsppack/e910/DV910/spec/glbltbl.ddb in READ mode.
Jun 30 13:52:21.956646 jdetama.c410 - 23134454/1 MAIN_THREAD JDETAMA:entering INTLockTam with pTamLock:[301900b8],pTamLock->hIPCTamLock:[301910c8],pTamLock->szLockName:/u01/oracle/jdedwardsppack/e910/DV910/spec/glbltbl.ddb, type:1
Jun 30 13:52:21.956652 jdetama.c418 - 23134454/1 MAIN_THREAD JDETAMA:entering INTLockTam for read lock,nReaders 0
Jun 30 13:52:21.956662 jdetama.c439 - 23134454/1 MAIN_THREAD LOCK: Total READ locks after operation: 1
Jun 30 13:52:21.956670 jdetama.c473 - 23134454/1 MAIN_THREAD JDETAMA:exited INTLockTam with pTamLock:[301900b8],pTamLock->hIPCTamLock:[301910c8], type:1, numReaders=1.
Jun 30 13:52:21.956705 jdetamio.c1032 - 23134454/1 MAIN_THREAD Can't get an EXCLUSIVE lock on TAM spec file "/u01/oracle/jdedwardsppack/e910/DV910/spec/glbltbl.xdb". Another process may be using it.
Jun 30 13:52:21.956743 jdetamio.c1611 - 23134454/1 MAIN_THREAD Can't Get TAM Index File HEADER Guard Lock
Jun 30 13:52:21.956773 jdetam.c729 - 23134454/1 MAIN_THREAD TAMInitX: Can't create TAM_INFO (/u01/oracle/jdedwardsppack/e910/DV910/spec/glbltbl.xdb)
Jun 30 13:52:21.956801 jdetama.c484 - 23134454/1 MAIN_THREAD JDETAMA:entering INTUnlockTam with pTamLock:[301900b8],pTamLock->hIPCTamLock:[301910c8],pTamLock->szLockName:/u01/oracle/jdedwardsppack/e910/DV910/spec/glbltbl.ddb
Jun 30 13:52:21.956808 jdetama.c488 - 23134454/1 MAIN_THREAD JDETAMA:entering INTUnlockTam nReaders 1
Jun 30 13:52:21.956817 jdetama.c510 - 23134454/1 MAIN_THREAD UNLOCK: Total READ locks after operation: 0
Jun 30 13:52:21.956821 jdetama.c511 - 23134454/1 MAIN_THREAD JDETAMA:exited INTUNLockTam with pTamLock:[301900b8].
Jun 30 13:52:21.956824 jdetama.c650 - 23134454/1 MAIN_THREAD JDESPEC0000027 - TAM init failed!
Jun 30 13:52:21.956851 specopen.c1584 - 23134454/1 MAIN_THREAD SpecEncapsulation : Close completed.
Jun 30 13:52:21.956859 specopen.c2632 - 23134454/1 MAIN_THREAD SpecEncapsulation : jdeSpecOpenLocal completed in error - JDESPECRESULT_FAILED.
Jun 30 13:52:21.956862 specopen.c2633 - 23134454/1 MAIN_THREAD jdeSpecOpenLocal completed in error - JDESPECRESULT_FAILED.
Jun 30 13:52:21.956886 jdb_rst.c474 - 23134454/1 MAIN_THREAD JDB9900915 - Failed to find global table specs.
Jun 30 13:52:21.956912 jdb_rst.c1243 - 23134454/1 MAIN_THREAD JDB9900307 - Failed to find table specifications
Jun 30 13:52:21.956948 jdb_rq1.c1883 - 23134454/1 MAIN_THREAD JDB3100007 - Failed to get valid table specifications
Jun 30 13:52:21.956979 jdb_rq1.c1180 - 23134454/1 MAIN_THREAD Exiting JDB_OpenTable(Table = F986101) with Failure
Jun 30 13:52:21.956982 jdb_omp1.c3369 - 23134454/1 MAIN_THREAD JDB9900257 - Failed to open F986101
Jun 30 13:52:21.957009 jdb_omp1.c1151 - 23134454/1 MAIN_THREAD Couldn't find role list for user JDE.


Issue 2:

Run time errors in MQSI Kernel debug log:

 

 

Sep 22 09:47:55.502412    jdetamio.c825     - 10485834/1 WRK:Starting jdeCallObject               tamflock: h=f075dc58,Cmd=LOCK,Mode=UPDATE,EXCLUSIVE,WAIT FOREVER,start=80,len=1 (/u01/oracle/jdedwardsppack/e910/QA910/spec/glbltbl.xdb)
Sep 22 09:47:55.502425    jdetamio.c1032     - 10485834/1 WRK:Starting jdeCallObject            Can't get an EXCLUSIVE lock on TAM spec file "/u01/oracle/jdedwardsppack/e910/QA910/spec/glbltbl.xdb". Another process may be using it.
Sep 22 09:47:55.502445    jdetamio.c1611     - 10485834/1 WRK:Starting jdeCallObject            Can't Get TAM Index File HEADER Guard Lock
Sep 22 09:47:55.502465    jdetamio.c639     - 10485834/1 WRK:Starting jdeCallObject               tamfclose: h=f075dc58

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms