A.14 Resetting Graph Pipeline Back to Day 0

To reset the graph pipeline to Day0 batch, follow these steps:

1. Navigate to <COMPLIANCE_STUDIO_INSTALLATION_PATH>/deployed/ficdb/ GraphPipeline-Cleanup-Scripts directory.
2. Perform the steps provided in the README.md file.

   Note:

   • User should provide "graph_id" value in lowercase when running the following cleanup scripts:

     GraphPipeline_cleanup_day0_in_studioschema.sql
     GraphPipeline_cleanup_day0_in_graphschema.sql

   • The graph_id value can also be fetched in the MMG_GRAPH_SCHEMA table from the Studio Schema.
3. Execute the following command:

   BEGIN
               FOR rec IN (
                  SELECT
                        index_name
                  FROM
                         user_indexes
                   WHERE
                      status = 'UNUSABLE' ) LOOP
                   EXECUTE IMMEDIATE 'ALTER INDEX ' || rec.index_name || '
        REBUILD';
            dbms_output.put_line(rec.index_name || ' index rebuilt');
       END LOOP;
   END;

4. Restart PGX server.