Import Reporting tables output errors

Resolving The Problem

After exporting the reporting tables using the Export-Reporting-Schema.cmd, running the following import command will output errors which can be ignored as these errors are not related to the reporting tables, SX_* tables. Below are the steps from the Admin Guide section to perform the import without seeing these errors. ----------------------------------------------------------------------------------------- imp system/,manager@soxtest fromuser='openpages' touser='opexport' file='report-tables.dmp' . importing OPENPAGES's objects into OPEXPORT . . importing table "RPT_OBJECTS" 16 rows imported . . importing table "RPT_RELATIONS" 108 rows imported . . importing table "EFFECTIVE_RIGHTS" 1306482 rows imported . . importing table "RESOURCES" 132333 rows imported . . importing table "USERINFO" 1408 rows imported . . importing table "ACTORINFO" 3788 rows imported . . importing table "FOLDERS" 6576 rows imported . . importing table "FOLDERACLS" 67783 rows imported . . importing table "SX_AUDIT" 280248 rows imported . . importing table "SX__ASSOCIATION" 377098 rows imported . . importing table "SX__ACCOUNT_ACTIONITEM" 0 rows imported . . importing table "SX__ACCOUNT_CONTROL" 0 rows imported . . importing table "SX__ACCOUNT_CONTROLOBJECTIVE" 0 rows imported . . importing table "SX__ACCOUNT_FILE" 0 rows imported . . importing table "SX__ACCOUNT_ISSUE" 0 rows imported . . importing table "SX__ACCOUNT_LINK" 0 rows imported . . importing table "SX__ACCOUNT_RISK" 0 rows imported . . importing table "SX__ACCOUNT_SIGNOFF" 0 rows imported . . importing table "SX__ACCOUNT_SUBACCOUNT" 0 rows imported . . importing table "SX__ACCOUNT_TEST" 0 rows imported . . importing table "SX__ACCOUNT_TESTRESULT" 0 rows imported . . importing table "SX__ACTIONITEM_FILE" 0 rows imported . . importing table "SX__ACTIONITEM_LINK" 0 rows imported . . importing table "SX__CONTROL_ACTIONITEM" 447 rows imported . . importing table "SX__CONTROL_FILE" 9754 rows imported . . importing table "SX__CONTROL_ISSUE" 795 rows imported . . importing table "SX__CONTROL_LINK" 46 rows imported . . importing table "SX__CONTROL_SIGNOFF" 0 rows imported . . importing table "SX__CONTROL_TEST" 6540 rows imported . . importing table "SX__CONTROL_TESTRESULT" 8623 rows imported . . importing table "SX__CONTROLOBJECTIVE_ACTIONITE" 0 rows imported . . importing table "SX__CONTROLOBJECTIVE_CONTROL" 0 rows imported . . importing table "SX__CONTROLOBJECTIVE_FILE" 0 rows imported . . importing table "SX__CONTROLOBJECTIVE_ISSUE" 0 rows imported . . importing table "SX__CONTROLOBJECTIVE_LINK" 0 rows imported . . importing table "SX__CONTROLOBJECTIVE_RISK" 0 rows imported . . importing table "SX__CONTROLOBJECTIVE_SIGNOFF" 0 rows imported . . importing table "SX__CONTROLOBJECTIVE_TEST" 0 rows imported . . importing table "SX__CONTROLOBJECTIVE_TESTRESUL" 0 rows imported . . importing table "SX__ENTITY_ACCOUNT" 4501 rows imported . . importing table "SX__ENTITY_ACTIONITEM" 996 rows imported . . importing table "SX__ENTITY_CONTROL" 14655 rows imported . . importing table "SX__ENTITY_CONTROLOBJECTIVE" 0 rows imported . . importing table "SX__ENTITY_ENTITY" 537 rows imported . . importing table "SX__ENTITY_FILE" 21752 rows imported . . importing table "SX__ENTITY_ISSUE" 1835 rows imported . . importing table "SX__ENTITY_LINK" 128 rows imported . . importing table "SX__ENTITY_PROCESS" 4568 rows imported . . importing table "SX__ENTITY_RISK" 15247 rows imported . . importing table "SX__ENTITY_SIGNOFF" 0 rows imported . . importing table "SX__ENTITY_SUBACCOUNT" 0 rows imported . . importing table "SX__ENTITY_SUBPROCESS" 0 rows imported . . importing table "SX__ENTITY_TEST" 9814 rows imported . . importing table "SX__ENTITY_TESTRESULT" 13922 rows imported . . importing table "SX__ISSUE_ACTIONITEM" 597 rows imported . . importing table "SX__ISSUE_FILE" 91 rows imported . . importing table "SX__ISSUE_LINK" 0 rows imported . . importing table "SX__MILESTONE_ACTIONITEM" 0 rows imported . . importing table "SX__MILESTONE_FILE" 0 rows imported . . importing table "SX__MILESTONE_ISSUE" 0 rows imported . . importing table "SX__MILESTONE_LINK" 0 rows imported . . importing table "SX__MILESTONE_MILESTONE" 0 rows imported . . importing table "SX__PROCESS_ACCOUNT" 36642 rows imported . . importing table "SX__PROCESS_ACTIONITEM" 1312 rows imported . . importing table "SX__PROCESS_CONTROL" 18380 rows imported . . importing table "SX__PROCESS_CONTROLOBJECTIVE" 0 rows imported . . importing table "SX__PROCESS_FILE" 28774 rows imported . . importing table "SX__PROCESS_ISSUE" 2254 rows imported . . importing table "SX__PROCESS_LINK" 171 rows imported . . importing table "SX__PROCESS_PROCESS" 0 rows imported . . importing table "SX__PROCESS_RISK" 15300 rows imported . . importing table "SX__PROCESS_SIGNOFF" 0 rows imported . . importing table "SX__PROCESS_SUBACCOUNT" 0 rows imported . . importing table "SX__PROCESS_SUBPROCESS" 0 rows imported . . importing table "SX__PROCESS_TEST" 12864 rows imported . . importing table "SX__PROCESS_TESTRESULT" 18523 rows imported . . importing table "SX__RISK_ACTIONITEM" 1820 rows imported . . importing table "SX__RISK_CONTROL" 24303 rows imported . . importing table "SX__RISK_FILE" 33919 rows imported . . importing table "SX__RISK_ISSUE" 2793 rows imported . . importing table "SX__RISK_LINK" 292 rows imported . . importing table "SX__RISK_SIGNOFF" 0 rows imported . . importing table "SX__RISK_TEST" 17449 rows imported . . importing table "SX__RISK_TESTRESULT" 25544 rows imported . . importing table "SX__SUBACCOUNT_ACTIONITEM" 0 rows imported . . importing table "SX__SUBACCOUNT_CONTROL" 0 rows imported . . importing table "SX__SUBACCOUNT_CONTROLOBJ" 0 rows imported . . importing table "SX__SUBACCOUNT_FILE" 0 rows imported . . importing table "SX__SUBACCOUNT_ISSUE" 0 rows imported . . importing table "SX__SUBACCOUNT_LINK" 0 rows imported . . importing table "SX__SUBACCOUNT_RISK" 0 rows imported . . importing table "SX__SUBACCOUNT_SIGNOFF" 0 rows imported . . importing table "SX__SUBACCOUNT_SUBACCOUNT" 0 rows imported . . importing table "SX__SUBACCOUNT_TEST" 0 rows imported . . importing table "SX__SUBACCOUNT_TESTRESULT" 0 rows imported . . importing table "SX__SUBPROCESS_ACCOUNT" 0 rows imported . . importing table "SX__SUBPROCESS_ACTIONITEM" 0 rows imported . . importing table "SX__SUBPROCESS_CONTROL" 0 rows imported . . importing table "SX__SUBPROCESS_CONTROLOBJ" 0 rows imported . . importing table "SX__SUBPROCESS_FILE" 0 rows imported . . importing table "SX__SUBPROCESS_ISSUE" 0 rows imported . . importing table "SX__SUBPROCESS_LINK" 0 rows imported . . importing table "SX__SUBPROCESS_RISK" 0 rows imported . . importing table "SX__SUBPROCESS_SIGNOFF" 0 rows imported . . importing table "SX__SUBPROCESS_SUBACCOUNT" 0 rows imported . . importing table "SX__SUBPROCESS_SUBPROCESS" 0 rows imported . . importing table "SX__SUBPROCESS_TEST" 0 rows imported . . importing table "SX__SUBPROCESS_TESTRESULT" 0 rows imported . . importing table "SX__TEST_ACTIONITEM" 254 rows imported . . importing table "SX__TEST_FILE" 7386 rows imported . . importing table "SX__TEST_ISSUE" 440 rows imported . . importing table "SX__TEST_LINK" 1 rows imported . . importing table "SX__TEST_SIGNOFF" 0 rows imported . . importing table "SX__TEST_TESTRESULT" 8623 rows imported . . importing table "SX__TESTRESULT_ACTIONITEM" 202 rows imported . . importing table "SX__TESTRESULT_FILE" 4636 rows imported . . importing table "SX__TESTRESULT_ISSUE" 368 rows imported . . importing table "SX__TESTRESULT_LINK" 0 rows imported . . importing table "SX_ACCOUNT" 4501 rows imported . . importing table "SX_ACCOUNT_ASSERTIONS" 20562 rows imported . . importing table "SX_ACCOUNT_FDC_LINE_ITEM_S_" 2384 rows imported . . importing table "SX_ACTIONITEM" 597 rows imported . . importing table "SX_ACTIONITEM_ACTION_ITEM_TYPE" 742 rows imported . . importing table "SX_CONTROL" 10220 rows imported . . importing table "SX_CONTROL_ASSERTION_S__CONTRO" 29819 rows imported . . importing table "SX_CONTROL_IT_SYSTEM" 13481 rows imported . . importing table "SX_CONTROL_POSSIBLE_TEST_TYPES" 17199 rows imported . . importing table "SX_CONTROL_SITE_S__COVERED" 24981 rows imported . . importing table "SX_CONTROLOBJECTIVE" 0 rows imported . . importing table "SX_CONTROLOBJECTIVE_CATEGORY" 0 rows imported . . importing table "SX_ENTITY" 194 rows imported . . importing table "SX_ENTITY_ENTITY_TYPE" 209 rows imported . . importing table "SX_ENTITY_SAP_COMPANY_CODE" 194 rows imported . . importing table "SX_ENTITY_WORLDWIDE_BUSINESS" 443 rows imported . . importing table "SX_FILE" 16436 rows imported . . importing table "SX_ISSUE" 1398 rows imported . . importing table "SX_ISSUE_ROOT_CAUSE_TYPE" 1367 rows imported . . importing table "SX_LINK" 68 rows imported . . importing table "SX_MILESTONE" 0 rows imported . . importing table "SX_PROCESS" 4568 rows imported . . importing table "SX_PROCESS_PROCESS_TYPE" 4568 rows imported . . importing table "SX_RISK" 15291 rows imported . . importing table "SX_RISK_ASSERTIONS" 15291 rows imported . . importing table "SX_RISK_ASSERTIONS_AT_RISK" 44959 rows imported . . importing table "SX_RISK_COSO_OBJECTIVE_CATEGOR" 26917 rows imported . . importing table "SX_SIGNOFF" 0 rows imported . . importing table "SX_SIGNOFF_STATUS" 0 rows imported . . importing table "SX_SUBACCOUNT" 0 rows imported . . importing table "SX_SUBACCOUNT_ASSERTIONS" 0 rows imported . . importing table "SX_SUBPROCESS" 0 rows imported . . importing table "SX_SUBPROCESS_PROCESS_TYPE" 0 rows imported . . importing table "SX_TEST" 6555 rows imported . . importing table "SX_TEST_TEST_TYPE_S__EXPECTED" 12689 rows imported . . importing table "SX_TESTRESULT" 8625 rows imported IMP-00017: following statement failed with ORACLE error 942: "ALTER TABLE "RPT_OBJECTS" ADD CONSTRAINT "RPT_OBJECTS_FK1" FOREIGN KEY ("CO" "NTENT_TYPE") REFERENCES "ASSETTYPES" ("ASSETTYPEID") ENABLE NOVALIDATE" IMP-00003: ORACLE error 942 encountered ORA-00942: table or view does not exist IMP-00017: following statement failed with ORACLE error 942: "ALTER TABLE "RESOURCES" ADD CONSTRAINT "RES2ACTORS_FK" FOREIGN KEY ("CREATO" "RID") REFERENCES "ACTORS" ("ACTORID") ON DELETE SET NULL ENABLE NOVALIDATE" IMP-00003: ORACLE error 942 encountered ORA-00942: table or view does not exist IMP-00017: following statement failed with ORACLE error 942: "ALTER TABLE "RESOURCES" ADD CONSTRAINT "RES2ACTORS_II_FK" FOREIGN KEY ("CHE" "CKEDINBY") REFERENCES "ACTORS" ("ACTORID") ON DELETE SET NULL ENABLE NOVALI" "DATE" IMP-00003: ORACLE error 942 encountered ORA-00942: table or view does not exist IMP-00017: following statement failed with ORACLE error 942: "ALTER TABLE "RESOURCES" ADD CONSTRAINT "RES2ACTORS_I_FK" FOREIGN KEY ("CHEC" "KEDOUTBY") REFERENCES "ACTORS" ("ACTORID") ON DELETE SET NULL ENABLE NOVALI" "DATE" IMP-00003: ORACLE error 942 encountered ORA-00942: table or view does not exist IMP-00017: following statement failed with ORACLE error 942: "ALTER TABLE "RESOURCES" ADD CONSTRAINT "RES2ASSETYPES_FK" FOREIGN KEY ("ASS" "ETTYPEID") REFERENCES "ASSETTYPES" ("ASSETTYPEID") ON DELETE CASCADE ENABLE" " NOVALIDATE" IMP-00003: ORACLE error 942 encountered ORA-00942: table or view does not exist IMP-00017: following statement failed with ORACLE error 942: "ALTER TABLE "RESOURCES" ADD CONSTRAINT "RES2CONTYPES_FK" FOREIGN KEY ("CONT" "ENTTYPEID") REFERENCES "CONTENTTYPES" ("CONTENTTYPEID") ENABLE NOVALIDATE" IMP-00003: ORACLE error 942 encountered ORA-00942: table or view does not exist IMP-00017: following statement failed with ORACLE error 942: "ALTER TABLE "RESOURCES" ADD CONSTRAINT "RES2LANG_FK" FOREIGN KEY ("CONTENTL" "ANGUAGEID") REFERENCES "LANGUAGES" ("LANGUAGEID") ON DELETE CASCADE ENABLE " "NOVALIDATE" IMP-00003: ORACLE error 942 encountered ORA-00942: table or view does not exist IMP-00017: following statement failed with ORACLE error 942: "ALTER TABLE "RESOURCES" ADD CONSTRAINT "RES2RESTYPES_FK" FOREIGN KEY ("TYPE" "") REFERENCES "RESOURCETYPES" ("RESOURCETYPEID") ON DELETE CASCADE ENABLE N" "OVALIDATE" IMP-00003: ORACLE error 942 encountered ORA-00942: table or view does not exist IMP-00017: following statement failed with ORACLE error 942: "ALTER TABLE "RESOURCES" ADD CONSTRAINT "RES2STORAGESERVERS" FOREIGN KEY ("S" "TORAGESERVERID") REFERENCES "STORAGESERVERS" ("STORAGESERVERID") ENABLE NOV" "ALIDATE" IMP-00003: ORACLE error 942 encountered ORA-00942: table or view does not exist IMP-00017: following statement failed with ORACLE error 942: "ALTER TABLE "RESOURCES" ADD CONSTRAINT "RES2SUBRESOURCETYPES" FOREIGN KEY (" ""SUBRESOURCETYPE") REFERENCES "SUBRESOURCETYPES" ("SUBRESOURCETYPEID") ON D" "ELETE SET NULL ENABLE NOVALIDATE" IMP-00003: ORACLE error 942 encountered ORA-00942: table or view does not exist IMP-00017: following statement failed with ORACLE error 942: "ALTER TABLE "RESOURCES" ADD CONSTRAINT "RES2VERSIONS_FK" FOREIGN KEY ("LATE" "STVERSION") REFERENCES "VERSIONS" ("VERSIONID") ON DELETE SET NULL ENABLE N" "OVALIDATE" IMP-00003: ORACLE error 942 encountered ORA-00942: table or view does not exist IMP-00017: following statement failed with ORACLE error 942: "ALTER TABLE "USERINFO" ADD CONSTRAINT "UINFO2ACTORS_FK" FOREIGN KEY ("ACTOR" "ID") REFERENCES "ACTORS" ("ACTORID") ON DELETE CASCADE ENABLE NOVALIDATE" IMP-00003: ORACLE error 942 encountered ORA-00942: table or view does not exist IMP-00017: following statement failed with ORACLE error 942: "ALTER TABLE "ACTORINFO" ADD CONSTRAINT "ACTORINFO2ACTORS_FK" FOREIGN KEY ("" "ACTORID") REFERENCES "ACTORS" ("ACTORID") ON DELETE CASCADE ENABLE NOVALIDA" "TE" IMP-00003: ORACLE error 942 encountered ORA-00942: table or view does not exist IMP-00017: following statement failed with ORACLE error 942: "ALTER TABLE "FOLDERACLS" ADD CONSTRAINT "FOLDACLS2ACLS1_FK" FOREIGN KEY ("A" "CLID") REFERENCES "ACLS" ("ACLID") ON DELETE CASCADE ENABLE NOVALIDATE" IMP-00003: ORACLE error 942 encountered ORA-00942: table or view does not exist About to enable constraints... IMP-00017: following statement failed with ORACLE error 2430: "ALTER TABLE "RPT_OBJECTS" ENABLE CONSTRAINT "RPT_OBJECTS_FK1"" IMP-00017: following statement failed with ORACLE error 2430: "ALTER TABLE "RESOURCES" ENABLE CONSTRAINT "RES2ACTORS_FK"" IMP-00017: following statement failed with ORACLE error 2430: "ALTER TABLE "RESOURCES" ENABLE CONSTRAINT "RES2ACTORS_II_FK"" IMP-00017: following statement failed with ORACLE error 2430: "ALTER TABLE "RESOURCES" ENABLE CONSTRAINT "RES2ACTORS_I_FK"" IMP-00017: following statement failed with ORACLE error 2430: "ALTER TABLE "RESOURCES" ENABLE CONSTRAINT "RES2ASSETYPES_FK"" IMP-00017: following statement failed with ORACLE error 2430: "ALTER TABLE "RESOURCES" ENABLE CONSTRAINT "RES2CONTYPES_FK"" IMP-00017: following statement failed with ORACLE error 2430: "ALTER TABLE "RESOURCES" ENABLE CONSTRAINT "RES2LANG_FK"" IMP-00017: following statement failed with ORACLE error 2430: "ALTER TABLE "RESOURCES" ENABLE CONSTRAINT "RES2RESTYPES_FK"" IMP-00017: following statement failed with ORACLE error 2430: "ALTER TABLE "RESOURCES" ENABLE CONSTRAINT "RES2STORAGESERVERS"" IMP-00017: following statement failed with ORACLE error 2430: "ALTER TABLE "RESOURCES" ENABLE CONSTRAINT "RES2SUBRESOURCETYPES"" IMP-00017: following statement failed with ORACLE error 2430: "ALTER TABLE "RESOURCES" ENABLE CONSTRAINT "RES2VERSIONS_FK"" IMP-00017: following statement failed with ORACLE error 2430: "ALTER TABLE "USERINFO" ENABLE CONSTRAINT "UINFO2ACTORS_FK"" IMP-00017: following statement failed with ORACLE error 2430: "ALTER TABLE "ACTORINFO" ENABLE CONSTRAINT "ACTORINFO2ACTORS_FK"" IMP-00017: following statement failed with ORACLE error 2430: "ALTER TABLE "FOLDERACLS" ENABLE CONSTRAINT "FOLDACLS2ACLS1_FK"" Import terminated successfully with warnings. ******************************************************** Importing the Reporting Schema Contents Importing the data is a two-step process. First, you must import the contents, constraints, and indexes for all of the reporting schema tables, except for the RPT_OBJECTS, RPT_RELATIONS, EFFECTIVE_RIGHTS, ACTORINFO and FOLDERS tables. Then import the contents and indexes for the above-mentioned tables. Note: The constraint definitions for those tables should not be imported, as foreign keys on those tables reference other tables which are not part of the reporting schema and are not exported. To simplify the importing process, you can use a copy of the reporting-schema-exp-params.txt file to create a parameter file for the Oracle IMP utility. For information about the format of Oracle parameter files for the EXP/IMP utilities consult your Oracle product documentation. Note: It is possible to import the entire data dump file and review the reported errors. However, only the foreign key creation errors for the above-mentioned tables can be safely ignored. Currently, in order to load updated data, the existing database objects have to be dropped. As part of the SOX installation, the AuroraDBDelete.sql script is supplied, which can be used to drop all the objects in the user schema. This script can be executed in SQL*Plus. Note: Exercise caution when executing the script, as the script removes all objects owned by the currently connected user. Once the contents are imported successfully, the reporting schema data source is ready to be accessed by the third-party query engine. ****************************************************