An error occurred when accessing the job from the inbox page or Main Search page.

Oops! A bad request was performed

tblUIErrors table in the database shows the below error for a particular User ID

Error: Caused by [Violation of PRIMARY KEY constraint 'PK__#Tasks____7C6949D19088ED19'. Cannot insert duplicate key in 
object 'dbo.#Tasks'. The duplicate key value is (15170373).

 

 

Projects being deleted from TMS were the root cause of the issue where Project ID values were not fully removed from all parts of the database.

CRQ-31730 was created and fixed as part of TMS 12.7 which updated the removal of Projects in TMS so that Project ID values are removed from all tables in TMS.
 

When Projects are deleted, values are left within tblInvoicedTasks. This may affect vendor users from viewing jobs and downloading items due to their unique user settings.