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

Pega 7.4 update fails when importing a zip file



Pega 7.4 update fails when importing the file.

Error Messages

[java]  [main] [ ] [ ] [ ] (internal.loaders.FastLoader) ERROR - Encountered batch element exception:
[java] java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (PEGARULES_UPD.PR4_FIELDVALUE_PK) violated

Steps to Reproduce

Run the Pega 7.4 Update script.

Root Cause

A defect or configuration issue in the operating environment.

Two rules from the batch have special characters in the pzInskey value. The database in this system is using a US7ASCII character set. The US7ASCII is a 7-bit character set that fits all of the supported symbols in a single byte with the high-bit stripped. The query to determine if these rules is already present in the database. However, this query is unable to locate them because of the character encoding and thus attempts to insert them again.

[java] [main] [ ] [ ] [ ] (internal.loaders.FastLoader) ERROR   - The update for instance of type Rule-Obj-FieldValue with key RULE-OBJ-FIELDVALUE @BASECLASS PYMESSAGELABEL!FILE EXCEEDS UPLOAD ATTACHMENT SIZE LIMIT OF #20140814T073601.292 GMT was aborted.
[java] [main] [ ] [ ] [ ] (internal.loaders.FastLoader) ERROR   - The update for instance of type Rule-Obj-FieldValue with key RULE-OBJ-FIELDVALUE @BASECLASS PYMESSAGELABEL!FILE SIZE EXCEEDS ATTACHMENT SIZE LIMIT OF [0] MB. #20141009T063523.695 GMT was aborted.


Perform the following local-change: 
  1. Delete the two rules with special characters from the pr4_fieldvalue and the pr4_rule_vw tables.
  2. Run the Update script.

Published December 13, 2018 - 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