/
Primary Key error when printing Student Activity Checks

Primary Key error when printing Student Activity Checks

Description of Issue

Unable to print SA Checks 

SQL Error Message: [Microsoft][SQL Server Native Client 11.0][SQL Server]Violation of PRIMARY KEY constraint 'pk_prfldval'. Cannot insert duplicate key in object 'dbo.prfldval'. The duplicate key value is (salocks , C.PHS , PHS ).

Context
  • EERP 

  • Student Activities

  • Checks 

Cause

Server Lock in Student Activities 

Resolution
  1. Navigate to the following Financials > Student Activity > Setup > Student Activity Settings

  2. Click Lock Check

  3. Click Search 

  4. Click Accept 

  5. Click on Delete 

  6. Click on Yes  if there are any results.  You are just deleting the lock record.

  7. Click on Back to exit the program

If issue did not resolve, please contact Accounts Payable Support for further assistance. 

Additional Information










Related content

Unable to delete a Student Activity Transaction Error: Error on lock 1474. 100
Unable to delete a Student Activity Transaction Error: Error on lock 1474. 100
More like this
Received lock when reprinting Student Activity purchase order
Received lock when reprinting Student Activity purchase order
More like this
Error in Student Activity Check Reconciliation - User is running sachckrcn for Cash Code XXXX
Error in Student Activity Check Reconciliation - User is running sachckrcn for Cash Code XXXX
More like this
Error: Cannot insert duplicate key row in object dbo.appolock with unique index 'appolock1. The duplicate key value is
Error: Cannot insert duplicate key row in object dbo.appolock with unique index 'appolock1. The duplicate key value is
More like this
Error when clicking check lock in AP System Locks program
Error when clicking check lock in AP System Locks program
More like this
How to remove Student Activity locks
How to remove Student Activity locks
More like this