SYSAUDIT section PIVOT-XX


Bug 20449315 - PEOPLEBOOKS VERSIONS 8.53 AND 8.54 HAVE THE WRONG INFORMATION FOR PIVOT-XX

This bug is currently open to have PeopleBooks updated.

Perform the steps below to clear the PIVOT-XX messages from the SYSAUDIT report.

Pivot Grid Administration component:

  1. 1. Log into PIA
    2.    Reporting Tools > Pivot Grid > Pivot Grid Adminstration
    3.    Click on Search
    4.    Scroll down towards bottom of page  [Select all]
    5.    Click on [Delete Model(s)]

For reference, see E-AUDIT - How to clear Pivot-XX messages from SYSAUDIT (Doc ID 1966348.1).


SYSAUDIT / ADS-01, ADS-02, ADS-03


The SYSAUDIT solution is not found in PeopleBooks  8.54 > Data Management for the Sysaudit row exceptions for sections  ADS-01, 02, 03. 

This was written up in Bug 20540306 - SYSAUDIT DETAILS FOR DATA SETS NEED TO BE INCLUDED INTO PEOPLEBOOKS


For reference,  see E-AUDIT: SYSAUDIT Errors ADS-01, ADS-02, ADS-03 and ADS-04 (Doc ID 1986494.1).


DDDAUDIT  runtime error:


DDDAUDIT fails with error PSTIMEZONEDEFN not found Error in include file "C:\PT8.53\sqr\\ptgbltme.sqc" on line 392: (SQR 3716) Error in SQL statement.

The PSTIMEZONEDEFN was a new PeopleTools  table as of PTools 8.52. If you are running an initial Dddaudit prior to an upgrade where the a Target environment is PT8.51 or before,  you may run into this problem.  The Dddaudit  may fail with this error if Configuration Manager points to the Copy of Production environment (PT8.51 or before), but uses the Source environment's new Dddaudit sqr.


For reference, see  E-AUDIT DDDAUDIT fails during upgrade: PSTIMEZONEDEFN not found (Doc ID 1457083.1).