Tag Archives: DDDAUDIT

You are not authorized to view the report(s).

Posted by on February 9, 2010 No comments

Problem:

After creating clone (tramdmo), the DDDAUDIT report was run from Process Scheduler. The report completes successfully, but when trying the view the report (PeopleTools > Process Scheduler > Process Monitor, then Details > View Log/Trace), the fsdmo PIA login screen appears with the message:

You are not authorized to view the report(s).

Solution:

Navigate to PeopleTools > Process Scheduler > Report Nodes

Set URL to http://GLWEBAPP:8020/psreports/tramdmo
Set Description to TRAMDMO Reporting Node
Ensure Operating System is NT/Win200
Network Path is \glwebappe$psreports

The correct URL now appears:

Click to access DDDAUDIT_7311.PDF

Running DDDAUDIT

Posted by on February 12, 2009 No comments

To run DDDAUDIT manually:

1. Click Start > Run

2. Click Browse, navigate to binsqlMSSbinw, and select sqrw.exe. Append the necessary flags:

On glwebapp:

E:PSOFTFS900binsqrMSSBINWsqrw.exe -IE:PSOFTFS900sqr -ZIFE:PSOFTFS900sqrpssqr.ini -fC:Temp -KEEP

Note that the above is one line without breaks.

If PS_HOME is mapped to a drive, use the drive letter instead:

P:binsqrMSSBINWsqrw.exe -IP:sqr -ZIFP:sqrpssqr.ini -fC:Temp -KEEP

Parameters for DDDAUDIT reportSQ

3. The SQR for PeopleSoft V8.49.15 form appears. Enter the following parameters:

Report name: E:PSOFTFS900sqrdddaudit.sqr
Data Source: FSDMO
Username: sa
Password: train

The FSDMO ODBC connection must be created for it to appear in the Data Source drop down list.

Parameters for SYSAUDIT report

4. The SQR for PeopleSoft V8.49.15 form appears. Enter the following parameters:

Report name: E:PSOFTFS900sqrsysaudit.sqr
Data Source: FSDMO
Username: sa
Password: train

The FSDMO ODBC connection must be created for it to appear in the Data Source drop down list.

5. To view the report, enter the following at the Command Prompt:

E:PSOFTFS900binsqrMSSBINWsqrwv.exe

(TRIGGER-1) Trigger defined in the Application Designer and not found in the Database

Posted by on February 7, 2009 No comments

Problem:

After cloning fsdev to fstst, DDDAUDIT was run. It showed the following error:

(TRIGGER-1) Trigger defined in the Application Designer and not found in the Database:
 Record Name Trigger Name
 --------------- ---------------
 CHARTFIELD1_TBL PSICHARTFIELD1_TBL
 CHARTFIELD1_TBL PSUCHARTFIELD1_TBL
 2 Total Rows

Solution:

In GLWEBAPP, launch Application Designer. Log on to FSTST (ensure FSTST ODBC Connection created).

DDDAUDIT Errors After Running FSCM MP5

Posted by on January 24, 2009 No comments

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.

DDDAUDIT Report Generates 136 Pages

Posted by on January 9, 2009 No comments

Problem:

After running DDDAUDIT on fsdmo, the report generates the following errors:

