Error:unique constraint (SYSADM.PS_PSPROJECTWORK)

Error:unique constraint (SYSADM.PS_PSPROJECTWORK)

If you found Error:unique constraint (SYSADM.PS_PSPROJECTWORK) when i compare project between 2 database on application designer.

Cause this problem has some field of LABEL_ID is blank in table PSDBFLDLABL.

You can check by this SQL.

SELECT FIELDNAME, LABEL_ID
FROM PSDBFLDLABL
WHERE LABEL_ID=’ ‘ OR LABEL_ID=”

Solution: You have to define label id of this field

Posted in PeopleSoft.