Tag Archives: Data Mover

PeopleSoft HR 8.9 Installation Checklist

Posted by on August 28, 2009 No comments

1. Install SQL Server

2. Install SQL Server Native Client

3. Stage PeopleTools 8.49 CDs on F:stagingpt-849

4. Install PeopleTools 8.49 on peoplesoft4hr (E:PSOFTHR900)

5. Install Application (Human Resources) on peoplesoft4hr

6. Install Database Manually

7. Task B-1: Running Server Configuration Scripts

8. Task B-2: Creating a Database

9. Task B-3: Configuring ODBC Data Source

10. Task B-4: Running ADDOBJ.SQL

11. Task B-5: Setting Up Connect ID

12. Task B-6: Creating Data Mover Import Scripts

13. Task B-7: Running Data Mover Import Scripts

14. Task B-8: Updating Database to Latest PeopleTools Release

15. Task B-8-2: Updating PeopleTools System Tables

16. Task B-8-3: Updating PeopleTools Database Objects

17. Task B-8-5: Deleting Obsolete PeopleTools Database Objects

18. Task B-8-6: Altering PeopleTools Tables

19. Task B-8-7: Updating PeopleTools System Data

20. Task B-8-8: Running PeopleTools Conversions

21. Task B-9: Running Additional Data Mover Scripts

22. Task B-11: Running VERSION Application Engine Program

23. Task B-12: Changing the Base Language

24. Task B-13: Running SQR Reports

25. Task B-14: Checking the Database

26. Task B-15: Cleaning and Backing Up the Database

27. Shutdown, Backup Database After Creating

28. Install Tuxedo (Application Server)

29. Install BEA WebLogic 9.2 Web Server

30. Install PIA

31. Create Application Domain

32. Install PeopleTools PeopleBooks

33. Install Application PeopleBooks

34. Create Process Scheduler

35. Install COBOL compiler (and license)

36. Execute PTPATCH.DMS using Data Mover (8.49.15)

37. Apply project PATCH849 using Application Designer

38. Run DDDAUDIT, SYSAUDIT to verify system ok, troubleshoot if necessary

39. Shutdown all servers and backup PS_HOME

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

Invalid Access ID and password for signon

Posted by on January 8, 2009 No comments

Problem:

When logging on to Data Mover as a PeopleSoft user (PTDMO, VP1), the following error appears:

Invalid Access ID and password for signon — see your security administrator.

In the Security Table Manager (Get) dialog box, the following message appears:

The database is at release 8.48. The PeopleTools being run require databases at release 8.49.

Solution:

In Query Analyzer, check the PSSTATUS table:

select * from PSSTATUS

If the TOOLSREL column shows 8.48, then the scriptsrel849n.sql script must be run.

Login failed for user ‘sa’

Posted by on January 8, 2009 No comments

Login failed for user ‘sa’

Problem:

When logging on to Data Mover as VP1, the following error appears:

File: SQL Access ManagerSQL error. Stmt #: 2 Error Position: 0 Return: 404 - [Microsoft][SQL Native Client][SQL Server]Login failed for user 'sa'.

Solution:

Log on to Data Mover as user sa and run the following lines from fsdmomss.dms:

UPDATE PSSTATUS SET OWNERID = 'sa';
 UPDATE PSOPRDEFN SET SYMBOLICID = 'sa1', OPERPSWD = OPRID, ENCRYPTED = 0;
 UPDATE PSACCESSPRFL SET ACCESSID = 'sa', SYMBOLICID = 'sa1', ACCESSPSWD = 'train', VERSION = 0, ENCRYPTED = 0;
 GRANT SELECT ON PSSTATUS TO people;
 GRANT SELECT ON PSOPRDEFN TO people;
 GRANT SELECT ON PSACCESSPRFL TO people;
REM - ENCRYPT PASSWORD
 /
 SET LOG c:tempencrypt.log;
 ENCRYPT_PASSWORD *;

References:

http://peoplesoft.ittoolbox.com/groups/technical-functional/peopletools-l/app-server-start-up-failed-2106157

Invalid Access ID and password for signon

Posted by on January 7, 2009 1 comment

Problem:

When logging on to Data Mover as a PeopleSoft user (PTDMO, VP1), the following error appears:

Invalid Access ID and password for signon -- see your security administrator.

In the Security Table Manager (Get) dialog box, the following message appears:

The database is at release 8.48. The PeopleTools being run require databases at release 8.49.

Solution:

In Query Analyzer, check the PSSTATUS table:

select * from PSSTATUS

If the TOOLSREL column shows 8.48, then the scriptsrel849n.sql script must be run.

Database creation fails when creating views

Posted by on January 3, 2009 No comments

