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

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