Automic Workload Automation

  • Private Community
 View Only

  • 1.  Event with a Workflow Errors: ORA-00060

    Posted Oct 13, 2019 05:42 AM

    Dear All,
    we updatet yesterday our production to V12.3. It's working fine - we have now only Problems with a Workflow/Jobs. Whenever the Workflow is executed we get Deadlocks on the Database.

    The Workflow has some Jobs and the Jobs executed on different Linuxmachines parallel <-- All the jobs are terminated with ok.

    20191013/102557.972 - U00029108 UCUDB: SQL_ERROR Database handles DB-HENV: 27b4f50 DB-HDBC: 2800b48
    20191013/102557.972 - U00003591 UCUDB - DB error info: OPC: 'OCIStmtExecute' Return code: 'ERROR'
    20191013/102557.972 - U00003592 UCUDB - Status: '' Native error: '60' Msg: 'ORA-00060: deadlock detected while waiting for resource'
    20191013/102602.976 - U00000006 DEADLOCK or Connection to database lost - Rollback handling initiated. See previous messages.
    20191013/102602.976 - U00003594 UCUDB Ret: '6' opcode: 'SLCU' SQL Stmnt: 'SELECT * FROM EV WHERE EV_AH_Idnr = ? AND EV_VName = ?'
    20191013/102602.976 - U00003524 UCUDB: ===> Time critical DB call! OPC: 'SLCU' time: '8:025.316.000'
    20191013/102602.976 - U00003525 UCUDB: ===> 'SELECT * FROM EV WHERE EV_AH_Idnr = ? AND EV_VName = ?'
    20191013/102602.976 - U00000006 DEADLOCK or Connection to database lost - Rollback handling initiated. See previous messages.
    20191013/102602.977 - U00003434 Server routine 'UCGENX_R/PWP_RESP' required '0' minutes and '8,270' seconds for processing.

    Somebody have an idea to fix this problem?


    Kind Regards

    Peter



  • 2.  RE: Event with a Workflow Errors: ORA-00060
    Best Answer

    Posted Oct 21, 2019 06:55 AM
    Hi Peter,

    I suspect the jobs and events use object variables? The EV table stores the object values during execution.

    Please check if the jobs and events use :PSET or :PUBLISH. If yes, check if this is absolutely necessary. And if yes, change the :PSETs to :PUBLISHs. With version 10.0 we also had many deadlocks and were able to minimize them a lot.

    Good luck
    Tim

    ------------------------------
    Automation Evangelist
    Fiducia & GAD IT AG
    ---
    Mitglied des deutschsprachigen Automic-Anwendervereins FOKUS e.V.
    Member of the German speaking Automic user association FOKUS e.V.
    ------------------------------

    Original Message