Tag Archives: Project

(QUERY-27) Following Queries Use XLAT Fields Whose Values Do not Exist in PSXLATITEM Table

(QUERY-27) Following Queries Use XLAT Fields Whose Values Do not Exist in PSXLATITEM Table

Problem:

After running SYSAUDIT on FSDEV, the following error appears:

(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

Solution:

1. Determine if scriptsPTPATCH.DMS was run. Log onto SQL Server Management Studio and running the following command:

select * from PS_MAINTENANCE_LOG where UPDATE_ID = '768890';

2. Next, load Application Designer and copy the PATCH849 project from file.

It was already copied.

3. Check PS_QRYFIELD_VW to see the fields used in the ARDISH01 query:

select * from dbo.PS_QRYFIELD_VW where QRYNAME = 'ARDISH01'

4. Get list of ‘DRAFT_’ field names from the PSXLATITEM table:

select distinct FIELDNAME from PSXLATITEM where FIELDNAME like 'DRAFT_%'

There is no DRAFT_TYPE field in this table.

5. Get list of ‘DRAFT_’ field names from the PSXLATITEM table:

Checked SYSAUDIT for FSDMO. This error is not present. Apply MP5 to FSDEV to resolve issue.

PPLTLS84CUR Results

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]