Tag Archives: DMS

Build and Alter Step While Applying MP5

Posted by on January 16, 2009 No comments

The Build and Alter step (or ‘chapter’) consists of two tasks:

1. Build and Alter Task_1
2. Build and Alter Task

Under the first task (Build and Alter Task_1), there are two steps:
a. Build Step
b. Run Recreate Tables Script

No action is required for the Build and Alter Task_1 steps. Read the documentation in the right pane, and then mark the steps as Complete.

Under the second task (Build and Alter Task), there are seven steps:
a. Build and Alter Step
b. Run Create Tables Script
c. Run Alter Tables Script
d. Run Create Triggers Script
e. Run Create Views Script
f. Additional Step 02
g. Run Create Indexes Script

The first step (Build and Alter Step) can be run automatically. The step completes with warnings, as there are some records have over 16 keys or some record definitions do not exist. The log file is:
E:/temp/softwareupdateFSCM900_MP5{3d899576-cc86-11dd-930f-9c077f4a98a5}/BuildAndAlter.log

The output scripts generated by the Build and Alter Step are located in E:tempsoftwareupdateFSCM900_MP5{3d899576-cc86-11dd-930f-9c077f4a98a5}

The second step, Run Create Tables Script is done by running the E:tempsoftwareupdateFSCM900_MP5{3d899576-cc86-11dd-930f-9c077f4a98a5} CreateTables.sql script in SQL Server Management Studio. The CreateTables.sql script executed successfully in 59 seconds.

The third step, Run Alter Tables Script is done by running the E:tempsoftwareupdateFSCM900_MP5{3d899576-cc86-11dd-930f-9c077f4a98a5} AlterTables.sql script in SQL Server Management Studio. The AlterTables.sql script executed successfully in 1 minute 30 seconds.

The fourth step, Run Create Triggers Script is done by running the E:tempsoftwareupdateFSCM900_MP5{3d899576-cc86-11dd-930f-9c077f4a98a5} CreateTriggers.sql script in SQL Server Management Studio. The CreateTriggers.sql script executed successfully in less than 1 second.

The fifth step, Run Create Views Script is done by running the E:tempsoftwareupdateFSCM900_MP5{3d899576-cc86-11dd-930f-9c077f4a98a5} CreateViews.sql script in SQL Server Management Studio. The CreateViews.sql script executed successfully in 26 seconds.

The sixth step, Additional Step 02 is done by logging into PIA and populating the KEYLIST field.

The seventh step, Run Create Indexes Script is done by running the E:tempsoftwareupdateFSCM900_MP5{3d899576-cc86-11dd-930f-9c077f4a98a5} CreateIndexes.sql script in SQL Server Management Studio. The CreateIndexes.sql script executed successfully in 10 seconds.

Note: When these steps were first run against the FSDMO instance, the Create Views step failed because the PTPATCH.DMS script and PATCH849 project were not run against the database.

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