Re[2]: People Soft Panel Problem

[Bill Bowers <bowersb@PSPH.PROVIDENCE.ORG>]

     Nicholas:

     You sent out the response to a panel problem that I recently
     encountered:

        "Another user has updated the panel (18,2)."

     In the message you said that the information was from the "PeopleSoft
     Users List".

     Where is this list located?

     Bill


______________________________ Reply Separator _________________________________
Subject: Re: People Soft Panel Problem
Author:  SQR-USERS@USA.NET at INTERNET
Date:    8/26/98 4:06 PM


Bill, (and others...) note this information is from the peoplesoft users
list. You may find it more beneficial for a question such as this...


Error message: "Another user has updated the panel (18,2)"
Top 11 reasons why you might get the above error message (and haven't we
all experienced it before....)
1) A key list item is updatable on a panel when it should be display
only
2) A key is not defined as a list item.
3) A group box is outside the scroll bar but the radio buttons inside of
it
are inside the scrollbar.
4) The scrollbar is after the effdt and eff_status in the panel order
5) There are more than four 254-char fields on the panel (may only be
relevant in a very early version of tools - like 2.21
6) One of the keys is auto incremented and the installation table has an
out of synch number
7) The last emplid assigned on the installation table has not been
changed
to a number lower than that assigned to the last employee hired (sounds
HR
specific)
8) When peoplecode assigns a value with 2 trailing blanks (e.g. "ABC ")
multiple saves cause this error.
9) Run a PC/SQL trace and examine the output. It's possible a COMMIT
statement was issued by another process preventing the user from saving
the
panel.
10) when an Insert SQL statement fails because of the unique key
constraint
violation. This happens a lot when some PeopleCode that's responsible
for
retrieving and incrementing indexes from tables fails unexpectedly. The
general solution is to find which value wasn't incremented and use
SQL*Talk, SQL*Plus, to increment that value. In the SQL trace, look for
a
Return Code (RC) beside a SQL Insert statement with a nonzero value
11) You perform a SQL update or insert to a table/field already on the
panel. You should have done a Updatevalue.

PS-Users - The PeopleSoft Users Discussion List
Subscribe/Unsubscribe at: www.ps-users.com

Regards,

Nicholas.


Nicholas Pegg
Business Information Technology
nicholas_pegg@bit.com


>----------
>From:  Bill Bowers[SMTP:bowersb@PSPH.PROVIDENCE.ORG]
>Sent:  August 26, 1998 3:45 PM
>To:    Multiple recipients of list SQR-USERS
>Subject:       People Soft Panel Problem
>
>     We are using version 6.0 of HRMS
>
>     I have created a custom panel.
>
>     In the process of executing the panel I am receiving the following:
>     "Another user has updated the panel (18,2)."
>
>     I have deleted and recreated the panel, Reviewed the process scheduler
>     options Reviewed the menu....
>
>     Any ideas?
>
>     Thanks in advance
>
>     Bill
>