Skip to main content

This content has been archived and is no longer being updated. Links may not function; however, this content may be relevant to outdated versions of the product.

Support Article

Missing index in PRPC shipped schema

SA-29415

Summary



The user noticed that after installing Pega 7.2 and upgrading to Pega 7.2.1, there is a missing Pega 7 Platform Shipped Schema for tree navigation

Error Messages



No Errors as such but system is showing index pr_sys_appcache-Shortcut_idX1 in PRPCRules schema is missing.

Steps to Reproduce

  1. Navigate to PRPC schema report
  2. Click on missing PRPC shipped schema.


Root Cause



On MSSQL, The create index statement is using include clause to add pzInskey in the index column list. 
CREATE INDEX pr_sys_appcache_shortcut_idx1 
ON PegaRULES.pr_sys_appcache_shortcut 

"pzImplementationKey" asc,"pzAppHash" asc,"pzPrimaryPageClassName" asc,"pzRuleName" asc,"pzRuleType" asc 
)INCLUDE(pzInsKey ) 

The upgrade applications schema page tries to retrieve the index column list using the JDBC DatabaseMetadata interface and tries to match the index colum list with data available in pr_changelog. The entries in this table are imported during installation/upgrade. 

DatabaseMetadata interface for MSSQL jdbc driver doesnt return the columns in the INCLUDE list when a call to getIndexInfo is made. This results in mismatch of column list available in pr_changelog. 

The issue is with the MSSQL jdbc driver which doesnt return those index columns which are part of INCLUDE list when DatabaseMetadata.getIndexInfo(..) call is made.

Resolution



Perform the following local-change: 
  1. Drop the index pr_sys_appcache_shortcut_idx1 
  2. Create using the below SQL command 



CREATE INDEX pr_sys_appcache_shortcut_idx1 
ON PegaRULES.pr_sys_appcache_shortcut 

"pzImplementationKey" asc,"pzAppHash" asc,"pzPrimaryPageClassName" asc,"pzRuleName" asc,"pzRuleType" asc, "pzInsKey" asc 
)




 

Published October 28, 2016 - Updated October 8, 2020

Was this useful?

0% found this useful

Have a question? Get answers now.

Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.

Did you find this content helpful?

Want to help us improve this content?

We'd prefer it if you saw us at our best.

Pega Community has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice
Contact us