Step 1: Set the following in
psappsrv.cfg
TracePPR=1
TracePPRMask=32767
TracePPRMask=32767
Step 2: Go to the PIA and
before logging on, add &trace=Y (uppercase y) at the end of the web address
and press the keyboard Enter key Or Select Set Trace Flag at signon page. Check
the first 5 SQL options and for PeopleCode the 'List Program' and 'Each
statement' options.
Step 3: Log in to PIA and
reproduce the error.
Step 4: Check the trace,
especially the portion which contains this information:
PSAPPSRV.28630 1-167605
11.00.03 0.001 Record PS_PERSON.LASTMANT_DTTM database value
"2012-06-11-10.58.44.000000" page value "2012-06-11-10.05.30.000000"
The trace should clearly show the field which is producing the error as well as the values populated both on database side and page side.
One of the most common reason
for this happening is, You are using a view to select
data into a Scroll based on a table and No Auto Select option is turned on. The
number of columns in view and scroll area base table differs and additional
column in base table contain not null values. You use Auto update for Scroll
and change the value of the field in a scroll and save.
To resolve this issue, add the
same number of columns to view as the base table or if possible, make the
same view as a base record for the scroll that you use for selection.
Other reason is using SQLExec
in SavePostChange to update the Base Table Record and therefore changing the
value.
