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

    Rosetta 7.2 Service Pack ends with WARNING related to rep DPS 20274.sql script

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

    Symptoms

    During installation of SP 7.2 you get a warning message:

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

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

    v249_rep00@DPS3> v249_rep00@DPS3> v249_rep00@DPS3> DELETE from DELIVERYVIEWER
    *
    ERROR at line 1:
    ORA-02292: integrity constraint (V249_REP00.FKE4A14C451879DE45) violated - child record found
    
    Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
    SQL_FAILED: /exlibris1/operational_shared/service_pack/download/7.20/build_dir_7.2.0.0/install_sp_dir/sql/content_sql/7_2_0/WARN/rep_DPS_20274.sql
    

    Cause

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

    The reason script failed is that File viewer 'File Flex Paper' is still configured in File Delivery Rules.

    Resolution

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

     


    • Article last edited: 14-Feb-2022