When running fsdmomss_fsdmo.dms to create the FSDMO instance, the createvw.dss script completes with message “Unsuccessful Completion”.

The last three rows of the views.log shows:

SQL Views: 27069 Error: 198
Ended: Tue Dec 16 12:20:08 2008
Unsuccessful completion

Solution:

Apply PTPATCH.DSS script

Build and Alter Step (MP5) returns errors

Posted by on December 29, 2008 No comments

Problem:

When running the Build and Alter Task > Build and Alter Step, the follow appear in the log file:

SQL Build process began on 12/29/2008 at 3:43:44 PM for database FSDEV.
 Warning: SAC_SRCNODE_VW - Record definition does not exist. Record not processed. (76,73)
 Warning: The record SPL_PEGGING_INF has more than 16 keys. Table will be altered to support functional index.
 Warning: The record WTHD_SENT_DTL has more than 16 keys. Table will be altered to support functional index.
 Warning: The record WTHD_SNT_D_HST has more than 16 keys. Table will be altered to support functional index.
 Warning: The record WTHD_TO_SND_DTL has more than 16 keys. Table will be altered to support functional index.
 Warning: The record WTHD_TO_SND_TMP has more than 16 keys. Table will be altered to support functional index.
 Warning: The record WTHD_TRXN_TMP3 has more than 16 keys. Table will be altered to support functional index.
 Warning: GM_CONT_CERT_VW - Record definition does not exist. Record not processed. (76,73)
 Warning: GM_CONT_JHDR_VW - Record definition does not exist. Record not processed. (76,73)
 Warning: GM_CONT_PROF_VW - Record definition does not exist. Record not processed. (76,73)
 Warning: PL_SOHOLD3_VW - Record definition does not exist. Record not processed. (76,73)
 Warning: RE_OPEXADT_PADD - Record definition does not exist. Record not processed. (76,73)
 Warning: RE_OPEXADT_RADD - Record definition does not exist. Record not processed. (76,73)
 Warning: SAC_TGTNODE_VW - Record definition does not exist. Record not processed. (76,73)
 Warning: SHIPTO_ADDR_VW1 - Record definition does not exist. Record not processed. (76,73)
 Warning: SHIPTO_ADDR_VW2 - Record definition does not exist. Record not processed. (76,73)
 Warning: SPA_SP_RC_PD_V2 - Record definition does not exist. Record not processed. (76,73)
 Warning: VNDR_ORDER_TMP - Record definition does not exist. Record not processed. (76,73)
 Warning: VNDR_REMIT_TMP - Record definition does not exist. Record not processed. (76,73)
**** Begin Build Settings for this Run
 Create Tables = Yes
 Create Indexes = Yes
 Create Views = Yes
 Create Triggers = Yes
 Alter Tables = Yes
 Log to File = Yes
 Log to Window = No
 Write comments to script = Yes
 Always overwrite files = Yes
 Execute SQL Now = No
 Write SQL to script file = Yes
 Logging level = Log fatal errors and warnings only
 Table creation option = Skip table if it exists
 View creation option = Drop and recreate view if it exists
 IndexCreationOption = Recreate index only if modified
 Alter Adds = Yes
 Alter Changes = Yes
 Alter Renames = Yes
 Alter Deletes = Yes
 Alter even if no changes = No
 Alter Table Option = Alter in Place
 Write script output to: Separate files
 Log filename = E:/temp/softwareupdateFSCM900_MP5{823d7dbc-c7c8-11dd-9439-e147c04c274d}/BuildAndAlter.log
 Table creation script filename = E:/temp/softwareupdateFSCM900_MP5{823d7dbc-c7c8-11dd-9439-e147c04c274d}/CreateTables.sql
 Index creation script filename = E:/temp/softwareupdateFSCM900_MP5{823d7dbc-c7c8-11dd-9439-e147c04c274d}/CreateIndexes.sql
 View creation script filename = E:/temp/softwareupdateFSCM900_MP5{823d7dbc-c7c8-11dd-9439-e147c04c274d}/CreateView.sql
 Trigger creation script filename = E:/temp/softwareupdateFSCM900_MP5{823d7dbc-c7c8-11dd-9439-e147c04c274d}/CreateTriggers.sql
 Alter table script filename = E:/temp/softwareupdateFSCM900_MP5{823d7dbc-c7c8-11dd-9439-e147c04c274d}/AlterTables.sql
 Alter drop column option = drop column if data present
 Alter truncate column option = truncate column if data present
 Target database platform = MICROSFT
 Target sizing set = 0
