CMS Snapshot Analysis - Run Analyzer - Fatal Error - SQL Error - Peoplesoft - Error while executing Batch select PSOFT DISCRIMINATION

While running the analysis, the tool after analysis Peoplesoft Discrimination with Vanilla tool fail with the error - Error while executing Batch : select PSOFT_DISCRIMINATION(0)

Figure 1

Below is the step-by-step scenario leading to the problem:

1. Run analysis

1. If you are using PeopleSoft version 5.0.1, then this is a bug that was fixed in PeopleSoft version 5.0.3, as a WA you can perform the bellow steps, else contact CAST Technical Support. with the following Relevant input

   1. Execute the contents of PSoft_SQLDiscrimination.sql on the local schema.
   2. Launch Cast-MS
   3. Run the PeopleSoft discrimination with Vanilla SQL tool as shown in the below screenshot 
      Figure 2
   4. If the run succeeds then the issue is resolved, you can run analysis. Else contact CAST Technical Support. with the following Relevant input

Relevant input

• CAST Support Tool (CST) - alias Sherlock export with the following options CAST Bases Checker, Export Logs, Export Configuration files, Export Computer Environment, Export CAST Bases with Management Base, Knowledge Base, Central base,  Export source code