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