Support Article
Unable to add French data on Excel
SA-2305
Summary
When adding Localization string values from the Excel spreadsheet back into PRPC, a database error is reported. Localization fails to update all of the string configuration values.
Error Messages
Error is displayed in browser window, while attempting to augment Localization values from Excel spreadsheet: Database save failed: ORA-12899: Value to Large for Column
Steps to Reproduce
- Obtain Localization spreadsheet containing values to edit.
- Edit the values with the foreign language equivalents in the spreadsheet
- Upload the spreadsheet back into PRPC to augment Localization values
- Observe the error condition
Root Cause
A defect in customer application code/rules. Specifically, a custom database table was used to store localization string values. As a result, an exposed property reference in the database table was incorrectly sized. The value was defined as Oracle VARCHAR2(64). Per the Database error reported in the logfile, an attempt was made to write a string of length 65bytes to the column.
Resolution
This issue is resolved through the following local change: Issue SQL to update the size of the property value in the database, and then retest.
Published January 31, 2016 - Updated October 8, 2020
Have a question? Get answers now.
Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.