Automic Workload Automation

 View Only
Expand all | Collapse all

U00003590 UCUDB - DB error: 'OCIStmtExecute', 'ERROR ', '', 'ORA-01031: insufficient privileges

  • 1.  U00003590 UCUDB - DB error: 'OCIStmtExecute', 'ERROR ', '', 'ORA-01031: insufficient privileges

    Posted Sep 17, 2022 09:06 PM
    Dear All,

    We are getting the following error in midst of 21.0.3 to 21.0.4 upgrade for Oracle/RHELsetup

    IF UPDATING('AH_TimeStamp4') AND :NEW.AH_TimeStamp4 IS NOT NULL AND :OLD.AH_TIMESTAMP4 IS NULL THEN
    INSERT INTO XEVENTS (XEVT_EventId, XEVT_Src, XEVT_Idnr, XEVT_Client, XEVT_OType, XEVT_OName, XEVT_EventType, XEVT_EventValue, XEVT_EventTime)
    VALUES(SQ_XEVENTS_ID.NEXTVAL,'AH',:NEW.AH_Idnr,:NEW.AH_Client,:NEW.AH_OTyp'
    20220918/060450.514 - U00003590 UCUDB - DB error: 'OCIStmtExecute', 'ERROR ', '', 'ORA-01031: insufficient privileges'
    20220918/060450.514 - U00003590 UCUDB - DB error: 'OCIStmtExecute', 'ERROR ', '', 'ORA-01031: insufficient privileges'

    The AUTOMIC user on Oracle DB has the following rights :

    GRANT create table, create sequence, create session, create procedure, create trigger, execute any procedure, create public synonym, drop public synonym, create view, alter session, select any dictionary TO uc4;
    GRANT execute ON dbms_lock TO uc4;
    GRANT unlimited tablespace TO uc4;

    Any ideas on what is required to fix this?

    Regards
    P Verghese


  • 2.  RE: U00003590 UCUDB - DB error: 'OCIStmtExecute', 'ERROR ', '', 'ORA-01031: insufficient privileges

    Broadcom Employee
    Posted Sep 19, 2022 01:49 AM
    Hi,

    please grant "create trigger" to the automic database user.

    Regards, Markus


  • 3.  RE: U00003590 UCUDB - DB error: 'OCIStmtExecute', 'ERROR ', '', 'ORA-01031: insufficient privileges

    Posted Sep 19, 2022 02:17 AM
    Hi,

    The user has the "create trigger" right. The above issue with db load we are seeing first time in 21.0.3 -> 21.0.4 upgrade. It was not there in the past with exactly same rights as listed above.

    Regards
    P Verghese


  • 4.  RE: U00003590 UCUDB - DB error: 'OCIStmtExecute', 'ERROR ', '', 'ORA-01031: insufficient privileges

    Broadcom Employee
    Posted Sep 19, 2022 10:22 AM
    Hi,
    I will investigate internally and get back to you within the next few days.
    Regards, Markus


  • 5.  RE: U00003590 UCUDB - DB error: 'OCIStmtExecute', 'ERROR ', '', 'ORA-01031: insufficient privileges

    Broadcom Employee
    Posted Sep 21, 2022 03:56 AM
    Hi
    ,
    please refer to
    https://docs.automic.com/documentation/webhelp/english/ALL/components/DOCU/21.0.4/Automic%20Automation%20Guides/Content/_Common/ReleaseHighlights/WhatsNew_21_0_4.htm

    The create trigger permission is required from 21.0.4 to create a new trigger in the database. This is for the AAI integration and is deactivated per default.

    That requirement was also added to following page:
    https://docs.automic.com/documentation/webhelp/english/ALL/components/DOCU/21.0.4/Automic%20Automation%20Guides/Content/Installation_Manual/AE/SetUptheAEDatabase.htm?Highlight=oracle%20grant

    Kindly double check if the user has the additional grant for CREATE TRIGGER. If it is still not possible to create the trigger please let me know.

    Thank you!

    Regards, Markus


  • 6.  RE: U00003590 UCUDB - DB error: 'OCIStmtExecute', 'ERROR ', '', 'ORA-01031: insufficient privileges

    Posted Sep 22, 2022 02:27 AM
    Hi @Markus Embacher,

    I found that the DB user also requires the CREATE VIEW privilege.​

    /Keld.


  • 7.  RE: U00003590 UCUDB - DB error: 'OCIStmtExecute', 'ERROR ', '', 'ORA-01031: insufficient privileges

    Broadcom Employee
    Posted Sep 22, 2022 02:53 AM
    Hi @Keld Mollnitz,

    the CREATE VIEW privilege is listed as a required permission too.

    https://docs.automic.com/documentation/webhelp/english/ALL/components/DOCU/21.0.4/Automic%20Automation%20Guides/Content/Installation_Manual/AE/SetUptheAEDatabase.htm#link3

    Regards, Markus​


  • 8.  RE: U00003590 UCUDB - DB error: 'OCIStmtExecute', 'ERROR ', '', 'ORA-01031: insufficient privileges

    Posted Sep 22, 2022 03:07 AM
    Hi @Markus Embacher,

    yes, you are right.​ CREATE VIEW was also listed in the 12.3 documentation....
    If the CREATE TRIGGER privilege was also mentioned in the 21.0.4 Release Notes, then customers could avoid the issue in the first hand....


  • 9.  RE: U00003590 UCUDB - DB error: 'OCIStmtExecute', 'ERROR ', '', 'ORA-01031: insufficient privileges

    Posted Sep 21, 2022 04:18 AM
    Please make sure your AE DB user has the "APPL_ROLE and SELECT_CATALOG_ROLE " rights.

    ------------------------------
    Dominic I
    ------------------------------



  • 10.  RE: U00003590 UCUDB - DB error: 'OCIStmtExecute', 'ERROR ', '', 'ORA-01031: insufficient privileges

    Broadcom Employee
    Posted Sep 22, 2022 06:31 AM
    Edited by Markus Embacher Sep 22, 2022 06:32 AM
    A KB article has been created:
    https://knowledge.broadcom.com/external/article?articleId=250492