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.
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
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
- Install PegaSURVEY 7.12 on PRPC 718
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.