stored procedure FillTimesheetListTempTable Pass Through SQL

Kelly 20 Reputation points
2026-08-19T18:41:30.3+00:00

See attached error.

User goes to her Home Page, clicks on the Procurement section and onto Timesheets and immediately gets the attached error. The stored procedure FillTimesheetsListTempTable. Pass Through SQL, returned the following results: DBMS: 2627, Microsoft Dynamics GP:

We cleared temp tables and all stuck batches, but unsure how else to resolve this.Timesheet error in project FillTimesheet.pdf

SQL Server | Other
SQL Server | Other

Additional SQL Server features and topics not covered by specific categories

0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Erland Sommarskog 136.7K Reputation points MVP Volunteer Moderator
    2026-08-19T19:26:19.6633333+00:00

    From the SQL Server side of things, I recognise error 2627 as a primary key violation, but I am not sure how much that helps you.

    Overall, this question is difficult to answer without knowledge about Dynamics which is not covered here in Microsoft Q&A. Instead they have their forums over on https://community.dynamics.com/ I suggest that you try there.

    Was this answer helpful?

    1 person found this answer helpful.

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.