search cancel

Upgrade fails on inserting lookup with java.lang.ArrayIndexOutOfBoundsException


Article ID: 129073


Updated On:


Clarity PPM SaaS Clarity PPM On Premise


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

Checking the out file:
java.lang.ArrayIndexOutOfBoundsException: 0
at com.niku.odf.ori.service.DynamicLookupService.updateNsql(
at com.niku.odf.ori.OdfEngine.importDynamicLookup(
at com.niku.odf.ori.xblhandlers.LookupsXogImportHandler.updateDynamicLookup(
at com.niku.odf.ori.xblhandlers.LookupsXogImportHandler.updateLookup(
at com.niku.odf.ori.xblhandlers.LookupsXogImportHandler.processXogRequest(
at com.niku.odf.ori.xblhandlers.LookupsXogImportHandler.postProcess(
at com.niku.xql2.XQLVisitor.postProcess(


Release: CODFSS99000-15.4.1-PPM SAAS FedRAMP-Sandbox-Small Environment


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 =
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.


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