Support Article
Add Tables to Database - step of install fails with DB error
SA-16661
Summary
Installing Product Composer for Healthcare 7.12 fails with a database error in the "Add Tables to Database" step.
Error Messages
Msg 8197, Level 16, State 4, Procedure trpca_rule_hc_pcs, Line 3
The object 'pca_rule_hc_pcs' does not exist or is invalid for this operation.
Msg 8197, Level 16, State 4, Procedure trpca_rule_hc_pcs_vw_del, Line 4
The object 'pca_rule_hc_pcs' does not exist or is invalid for this operation.
Msg 8197, Level 16, State 4, Procedure trpca_rule_hc_pcs_vw_upd, Line 5
The object 'pca_rule_hc_pcs' does not exist or is invalid for this operation.
Steps to Reproduce
Run the SQL script to add tables to the PegaRULES database as per step 2 of the Product Composer for Healthcare guide.
Root Cause
A defect in Pegasystems’ code or rules. The database scripts in the media should be schema qualified for split schema setup.
Resolution
Perform the following local-change:
Modify the provided database script to be schema qualified.
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.