CMS Snapshot Analysis - Compute Snapshot - Fatal Error - Error while executing procedure - function does not exist

This page helps you to resolve the snapshot issue where it is failing with the error in CAST-MS log -' function updateobjectstatistics(information_schema.sql_identifier, integer) does not exist' 

 ERROR: function updateobjectstatistics(information_schema.sql_identifier, integer) does not exist
      Hint: No function matches the given name and argument types. You might need to add explicit type casts.
      Where: PL/pgSQL function dss_gather_stats() line 10 at PERFORM
      org.postgresql.util.PSQLException:ERROR: function updateobjectstatistics(information_schema.sql_identifier, integer) does not exist

1. Run snapshot
2. Observe it is failed at compute snapshot step

If you observe that the snapshot is failing at compute snapshot step with the above mentioned error, then please perform the below actions :

1. If you are using postgresql version<12, then please perform the below action 
   1. Perform component reinstall from server manager and see if the function is created under central schema.
      1. If function is present then take a snapshot skipping analysis
      2. If function is not present then go to next step
   2. Copy the function 'updateobjectstatistics' from any existing schema of same AIP version and run on faulty schema followed by snapshot skipping analysis.
2. If you are using postgresql version=12, then please run the attached procedure  on central schema fix_pg12_DSS_GATHER_STATS and take a snapshot skipping analysis. This is a known issue when using a postgresql version 12.
3. If the above steps do not solve your issue contact CAST Technical Support. with the following Relevant input 

Relevant input

• CAST Support Tool (CST) - alias Sherlock export with the following options Export CAST Bases with Management Base, Knowledge Base, Central base
• CAST-MS log file

Ticket # 24898