Solution - Designer - ORA-01031 Error When Saving a Design After Upgrade to ArcFM 10.1 and Later Releases

Version 19

    Behavior

     

    The following error message is received when attempting to save a Design after upgrading to 10.1 and later ArcFM releases:


    There was an error saving design 2097. See details in the event log.


    Your design in workflow manager will not reflect your most recent geodatabase changes. The next time you open your design, it will have your most recent
    geodatabase changes but no WMS changes (i.e. site conditions) if you make any before your next successful save. The next successful save of the design will reflect your geodatabase changes in workflow manager.

     

    Several errors are written to the Miner event log, including this error:

     

    2013-05-13 14:10:56,780 [1] ERROR [(null)] - Designer Workflow Manager:
    mmWorkflowManager.modWorkflowUtils::DeleteWL_CU_Optimized3 failed to delete WL&CUs, SQL=DELETE (select cst.* FROM (PROCESS.MM_PX_CURRENT_STATE cst INNER JOIN PROCESS.MM_WMS_COMPATIBLE_UNIT cu ON cst.soid = cu.id) INNER JOIN
    PROCESS.MM_PX_STATE st ON st.state_id = cst.state_id) WHERE cu.design_id=2097 AND st.node_type_id = 13)...

    Error: ORA-01031: insufficient privileges
    Error at line: 1442 - Build: 10.10.292
    {log4net:HostName=tuswpesri06, LoggingAssemblyFileVersion=10.10.0.276}

     

    Cause

     

    This error is caused by bug MM51152. When this bug is fixed it will no longer be necessary to grant delete permissions to members of the WMS_USER role as shown in the work around.


    Workaround

     

    Add delete permissions on the MM_PX_STATE table for the WMS_USER and SM_USER by selecting Manage > Privileges on the MM_PX_STATE table in ArcCatalog. This can also be done using SQL with the following grant statements:

     

    GRANT DELETE ON PROCESS.MM_PX_STATE TO WMS_USER;

    GRANT DELETE ON PROCESS.MM_PX_STATE TO SM_USER; (If using Session Manager)