Posted: 13 Mar 2017 13:17 EDT Last activity: 14 Mar 2017 12:54 EDT
sppr_aggregate_usage referencing PR_HOURLY_USAGE table in PegaRules vs Pegadata
We have just installed PRPC 7.2.2. with split-schema. We are getting an exception which looks like the sproc sppr_aggregate_usage is referencing the PR_HOURLY_USAGE table in the PegaRULES schema instead of the PegaDATA schema.
Is there a HFix for this? Is the only fix a local fix to update the sproc?
***Updated by moderator: Lochan to add Categories***
Did you install 7.2.2 or upgrade from another version? The OOB stored procedure does not reference the rules schema. If you look at the stored procedure body everything should be schema qualified with the data schema name. What is the actual exception that you are seeing?