Discussion
Covance
IN
Last activity: 17 Apr 2015 12:42 EDT
Database error while Reindexing the Work rules
Hi All,
In Dev envioronment we are getting error while doing reidnexing for Work instances in dev envvioronment .We are using Pega 6.3 with tomcat 7 and DB as Oracle 11 g.
Below is the exception
Database-General There was a problem getting a list 904 42000 ORA-00904: "PYPRIMARYWORKTYPE": invalid identifier
Is any body come across such issue ? Please share your thoughts on this
Thanks
shiva
Pegasystems Inc.
US
Hi,
Typically this exception is thrown when the mapped database table does not contain the referenced column or the Operator ID you are using to connect PRPC to the Database does not have permissions to reference the referenced column. At a minimum the Operator ID you use to connect PRPC to the Pega DB Repository must have full DML (Data Modification Language) support (Insert, Update, and Delete) on every column of every table in the Pega DB Repository. Here are two articles that may help you resolve this issue:
Invalid Identifier:
Trying to write to non-existent column:
If after double checking everything, you still get the exception please submit a Service Request (SR). You can do so by accessing the new My Support Portal (https://collaborate.pega.com/question/how-raise-sr-my-support-portal-how-question).
Regards,
Henry
Pega Academy
Hi,
Typically this exception is thrown when the mapped database table does not contain the referenced column or the Operator ID you are using to connect PRPC to the Database does not have permissions to reference the referenced column. At a minimum the Operator ID you use to connect PRPC to the Pega DB Repository must have full DML (Data Modification Language) support (Insert, Update, and Delete) on every column of every table in the Pega DB Repository. Here are two articles that may help you resolve this issue:
Invalid Identifier:
Trying to write to non-existent column:
If after double checking everything, you still get the exception please submit a Service Request (SR). You can do so by accessing the new My Support Portal (https://collaborate.pega.com/question/how-raise-sr-my-support-portal-how-question).
Regards,
Henry
Pega Academy