Upgrade fails on inserting a lookup (can be any lookup):
3/08/19 8:04 PM (ExecTask) Error Applying XOG: Failure occurred while applying RQP_BROWSE_INVESTMENTS_LOOKUP.xml 3/08/19 8:04 PM (ExecTask) Check Home Directory/logs/xog-seeddata/out/database/RQP_BROWSE_INVESTMENTS_LOOKUP_out.xml for errors 3/08/19 8:04 PM (ExecTask) Home Directory/.setup/scripts/db.xml:2352: The following error occurred while executing this line: 3/08/19 8:04 PM (ExecTask) Home Directory/.setup/scripts/db.xml:2568: The following error occurred while executing this line: 3/08/19 8:04 PM (ExecTask) Home Directory/.setup/scripts/db.macros.xml:105: Java returned: 2
Lookup is no longer present on the database
SQL query used to check:
select * from cmn_list_of_values clov, cmn_nsql_queries cnq
where clov.sql_text_id = cnq.id
and lookup_type_code ='RQP_BROWSE_INVESTMENTS'
If rolled back already, try opening the lookup and accessing the dynamic SQL, as that may give an error as well.
Release: CODFSS99000-15.4.1-PPM SAAS FedRAMP-Sandbox-Small Environment
1. Rollback to previous environment or installed checkpoint
2. Ensure the lookup is there (insert from another environment if needed by XOG)
3. Stop services and re-start the upgrade