2401256 - Error DataAccessException - Could not update or insert a bookmark (i.e. Favorite/Recent) record is generated when opening an item or user

Error is generated when opening an item or admin is clicking on a user.

Failure: [FaultEvent fault=[RPC Fault faultString="com.plateausystems.elms.framework.snapshot.api.SnapshotException : com.plateausystems.elms.util.helper.ElmsUpdateException: DataAccessException - Could not update or insert a bookmark (i.e. Favorite/Recent) record!" faultCode="Server.Processing" faultDetail="null"] messageId="5377C56B-0308-B6E9-9798-66EBBF70A00E" type="fault" bubbles=false cancelable=true eventPhase=2]

Note: messageID number in error above may be different per instance.

SuccessFactors Learning Management System (LMS) - All Supported Versions

• There is more than one item present with same cpnt_key in the PA_CPNT table.
• There is more than one reference to the same user in the admin bookmark and user folder tables.

To fix this issue we need to update cpnt_key for the item to next value from PSQ_CPNT_KEY. Once confirmed that the item has a duplicate cpnt_key, a script will have to be provided to Operations to update the PA_CPNT table.

Example > update pa_cpnt set cpnt_key=PSQ_CPNT_KEY.nextval where cpnt_id=<cpnt_id>

Or

Duplicate bookmark & User folder references to be deleted from admin to be deleted by Operations.

• Issue identified in Engineering JIRA LRN-15817 & Script provided by Engineering executed by Operations in COSD-7939 for item
• Script to resolve admin user issue executed by Operations in SRSD-17690
• Issue re-evaluated in COSD-26894 to be casued by missing constraint - please refer to this Jira and DB team to find root cause why constraint is missing for future occurrence.

Failure: [FaultEvent fault=[RPC Fault faultString; SnapshotException; DataAccessException; Could not update or insert a bookmark; faultCode="Server.Processing" faultDetail="null"; Failure: [FaultEvent fault=[RPC Fault faultString="com.plateausystems.elms.framework.snapshot.api.SnapshotException : com.plateausystems.elms.util.helper.ElmsUpdateException: DataAccessException - Could not update or insert a bookmark (i.e. Favorite/Recent) record!" faultCode="Server.Processing" faultDetail="null"] messageId= "7D6C8357-A30E-D8E6-4325-3D263C0A9986" type="fault" bubbles=false cancelable=true eventPhase=2] user record view click clicking , KBA , LOD-SF-LMS-COR , LMS Core - Items, Catalog, Curricula , LOD-SF-LMS , Learning Management System , Problem