Support Article
Database table error when importing circumstanced rule
SA-17986
Summary
When attempting to import a circumstanced rule an error is observed.
Error Messages
From: (A3305832B0C25372A8D723F0A6BCB2FF3:PPDeployServicePackage)
SQL: alter table PRPC71.pr_index_circumstance_def add (IsNewBNAA VARCHAR2(5) )
Caused by SQL Problems.
Problem #1, SQLState 42000, Error code 942: java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist
Steps to Reproduce
- Create a circumstanced rule with the property "IsNewBNAA " in one environment.
- Import the rule to another environment.
Root Cause
A defect or configuration issue in the operating environment: The referenced table cannot be found in the database or lacks the appropriate column for rule circumstancing.
Resolution
Create the table with a circumstancing column.
Published January 31, 2016 - Updated October 8, 2020
Have a question? Get answers now.
Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.