[SUPPORTCENTERPLUS] error when changing tech signature
Hello,
We have supportcenter
8005 with postgresql database.
Last week we did a change : coming from mysql supportcenter 7946, change to postgresql, then upgrade to 8005.
With you, we had to ignore in restoreData.bat the table sduserprofile.
All is ok for now, except one thing :
A support tech can't change anything in its profile : in "Preferences", we can't change language, or change the signature.
Error message is :
Error while processing the request.
Try Home Page.
In the serveout log file we see at the same time :
Caused by: org.postgresql.util.PSQLException: ERROR: duplicate key value violates unique constraint "aaauserprofile_pk"
Détail : Key (user_id)=(18908) already exists.
Please find enclose the full error in a log file.
Here is data from the aaauserprofile table :
Can you please give us a request to solve this problem
?
Best regards
New to ADSelfService Plus?