MarkView Connector - Connector Review Users Locked - ORA-00054 resource busy and acquire with NOWAIT specified ORA-06512 at MVCN_UTIL / MVCN_REVIEW

Applies To

• ERP System: Oracle
• MarkView Version: 5.5 - 6.4

Behavior

Connector Review users are locked out and unable to process any invoices until middle tier is bounced.

Known Causes

This is known to occur when delete actions are being taken in Connector Review.

Resolution

To resolve, add the following indexes in the MARKVIEW schema:

CREATE INDEX MVCN_STR_MSG_STRUCTURE_ID
    ON MVCN_STRUCTURE_MESSAGE (STRUCTURE_ID)
STORAGE(
        INITIAL 128K
        NEXT 128K PCTINCREASE 10)
    TABLESPACE &IndexTableSpace;
    
exec dbms_stats.gather_table_stats('&MARKVIEW_SCHEMA','MVCN_STRUCTURE_MESSAGE');
    
CREATE INDEX MVCN_OPI_STRUCTURE_ID
    ON MVCN_OPERATION_INVOCATION (STRUCTURE_ID)
STORAGE(
        INITIAL 128K
        NEXT 128K
        PCTINCREASE 10)
    TABLESPACE &IndexTableSpace;
    
exec dbms_stats.gather_table_stats('&MARKVIEW_SCHEMA','MVCN_OPERATION_INVOCATION');

Keywords: mvcn util, mvcn review