Skip to main content

This content has been archived and is no longer being updated. Links may not function; however, this content may be relevant to outdated versions of the product.

Support Article

Pharmacovigilance Agreements error: ORA-12899: value too large

SA-18318

Summary



When a user updates Pharmacovigilance Agreements within the Pharmacovigiliance Exchange, an error message is generated: ORA-12899: value too large for column


Error Messages



10:52:01,402 [ajp-/your_IP_address:16719-8] (WithErrorHandling.Work_.Action) ERROR - Error in commit() 
com.pega.pegarules.pub.database.DatabaseException: Database-Saver-InsertUpdatefail 

                   SQL: insert into .......
                           
 
Caused by SQL Problems. 
Problem #1, SQLState 72000, Error code 12899: java.sql.SQLException: ORA-12899: value too large for column "RULES_ADM"."AUDITDETAILS"."NEWVALUE" (actual: 260, maximum: 256) 
 


Steps to Reproduce

Perform an operation that inserts a value in to the affected column.


Root Cause



A defect in Pegasystems’ code or rules. The code was not configured to handle unicode.  As a result, the number of characters stored is greater than the number of bytes.

Resolution



Perform the following local-change:

Modify the column to be of different type and also of a larger size:


ALTER table_name MODIFY column_name VARCHAR2(256 CHAR)

 

Published January 31, 2016 - Updated December 2, 2021

Was this useful?

0% found this useful

Have a question? Get answers now.

Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.

Did you find this content helpful?

Want to help us improve this content?

We'd prefer it if you saw us at our best.

Pega Community has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice
Contact us