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

Error while installing Pega Survey 7.12 framework



User reported error during the installation of PegaSURVEY 7.12 Framework on PRPC 718. The problem was related to the following SQL statement:

alter table PEGA_SVP_RULES_A.pr_index_circumstance_def add (Mode VARCHAR2(32) )

The error message is related to invalid identifier. Mode is an Oracle reserved keyword and user wants to know why it is required to import the jar.

Error Messages

2016-02-09 16:33:18,379 [.PRPCWorkManager : 1] [  STANDARD] [                    ] [     PegaRULES:07.10] (  internal.access.DatabaseImpl) ERROR  lid2l82_admin - Error occured while trying to add Index columns for an property Database-General    Problem executing SQL to update database schema    904    42000    ORA-00904: : invalid identifier

From: (BFCEE4A265A33B811C58DFDE8DE6A20E4) 
    SQL: alter table RULES.pr_index_circumstance_def add  (Mode VARCHAR2(32) )

Caused by SQL Problems.
Problem #1, SQLState 42000, Error code 904: java.sql.SQLSyntaxErrorException: ORA-00904: : invalid identifier

Steps to Reproduce

  1. Install PegaSURVEY 7.12 on PRPC 718

Root Cause

A defect in Pegasystems’ code or rules is identified as the root cause of this issue.


Mode is a reserved keyword in Oracle. There is a property named "Mode" in one of the PegaSURVEY classes which is causing this problem. There is  no use of "Mode" in "pr_index_circumstance_def" table. So, the error message in this case can be ignored. The fix for this issue is being tracked through BUG-221296. It is targeted to be addressed in future PegaSURVEY release.

Published February 27, 2016 - Updated October 8, 2020

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