Question
SedgwickCMS
US
Last activity: 23 Dec 2015 10:38 EST
PEGARULES.PCA_RULE_TASK table is not get identified while importing the Intent Task rules..Import Errored out
Hi,
We are trying to move the product where we have Intent Task rules and we see the error PEGARULES.PCA_RULE_TASK is not identifiable.
1. But we have the table in back end oracle db
2. Tried to re save the DB table instance and did the test connectivity..Even test connectivity is failing.
Any help what other possibilities why it it is failing.
Thanks
Pegasystems Inc.
IN
could we double check the schema? (PegaRULES, DB Connections). also please copy the error screenshot.
SedgwickCMS
US
Please find the screen shots
Pegasystems Inc.
US
can you check for Rule-PegaCA-Dialog class definition, is it mapped to right schema or not?
SedgwickCMS
US
Yes the Rule-PegaCA-Dialog is mapped to correct schema, for this instance the test connectivity is failing and the table exist in back end oracle db.
I am wondering if the schema name is wrong it should fail for other class or db instances with PEGARULES which is not happening.
Pegasystems Inc.
US
basically all the Rule-PegaCA- tables would in the same schema. If you are able to do the Test connectivity for Rule-PegaCA-Dialog and if its working fine, can you check in the SMA whether you able to see that table under database table information
SedgwickCMS
US
Verified Rule-PegaCA-Dialog test connectivity and it is failing...In SMA I see the table but when i select and click on List Record Count it is throwing error
"TableInfo : DatabaseException occured. Problem obtaining results from database: Database-General There was a problem getting a list 942 42000 ORA-00942: table or view does not exist"
Seems all the tables that start with PCA_ have this issue...
Are there any possibilities that something went wrong from Database side, any idea what it could be.
Pegasystems Inc.
US
Looks like the database configuration is not mapped correctly.