Skip to main content
ExLibris

Knowledge Assistant

BETA
 
  • Subscribe by RSS
  • Back
    Rosetta

     

    Ex Libris Knowledge Center
    1. Search site
      Go back to previous article
      1. Sign in
        • Sign in
        • Forgot password
    1. Home
    2. Rosetta
    3. Knowledge Articles
    4. Rosetta 7.1 Service Pack ends with WARNING related to rep_DPS_20123.sql script

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

    1. Last updated
    2. Save as PDF
    3. Share
      1. Share
      2. Tweet
      3. Share
    1. Symptoms
    2. Cause
    3. Resolution
    • 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
    View article in the Exlibris Knowledge Center
    1. Back to top
      • Rosetta service pack 5.2 ends with warning related to the script rep_DPS_16142.sql
      • Rosetta SP 7.4 installation corrupts cantaloupe delivery
    • Was this article helpful?

    Recommended articles

    1. Article type
      Topic
      Content Type
      Knowledge Article
      Language
      English
      Product
      Rosetta
    2. Tags
      This page has no tags.
    1. © Copyright 2025 Ex Libris Knowledge Center
    2. Powered by CXone Expert ®
    • Term of Use
    • Privacy Policy
    • Contact Us
    2025 Ex Libris. All rights reserved