Discussion
Cognizant Technology Solutions
US
Last activity: 6 Apr 2018 19:26 EDT
BIX extract scripts failing after upgraded from PRPC 6.1 SP2 to PRPC 7.1.7
BIX extract scripts failing after upgrade from PRPC 6.1 SP2 to PRPC 7.1.7. Identified that the 'PR_SYS_QUEUES_BIX' and 'PR_EXTRACT_TIME’ gets dropped after the upgrade.
**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.
Cognizant Technology Solutions
US
Prior to Pega 7.1.7 the 'PR_SYS_QUEUES_BIX' , 'PR_EXTRACT_TIME’ table was created during the installation of core Pega. Starting in 7.1.7 it needs to be created as part of the installation of BIX. Since the core Pega upgrade no longer needs these tables and are getting dropped.
Prior to running the upgrade scripts, remove the dropping of these table scripts from the generated ddl before applying it.
If this issue is identified after the upgrade and the tables are alredy been dropped, recreate these tables as part of the installation of BIX 7.1.7. For the existing content of these tables, need to use database tools to copy the old table content to your new rules schema.
The Readme file in the AdditionalProducts/BIX directory has a following note telling to create these tables if they are not present.
Please apply DDL scripts manually to create the tables pr_extract_time and pr_sys_queues_bix if not already present in PegaRULES schema
AIG
US
We observed above table missing in "Lift and Shift" approach while building SIT
Solution : Either execute create script of above table in DB or reimport BIX package again
TCS
GB
I would appreciate if the " the said note in the Readme file in the AdditionalProducts/BIX directory" is qouted in the BiX upgrade guide as well.
Thanks, Jaffer
Pegasystems Inc.
US
Hi Jaffer,
That information has been added to the new upgrade section in the BIX User Guide that will be available in the next release.
Mary Anna
TCS
GB