(TABLE-1) SQL Table Names defined in the Application Designer that are not blank and not the same as the Record Name: No rows found.
(TABLE-2) SQL Table defined in the Application Designer and not found in the Database: (continued) 3,739 Total Rows
(TABLE-3) SQL Table defined in the Database and not found in the Application Designer: No rows found.
(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: 4,028 Total Rows
(TRIGGER-1) Trigger defined in the Application Designer and not found in the Database: No rows found.

Solution:

Script to populate the database was not run. Logged on to Data Mover as user ‘sa’ (in bootstrap mode) and ran fsdmomss_fsdmo.dms script. Ensure that the fsdmomss script from the correct PS_HOME is used.

Did not complete the database installation. In the “Enterprise PeopleTools 8.49 Installation for Microsoft SQL Server”, start from Task B-8 and import the projects. Run Application Designer and import PS

Fixing Views-1 Errors on DDDAUDIT

Posted by on January 1, 2009 No comments

To fix Views-1 errors on DDDAUDIT:

1. Load Application Designer.
2. Click Insert > Definitions into Project.
3. In Definition Type, choose Records and press Enter.
4. Scroll down the list and select the record which appears in the DDDAUDIT.
5. The record appears in Application Designer. Click Build > Project.
6. Check Create Views.
7. Click Settings and change the Log file name and Output file name. Ensure that you choose Recreate view if it already exists.

DDDAUDIT Errors After Running Change Assistant

Posted by on November 25, 2008 No comments

DDDAUDIT Errors after Partially Running Change Assistant (FSCM MP5)

Problem:

After partially running Change Assistant (FSCM MP5), many errors are appearing on the DDDAUDIT.sql report (e.g. objects are now missing from the database):

PeopleSoft
Report Name :DDDAUDIT APPLICATION DESIGNER/DATABASE AUDIT REPORT Page No : 1
Database Name: Run Date: 11/25/2008
Platform :WINDOWS-NT DBType: Microsoft SQL Server Run Time: 15:57:39
(TABLE-1) SQL Table Names defined in the
Application Designer that are not blank and
not the same as the Record Name: No rows found.

(TABLE-2) SQL Table defined in the
Application Designer and not found in the
Database:
Record Name Ownerid
————— ——-
AE_DETIJ_AET TTS
AE_DETIS_AET TTS
AE_DETW_AET TTS
AE_PEPXPLOD_AET TTS
AM_EXT_AUD_DTL FAM
AM_EXT_AUD_HDR FAM
AM_JE_DTL_TMP FAM
APS8003_RPT FAP
AP_APS8003_AET FAP
AP_DAM_LTD_T FAP
AP_IU_LN2_AET FGL
AP_IU_LN_AET FGL
AP_MTVLN5A_T FAP
BP_ACT2_TAO FGL
BP_ACTFS_TAO FGL
BP_ACT_TAO FGL
BP_APA_S_TAO FAP
BP_APN_S_TAO FAP
BP_APV_S_TAO FAP
BP_AREV_G_TAO FGL
BP_ARM_S_TAO FAR
BP_ARR_S_TAO FAR
BP_ASEXLG_TAO FGL
BP_BDHDR_TAO FGL
BP_BDLN_TAO FGL
BP_BI_S_TAO DBI
BP_BKOUT_TAO FGL
BP_BP_TAO FGL
BP_CF_TAO FGL
BP_CM_S_TAO DCM
BP_EE_TAO FFA
BP_EXCPTN_TAO FGL
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_KKAMT_TAO
BP_LEDGER_TAO FGL
BP_LGRP_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

PeopleSoft
Report Name :DDDAUDIT APPLICATION DESIGNER/DATABASE AUDIT REPORT Page No : 2
Database Name: Run Date: 11/25/2008
Platform :WINDOWS-NT DBType: Microsoft SQL Server Run Time: 15:57:39
(TABLE-2) SQL Table defined in the
Application Designer and not found in the
Database: (continued)
Record Name Ownerid
————— ——-
BP_PST1_TAO FGL
BP_PST2_TAO FGL
BP_REFDBK_TAO FGL
BP_REFD_TAO FGL
BP_RFLDS_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
BS_BLD_PROJ ENV
BS_MRG_PRJ_AET ENV
BS_PRJ_MRG_RN ENV
CA_CH_APS_TA1 FCA
CE_LOP_PROC_T DCM
DEPR_RP43_TMP FAM
DEPR_RP50_TMP FAM
DEPR_RP51_TMP FAM
DIST_LN3_TAO FAM
DIST_LN4_TAO FAM
DP_CALCLIB_RC DDP
DP_DDH_BI_TAO DDP
DP_DDH_CK_TAO DDP
DP_DDH_CP_TAO DDP
DP_DDH_IN_TAO DDP
DP_DDH_KN_TAO DDP
DP_DDH_OM_TAO DDP
DP_DDH_SO_TAO DDP
DP_FCADJHSTAO DDP
DP_FCITEMSDRV DDP
DP_FCITEMSTAO DDP
DP_FCITMDRV_AET DDP
DP_FCITMD_TAO DDP
DP_FCPRDS_TAO DDP
DP_FCWRKQMTAO DDP
EXPLODE_IDS TTS
EXPLODE_IDS_NUM TTS
EXP_CHUNK_TMP TTS
EXP_CTRL TTS
EXP_FIELD_SEQ TTS
EXP_PROJ TTS
EXP_RECDEFN TTS
EXP_RECFIELD TTS
EXP_REQUEST TTS
EXP_REQUEST_OPT TTS
EXP_SEQ TTS
EXP_STMT TTS
EXP_STMT_CHUNK TTS
EXP_TBL TTS
EX_ADVLN_TAO FEX
EX_ADVLSS_TAO FEX
EX_ADV_HDR_TMP FEX
EX_ADV_HDR_TMP2 FEX
EX_BCHK_ERTAO
EX_PYNTFY_TAO FEX
EX_PYNTFY_TBL FEX

PeopleSoft
Report Name :DDDAUDIT APPLICATION DESIGNER/DATABASE AUDIT REPORT Page No : 3
Database Name: Run Date: 11/25/2008
Platform :WINDOWS-NT DBType: Microsoft SQL Server Run Time: 15:57:39
(TABLE-2) SQL Table defined in the
Application Designer and not found in the
Database: (continued)
Record Name Ownerid
————— ——-
EX_STGSHT_TMP FEX
FS_CE_CFS_TAO FGL
FS_CE_CFV_TAO FGL
GBR_RUN_CTL_CIS FAP
GL_ACCT_ENTRY AGC
IN_ALMDMND_AET DIN
IN_DEMAND1_T DPO
IN_RLS_OPCK_TAO DIN
IN_UNDOSDPTAO DIN
IN_UNDOSETTAO DIN
JRNL_IUW2_AET FGL
JRNL_IUWK_AET FGL
KK_DUP_SHDR FGL
KK_SHDR_TAO FGL
OCH_ITLD_TAO DOM
OCH_LOCK_TAO DOM
OMA_LOCK_TAO DOM
OMB_ITLD_TAO DOM
OMB_LOCK_TAO DOM
OMCB_LOCK_TAO DOM
OMD_LOCK_TAO DOM
OMEC_OUTLS_INF DOM
OME_ITLD_TAO DOM
OME_LOCK_TAO DOM
OMH_LOCK_TAO DOM
ORD_HEADER_LOCK DOM
PC_BUD_SM_TMP FPC
PC_OLT_TAO FPC
PG_PNVAT3_TAO FAR
POP_PROJ TTS
POP_SEQ TTS
POP_TBL TTS
PST_APPCT_TMP FAP
PST_WVCH_TMP FAP
RECV_ASN_DIST2 DPO
REC_COUNT TTS
REC_COUNT_WRK2 TTS
REQ_CHG_HDR_T DPO
REQ_CHG_LN_T DPO
REQ_CHG_ORD_TMP DPO
REQ_CHG_SHP_T DPO
REQ_CNCL_CO_TMP DPO
RUN_TDS_ANNEXUR FLC
RUN_TDS_QRETURN FLC
RVL_AR_TAO FAR
SF1219_DTL_TBL FGL
SF1219_SUM_TBL FGL
SF1219_TMP_TBL FGL
SUMLED_REQ_BU FGL
TDS_QRETURN_DTL FLC
TDS_QRETURN_TAO FLC
TDS_QRETURN_TBL FLC
TDS_QRET_NMHDR FLC
TDS_QRET_NUM FLC
TDS_REP_TBL FLC
TT_WRK2 TTS
UPD_QTY_TMP

Solution:

Run Application Designer.

In a new project, click Insert > Definitions Into Project

Search for and insert all Records and Indexes

Click Build > Project

Click Settings. Ensure the following are set:
• Skip table if it already exists
• Recreate view if it already exists
• Recreate index only if modified

Check Create Tables and Create Views