Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics SL forum
Unanswered

Fatal Database Error! Number = 5 on table PJPTDROL

Posted on by Microsoft Employee

SL7 sp3

For some project if we run the Integrity rebuild we get the error in the title.  Thru SQL traces it seems to be an issue with Inserting records to the PJPENTEM table, that violate the primary index.

if I delete all the records from the PJPENTEM for that job and run the integrity check it runs successfully and rebuilds the records in PJPENTEM.

Does anyone know anything about PJPENTEM?  Am I causing any other issues by doing this?  If it is safe, I would like to delete all from PJPENTEM and rebuild all projects (over the weekend).

Thanks,

Ayrin

 

 

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    Re: Fatal Database Error! Number = 5 on table PJPTDROL

    This has to be very rar,e but just incase somebody else come accross this.  In my case it the PJPENTEM table did not have a pjpentem0 index.  When I tried to add it, it said it already existed.  so I droped the index and then added it back thru SQL.  Everything worked after that.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    Re: Fatal Database Error! Number = 5 on table PJPTDROL

    The PJPENTEM stores the information that you see on the Resource Assignment screen, including your project/task/resource combinations (assignments), the actual hours for those assignments, and any budgets hours you entered for those assignments.  The integrity check may somewhat rebuild the table, but if a resource doesn’t have any actual work posted to a given assignment, the integrity check would have no way of knowing that the resource needs to be re-assigned to the task so it wouldn’t get re-added.   I would also suspect that your estimated/budgeted hours for the assignments would be lost as well.   So unless you don’t really use the resource assignment screen, I wouldn’t recommend just deleting from the table.

    Are you able to tell which project/task/employee combination might be duplicated?

Helpful resources

Quick Links

Replay now available! Dynamics 365 Community Call (CRM Edition)

Catch up on the first D365 Community Call held on 7/10

Community Spotlight of the Month

Kudos to Saurav Dhyani!

Congratulations to the June Top 10 community leaders!

These stars go above and beyond . . .

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 287,773 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 225,513 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans