DDDAUDIT Errors After Running FSCM MP5
Problem:
After completing FSCM MP5, the DDDAUDIT report is run. The following errors appear:
(TABLE-2) SQL Table defined in the Application Designer and not found in the Database: Record Name Ownerid --------------- ------- BP_ACT2_TAO FGL BP_APA_S_TAO FAP BP_APN_S_TAO FAP BP_APV_S_TAO FAP BP_ARM_S_TAO FAR BP_ARR_S_TAO FAR BP_BDHDR_TAO FGL BP_BDLN_TAO FGL BP_BI_S_TAO DBI BP_BKOUT_TAO FGL BP_CF_TAO FGL BP_CM_S_TAO DCM BP_EX_S_TAO FEX BP_FSRC_TAO FGL BP_GEN_S_TAO FGL BP_GLB_S_TAO FGL BP_GL_S_TAO FGL BP_GM_S_TAO FGM BP_HR_S_TAO FGL BP_LQDFS_TAO FGL BP_LQD_TAO FGL BP_PC1_S_TAO FPC BP_PC_S_TAO FPC BP_PFS1_TAO FGL BP_PFS2_TAO FGL BP_POA_S_TAO DPO BP_POC_S_TAO DPO BP_PO_S_TAO DPO BP_PRNT_TAO FGL BP_PST1_TAO FGL BP_PST2_TAO FGL BP_REFDBK_TAO FGL BP_REFD_TAO FGL BP_RQN_S_TAO DPO BP_RQ_S_TAO DPO BP_TA_S_TAO FEX BP_XCF2_TAO FGL BP_XCF_TAO FGL BP_XLBP_TAO FGL EX_ADVLN_TAO FEX EX_ADVLSS_TAO FEX EX_STGSHT_TMP FEX FS_CE_CFV_TAO FGL VUN_DOC_TAO FAP VUN_RVS_TAO FAP VUN_UNP_TAO FAP 46 Total Rows (TABLE-3) SQL Table defined in the Database and not found in the Application Designer: SQL Table Name ------------------ PS_VNDR_ORDER_TMP PS_VNDR_REMIT_TMP PS_WEBLIB_EX_TV 3 Total Rows (TABLE-4)INFORMATIONAL ONLY - Tablespace not defined for SQL Table in the Application Designer: No rows found. (TABLE-5) Table Contains More Than 500 Fields : No rows found. (VIEWS-1) Views defined in the Application Designer and not found in the Database: No rows found. (VIEWS-2) Views defined in the Database and not found in the Application Designer: No rows found. (INDEX-1) Index defined in the Application Designer and not found in the Database: Record Name Index ID Ownerid --------------- -------- ------- BP_ACT2_TAO A FGL BP_ACT2_TAO B FGL BP_ACT2_TAO _ FGL BP_APA_S_TAO A FAP BP_APA_S_TAO B FAP BP_APA_S_TAO _ FAP BP_APN_S_TAO A FAP BP_APN_S_TAO B FAP BP_APN_S_TAO _ FAP BP_APV_S_TAO A FAP BP_APV_S_TAO B FAP BP_APV_S_TAO _ FAP BP_ARM_S_TAO A FAR BP_ARM_S_TAO _ FAR BP_ARR_S_TAO A FAR BP_ARR_S_TAO _ FAR BP_BDHDR_TAO 0 FGL BP_BDHDR_TAO _ FGL BP_BI_S_TAO A DBI BP_BI_S_TAO B DBI BP_BKOUT_TAO A FGL BP_CF_TAO A FGL BP_CF_TAO B FGL BP_CM_S_TAO A DCM BP_CM_S_TAO B DCM BP_CM_S_TAO _ DCM BP_EX_S_TAO A FEX BP_EX_S_TAO B FEX BP_EX_S_TAO _ FEX (INDEX-1) Index defined in the Application Designer and not found in the Database:(continued) Record Name Index ID Ownerid --------------- -------- ------- BP_FSRC_TAO A FGL BP_GEN_S_TAO A FGL BP_GEN_S_TAO _ FGL BP_GLB_S_TAO A FGL BP_GLB_S_TAO _ FGL BP_GL_S_TAO A FGL BP_GL_S_TAO _ FGL BP_GM_S_TAO A FGM BP_GM_S_TAO B FGM BP_HR_S_TAO A FGL BP_HR_S_TAO B FGL BP_LQDFS_TAO A FGL BP_LQD_TAO A FGL BP_PC1_S_TAO A FPC BP_PC1_S_TAO B FPC BP_PC_S_TAO A FPC BP_PC_S_TAO B FPC BP_POA_S_TAO A DPO BP_POA_S_TAO B DPO BP_POC_S_TAO A DPO BP_POC_S_TAO _ DPO BP_PO_S_TAO A DPO BP_PO_S_TAO B DPO BP_PO_S_TAO _ DPO BP_PST1_TAO A FGL BP_REFDBK_TAO A FGL BP_REFD_TAO A FGL BP_RQN_S_TAO A DPO BP_RQN_S_TAO _ DPO BP_RQ_S_TAO A DPO BP_RQ_S_TAO _ DPO BP_TA_S_TAO A FEX BP_TA_S_TAO _ FEX BP_XCF_TAO A FGL BP_XCF_TAO B FGL BP_XCF_TAO C FGL EX_ADVLN_TAO A FEX EX_ADVLN_TAO _ FEX EX_ADVLSS_TAO _ FEX EX_STGSHT_TMP A FEX EX_STGSHT_TMP B FEX EX_STGSHT_TMP _ FEX FS_CE_CFV_TAO A FGL VUN_DOC_TAO _ FAP VUN_RVS_TAO _ FAP VUN_UNP_TAO _ FAP 75 Total Rows
Solution:
See the Acceptable Audit Errors section on page 53 for tips to resolving these errors, including deleting the tables under section TABLE-3
To rebuild the tables under the TABLE-2 section of the DDDAUDIT report, the RBL_MP5ERRORS_VS project was created in Application Designer and the SQL script was built to create the missing tables.
0 Comments.