Error generating the reporting schema

When you generate the reporting schema, the process fails with an error.

Symptoms

When you generate the reporting schema, you see an error that is similar to the following message: 
StatusCreate Reporting Schema: ERROR Object = General_; Parameters = [-727, SQL0727N An error occurred during implicit system action] The requested operation could not be completed. 
Please contact your system administrator.

Causes

After Db2® is upgraded, the database might contain invalid objects. The invalid objects cause the reporting schema generation process to fail.

Environment

This issue applies when you upgrade OpenPages and you are using the database that is provided with OpenPages. The issue does not occur in fresh installations of OpenPages.

Resolving the problem

  1. Log in to the Db2 container.
    oc exec -it c-db2oltp-<instance_id>-db2u-0 bash
  2. Run the following query to check if there are any invalid objects in the database:
    db2 connect to OPX
db2 "select objectschema, objectmodulename, routinename, objectname, objecttype from syscat.invalidobjects"
  3. If the query in step 2 returns any value other than 0, run the following query:
    db2 "call admin_revalidate_db_objects(null,null,null)"
  4. Re-run the query from step 2 to verify the fix:
    db2 connect to OPX
db2 "select objectschema, objectmodulename, routinename, objectname, objecttype from syscat.invalidobjects"

    The expected result is 0.

  5. Generate the reporting schema.