Load Data Warehouse job - Full Load on Oracle fails with error: [CA Clarity][Oracle JDBC Driver][Oracle]ORA-12899: value too large for column "PPM_DWH"."DWH_LKP_TRANSLATION"."TRANSLATION" (actual: 1500, maximum: 255)

Document ID : KB000008990
Last Modified Date : 14/02/2018
Show Technical Document Details
Issue:

On a multilingual environment:

Load Data Warehouse job - Full Load on Oracle fails with error:
[CA Clarity][Oracle JDBC Driver][Oracle]ORA-12899: value too large for column "PPM_DWH"."DWH_LKP_TRANSLATION"."TRANSLATION" (actual: 1500, maximum: 255)

(Note: Value for "actual" may vary.)

Cause:

A translation with a value over 255 characters was entered on a lookup value, for a language included in Data Warehouse

Resolution:

1. On the PPM database, please connect with a database query analyser tool and run the query:
select * from DWH_LOOKUPS_V where length(NAME )>255
2.In the results, note the name of the Lookup (Lookup_type) and Lookup_code (the lookup_value), and the language.
3. Now go to Lookups and open the lookup type you found in the query results.
4. Go to the Values and find the value above, click on the Translate icon
5. For the languages indicated, (so all languages included in DWH), correct the Name to be under 255 characters. The Description field can go beyond this limit, so you may leave it and not change it.
6. Save and Return
7. Now run Load Data Warehouse Full until completion

Additional Information:

As best practice we recommend you to keep the translation names for lookup values to be short and concise and under 255 characters

 

To discuss this issue, join us in the Communities:
https://communities.ca.com/message/242026740-tech-tip-load-data-warehouse-job-fails-with-ora-12899-on-dwhlkptranslation