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

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.

Obtaining PeopleTools 8.49.15

Posted by on January 6, 2009 No comments

Log on to Metalink3 and click the Patches and Downloads tab. Click PeopleSoft Products. Enter the following search criteria:

Search for:
Product Line: PeopleTools
Product: PeopleTools
Release: 8.49

Check the Bundles checkbox.
Then click the search button (a right arrow).

Update ID: 768890
Name: PT 8.49.15 Product Patch

https://psft-updates.oracle.com/psc/UGPRD/CUSTOMER/CUST/c/ICE_MAIN_MENU.ICE_SRCH_COMPONENT.GBL

https://psft-updates.oracle.com/ice/Resolutions/768890/PT84915-PSCA.htm
https://psft-updates.oracle.com/ice/Resolutions/768890/PT84915UserDoc_rev2.htm

Errors on SYSAUDIT Report

Posted by on January 5, 2009 No comments

Problem:

After completing installing FSDEMO, SYSAUDIT is run. The following errors appear on the report:

Application Engine Audits Result: OK
Clear List Audits Result: OK
Electronic Commerce Audit Result: OK
Field Definition Audit Result: OK
Menu Definition Audit Result: OK
Security Audits Result: Exception(s) Found
(SEC-30) Role User table (ROLEXLATOPR) should be populated when new User Profiles (entries in PSOPRDEFN) are created
 using User Profile component through PIA. The following User Profiles need to be fixed by simply opening and saving
 them through PIA:
Oper ID Description
 - ----------------------------- ------------------------------
 ENTMGR_PRO Procurement Catalog Manager
 1 Total Rows
Page Definition Audit Result: OK
PeopleCode Definition Audit Result: OK
Process Scheduler Audit Result: OK
Query Definition Audit Result: Exception(s) Found
(QUERY-27) Following Queries Use XLAT Fields Whose Values Do not Exist In PSXLATITEM Table:
Query Name Field Name
 - ---------------------------------------------------------------------
 ARDISH01 DRAFT_TYPE
 1 Total Rows
Record Definition Audit Result: OK
Language Definition Audit Result: OK
SQL Audits Result: OK
Tree Definition Audit Result: OK
Version Check Audits Result: OK
XLATT Definition Audit Result: OK
Analytic Audit Result: OK
XML Publisher Audit Result: OK
Integration Broker Audits Result: Exception(s) Found
(IBRK-08) : IB Routing referencing invalid service operation:
Routing Operation Version
 - ------ --------- -------
 ~GEN~UPG~24567 IB_INST_VER_ASYNC_MSG VERSION_1
 ~GEN~UPG~17626 IB_INST_VER_RESP_MSG VERSION_1
 2 Total Rows
(IBRK-21) : Operations with duplicate routings:
Operation Version Routing
 - -------- ------- -------
 QAS_CRASH_MSG VERSION_1 ~GEN_UPG~18727
 QAS_CRASH_MSG VERSION_1 ~GEN~UPG~19278
 2 Total Rows

Solution:

Apply the latest Financials/SCM Maintenance Pack to resolve some of these errors.

Invalid Access ID and password for signon

Posted by on January 4, 2009 No comments

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

Problem:

When signing on to FSDEMO using Application Designer, the following error appears:

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

Solution:

When configuring the FSDEMO ODBC connection, set ‘Change the default database to’ to FSDEMO.

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