x Want to participate? Join the group to interact
  • State Suggested Answer
  • Replies 1 reply
  • Answers 1 answer
  • Subscribers 240 subscribers
  • Views 2883 views
  • Users 0 members are here
Browse Forums
Sage 100 Contractor Announcements
119
topics
57
replies
Sage 100 Contractor General Discussion
1k
topics
4k
replies
Sage 300 CRE Announcements
168
topics
526
replies
Sage 300 CRE General Discussion
3k
topics
9k
replies
Sage Construction Management Announcements
4
topics
0
replies
Sage Construction Management General Discussion
16
topics
21
replies
Sage Estimating Announcements
39
topics
3
replies
Sage Estimating General Discussion
189
topics
448
replies
PeterMan

Possible Data Corruption

SUGGESTED
Posted By

Sage300 CRE Version 17.1 Rev6

We had a power issue and the database server shut down unexpectedly during operations. After the server was powered on again, several users complained they were getting errors in the application. We tried restarting the server again but it does not fix the issue.


One of the reported issues can be seen when we try to open Project Management>Contract Control>Commitments. We get the errors attached. I suspect there are multiple other errors because multiple users are complaining. 

I see the following errors in the PSQL PVSW log. 

MKDE-2111: System Error: 112.2.0 File: E:\SHARED_TIMBERLINE\DATA\MCNDATA\PVDATA\NEW_JCT\JCT_R2.MKD
MKDE-2111: System Error: 110.2.0 File: E:\SHARED_TIMBERLINE\DATA\MCNDATA\PVDATA\DOCUMENT_PJD\PJD_R11.MKD
MKDE-2111: System Error: 110.2.0 File: E:\SHARED_TIMBERLINE\DATA\MCNDATA\PVDATA\DOCUMENT_PJD\PJD_R11.MKD
MKDE-2111: System Error: 112.2.0 File: E:\SHARED_TIMBERLINE\DATA\MCNDATA\PVDATA\NEW_JCT\JCT_R2.MKD
MKDE-2111: System Error: 112.2.0 File: E:\SHARED_TIMBERLINE\DATA\MCNDATA\PVDATA\NEW_JCT\JCT_R2.MKD
MKDE-2111: System Error: 110.2.0 File: E:\SHARED_TIMBERLINE\DATA\MCNDATA\PVDATA\DOCUMENT_PJD\PJD_R11.MKD
MKDE-2111: System Error: 112.2.0 File: E:\SHARED_TIMBERLINE\DATA\MCNDATA\PVDATA\NEW_JCT\JCT_R2.MKD
MKDE-2111: System Error: 112.2.0 File: E:\SHARED_TIMBERLINE\DATA\MCNDATA\PVDATA\NEW_JCT\JCT_R2.MKD
MKDE-2111: System Error: 112.2.0 File: E:\SHARED_TIMBERLINE\DATA\MCNDATA\PVDATA\NEW_JCT\JCT_R2.MKD
MKDE-2111: System Error: 112.2.0 File: E:\SHARED_TIMBERLINE\DATA\MCNDATA\PVDATA\NEW_JCT\JCT_R2.MKD
MKDE-2111: System Error: 110.2.0 File: E:\SHARED_TIMBERLINE\DATA\MCNDATA\PVDATA\DOCUMENT_PJD\PJD_R11.MKD
MKDE-2111: System Error: 112.2.0 File: E:\SHARED_TIMBERLINE\DATA\MCNDATA\PVDATA\NEW_JCT\JCT_R2.MKD
MKDE-2111: System Error: 110.2.0 File: E:\SHARED_TIMBERLINE\DATA\MCNDATA\PVDATA\DOCUMENT_PJD\PJD_R11.MKD
MKDE-2111: System Error: 110.2.0 File: E:\SHARED_TIMBERLINE\DATA\MCNDATA\PVDATA\DOCUMENT_PJD\PJD_R11.MKD
MKDE-2111: System Error: 110.2.0 File: E:\SHARED_TIMBERLINE\DATA\MCNDATA\PVDATA\DOCUMENT_PJD\PJD_R11.MKD
MKDE-2111: System Error: 112.2.0 File: E:\SHARED_TIMBERLINE\DATA\MCNDATA\PVDATA\NEW_JCT\JCT_R2.MKD
MKDE-2111: System Error: 110.2.0 File: E:\SHARED_TIMBERLINE\DATA\MCNDATA\PVDATA\DOCUMENT_PJD\PJD_R11.MKD
MKDE-2111: System Error: 112.2.0 File: E:\SHARED_TIMBERLINE\DATA\MCNDATA\PVDATA\NEW_JCT\JCT_R2.MKD
MKDE-2111: System Error: 112.2.0 File: E:\SHARED_TIMBERLINE\DATA\MCNDATA\PVDATA\NEW_JCT\JCT_R2.MKD
MKDE-2024: The file E:\SHARED_TIMBERLINE\DATA\MCNDATA\PVDATA\NEW_GLT\GLT_R1.MKD is rolling back.
MKDE-2134: Roll forward recovery has started for file: E:\SHARED_TIMBERLINE\DATA\MCNDATA\PVDATA\NEW_GLT\GLT_R1.MKD.
MKDE-2136: Roll forward recovery has finished for file: E:\SHARED_TIMBERLINE\DATA\MCNDATA\PVDATA\NEW_GLT\GLT_R1.MKD.
MKDE-2111: System Error: 112.2.0 File: E:\SHARED_TIMBERLINE\DATA\MCNDATA\PVDATA\NEW_JCT\JCT_R2.MKD
MKDE-2111: System Error: 112.2.0 File: E:\SHARED_TIMBERLINE\DATA\MCNDATA\PVDATA\NEW_JCT\JCT_R2.MKD
MKDE-2111: System Error: 112.2.0 File: E:\SHARED_TIMBERLINE\DATA\MCNDATA\PVDATA\NEW_JCT\JCT_R2.MKD
MKDE-2111: System Error: 112.2.0 File: E:\SHARED_TIMBERLINE\DATA\MCNDATA\PVDATA\NEW_JCT\JCT_R2.MKD
MKDE-2111: System Error: 110.2.0 File: E:\SHARED_TIMBERLINE\DATA\MCNDATA\PVDATA\DOCUMENT_PJD\PJD_R11.MKD
MKDE-2111: System Error: 112.2.0 File: E:\SHARED_TIMBERLINE\DATA\MCNDATA\PVDATA\NEW_JCT\JCT_R2.MKD

