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:
Expected Results: Datamart Extraction job should succeed.
Actual Results: Datamart Extraction job is failing with the errors above.
select odf_object_code, code,length(name)
order by length(name)desc
Release : 15.9.3