Monthly Archives: January 2009 - Page 2

Invalid User ID and Password Logging Into Application Designer

Posted by on January 17, 2009 No comments

Problem:

When logging on to Application Designer as a new (Windows) user, the user is unable to login and the following error appears:

Invalid User ID and Password Logging Into Application Designer

Solution:

In Configuration Manager, under Profile, edit the Default program and create new entries for Database and Application Server.

[amazon asin=0071664939&template=iframe image&chan=default]     [amazon asin=1430237074&template=iframe image&chan=default]     [amazon asin=0071787925&template=iframe image&chan=default]

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.

Cleaning Up the Environment Management Hub

Posted by on January 15, 2009 No comments

How to Clean Up the Environment Management Hub

Problem:

Previous attempt to clean up the EM Hub was not completely successful, the previous Agent IDs (1 & 3) still appear.

Solution:

1. Stop the PSEM Agents on gldbase and glwebapp.

2. Exit the Change Assistant

3. Stop the web server. The application server and batch server may also be stopped.

For Agents, Viewer and Change Assistant:

Delete the files in the following directories:
• Under PS_HOMEPSEMAgent for Agents
• Under PS_HOMEPSEMViewer for the Viewer
• Under the Change Assistant directory for Change Assistant

envmetadata/PersistentStorage/
envmetadata/scratchpad
envmetadata/data/ids/
envmetadata/transactions/ (if it exists)
envmetadata/data/search-results.xml (just for Agents and CA)

For HUB:

Delete the files in the following directories:
• Under PS_HOMEwebservfsdmoapplicationspeoplesoftPSEMHUB

PSEMHUBenvmetadataScratchpad
PSEMHUBenvmetadataPersistentStorage
PSEMHUBenvmetadatatransactions (if it exists)
PSEMHUBenvmetadatadata*.* (files and directories.don’t delete the data directory itself)

Problem:

After cleaning up Environment Management Hub using the above method, the old Peer IDs still appear in the PSEM Viewer.

Solution:

Bounce the web server (fsdmo-PIA service) on glwebapp.

Reference:

E-CA Refresh and Clean Up of the Environment Management Hub (PSEMHUB) data (Doc ID 622874.1)

Subquery returned more than 1 value

Posted by on January 13, 2009 No comments

Problem:

File: e:pt84915b-retailpeopletoolssrcpsappengaedebug.hSQL error. Stmt #: 16
 03 Error Position: 0 Return: 8601 - [Microsoft][SQL Native Client][SQL Server]
 Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, , >= or 
when the subquery is used as an expression.
 [Microsoft][SQL Native Client][SQL Server]The statement has
 Failed SQL stmt:UPDATE PS_PTPP_OPTIONS SET PTPP_REG_PREFIX = 
( SELECT A1.EOPP_REG_PREFIX FROM PS_EOPP_OPTIONS A1)
 Message Set Number: 200
 Message Number: 0
 Message Reason: File: e:pt84915b-retailpeopletoolssrcpsappengaedebug.hSQL
 error. Stmt #: 1603 Error Position: 0 Return: 8601 - [Microsoft][SQL Native Client][SQL Server]Subquery 
returned more than 1 value. This is not permitted when the subquery follows =, !=, <, , >= or 
when the subquery is used as an expression.
 [Microsoft][SQL Native Client][SQL Server]The statement has
 Failed SQL stmt:UPDATE PS_PTPP_OPTIONS SET PTPP_REG_PREFIX = 
( SELECT A1.EOPP_REG_PREFIX FROM PS_EOPP_OPTIONS A1) (200,0)
Process 7113 ABENDED at Step UPGPT846PP.EO_TO_PT.Step51a (SQL) -- RC = 8601 (108,524)
 Message Set Number: 108
 Message Number: 524
 Message Reason: Process 7113 ABENDED at Step UPGPT846PP.EO_TO_PT.Step51a (SQL)
 -- RC = 8601 (108,524)
Process %s ABENDED at Step %s.%s.%s (Action %s) -- RC = %s

Solution:

Ran:

SELECT * FROM PS_EOPP_OPTIONS A1
Two rows returned. Ran:

SELECT DISTINCT * FROM PS_EOPP_OPTIONS A1
One row returned.

Checked PS_EOPP_OPTIONS table in FSDEMO. It has one row.

Solution: Delete duplicate row:

SET ROWCOUNT 1
DELETE FROM [FSDMO].[dbo].[PS_EOPP_OPTIONS]

Unable to Install Micro Focus Net Express

Posted by on January 12, 2009 No comments

Problem:

Micro Focus Net Express not installing

Solution:

1. On GLWEBAPP, share the E:stagingCDImagesMicro Focus NetExpress CDsdisk1

2. On GLWEBAPP, map the shared disk1 directory to Z:

3. Using My Computer, navigate to Z:AUTORUNHTML and run START.HTM

4. Click Install, and then click “Click here to install or upgrade Net Express 4.0”

All Processing Suspended: Restart OPRID=VP1

Posted by on January 11, 2009 No comments

Problem:

When running the UPGPT846PP Application Engine program the following error appears:

C:>E:PSOFTFS900binclientwinx86psae -CD FSDMO -CT MICROSFT -CO VP1 -CP VP1 -R INSTALL -AI UPGPT846PP
PeopleTools 8.49.15 – Application Engine
Copyright (c) 1988-2008 PeopleSoft, Inc.
All Rights Reserved

All Processing Suspended: Restart OPRID=VP1, RUNID=INSTALL, PI=7078 (108,503)
Message Set Number: 108
Message Number: 503
Message Reason: All Processing Suspended: Restart OPRID=VP1, RUNID=INSTALL, PI=7078 (108,503)

C:>

Solution:

When an application engine program is restarted, it returns:

All Processing Suspended: Restart OPRID=%1 RUNID=%2, PI=%3

Delete the offending application engine run control record using the following SQL statement:

delete from PS_AERUNCONTROL where OPRID = %OPRID% and PROCESS_INSTANCE = %PI%

That is, in SQL Server Query Editor, choose FSDMO and run:

select * from PS_AERUNCONTROL

Process Instance OPRID RUN_CTRL_ID AE_APPLID RUN_DTTM
7078 VP1 INSTALL UPGPT846PP 40:39.0

delete from PS_AERUNCONTROL where OPRID = ‘VP1’ and PROCESS_INSTANCE = 7078

Reference:
http://www.zutshigroup.com/site/tech/app_engine_processing_suspended

PPLTLS84CUR Results

Posted by on January 10, 2009 No comments

PPLTLS84CUR Results

Problem:

The following is the output on the Results tab in Application Designer when PPLTLS848CUR project is copied from file to the database. Note that this is run on PeopleTools 8.49.15.

Opening project …
4009 Records definition(s) in project. 77 Indexes definition(s) in project. 10782 Fields definition(s) in project. 1669 Translate Values definition(s) in project. 1255 Pages definition(s) in project. 36 Menus definition(s) in project. 401 Components definition(s) in project. 2780 Record PeopleCode definition(s) in project. 48 Queries definition(s) in project. 1 Trees definition(s) in project. 3 Access Groups definition(s) in project. 7 Business Processes definition(s) in project. 16 Activities definition(s) in project. 16 Roles definition(s) in project. 40 Process Definitions definition(s) in project. 4 Server Definitions definition(s) in project. 61 Process Type Definitions definition(s) in project. 1 Job Definitions definition(s) in project. 3 Recurrence Definitions definition(s) in project. 8 Business Interlink definition(s) in project. 1760 SQL definition(s) in project. 16 File Layout Definitions definition(s) in project. 25 Component Interfaces definition(s) in project. 96 Application Engine Programs definition(s) in project. 248 Application Engine Sections definition(s) in project. 11 Message Nodes definition(s) in project. 82 Messages definition(s) in project. 3 Message PeopleCode definition(s) in project. 2 Subscription PeopleCode definition(s) in project. 8 Comp. Interface PeopleCode definition(s) in project. 267 Application Engine PeopleCode definition(s) in project. 411 Page PeopleCode definition(s) in project. 272 Component PeopleCode definition(s) in project. 86 Component Record PeopleCode definition(s) in project. 503 Component Rec Fld PeopleCode definition(s) in project. 725 Images definition(s) in project. 26 Style Sheets definition(s) in project. 494 HTML definition(s) in project. 22 Permission Lists definition(s) in project. 2 Portal Registry Definitions definition(s) in project. 3388 Portal Registry Structures definition(s) in project. 11 URL Definitions definition(s) in project. 197 Application Packages definition(s) in project. 732 Application Package PeopleCode definition(s) in project. 1 Analytic Types definition(s) in project. 7 XSLT definition(s) in project. 1 Mobile Pages definition(s) in project. 1 Analytic Models definition(s) in project. 56 Services definition(s) in project. 65 Service Operations definition(s) in project. 50 Service Operation Handlers definition(s) in project. 65 Service Operation Versions definition(s) in project. 58 Service Operation Routings definition(s) in project. 29 IB Queues definition(s) in project. 2 XMLP Template Defn definition(s) in project. 1 XMLP Report Defn definition(s) in project. 4 XMLP File Defn definition(s) in project. 1 XMLP Data Src Defn definition(s) in project. 30945 total definition(s) in project.

[amazon asin=0071664939&template=iframe image&chan=default]     [amazon asin=1430237074&template=iframe image&chan=default]     [amazon asin=0071787925&template=iframe image&chan=default]

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