I have a backup from the previous night and I tried replacing the file JCT_R2.MKD and that lets me open committments in Proj Management. Even though both files have the same size, they have different md5 hashes which makes me believe they are not the same, so I don't know what data i will be loosing by replacing the file. I will like to avoid restoring the entire data from previous night just because we have over a hundred users and it will be a lot of work wasted.

How can I check the entire database for errors and is it safe to replace the MKD files from the previous night? Any help will be most appreciated.


Thanks

Peter

  • 0
    SUGGESTED

    Hi Peter,

    You cannot restore individual MKD files. Each file contains a specific set of records and by only replacing one file, you are creating a mis-match of data with the other records in that file. Also, you can't restore individual files within the data folder. For example, you cannot restore only the new_jct folder because of other interfacing applications that send data to that file. You can end up missing data as you'll have data in other files that are not accounted for in that JC new file.

    If you can put the file that you replaced back to what it was, you should try File Doctor to see if it is able to repair the file. Refer to Sage Knowledgebase article 20400. Then contact Sage 300 CRE Customer Support to have the File Doctor journal reviewed to determine if the fixes are good fixes or not (some fixes can result in the loss of data). If the fixes are not good, you may have to restore the entire company folder from a backup. In some cases, our Sage Professional Services Group may be able to do a file fix (there is a fee for their services).

    If you are not able to put the MKD file back to what it was before you replaced it, you will have to restore the entire data folder from a backup.

*Community Hub is the new name for Sage City