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