I thought I'd share an issue I had with a customer:
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)
(Value for "actual" may vary.)
A translation with a value over 255 characters was entered on a lookup value, for a language included in Data Warehouse
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.
As best practice we recommend you to keep the translation names for lookup values to be short and concise and under 255 characters
I've posted this as:
KB TEC1814223 which should be available shortly.
Hope this helps -Nika
Thank you for sharing this tip with the community Nika!
Tech Tip: Load Data Warehouse job fails with ORA-12899 on DWH_LKP_TRANSLATION