We are upgrading from v5.5 to 7.1.9 and for CPM to CS 7.1.4. While importing CSSample.jar we have issue with table not exist exception. We have 2 databases PRPC DB(PegaRules schema, PegaData schema) and separate Sample database and there corresponding DataBase rule instances set appriopriately.
Now while importing sample package, we generaed ddl's and all ddl's are generated with PegaData schema ..... is this something wrong ? my guess is it it should have generated ddls' for Sample database schema ? please correct me if i wrong ? we manually edited the ddl's to change schema to Sample and applied to DB. Now while reimporting package, it is trying to save instances to the table in PegaData schema and throwing excpetion table not found . Example tables are as below. do i need to put this table back to PegaUSR schema instaed of Sample schema ? please help ...
CREATE TABLE SAMPLE.pa_contact
CREATE TABLE SAMPLE.pa_address
**Moderation Team has archived post**
This post has been archived for educational purposes. Contents and links will no longer be updated. If you have the same/similar question, please write a new post.
Did you change the your sample database reference properly? Can you make sure that your Data-Admin-Database sample instance is pointed to correct database along with all the sample tables are pointed to respective database instance and check the test connection.
Posted: 7 years ago
Posted: 18 Dec 2015 8:14 EST
Ravindra Mandya Girigowda (ravindra007)
Pega Lead System Architect
This was also our first checkpoint, we checked Sample Data-Admin-Database instance, it is set up to connect using JDBC connection pool with correct userId and password. We tested this two ways 1> clicking Test connection in Sample database instance 2> Opened sample class like PegaApp-Interface-Account and did Test Connection, it is showing "Class PegaApp-Interface-Account is mapped to table SAMPLE.pa_account in database Sample." so our connections are good.
Also when we went ahaed to import IIF package, it generated DDl's where i could see some ddl's was having Sample scheme referencced properly. Now question is if IIF package can identify Sample schema, why CS Sample package is not doing same... We guess some bug in that package. Please help here.