AnsweredAssumed Answered

Understanding File Recovery, log file messages

Question asked by justinc on Jul 27, 2012
Latest reply on Aug 3, 2012 by gdurniak

Hey all,

I am trying to troubleshoot some issues we have been having with corruption in our database, corruption that doesn't seem to be cleared up by a recovery. In doing so, I am delving into the Recovery Log and trying to analyze what exactly is being found during that process.

 

So here are snippets (in sequence) from my log file, showing what I think are the important bits for the errors that it says it found. After finding an error I went back to the top of that section where the error occurred to pull out the table that was being worked on. (At least that is my understanding of the file structure.) Summary is shown at the bottom.

...

2012-07-26 17:43:18.715 -0700 Milton.fmp12 0 Recovering fields for table 'Courses'

2012-07-26 17:43:18.715 -0700 Milton.fmp12 0 Recovering: field catalog 'Courses'

2012-07-26 17:43:18.761 -0700 Milton.fmp12 0 Rebuilding field catalog 'Courses' order list: name

2012-07-26 17:43:18.928 -0700 Milton.fmp12 0 Rebuilding field catalog 'Courses' order list: custom

2012-07-26 17:43:19.055 -0700 Milton.fmp12 0 Rebuilding field catalog 'Courses' order list: type

2012-07-26 17:43:19.214 -0700 Milton.fmp12 0 Recovering data for table 'Courses'

2012-07-26 17:43:19.215 -0700 Milton.fmp12 0 Recovering: library catalog 'Courses'

2012-07-26 17:43:19.727 -0700 Milton.fmp12 0 Rebuilding library catalog 'Courses' order list: quick reference

2012-07-26 17:43:32.077 -0700 Milton.fmp12 0 Recovering: library '' (5204)

2012-07-26 17:43:34.456 -0700 Milton.fmp12 0 Recovering: library '' (8388)

2012-07-26 17:43:34.456 -0700 Milton.fmp12 0 Recovering: library '' (8389)

2012-07-26 17:43:37.158 -0700 Milton.fmp12 0 Evaluating library (131)

2012-07-26 17:43:37.193 -0700 Milton.fmp12 0 Found 2 stranded library object(s)

...

2012-07-26 17:43:37.379 -0700 Milton.fmp12 0 Recovering: field 'zgn_iCalPluginCheck' (532)

2012-07-26 17:43:37.380 -0700 Milton.fmp12 8477 Calculation modified

2012-07-26 17:43:37.381 -0700 Milton.fmp12 8476 This item changed

2012-07-26 17:44:05.357 -0700 Milton.fmp12 0 Recovering fields for table 'ScreenCaps'

2012-07-26 17:44:05.358 -0700 Milton.fmp12 0 Recovering: field catalog 'ScreenCaps'

...

2012-07-26 17:44:05.367 -0700 Milton.fmp12 0 Recovering: field 'sc_FileName' (9)

2012-07-26 17:44:05.368 -0700 Milton.fmp12 8477 Calculation modified

2012-07-26 17:44:05.369 -0700 Milton.fmp12 8476 This item changed

2012-07-26 17:52:20.807 -0700 Milton.fmp12 0 Deleted last used found sets

2012-07-26 17:52:21.388 -0700 Milton.fmp12 8495 WARNING: problems were detected while recovering the database. The recovered file should NOT be used going forward; copy only the most recent work from it into a backup copy of the original file.

2012-07-26 17:52:21.389 -0700 Milton.fmp12 0 File blocks: scanned and rebuilt 108289 block(s), dropped 0 invalid data block(s)

2012-07-26 17:52:21.389 -0700 Milton.fmp12 0 Schema: scanned fields and tables; some problems were found...

2012-07-26 17:52:21.390 -0700 Milton.fmp12 0 fields created to match record data: 0

2012-07-26 17:52:21.391 -0700 Milton.fmp12 0 field values deleted due to invalid ID or repetition: 0

2012-07-26 17:52:21.391 -0700 Milton.fmp12 0 records deleted due to invalid ID: 0

2012-07-26 17:52:21.392 -0700 Milton.fmp12 0 Structure: scanned; 3 item(s) modified

2012-07-26 17:52:21.393 -0700 Milton.fmp12 0 File size after recovery is 450629632 bytes

2012-07-26 17:52:21.393 -0700 Milton.fmp12 0 *** Completed recovery to 'Milton Backup Recovered.fmp12'

 

First, it says that it found 3 items that it modified. In searching through the log file I was looking for the set of keywords that Alexei Folger recommended:


(error|warning|modified|changed|dropped|damaged|invalid)

 

However, that only turned up two entries in the log; the two 8477 errors: "Calculation modified". Upon further perusing of the file I found the "Found 2 stranded library objects..." entry. Is that the 3rd error that is listed in the summary?

 

Secondly, what do these error code numbers mean? Are they literally just numeric representations of the text field? I.e. 8477 = "Calculation modified" and 8476 = "This item changed". Or is there more the be learned from them somewhere?

 

Third, specific to the errors it found: the errors mentioned don't seem to be applicable to the fields they are associated with. Again, my understanding of the structure is that the errors are indented BELOW the field that they refer to. Hence, in the clips above I have copied the line ABOVE the error message. But, if I go look at "Courses::zgn_iCalPluginCheck", it is NOT a calculation field. It is a text field. So I am confused. It doesn't have any Auto-enter or Validation calculations, either. So what calculation was modified?

 

Lastly, the library that was supposedly recovered: "Evaluating Library (131)...Two Stranded objects found". What can I learn from that entry? What does the numbers mean (e.g. "131" or "8389")?

 

Ultimately, our problem still persists after doing the recovery. (Yeah, I know, don't use the recovered file...that's a whole other question, though: how to create a 'new' file.) The primary evidence of the corruption is that the Layout Manager doesn't allow us to reorder layouts; they keep returning to their original position.

 

Any clarifications, comments, hints, or information would be appreciated.

 

Thanks,

J

Outcomes