Cannot or unable to create the reporting schema in OpenPages

Technote (troubleshooting)


Problem(Abstract)

When trying to create a Reporting Schema, the process errors out.

Cause

There are invalid relationships or versions stored in the reporting period snapshots

Diagnosing the problem

In the OpenPages UI, navigate to "Administration" => "Reporting Schema"

Select the name of the "Create Reporting Schema" that failed.

Select the "View Log" button.

One of the top rows will show a status as follows:

Create Reporting Schema: ERROR Object = General_; Parameters = [-2291, ORA-02291: integrity constraint (OPENPAGES.SYS_C0083370) violated - parent key not found, INSERT INTO rt__process_subprocess(process_id,subprocess_id,hier_instance_id,reporting_period_id,is_primary,distance) VALUES (:BIND_1,:BIND_2,:BIN...] The requested operation could not be completed. Please contact your System Administrator.


Resolving the problem

The steps to run are as follows: after downloading the associated SQL files:

  1. An Administrator must log onto the OpenPages Application server and extract the contents of the zip files into a folder (i.e. C:\OP_FIX).
  2. Open a CMD, and CD to the folder that the files were extracted to in step 1.
  3. Log into the OpenPages database as the OPENPAGES schema (not a DBA). An example is as follows:
    sqlplus openpages/openpages@SID
  4. Run the following command:
    @runner1.sql
  5. Run the following command:
    @runner2.sql
  6. Log into the OpenPages Application as an Administrator.
  7. Using the navigation menubar, navigate to "Administration" => "Reporting Schema".
  8. Make sure that System Admin Mode (SAM) is enabled.
  9. Drop the Reporting Schema.
  10. Create the Reporting Schema.

Rate this page:

(0 users)Average rating

Add comments

Document information


More support for:

OpenPages GRC Platform

Software version:

5.1, 5.5, 5.5.2, 6.0, 6.0.1, 6.1, 6.2

Operating system(s):

Platform Independent

Reference #:

1632809

Modified date:

2013-05-14

Translate my page

Machine Translation

Content navigation