Skip to main content
ExLibris
  • Subscribe by RSS
  • Ex Libris Knowledge Center

    Rosetta 7.1 Service Pack ends with WARNING related to rep_DPS_20123.sql script

    • Product: Rosetta
    • Product Version: 7.1
    • Relevant for Installation Type: Local

    Symptoms

    During installation of SP 7.1 you get a warning message:

    | [>>] Executing SQL's Scripts ................................ [ WARNING ]
    | [ >] - Encountered 1 Warnings: .............................. [ ^ ]
    | [ >] - content_sql/7_1_0/rep_DPS_20123.sql .................. [ ^ ]

    In install_sp.log (under $dps_dev/local_sp_install/7.1.0.0/log) you will find 

    v232_rep00@ROSETTAQ> v232_rep00@ROSETTAQ> v232_rep00@ROSETTAQ> DELETE from DELIVERYVIEWER
    *
    ERROR at line 1:
    ORA-02292: integrity constraint (V232_REP00.FK_OUT_DELIVERYVIEWERID) violated - child record found
    
    
    Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
    SQL_FAILED: /operational_shared/service_pack/download/7.10/build_dir_7.1.0.0/install_sp_dir/sql/content_sql/7_1_0/WARN/rep_DPS_20123.sql
    

    Cause

    The script that failed was supposed to remove the deprecated viewer 'Flex Paper Viewer'.
    We no longer need this viewer because it can be replaced with 'FlexPaper Viewer (HTML5)'.

    The reason it failed is it is still configured in IE delivery rules.

    Resolution

    1. re-configure IE Delivery Rules (Rosetta Administration)
    2. Run the rep_DPS_16142.sql script manually:
      1. ssh to one of Rosetta servers with dps user
      2. s+ rep00
      3. DELETE from DELIVERYVIEWER where id = 9 AND NAME = 'Flex Paper Viewer';
        commit;
        quit
      4. restart Rosetta (dps_restart)

     


    • Article last edited: 26-Jul-2021