Datamart Extraction Job Failing after upgrade to 15.9.3 - Error in NBI_PROJECT_CURRENT_FACTS_SP - Inserting into NBI_PROJECT_CURRENT_FACTS: value too long for type character varying(240)
PostgreSQL error message:
Error in NBI_PROJECT_CURRENT_FACTS_SP - Inserting into NBI_PROJECT_CURRENT_FACTS: value too long for type character varying(240)
Oracle error message:
java.sql.SQLException: [CA Clarity][Oracle JDBC Driver][Oracle]ORA-20000: Error in NBI_EXTRACT_SP - Executing NBI_EXTR_PCF_SP: ORA-20000: Error in NBI_EXTR_PCF_SP - executing NBI_PROJECT_CURRENT_FACTS_SP: ORA-20000: Error in NBI_PROJECT_CURRENT_FACTS_SP - Calling NBI_PROJECT_FORECAST_SP since there are projects with Forecast: ORA-06502: PL/SQL: numeric or value error: Bulk Bind: Truncated Bind
ORA-06512: at "NIKU.NBI_EXTRACT_SP", line 362
ORA-06512: at line 1
STEPS TO REPRODUCE:
1. Create an Investment with Name length 256 characters as per UI allowance (This issue is with any investment name that is longer than 240 characters)
2. Run Datamart Extraction job
Expected Results: Datamart Extraction job should succeed
Actual Results: Datamart Extraction job is failing with the errors above
Release : 15.9.3
DE62599, Fixed in 16.0 and 15.9.3.1.
Workaround:
select odf_object_code, code,length(name)
from inv_investments
order by length(name)desc