CMS Snapshot Analysis - Compute Snapshot - Fatal Error - Error while executing procedure - Pwc Diag Scope EFF004

This page outlines the issue with a power center QR "PowerCenter:Avoid "Sorted Input" set to false for aggregators and joiners after a Sorter Transformation" where the snapshot crashes while executing one of the SQL procedures.
The snapshot crashes at the compute step with the following error:

ERR: 2015-02-12 22:51:19: Error while executing Procedure
com.castsoftware.java.InternalException:Error while executing Procedure

Error free logs - CMS Snapshot Analysis - Run Universal Analyzer - Custom UA profile - Error Free Logs - CAST AIP 8 - CAST Internal

1. Install Power center package 2.1.1
2. Run Analysis and Snapshot.
3. Snapshot fails with error.

Since the procedure is not mentioned in the Cast-MS log file,query it in the DSS_HISTORY table on the local base.

1. To find the last executing procedure run the below query

   select * from <KB name>.dss_history order by history_id desc;

   You get the following result

   Start PWC_DIAG_SCOPE_EFF004 -3 61019 1665542 1665543;"2015-02-17 09:39:20.53586";516373

   So this procedure has started but has not ended and has led to the crash of the snapshot.

2. We have to retrieve the quality rule that have the total procedure PWC_DIAG_SCOPE_EFF004..

   For this refer to the following page SQL Queries - CAST Knowledge Base - Queries on metrics and diagnostics - How to list all Quality Rules and their definition from the Metric Tree,

   This page provides all the Quality Rules and their definition from the Metric Tree on the knowledge base,

3. Search for the procedure name "PWC_DIAG_SCOPE_EFF004", then retrieve the correspondent quality rule, for this case the correspondent quality rule is:

   "PowerCenter:Avoid "Sorted Input" set to false for aggregators and joiners after a Sorter Transformation"

4. The work around for this issue is to
   1. Disable the QR "PowerCenter:Avoid "Sorted Input" set to false for aggregators and joiners after a Sorter Transformation" which is using the failing procedure. Refer the following page in order to disable this QR: CMS assessment model

This issue comes from one of the procedure in the power center package.
The procedure has been optimized and is planned to be improved in the next power center package.