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

SA-20349

Summary



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
com.pega.pegarules.pub.database.DatabaseException: 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.

Resolution



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.
Suggest Edit

Published February 27, 2016 - Updated October 8, 2020

Did you find this content helpful? Yes No

Have a question? Get answers now.

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

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