AnsweredAssumed Answered

Restore the PRCALENDAR table from a backup

Question asked by another_martink on Oct 10, 2011
Latest reply on Aug 28, 2012 by another_martink
TEC555483 and TEC555484 have

Description:

The association between the Resource and the Resource Calendar has been lost in the PRCALENDAR table.

Solution:

Restore the PRCALENDAR table from a backup.

Does that mean that prcalendar table is completely corrupt or just for the record for the resource in question?
Or does it mean what is says: The association between the Resource and the Resource Calendar has been lost in the PRCALENDAR table?
If the prcalendar table is not completely corrupt wouldn't an easier method be to associate the resource in question first with another calendar and then with the correct one?
The only problem with that is that neither the error message nor the description nor the solution says which resource or how to identify it.
So it has to be with a prcalendar backup. Now where to we have the prcalendar backups?
I guess the answer is in the database dump unless we create separate backups from prcalendar and why should we do that?
Say that we did have a backup of prcalendar or to be more precise we have taken them daily and keep one per week for a month and from then on one for each month.
How to establish which one is is not corrupt?
And so n.

Question 1: What would be the solution for a nontechnical admin to solve the problem in a supported manner?

Martti K.

P.S. Question 2: What would be the approach to take when you feel a TEC DOC flies over your dandruft (a local saying)?

Outcomes