IBM webMethods Hybrid Integration

IBM webMethods Hybrid Integration

Join this online group to communicate across IBM product users and experts by sharing advice and best practices with peers and staying up to date regarding product enhancements.

 View Only
Back to discussions
Expand all | Collapse all

Error after Oracle DB deadlock - ORA-00060 -- Urgent

  • 1.  Error after Oracle DB deadlock - ORA-00060 -- Urgent

    Posted Sat November 24, 2012 06:45 AM

    Hi All,

    Need a quick help…

    A deadlock happened 2 days back… after DB fixed, and IS was restarted got lotz of errors below

    2012-11-21 15:50:33 AST [ISC.0050.0018E] Error decoding schema in FlowMap com.wm.util.coder.InvalidDatatypeException: com.wm.lang.xml.WMDocumentException: [I SC.0042.9327] Expecting </DOCUMENT> got
    2012-11-21 15:50:33 AST [ISC.0050.0018E] Error decoding schema in FlowMap com.wm.util.coder.InvalidDatatypeException: com.wm.lang.xml.WMDocumentException: [I SC.0042.9327] Expecting </DOCUMENT> got
    2012-11-21 15:50:33 AST [ISC.0049.0013I] Set: com.wm.util.coder.InvalidDatatypeException: [ISC.0076.9010] Sibling root element is null rootTag:Values localNa
    me:null root:Text:

    2012-11-21 15:50:33 AST [ISC.0049.0013I] Set: com.wm.util.coder.InvalidDatatypeException: [ISC.0076.9010] Sibling root element is null rootTag:Values localNa
    me:null root:Text:

    2012-11-21 15:50:33 AST [ISC.0049.0013I] Set: com.wm.util.coder.InvalidDatatypeException: [ISC.0076.9010] Sibling root element is null rootTag:Values localNa
    me:null root:Text:

    2012-11-21 15:50:33 AST [ISC.0050.0018E] Error decoding schema in FlowMap com.wm.util.coder.InvalidDatatypeException: com.wm.lang.xml.WMDocumentException: [I SC.0042.9327] Expecting </DOCUMENT> got

    2012-11-21 15:55:05 AST [WmDistributedLockManager.JdbcLockDbManager.selectOlderSqlD] selecting locks older than (SELECT EXCL_LOCK_ID, TARGET_ID, LOCK_HOLDER,
    LOCK_TYPE, LOCK_SHARE_COUNT, LOCK_TIMESTAMP FROM WM_EXCL_DIST_LOCK WHERE LOCK_TIMESTAMP<? AND LOCK_TYPE=‘E’) with this sql: 1353502325805
    2012-11-21 15:55:05 AST [WmDistributedLockManager.JdbcLockDbManager.selectOlderCountD] Found 0 locks older than 1353502325805
    2012-11-21 15:55:05 AST [WmDistributedLockManager.JdbcLockDbManager.selectOlderSqlD] selecting locks older than (SELECT WM_EXCL_DIST_LOCK.EXCL_LOCK_ID, WM_EX
    CL_DIST_LOCK.TARGET_ID, WM_EXCL_DIST_LOCK.LOCK_HOLDER, WM_EXCL_DIST_LOCK.LOCK_TYPE, WM_EXCL_DIST_LOCK.LOCK_SHARE_COUNT, WM_EXCL_DIST_LOCK.LOCK_TIMESTAMP, WM_
    SHAR_DIST_LOCK.SHAR_LOCK_ID, WM_SHAR_DIST_LOCK.LOCK_HOLDER, WM_SHAR_DIST_LOCK.EXCL_LOCK_ID, WM_SHAR_DIST_LOCK.LOCK_TIMESTAMP FROM WM_EXCL_DIST_LOCK, WM_SHAR_
    DIST_LOCK WHERE WM_EXCL_DIST_LOCK.EXCL_LOCK_ID=WM_SHAR_DIST_LOCK.EXCL_LOCK_ID AND WM_EXCL_DIST_LOCK.LOCK_TYPE=‘S’ AND WM_SHAR_DIST_LOCK.LOCK_TIMESTAMP<?) wit
    h this sql: 1353502325805
    2012-11-21 15:55:05 AST [WmDistributedLockManager.JdbcLockDbManager.selectOlderCountD] Found 0 locks older than 1353502325805
    2012-11-21 15:55:05 AST [WmDistributedLockManager.JdbcLockFactory.listOlderLocksD] Leave JdbcLockFactory.listOlderLocks(1353502325805), returning 0 locks
    2012-11-21 15:55:10 AST [WmDistributedLockManager.JdbcLockDbManager.selectOlderSqlD] selecting locks older than (SELECT EXCL_LOCK_ID, TARGET_ID, LOCK_HOLDER,
    LOCK_TYPE, LOCK_SHARE_COUNT, LOCK_TIMESTAMP FROM WM_EXCL_DIST_LOCK WHERE LOCK_TIMESTAMP<? AND LOCK_TYPE=‘E’) with this sql: 1353502330844
    2012-11-21 15:55:10 AST [WmDistributedLockManager.JdbcLockDbManager.selectOlderCountD] Found 0 locks older than 1353502330844
    2012-11-21 15:55:10 AST [WmDistributedLockManager.JdbcLockDbManager.selectOlderSqlD] selecting locks older than (SELECT WM_EXCL_DIST_LOCK.EXCL_LOCK_ID, WM_EX
    CL_DIST_LOCK.TARGET_ID, WM_EXCL_DIST_LOCK.LOCK_HOLDER, WM_EXCL_DIST_LOCK.LOCK_TYPE, WM_EXCL_DIST_LOCK.LOCK_SHARE_COUNT, WM_EXCL_DIST_LOCK.LOCK_TIMESTAMP, WM_
    SHAR_DIST_LOCK.SHAR_LOCK_ID, WM_SHAR_DIST_LOCK.LOCK_HOLDER, WM_SHAR_DIST_LOCK.EXCL_LOCK_ID, WM_SHAR_DIST_LOCK.LOCK_TIMESTAMP FROM WM_EXCL_DIST_LOCK, WM_SHAR_
    DIST_LOCK WHERE WM_EXCL_DIST_LOCK.EXCL_LOCK_ID=WM_SHAR_DIST_LOCK.EXCL_LOCK_ID AND WM_EXCL_DIST_LOCK.LOCK_TYPE=‘S’ AND WM_SHAR_DIST_LOCK.LOCK_TIMESTAMP<?) wit
    h this sql: 1353502330844
    2012-11-21 15:55:10 AST [WmDistributedLockManager.JdbcLockDbManager.selectOlderCountD] Found 0 locks older than 1353502330844


    #webMethods
    #Adapters-and-E-Standards
    #Integration-Server-and-ESB


Related Content