SQL Build process ended on 12/29/2008 at 3:45:28 PM.
 1641 records processed, 0 errors, 19 warnings.
 SQL Build script for Create Tables written to file E:/temp/softwareupdateFSCM900_MP5{823d7dbc-c7c8-11dd-9439-e147c04c274d}/CreateTables.sql.
 SQL Build script for Create Indexes written to file E:/temp/softwareupdateFSCM900_MP5{823d7dbc-c7c8-11dd-9439-e147c04c274d}/CreateIndexes.sql.
 SQL Build script for Create Views written to file E:/temp/softwareupdateFSCM900_MP5{823d7dbc-c7c8-11dd-9439-e147c04c274d}/CreateView.sql.
 SQL Build script for Create Triggers written to file E:/temp/softwareupdateFSCM900_MP5{823d7dbc-c7c8-11dd-9439-e147c04c274d}/CreateTriggers.sql.
 SQL Build script for Alter Tables written to file E:/temp/softwareupdateFSCM900_MP5{823d7dbc-c7c8-11dd-9439-e147c04c274d}/AlterTables.sql.
 SQL Build log file written to E:/temp/softwareupdateFSCM900_MP5{823d7dbc-c7c8-11dd-9439-e147c04c274d}/BuildAndAlter.log.

Solution:

This is acceptable according to the documentation for the step:

Important!
If you receive the following warning message during the Build and Alter Step of the Build and Alter task, it is due to the Record being deleted by the Project. Please ignore the warning: Record definition does not exist. Record not processed. (76,73). If you receive the following warning message during the Build and Alter Step of the Build and Alter task, it is due to the field being deleted by the Project. Please ignore the warning: Field to be deleted has data present. Record processed. (76,23).DB2 Customers may need to recreate All Views manually by running createvw.dms using Datamover. This is because some views might become inoperable due to dependencies.If Run Create Triggers Script step fails because a trigger does not exist in the database then go to the CREATETRIGGERS.sql script in the Output directory, remove the offending statement and rerun the script.

Errors while running createvw.dms

Posted by on December 17, 2008 No comments

Errors while running createvw.dms:

Related language record RE_LANDLORD_LG used by record RE_LANDLORD not found. (20,52)
Related Language Record VCHR_SRCHLG1_VW used by VCHR_SRCHCRT_VW not found (20,52)
Related language record BI_SHP_LANG_VW used by record BI_SHP_ADDR_VW2 not found. (20,52)

Data Mover crashes out.

Solution:

Did not perform step 10 of the PT 8.49.15 Product Patch User Documentation (https://psft-updates.oracle.com/ice/Resolutions/768890/PT84915UserDoc_rev2.htm). Using Application Designer, log on as user VP1 and copy project PATCH849. Then, in Data Mover, log on as VP1 and rerun CREATEVW.DMS.

10. Copy Patch Project – ONLY if PATCH849 exists –

Note: If no database changes have been made in PT 8.49 by the time this patch is released, the PATCH849 project will not exist in the projects folder and this step can be ignored.

a. Using PeopleTools 8.49.15, launch Application Designer, and sign on to the database as a PeopleSoft User. [VP1]
b. Select Tools > Copy Project > From File
c. Enter projects and select PATCH849 from the list of projects
d. Select Options and highlight the languages Common and English ONLY.
e. Select Copy to begin copying updated PeopleTools objects to your database.

After rerunning CREATEVW.DMS, the last four lines of the CREATEVW.LOG file shows:

SQL Views: 27267
Ended: Wed Dec 17 18:23:25 2008
Successful completion
Script Completed.

Other steps to try:

Stop SQL Server services and restart.
Log on as user VP1 when running createvw.dms

Reference:

http://www.pinpointps.com/?q=node/59

Restarting data mover after a crash
A data mover script can be restarted by coding in the DMS ‘set start after record name’ before the Import * command. If the record is name ps_tablename, then do not code the ‘ps_’, just code tablename.

Attempted to create views using Application Designer: In Application Designer, click Ctrl+F7 (Insert > Definitions from Project…), and search for all Records. Select All records and insert them into the current project (takes about 10 minutes to complete). Then click Build > Project and check only Create Views (modify other settings as necessary). Build the SQL script, and after creating,

Data Mover Log Files

Posted by on December 1, 2008 No comments

After the fsdmomss.dms script is run Data Mover to create the database, the following log files are created:

epengs.log
epengl.log
encrypt.log
triggers.log
views.log

The script was started at 15:57:52 and it completed at 17:25:19, taking about 1½ hours.

The general structure of the log file is:

Started: Mon Dec 01 17:25:13 2008
Data Mover Release: 8.49.15
Database: FSDMO (ENG)

SQL Triggers: 195
Ended: Mon Dec 01 17:25:19 2008
Successful completion

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