Possible Data Corruption

Question

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

April Dahl · Answer

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.

Sage Construction & Real Estate

Possible Data Corruption

Top Replies

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING