CMS Snapshot Analysis - Run Analyser - Fatal Error - Universal Analyzer - PeopleSoft - function psoft metrics update does not exist

This page is a troubleshooting guide for the below error:

Error while executing batch : Select <Knowledge_Base>.psoft_metrics_update()
Query failed because :
Error : function <Knowledge_Base>.psoft_metrics_update() does not exist.

This error occurs while running peoplesoft analysis during the step of running tools after analysis - "PeopleSoft Metrics Update"

Step by Step scenario

1. Run Peoplesoft analysis

Perform the below actions:

1. Check if the function is installed on your local database
   1. Check with the help of PGAdmin
      
      1. Open PGAdmin
      2. Connect to your server  
      3. Double click on the series starting with Databases -> postgres -> Schemas -> <Knowledge_Base> -> Function
      4. Under functions please check in the list if you have the function "psoft_metrics_update()"
         
   2. Check with the help of Oracle SQL Developer
      1. Launch SQL Developer
      2. Connect to your server
      3. Double click on the name of the database <Knowledge_Base> - > Functions 
      4. Under functions please check in the list if you have the function "psoft_metrics_update()"
2. If it does not exist then it means you have not installed PeopleSoft Language Pack correctly on your databases. Follow the steps under solutions mentioned in this page to solve the issue - CMS Snapshot Analysis - Run Analyser - Fatal Error - Universal Analyzer - Invalid type name xxx not declared in metamodel
   

3. If the function exists and you are still facing the issue or if you are facing the same error after applying the above steps then contact CAST Technical Support with Relevant Input
   For CAST Technical Support only - follow the steps given in the page - CMS Snapshot Analysis - Run Analyzer - Information - How to reproduce user issues for Extension 

Relevant Input

1. CAST Support Tool (CST) - alias Sherlock export
2. Screenshot of the problem