Symantec IGA

  • Private Community
Back to discussions
Expand all | Collapse all

Post-install SQL Scripts for Indetity Portal failed to execute and need to be executed manually

  • 1.  Post-install SQL Scripts for Indetity Portal failed to execute and need to be executed manually

    Posted Apr 02, 2019 01:02 PM

    Hi

     

    I have made the update of ids 14.1 to the version ids 14.2 but at the end it generates the following error (see image)

     

     

    Any idea how I can connect to the DB to run this script


    IDS has been deployed in stand-by mode and the database is the generic one provided by the appliance

    the command to execute in the script is the following

     

    update request_backend_msg msg set ISSYSTEM = 0, ROOTID = (select bck.ROOTID from request_backend bck where bck.id = msg.req_backend_id);
    commit;

     

    Any idea for this



  • 2.  Re: Post-install SQL Scripts for Indetity Portal failed to execute and need to be executed manually

    Broadcom Employee
    Posted Apr 07, 2019 06:44 AM

    It is not clear why the automatic script failed.

    You can login with SSH and type 'compressLogs' and get all the logs of the VApp to check.
    You can also login to the database with SQL Developer and run the script manually.

     

    If you still require assistance, please open a support case.