CMS Snapshot Analysis - Run Analyzer - Fatal Error - SQL Error - Peoplesoft - O6550 SQL Error PLS - 00201 identifier xyz PSOFT UAMETRICS UPDATE must be declared

This page gives a solution to below error  which occurs during PeopleSoft analysis while running the job PeopleSoft Analysis Content Update

1. Configure Peoplesoft job
2. run analysis

This issue occurs if the Peoplesoft language is not correctly installed in the KB. To confirm the same, the below queries will help us to check that the pck files are correctly referenced in InstallScripts and confirm that the functions are created  on the local.

Run the below queries on both the Knowledge Bases(For vanilla and project) :
1. select * from SYS_PACKAGE_VERSION where PACKAGE_NAME='PEOPLESOFT_LOCAL'
2. select * from all_objects where object_name = 'PSOFT_UAMETRICS_UPDATE'

If the above queries do not return any rows then follow the below steps to solve the issue :

1. see that the files central_client.pck & local_client.pck are placed in correct location as mentioned in the documentation -
   1. Select folders configuration and InstallScripts from PeopleSoft_V4.0.0\Deployment\01_Installation and copy them at the root of folder “C:\Program Files\CAST\7.0.x for PeopleSoft V4.0.x”. Acknowledge the merge folder (InstallScripts) dialog.
   2. If no previous custom package has been deployed to this AIP, then rename in InstallScripts\Common the files central_client.pck.template and local_client.pck.template without the .template extension. Otherwise, you have to merge their content with the existing files from other custom packages.
2. If not then you need to follow the above steps you need to do the
3. Run component re-install which will install the missing functions
4. re-run the PeopleSoft Analysis Content Update tool

Analysis - PeopleSoft Analysis Content Update tool runs successfully without any error
Dashboard - N/A