5 Replies Latest reply on Feb 27, 2015 10:46 AM by schamblee

    Trying to recover a Database

    TracyBogans

      Title

      Trying to recover a Database

      Post

      Working on my database and  added a new Global field in my Global table. Calculation was

       g_Shift = Case(ShiftTable="1st";"1st Shift" or ShiftTable="2nd";"2nd Shift"or ShiftTable="3rd";"3rd Shift")

      Now I can't start my database it goes to Filemaker Not Responding .. I have tried a database recover.. See Screen shot and attached log file.. it still hangs... other databases open with no problems

      Log File:2015-02-26 11:33:38.331 -0500    OIV_02162015.fmp12    0    *** Started consistency check of improperly closed file, total of 69842 block(s) to check
      2015-02-26 11:33:55.100 -0500    OIV_02162015.fmp12    8432    Page 69842 marked free but not in free list
      2015-02-26 11:33:55.115 -0500    OIV_02162015.fmp12    0    Reset maximum block sequence number to 216487502
      2015-02-26 11:33:55.146 -0500    OIV_02162015.fmp12    0    *** Completed consistency check, checked 69842 block(s)
      2015-02-26 21:56:32.475 -0500    OIV_02162015.fmp12    0    *** Started consistency check of improperly closed file, total of 69930 block(s) to check
      2015-02-26 21:56:40.293 -0500    OIV_02162015.fmp12    8432    Page 69930 marked free but not in free list
      2015-02-26 21:56:40.293 -0500    OIV_02162015.fmp12    0    Reset maximum block sequence number to 216988090
      2015-02-26 21:56:40.293 -0500    OIV_02162015.fmp12    0    *** Completed consistency check, checked 69930 block(s)
      2015-02-26 22:03:35.458 -0500    OIV_02162015.fmp12    0    *** Started consistency check of improperly closed file, total of 69930 block(s) to check
      2015-02-26 22:03:43.276 -0500    OIV_02162015.fmp12    8432    Page 69930 marked free but not in free list
      2015-02-26 22:03:43.292 -0500    OIV_02162015.fmp12    0    Reset maximum block sequence number to 216988090
      2015-02-26 22:03:43.292 -0500    OIV_02162015.fmp12    0    *** Completed consistency check, checked 69930 block(s)
      2015-02-27 09:35:40.807 -0500    OIV_02162015.fmp12    0    *** Started consistency check of improperly closed file, total of 69930 block(s) to check
      2015-02-27 09:35:46.657 -0500    OIV_02162015.fmp12    8432    Page 69930 marked free but not in free list
      2015-02-27 09:35:46.657 -0500    OIV_02162015.fmp12    0    Reset maximum block sequence number to 216988090
      2015-02-27 09:35:46.657 -0500    OIV_02162015.fmp12    0    *** Completed consistency check, checked 69930 block(s)
      2015-02-27 09:44:58.956 -0500    OIV_02162015.fmp12    0    *** Started consistency check, total of 69930 block(s) to check
      2015-02-27 09:45:14.355 -0500    OIV_02162015.fmp12    8432    Page 69930 marked free but not in free list
      2015-02-27 09:45:14.355 -0500    OIV_02162015.fmp12    0    Reset maximum block sequence number to 216988090
      2015-02-27 09:45:14.355 -0500    OIV_02162015.fmp12    0    *** Completed consistency check, checked 69930 block(s)
      2015-02-27 09:47:13.989 -0500    OIV_02162015.fmp12    0    *** Started recovery of 'OIV_02162015.fmp12'
      2015-02-27 09:47:13.989 -0500    OIV_02162015.fmp12    0    Scanning blocks and rebuilding file...
      2015-02-27 09:47:20.744 -0500    OIV_02162015.fmp12    0    Scan complete, found 69192 page(s) to process
      2015-02-27 09:47:23.895 -0500    OIV_02162015.fmp12    0    Rebuild processed 69192 page(s), completing end of file
      2015-02-27 09:47:24.815 -0500    OIV_02162015.fmp12    0    Completed copy or rebuild of file blocks
      2015-02-27 09:47:24.846 -0500    OIV_02162015.fmp12    0    Recovering: font catalog
      2015-02-27 09:47:24.846 -0500    OIV_02162015.fmp12    0      Rebuilding font catalog order list: name 
      2015-02-27 09:47:24.846 -0500    OIV_02162015.fmp12    0      Recovering: font 'Arial' (0)
      2015-02-27 09:47:24.846 -0500    OIV_02162015.fmp12    0      Recovering: font 'Segoe UI' (1)
      2015-02-27 09:47:24.846 -0500    OIV_02162015.fmp12    0      Recovering: font 'arial,sans-serif' (2)
      2015-02-27 09:47:24.862 -0500    OIV_02162015.fmp12    0      Recovering: font 'Tahoma' (3)
      2015-02-27 09:47:24.862 -0500    OIV_02162015.fmp12    0      Recovering: font 'Arial Narrow' (4)
      2015-02-27 09:47:24.862 -0500    OIV_02162015.fmp12    0      Recovering: font 'Courier New' (5)
      2015-02-27 09:47:24.862 -0500    OIV_02162015.fmp12    0      Recovering: font 'Century' (6)
      2015-02-27 09:47:24.862 -0500    OIV_02162015.fmp12    0      Recovering: font 'Arial Black' (7)
      2015-02-27 09:47:24.862 -0500    OIV_02162015.fmp12    0      Recovering: font 'Times New Roman' (8)
      2015-02-27 09:47:24.862 -0500    OIV_02162015.fmp12    0      Recovering: font 'Symbol' (9)
      2015-02-27 09:47:24.862 -0500    OIV_02162015.fmp12    0      Recovering: font 'Wingdings' (10)
      2015-02-27 09:47:24.878 -0500    OIV_02162015.fmp12    0    Recovering schema
      2015-02-27 09:47:24.878 -0500    OIV_02162015.fmp12    0    Recovering schema catalogs
      2015-02-27 09:47:24.878 -0500    OIV_02162015.fmp12    0    Recovering: table catalog
      2015-02-27 09:47:24.878 -0500    OIV_02162015.fmp12    0      Rebuilding table catalog order list: name 
      2015-02-27 09:47:24.878 -0500    OIV_02162015.fmp12    0      Rebuilding table catalog order list: custom 
      2015-02-27 09:47:24.893 -0500    OIV_02162015.fmp12    0      Recovering: table 'OIV_Alrm_Data' (129)
      2015-02-27 09:47:24.893 -0500    OIV_02162015.fmp12    0      Recovering: table 'PSC_SOP' (135)
      2015-02-27 09:47:24.893 -0500    OIV_02162015.fmp12    0      Recovering: table 'GlobalSearchFields' (137)
      2015-02-27 09:47:24.893 -0500    OIV_02162015.fmp12    0      Recovering: table 'Global_Screen1' (139)
      2015-02-27 09:47:24.893 -0500    OIV_02162015.fmp12    0      Recovering: table 'RaconServer' (145)
      2015-02-27 09:47:24.909 -0500    OIV_02162015.fmp12    0      Recovering: table 'CNOCPE_Users' (146)
      2015-02-27 09:47:24.909 -0500    OIV_02162015.fmp12    0      Recovering: table 'ApplicationGroup' (147)
      2015-02-27 09:47:24.909 -0500    OIV_02162015.fmp12    0      Recovering: table 'Months' (155)
      2015-02-27 09:47:24.909 -0500    OIV_02162015.fmp12    0      Recovering: table 'DashBoard' (156)
      2015-02-27 09:47:24.909 -0500    OIV_02162015.fmp12    0      Recovering: table 'FileMasker' (157)
      2015-02-27 09:47:24.924 -0500    OIV_02162015.fmp12    0      Recovering: table 'FileMasker 2' (158)
      2015-02-27 09:47:24.924 -0500    OIV_02162015.fmp12    0      Recovering: table 'Test' (159)
      2015-02-27 09:47:24.924 -0500    OIV_02162015.fmp12    0      Recovering: table 'ShiftTotal' (160)
      2015-02-27 09:47:24.924 -0500    OIV_02162015.fmp12    0    Recovering: table alias catalog
      2015-02-27 09:47:24.940 -0500    OIV_02162015.fmp12    0      Rebuilding table alias catalog order list: name 
      2015-02-27 09:47:24.940 -0500    OIV_02162015.fmp12    0      Rebuilding table alias catalog order list: custom 
      2015-02-27 09:47:24.956 -0500    OIV_02162015.fmp12    0      Deleted relational dependencies
      2015-02-27 09:47:24.956 -0500    OIV_02162015.fmp12    0      Recovering: table alias 'OIV_Alrm_Data' (1065089)
      2015-02-27 09:47:24.956 -0500    OIV_02162015.fmp12    0      Recovering: table alias 'PSC_SOP' (1065095)
      2015-02-27 09:47:24.971 -0500    OIV_02162015.fmp12    0      Recovering: table alias 'GlobalSearchFields' (1065098)
      2015-02-27 09:47:24.971 -0500    OIV_02162015.fmp12    0      Recovering: table alias 'OIV_Viewer' (1065100)
      2015-02-27 09:47:24.971 -0500    OIV_02162015.fmp12    0      Recovering: table alias 'Global_Screen1' (1065101)
      2015-02-27 09:47:24.971 -0500    OIV_02162015.fmp12    0      Recovering: table alias 'RaconServer' (1065106)
      2015-02-27 09:47:24.971 -0500    OIV_02162015.fmp12    0      Recovering: table alias 'CNOCPE_Users' (1065107)
      2015-02-27 09:47:24.971 -0500    OIV_02162015.fmp12    0      Recovering: table alias 'ApplicationGroup' (1065108)
      2015-02-27 09:47:24.971 -0500    OIV_02162015.fmp12    0      Recovering: table alias 'Months' (1065116)
      2015-02-27 09:47:24.971 -0500    OIV_02162015.fmp12    0      Recovering: table alias 'DashBoard' (1065117)
      2015-02-27 09:47:24.987 -0500    OIV_02162015.fmp12    0      Recovering: table alias 'AlertsPerMonth' (1065118)
      2015-02-27 09:47:24.987 -0500    OIV_02162015.fmp12    0      Recovering: table alias 'AlertsPerMonthPrevYr' (1065119)
      2015-02-27 09:47:24.987 -0500    OIV_02162015.fmp12    0      Recovering: table alias 'AllMonths' (1065120)
      2015-02-27 09:47:24.987 -0500    OIV_02162015.fmp12    0      Recovering: table alias 'Months1stQuarter' (1065121)
      2015-02-27 09:47:24.987 -0500    OIV_02162015.fmp12    0      Recovering: table alias 'Months2ndQuarter 2' (1065122)
      2015-02-27 09:47:24.987 -0500    OIV_02162015.fmp12    0      Recovering: table alias 'Months3rdQuarter 3' (1065123)
      2015-02-27 09:47:24.987 -0500    OIV_02162015.fmp12    0      Recovering: table alias 'Months4thQuarter 4' (1065124)
      2015-02-27 09:47:24.987 -0500    OIV_02162015.fmp12    0      Recovering: table alias 'Shift1' (1065125)
      2015-02-27 09:47:24.987 -0500    OIV_02162015.fmp12    0      Recovering: table alias 'ApplicationGroup 2' (1065129)
      2015-02-27 09:47:24.987 -0500    OIV_02162015.fmp12    0      Recovering: table alias 'FileMasker' (1065130)
      2015-02-27 09:47:24.987 -0500    OIV_02162015.fmp12    0      Recovering: table alias 'FileMasker 2' (1065131)
      2015-02-27 09:47:24.987 -0500    OIV_02162015.fmp12    0      Recovering: table alias 'Test' (1065132)
      2015-02-27 09:47:25.002 -0500    OIV_02162015.fmp12    0      Recovering: table alias 'ShiftTotal' (1065136)
      2015-02-27 09:47:25.002 -0500    OIV_02162015.fmp12    0      Recovering: table alias 'AlertsPerMonth 2' (1065137)
      2015-02-27 09:47:25.002 -0500    OIV_02162015.fmp12    0      Recovering: table alias 'AllShifts' (1065138)
      2015-02-27 09:47:25.002 -0500    OIV_02162015.fmp12    0    Recovering: relation catalog
      2015-02-27 09:47:25.002 -0500    OIV_02162015.fmp12    0      Recovering relation from 'OIV_Alrm_Data' to 'PSC_SOP'
      2015-02-27 09:47:25.002 -0500    OIV_02162015.fmp12    0      Recovering relation from 'Global_Screen1' to 'OIV_Viewer'
      2015-02-27 09:47:25.002 -0500    OIV_02162015.fmp12    0      Recovering relation from 'RaconServer' to 'OIV_Alrm_Data'
      2015-02-27 09:47:25.002 -0500    OIV_02162015.fmp12    0      Recovering relation from 'OIV_Alrm_Data' to 'OIV_Viewer'
      2015-02-27 09:47:25.002 -0500    OIV_02162015.fmp12    0      Recovering relation from 'CNOCPE_Users' to 'OIV_Alrm_Data'
      2015-02-27 09:47:25.018 -0500    OIV_02162015.fmp12    0      Recovering relation from 'ApplicationGroup' to 'OIV_Alrm_Data'
      2015-02-27 09:47:25.018 -0500    OIV_02162015.fmp12    0      Recovering relation from 'Months' to 'AlertsPerMonth'
      2015-02-27 09:47:25.018 -0500    OIV_02162015.fmp12    0      Recovering relation from 'Months' to 'AlertsPerMonthPrevYr'
      2015-02-27 09:47:25.018 -0500    OIV_02162015.fmp12    0      Recovering relation from 'AllMonths' to 'DashBoard'
      2015-02-27 09:47:25.018 -0500    OIV_02162015.fmp12    0      Recovering relation from 'Months1stQuarter' to 'DashBoard'
      2015-02-27 09:47:25.018 -0500    OIV_02162015.fmp12    0      Recovering relation from 'Months2ndQuarter 2' to 'DashBoard'
      2015-02-27 09:47:25.018 -0500    OIV_02162015.fmp12    0      Recovering relation from 'Months3rdQuarter 3' to 'DashBoard'
      2015-02-27 09:47:25.034 -0500    OIV_02162015.fmp12    0      Recovering relation from 'Months4thQuarter 4' to 'DashBoard'
      2015-02-27 09:47:25.034 -0500    OIV_02162015.fmp12    0      Recovering relation from 'ShiftTotal' to 'AlertsPerMonth 2'
      2015-02-27 09:47:25.034 -0500    OIV_02162015.fmp12    0      Recovering relation from 'AllShifts' to 'DashBoard'
      2015-02-27 09:47:25.034 -0500    OIV_02162015.fmp12    0    Recovering fields for table 'OIV_Alrm_Data'
      2015-02-27 09:47:25.034 -0500    OIV_02162015.fmp12    0    Recovering: field catalog 'OIV_Alrm_Data'
      2015-02-27 09:47:25.049 -0500    OIV_02162015.fmp12    0      Rebuilding field catalog 'OIV_Alrm_Data' order list: name 
      2015-02-27 09:47:25.049 -0500    OIV_02162015.fmp12    0      Rebuilding field catalog 'OIV_Alrm_Data' order list: custom 
      2015-02-27 09:47:25.049 -0500    OIV_02162015.fmp12    0      Rebuilding field catalog 'OIV_Alrm_Data' order list: type 
      2015-02-27 09:47:25.065 -0500    OIV_02162015.fmp12    0      Recovering data for table 'OIV_Alrm_Data'
      2015-02-27 09:47:38.142 -0500    OIV_02162015.fmp12    0      Evaluating library (129)
      2015-02-27 09:47:38.142 -0500    OIV_02162015.fmp12    0      Recovering: field '_OIV_ID' (1)
      2015-02-27 09:47:38.142 -0500    OIV_02162015.fmp12    0      Recovering: field 'Acknowledged_by_User' (4)
      2015-02-27 09:47:38.142 -0500    OIV_02162015.fmp12    0      Recovering: field 'Additional_Description' (5)
      2015-02-27 09:47:38.142 -0500    OIV_02162015.fmp12    0      Recovering: field 'Aggregated_Count' (6)
      2015-02-27 09:47:38.142 -0500    OIV_02162015.fmp12    0      Recovering: field 'Alarm_ID' (7)
      2015-02-27 09:47:38.142 -0500    OIV_02162015.fmp12    0      Recovering: field 'Application_Name' (8)
      2015-02-27 09:47:38.142 -0500    OIV_02162015.fmp12    0      Recovering: field 'Brouha_browse_Issue_Path' (9)
      2015-02-27 09:47:38.142 -0500    OIV_02162015.fmp12    0      Recovering: field 'Brouha_Incident_ID' (10)
      2015-02-27 09:47:38.142 -0500    OIV_02162015.fmp12    0      Recovering: field 'Brouha_Incident_Status' (11)
      2015-02-27 09:47:38.157 -0500    OIV_02162015.fmp12    0      Recovering: field 'Created_At' (12)
      2015-02-27 09:47:38.157 -0500    OIV_02162015.fmp12    0      Recovering: field 'Description' (13)
      2015-02-27 09:47:38.157 -0500    OIV_02162015.fmp12    0      Recovering: field 'HostImpacted' (14)
      2015-02-27 09:47:38.157 -0500    OIV_02162015.fmp12    0      Recovering: field 'Service_Impacted' (16)
      2015-02-27 09:47:38.157 -0500    OIV_02162015.fmp12    0      Recovering: field 'Subject' (17)
      2015-02-27 09:47:38.157 -0500    OIV_02162015.fmp12    0      Recovering: field 'Acknowledged_At' (18)
      2015-02-27 09:47:38.157 -0500    OIV_02162015.fmp12    0      Recovering: field 'Event_Hash' (19)
      2015-02-27 09:47:38.157 -0500    OIV_02162015.fmp12    0      Recovering: field 'Event_Status' (20)
      2015-02-27 09:47:38.157 -0500    OIV_02162015.fmp12    0      Recovering: field 'First_Event_initiatedAt' (21)
      2015-02-27 09:47:38.157 -0500    OIV_02162015.fmp12    0      Recovering: field 'Host_IP_Address' (22)
      2015-02-27 09:47:38.157 -0500    OIV_02162015.fmp12    0      Recovering: field 'Incident_Status' (23)
      2015-02-27 09:47:38.157 -0500    OIV_02162015.fmp12    0      Recovering: field 'Incident_Ticket_ID' (24)
      2015-02-27 09:47:38.157 -0500    OIV_02162015.fmp12    0      Recovering: field 'Incident_Ticket_Sor' (25)
      2015-02-27 09:47:38.173 -0500    OIV_02162015.fmp12    0      Recovering: field 'Initiated_At' (26)
      2015-02-27 09:47:38.173 -0500    OIV_02162015.fmp12    0      Recovering: field 'ITRC_Applicaiton_ID' (27)
      2015-02-27 09:47:38.173 -0500    OIV_02162015.fmp12    0      Recovering: field 'JIRA_Browse_Issue_Path' (31)
      2015-02-27 09:47:38.173 -0500    OIV_02162015.fmp12    0      Recovering: field 'JIRA_Incident_ID' (32)
      2015-02-27 09:47:38.173 -0500    OIV_02162015.fmp12    0      Recovering: field 'JIRA_Incident_Instance' (33)
      2015-02-27 09:47:38.173 -0500    OIV_02162015.fmp12    0      Recovering: field 'JIRA_Incident_Status' (34)
      2015-02-27 09:47:38.173 -0500    OIV_02162015.fmp12    0      Recovering: field 'Recevied_By_OIV_At' (35)
      2015-02-27 09:47:38.189 -0500    OIV_02162015.fmp12    0      Recovering: field 'Service_Desk' (36)
      2015-02-27 09:47:38.189 -0500    OIV_02162015.fmp12    0      Recovering: field 'Snoozed' (37)
      2015-02-27 09:47:38.189 -0500    OIV_02162015.fmp12    0      Recovering: field 'Snoozed_At' (38)
      2015-02-27 09:47:38.189 -0500    OIV_02162015.fmp12    0      Recovering: field 'Snoozed_By' (39)
      2015-02-27 09:47:38.189 -0500    OIV_02162015.fmp12    0      Recovering: field 'Snoozed_By_User' (40)
      2015-02-27 09:47:38.204 -0500    OIV_02162015.fmp12    0      Recovering: field 'Snoozed_Comment' (41)
      2015-02-27 09:47:38.204 -0500    OIV_02162015.fmp12    0      Recovering: field 'Snoozed_For' (42)
      2015-02-27 09:47:38.204 -0500    OIV_02162015.fmp12    0      Recovering: field 'Sub_type' (43)
      2015-02-27 09:47:38.204 -0500    OIV_02162015.fmp12    0      Recovering: field 'Threshold_Value' (44)
      2015-02-27 09:47:38.220 -0500    OIV_02162015.fmp12    0      Recovering: field 'Ticketed_At' (45)
      2015-02-27 09:47:38.220 -0500    OIV_02162015.fmp12    0      Recovering: field 'Ticket_By' (46)
      2015-02-27 09:47:38.220 -0500    OIV_02162015.fmp12    0      Recovering: field 'Ticket_By_User' (47)
      2015-02-27 09:47:38.220 -0500    OIV_02162015.fmp12    0      Recovering: field 'UPdated_At' (48)
      2015-02-27 09:47:38.220 -0500    OIV_02162015.fmp12    0      Recovering: field 'ID' (49)
      2015-02-27 09:47:38.235 -0500    OIV_02162015.fmp12    0      Recovering: field 'Acknowledged_BY' (50)
      2015-02-27 09:47:38.235 -0500    OIV_02162015.fmp12    0      Recovering: field '_gr_Ticket_By Count' (51)
      2015-02-27 09:47:38.235 -0500    OIV_02162015.fmp12    0      Recovering: field 'SOP' (52)
      2015-02-27 09:47:38.235 -0500    OIV_02162015.fmp12    0      Recovering: field '_c_CountIDs' (53)
      2015-02-27 09:47:38.235 -0500    OIV_02162015.fmp12    0      Recovering: field '_g_GlobalValue' (55)
      2015-02-27 09:47:38.251 -0500    OIV_02162015.fmp12    0      Recovering: field '_c_Date' (56)
      2015-02-27 09:47:38.251 -0500    OIV_02162015.fmp12    0      Recovering: field '_gr_Application_Name Count' (58)
      2015-02-27 09:47:38.251 -0500    OIV_02162015.fmp12    0      Recovering: field '_c_MonthName' (60)
      2015-02-27 09:47:38.251 -0500    OIV_02162015.fmp12    0      Recovering: field '_c_Application Group' (62)
      2015-02-27 09:47:38.251 -0500    OIV_02162015.fmp12    0      Recovering: field '_nc_FoundCount_Global' (63)
      2015-02-27 09:47:38.267 -0500    OIV_02162015.fmp12    0      Recovering: field '_nc_RecordNumber' (64)
      2015-02-27 09:47:38.267 -0500    OIV_02162015.fmp12    0      Recovering: field '_nc_FoundCount_Unstored' (66)
      2015-02-27 09:47:38.267 -0500    OIV_02162015.fmp12    0      Recovering: field '_nc_RecordNumbering' (67)
      2015-02-27 09:47:38.267 -0500    OIV_02162015.fmp12    0      Recovering: field '_c_AckBy' (68)
      2015-02-27 09:47:38.267 -0500    OIV_02162015.fmp12    0      Recovering: field '_c_ShiftName' (71)
      2015-02-27 09:47:38.267 -0500    OIV_02162015.fmp12    0      Recovering: field '_c_SOP' (85)
      2015-02-27 09:47:38.267 -0500    OIV_02162015.fmp12    0    Recovering fields for table 'PSC_SOP'
      2015-02-27 09:47:38.282 -0500    OIV_02162015.fmp12    0    Recovering: field catalog 'PSC_SOP'
      2015-02-27 09:47:38.282 -0500    OIV_02162015.fmp12    0      Rebuilding field catalog 'PSC_SOP' order list: name 
      2015-02-27 09:47:38.282 -0500    OIV_02162015.fmp12    0      Rebuilding field catalog 'PSC_SOP' order list: custom 
      2015-02-27 09:47:38.282 -0500    OIV_02162015.fmp12    0      Rebuilding field catalog 'PSC_SOP' order list: type 
      2015-02-27 09:47:38.282 -0500    OIV_02162015.fmp12    0      Recovering data for table 'PSC_SOP'
      2015-02-27 09:47:38.563 -0500    OIV_02162015.fmp12    0      Evaluating library (135)
      2015-02-27 09:47:38.563 -0500    OIV_02162015.fmp12    0      Recovering: field 'added_at' (1)
      2015-02-27 09:47:38.563 -0500    OIV_02162015.fmp12    0      Recovering: field 'alarm_type' (2)
      2015-02-27 09:47:38.563 -0500    OIV_02162015.fmp12    0      Recovering: field 'application_name' (3)
      2015-02-27 09:47:38.563 -0500    OIV_02162015.fmp12    0      Recovering: field 'component' (4)
      2015-02-27 09:47:38.563 -0500    OIV_02162015.fmp12    0      Recovering: field 'description' (5)
      2015-02-27 09:47:38.563 -0500    OIV_02162015.fmp12    0      Recovering: field 'id' (6)
      2015-02-27 09:47:38.563 -0500    OIV_02162015.fmp12    0      Recovering: field 'impact_level' (7)
      2015-02-27 09:47:38.563 -0500    OIV_02162015.fmp12    0      Recovering: field 'impacted_business_process' (8)
      2015-02-27 09:47:38.579 -0500    OIV_02162015.fmp12    0      Recovering: field 'is_active' (9)
      2015-02-27 09:47:38.579 -0500    OIV_02162015.fmp12    0      Recovering: field 'itrc_application_id' (10)
      2015-02-27 09:47:38.579 -0500    OIV_02162015.fmp12    0      Recovering: field 'last_reviewed_at' (11)
      2015-02-27 09:47:38.579 -0500    OIV_02162015.fmp12    0      Recovering: field 'lower_threshold' (12)
      2015-02-27 09:47:38.579 -0500    OIV_02162015.fmp12    0      Recovering: field 'name' (13)
      2015-02-27 09:47:38.579 -0500    OIV_02162015.fmp12    0      Recovering: field 'originating_system' (14)
      2015-02-27 09:47:38.579 -0500    OIV_02162015.fmp12    0      Recovering: field 'primary_owner' (15)
      2015-02-27 09:47:38.579 -0500    OIV_02162015.fmp12    0      Recovering: field 'secondary_owner' (16)
      2015-02-27 09:47:38.579 -0500    OIV_02162015.fmp12    0      Recovering: field 'service_desk' (17)
      2015-02-27 09:47:38.579 -0500    OIV_02162015.fmp12    0      Recovering: field 'sop' (18)
      2015-02-27 09:47:38.594 -0500    OIV_02162015.fmp12    0      Recovering: field 'upper_threshold' (19)
      2015-02-27 09:47:38.594 -0500    OIV_02162015.fmp12    0      Recovering: field '_SOP_ID' (20)
      2015-02-27 09:47:38.594 -0500    OIV_02162015.fmp12    0      Recovering: field '_c_application_name' (21)
      2015-02-27 09:47:38.594 -0500    OIV_02162015.fmp12    0      Recovering: field '_c_Count_Alarms' (22)
      2015-02-27 09:47:38.594 -0500    OIV_02162015.fmp12    0      Recovering: field '_c_CountAlarmsOIV' (23)
      2015-02-27 09:47:38.594 -0500    OIV_02162015.fmp12    0    Recovering fields for table 'GlobalSearchFields'
      2015-02-27 09:47:38.610 -0500    OIV_02162015.fmp12    0    Recovering: field catalog 'GlobalSearchFields'
      2015-02-27 09:47:38.610 -0500    OIV_02162015.fmp12    0      Rebuilding field catalog 'GlobalSearchFields' order list: name 
      2015-02-27 09:47:38.610 -0500    OIV_02162015.fmp12    0      Rebuilding field catalog 'GlobalSearchFields' order list: custom 
      2015-02-27 09:47:38.610 -0500    OIV_02162015.fmp12    0      Rebuilding field catalog 'GlobalSearchFields' order list: type 
      2015-02-27 09:47:38.610 -0500    OIV_02162015.fmp12    0      Recovering: field 'g_SOP_AppNameSearchButton' (1)
      2015-02-27 09:47:38.625 -0500    OIV_02162015.fmp12    0      Recovering: field 'g_SubjectNameSearch' (2)
      2015-02-27 09:47:38.625 -0500    OIV_02162015.fmp12    0      Recovering: field 'g_ApplicaitonNameSearch' (3)
      2015-02-27 09:47:38.625 -0500    OIV_02162015.fmp12    0      Recovering: field 'g_UserName' (4)
      2015-02-27 09:47:38.625 -0500    OIV_02162015.fmp12    0      Recovering: field 'g_BrouhaID' (5)
      2015-02-27 09:47:38.625 -0500    OIV_02162015.fmp12    0      Recovering: field 'g_ImpactedHost' (7)
      2015-02-27 09:47:38.641 -0500    OIV_02162015.fmp12    0      Recovering: field 'g_Weblink' (8)
      2015-02-27 09:47:38.641 -0500    OIV_02162015.fmp12    0      Recovering: field 'g_BrouhaStatus' (9)
      2015-02-27 09:47:38.641 -0500    OIV_02162015.fmp12    0      Recovering: field 'g_Date1' (10)
      2015-02-27 09:47:38.641 -0500    OIV_02162015.fmp12    0      Recovering: field 'g_Date2' (11)
      2015-02-27 09:47:38.641 -0500    OIV_02162015.fmp12    0      Recovering: field 'UTC' (12)
      2015-02-27 09:47:38.657 -0500    OIV_02162015.fmp12    0      Recovering: field 'g_Application_Group' (13)
      2015-02-27 09:47:38.657 -0500    OIV_02162015.fmp12    0      Recovering: field 'g_CurrentBrouha' (14)
      2015-02-27 09:47:38.657 -0500    OIV_02162015.fmp12    0      Recovering: field 'g_CurrentJIRA' (15)
      2015-02-27 09:47:38.657 -0500    OIV_02162015.fmp12    0      Recovering: field 'g_CurrentAlert' (16)
      2015-02-27 09:47:38.657 -0500    OIV_02162015.fmp12    0      Recovering: field 'g_CurrentSI' (17)
      2015-02-27 09:47:38.672 -0500    OIV_02162015.fmp12    0      Recovering: field 'g_Email' (18)
      2015-02-27 09:47:38.672 -0500    OIV_02162015.fmp12    0      Recovering: field 'g_Hello' (19)
      2015-02-27 09:47:38.672 -0500    OIV_02162015.fmp12    0    Recovering fields for table 'Global_Screen1'
      2015-02-27 09:47:38.672 -0500    OIV_02162015.fmp12    0    Recovering: field catalog 'Global_Screen1'
      2015-02-27 09:47:38.672 -0500    OIV_02162015.fmp12    0      Rebuilding field catalog 'Global_Screen1' order list: name 
      2015-02-27 09:47:38.672 -0500    OIV_02162015.fmp12    0      Rebuilding field catalog 'Global_Screen1' order list: custom 
      2015-02-27 09:47:38.688 -0500    OIV_02162015.fmp12    0      Rebuilding field catalog 'Global_Screen1' order list: type 
      2015-02-27 09:47:38.688 -0500    OIV_02162015.fmp12    0      Recovering data for table 'Global_Screen1'
      2015-02-27 09:47:38.688 -0500    OIV_02162015.fmp12    0      Evaluating library (139)
      2015-02-27 09:47:38.688 -0500    OIV_02162015.fmp12    0      Recovering: field 'g_screen1' (1)
      2015-02-27 09:47:38.688 -0500    OIV_02162015.fmp12    0    Recovering fields for table 'RaconServer'
      2015-02-27 09:47:38.688 -0500    OIV_02162015.fmp12    0    Recovering: field catalog 'RaconServer'
      2015-02-27 09:47:38.688 -0500    OIV_02162015.fmp12    0      Rebuilding field catalog 'RaconServer' order list: name 
      2015-02-27 09:47:38.703 -0500    OIV_02162015.fmp12    0      Rebuilding field catalog 'RaconServer' order list: custom 
      2015-02-27 09:47:38.703 -0500    OIV_02162015.fmp12    0      Rebuilding field catalog 'RaconServer' order list: type 
      2015-02-27 09:47:38.703 -0500    OIV_02162015.fmp12    0      Recovering data for table 'RaconServer'
      2015-02-27 09:47:38.703 -0500    OIV_02162015.fmp12    0      Evaluating library (145)
      2015-02-27 09:47:38.703 -0500    OIV_02162015.fmp12    0      Recovering: field '_RaconID' (1)
      2015-02-27 09:47:38.703 -0500    OIV_02162015.fmp12    0      Recovering: field 'Racon Name' (2)
      2015-02-27 09:47:38.703 -0500    OIV_02162015.fmp12    0      Recovering: field 'RaconLink' (3)
      2015-02-27 09:47:38.719 -0500    OIV_02162015.fmp12    0      Recovering: field 'g_GlobalValue' (5)
      2015-02-27 09:47:38.719 -0500    OIV_02162015.fmp12    0      Recovering: field 'VariableLink' (6)
      2015-02-27 09:47:38.719 -0500    OIV_02162015.fmp12    0      Recovering: field 'RaconNAmeDisplay' (7)
      2015-02-27 09:47:38.719 -0500    OIV_02162015.fmp12    0    Recovering fields for table 'CNOCPE_Users'
      2015-02-27 09:47:38.719 -0500    OIV_02162015.fmp12    0    Recovering: field catalog 'CNOCPE_Users'
      2015-02-27 09:47:38.719 -0500    OIV_02162015.fmp12    0      Rebuilding field catalog 'CNOCPE_Users' order list: name 
      2015-02-27 09:47:38.735 -0500    OIV_02162015.fmp12    0      Rebuilding field catalog 'CNOCPE_Users' order list: custom 
      2015-02-27 09:47:38.735 -0500    OIV_02162015.fmp12    0      Rebuilding field catalog 'CNOCPE_Users' order list: type 
      2015-02-27 09:47:38.735 -0500    OIV_02162015.fmp12    0      Recovering data for table 'CNOCPE_Users'
      2015-02-27 09:47:38.735 -0500    OIV_02162015.fmp12    0      Evaluating library (146)
      2015-02-27 09:47:38.735 -0500    OIV_02162015.fmp12    0      Recovering: field '_UserID' (1)
      2015-02-27 09:47:38.735 -0500    OIV_02162015.fmp12    0      Recovering: field 'FirstName' (3)
      2015-02-27 09:47:38.735 -0500    OIV_02162015.fmp12    0      Recovering: field 'LastName' (4)
      2015-02-27 09:47:38.750 -0500    OIV_02162015.fmp12    0      Recovering: field 'UserName' (5)
      2015-02-27 09:47:38.750 -0500    OIV_02162015.fmp12    0      Recovering: field 'FullName' (6)
      2015-02-27 09:47:38.750 -0500    OIV_02162015.fmp12    0      Recovering: field 'NOtes' (7)
      2015-02-27 09:47:38.750 -0500    OIV_02162015.fmp12    0      Recovering: field 'NTName' (8)
      2015-02-27 09:47:38.750 -0500    OIV_02162015.fmp12    0      Recovering: field 'Shift' (9)
      2015-02-27 09:47:38.766 -0500    OIV_02162015.fmp12    0    Recovering fields for table 'ApplicationGroup'
      2015-02-27 09:47:38.766 -0500    OIV_02162015.fmp12    0    Recovering: field catalog 'ApplicationGroup'
      2015-02-27 09:47:38.766 -0500    OIV_02162015.fmp12    0      Rebuilding field catalog 'ApplicationGroup' order list: name 
      2015-02-27 09:47:38.766 -0500    OIV_02162015.fmp12    0      Rebuilding field catalog 'ApplicationGroup' order list: custom 
      2015-02-27 09:47:38.781 -0500    OIV_02162015.fmp12    0      Rebuilding field catalog 'ApplicationGroup' order list: type 
      2015-02-27 09:47:38.781 -0500    OIV_02162015.fmp12    0      Recovering data for table 'ApplicationGroup'
      2015-02-27 09:47:38.781 -0500    OIV_02162015.fmp12    0      Evaluating library (147)
      2015-02-27 09:47:38.797 -0500    OIV_02162015.fmp12    0      Recovering: field 'application_group' (1)
      2015-02-27 09:47:38.797 -0500    OIV_02162015.fmp12    0      Recovering: field 'created_at' (2)
      2015-02-27 09:47:38.797 -0500    OIV_02162015.fmp12    0      Recovering: field 'description' (3)
      2015-02-27 09:47:38.797 -0500    OIV_02162015.fmp12    0      Recovering: field 'id' (4)
      2015-02-27 09:47:38.797 -0500    OIV_02162015.fmp12    0      Recovering: field 'itrc_id' (5)
      2015-02-27 09:47:38.813 -0500    OIV_02162015.fmp12    0      Recovering: field 'name' (6)
      2015-02-27 09:47:38.813 -0500    OIV_02162015.fmp12    0      Recovering: field 'updated_at' (7)
      2015-02-27 09:47:38.813 -0500    OIV_02162015.fmp12    0      Recovering: field 'ServiceDesk' (8)
      2015-02-27 09:47:38.813 -0500    OIV_02162015.fmp12    0      Recovering: field '_AppID' (9)
      2015-02-27 09:47:38.813 -0500    OIV_02162015.fmp12    0      Recovering: field 'application_group Count' (10)
      2015-02-27 09:47:38.828 -0500    OIV_02162015.fmp12    0    Recovering fields for table 'Months'
      2015-02-27 09:47:38.828 -0500    OIV_02162015.fmp12    0    Recovering: field catalog 'Months'
      2015-02-27 09:47:38.828 -0500    OIV_02162015.fmp12    0      Rebuilding field catalog 'Months' order list: name 
      2015-02-27 09:47:38.828 -0500    OIV_02162015.fmp12    0      Rebuilding field catalog 'Months' order list: custom 
      2015-02-27 09:47:38.844 -0500    OIV_02162015.fmp12    0      Rebuilding field catalog 'Months' order list: type 
      2015-02-27 09:47:38.844 -0500    OIV_02162015.fmp12    0      Recovering data for table 'Months'
      2015-02-27 09:47:38.844 -0500    OIV_02162015.fmp12    0      Evaluating library (155)
      2015-02-27 09:47:38.844 -0500    OIV_02162015.fmp12    0      Recovering: field '_id' (1)
      2015-02-27 09:47:38.844 -0500    OIV_02162015.fmp12    0      Recovering: field 'MonthNumber' (2)
      2015-02-27 09:47:38.859 -0500    OIV_02162015.fmp12    0      Recovering: field 'DateEnd' (3)
      2015-02-27 09:47:38.859 -0500    OIV_02162015.fmp12    0      Recovering: field 'DateEndPrevYr' (4)
      2015-02-27 09:47:38.859 -0500    OIV_02162015.fmp12    0      Recovering: field 'MonthAbbr' (5)
      2015-02-27 09:47:38.859 -0500    OIV_02162015.fmp12    0      Recovering: field 'Quarter' (7)
      2015-02-27 09:47:38.859 -0500    OIV_02162015.fmp12    0      Recovering: field 'DateStart' (8)
      2015-02-27 09:47:38.859 -0500    OIV_02162015.fmp12    0      Recovering: field 'DateStartPrevYr' (9)
      2015-02-27 09:47:38.859 -0500    OIV_02162015.fmp12    0      Recovering: field '_c_CountAllRecords' (11)
      2015-02-27 09:47:38.859 -0500    OIV_02162015.fmp12    0      Recovering: field 'Shift' (13)
      2015-02-27 09:47:38.875 -0500    OIV_02162015.fmp12    0    Recovering fields for table 'DashBoard'
      2015-02-27 09:47:38.875 -0500    OIV_02162015.fmp12    0    Recovering: field catalog 'DashBoard'
      2015-02-27 09:47:38.875 -0500    OIV_02162015.fmp12    0      Rebuilding field catalog 'DashBoard' order list: name 
      2015-02-27 09:47:38.875 -0500    OIV_02162015.fmp12    0      Rebuilding field catalog 'DashBoard' order list: custom 
      2015-02-27 09:47:38.875 -0500    OIV_02162015.fmp12    0      Rebuilding field catalog 'DashBoard' order list: type 
      2015-02-27 09:47:38.875 -0500    OIV_02162015.fmp12    0      Recovering data for table 'DashBoard'
      2015-02-27 09:47:38.875 -0500    OIV_02162015.fmp12    0      Evaluating library (156)
      2015-02-27 09:47:38.891 -0500    OIV_02162015.fmp12    0      Recovering: field 'g_CurrentDate' (2)
      2015-02-27 09:47:38.891 -0500    OIV_02162015.fmp12    0      Recovering: field 'g_DateEnd' (3)
      2015-02-27 09:47:38.891 -0500    OIV_02162015.fmp12    0      Recovering: field 'g_DateEndPrevYr' (4)
      2015-02-27 09:47:38.891 -0500    OIV_02162015.fmp12    0      Recovering: field 'g_DateStart' (5)
      2015-02-27 09:47:38.891 -0500    OIV_02162015.fmp12    0      Recovering: field 'g_DateStartPrevYr' (6)
      2015-02-27 09:47:38.891 -0500    OIV_02162015.fmp12    0      Recovering: field 'c_Year' (7)
      2015-02-27 09:47:38.891 -0500    OIV_02162015.fmp12    0      Recovering: field 'c_YearPrevious' (8)
      2015-02-27 09:47:38.891 -0500    OIV_02162015.fmp12    0      Recovering: field 'Quarter1st' (9)
      2015-02-27 09:47:38.906 -0500    OIV_02162015.fmp12    0      Recovering: field 'Quarter2nd' (10)
      2015-02-27 09:47:38.906 -0500    OIV_02162015.fmp12    0      Recovering: field 'Quarter3rd' (11)
      2015-02-27 09:47:38.906 -0500    OIV_02162015.fmp12    0      Recovering: field 'Quarter4th' (12)
      2015-02-27 09:47:38.906 -0500    OIV_02162015.fmp12    0      Recovering: field '_c_Count1st' (15)
      2015-02-27 09:47:38.906 -0500    OIV_02162015.fmp12    0      Recovering: field '_c_Count2nd' (16)
      2015-02-27 09:47:38.906 -0500    OIV_02162015.fmp12    0      Recovering: field '_c_Count3rd' (17)
      2015-02-27 09:47:38.906 -0500    OIV_02162015.fmp12    0      Recovering: field '_c_Count4th' (18)
      2015-02-27 09:47:38.906 -0500    OIV_02162015.fmp12    0      Recovering: field 'currendate' (25)
      2015-02-27 09:47:38.922 -0500    OIV_02162015.fmp12    0      Recovering: field 'Shift' (26)
      2015-02-27 09:47:38.922 -0500    OIV_02162015.fmp12    0    Recovering fields for table 'FileMasker'
      2015-02-27 09:47:38.922 -0500    OIV_02162015.fmp12    0    Recovering: field catalog 'FileMasker'
      2015-02-27 09:47:38.922 -0500    OIV_02162015.fmp12    0      Rebuilding field catalog 'FileMasker' order list: name 
      2015-02-27 09:47:38.922 -0500    OIV_02162015.fmp12    0      Rebuilding field catalog 'FileMasker' order list: custom 
      2015-02-27 09:47:38.937 -0500    OIV_02162015.fmp12    0      Rebuilding field catalog 'FileMasker' order list: type 
      2015-02-27 09:47:38.937 -0500    OIV_02162015.fmp12    0      Recovering data for table 'FileMasker'
      2015-02-27 09:47:38.953 -0500    OIV_02162015.fmp12    0      Evaluating library (157)
      2015-02-27 09:47:38.953 -0500    OIV_02162015.fmp12    0      Recovering: field 'acknowledged_at' (1)
      2015-02-27 09:47:38.969 -0500    OIV_02162015.fmp12    0      Recovering: field 'acknowledged_by' (2)
      2015-02-27 09:47:38.969 -0500    OIV_02162015.fmp12    0      Recovering: field 'created_at' (3)
      2015-02-27 09:47:38.969 -0500    OIV_02162015.fmp12    0      Recovering: field 'service_desk' (4)
      2015-02-27 09:47:38.969 -0500    OIV_02162015.fmp12    0      Recovering: field 'initiated_at' (5)
      2015-02-27 09:47:38.969 -0500    OIV_02162015.fmp12    0      Recovering: field 'received_by_oiv_at' (6)
      2015-02-27 09:47:38.969 -0500    OIV_02162015.fmp12    0    Recovering fields for table 'FileMasker 2'
      2015-02-27 09:47:38.984 -0500    OIV_02162015.fmp12    0    Recovering: field catalog 'FileMasker 2'
      2015-02-27 09:47:38.984 -0500    OIV_02162015.fmp12    0      Rebuilding field catalog 'FileMasker 2' order list: name 
      2015-02-27 09:47:38.984 -0500    OIV_02162015.fmp12    0      Rebuilding field catalog 'FileMasker 2' order list: custom 
      2015-02-27 09:47:38.984 -0500    OIV_02162015.fmp12    0      Rebuilding field catalog 'FileMasker 2' order list: type 
      2015-02-27 09:47:38.984 -0500    OIV_02162015.fmp12    0      Recovering data for table 'FileMasker 2'
      2015-02-27 09:47:39.015 -0500    OIV_02162015.fmp12    0      Evaluating library (158)
      2015-02-27 09:47:39.015 -0500    OIV_02162015.fmp12    0      Recovering: field 'acknowledged_at' (1)
      2015-02-27 09:47:39.015 -0500    OIV_02162015.fmp12    0      Recovering: field 'acknowledged_by' (2)
      2015-02-27 09:47:39.015 -0500    OIV_02162015.fmp12    0      Recovering: field 'created_at' (3)
      2015-02-27 09:47:39.047 -0500    OIV_02162015.fmp12    0      Recovering: field 'initiated_at' (4)
      2015-02-27 09:47:39.047 -0500    OIV_02162015.fmp12    0      Recovering: field 'received_by_oiv_at' (5)
      2015-02-27 09:47:39.047 -0500    OIV_02162015.fmp12    0      Recovering: field 'service_desk' (6)
      2015-02-27 09:47:39.047 -0500    OIV_02162015.fmp12    0      Recovering: field 'brouha_browse_issue_path' (7)
      2015-02-27 09:47:39.047 -0500    OIV_02162015.fmp12    0    Recovering fields for table 'Test'
      2015-02-27 09:47:39.062 -0500    OIV_02162015.fmp12    0    Recovering: field catalog 'Test'
      2015-02-27 09:47:39.062 -0500    OIV_02162015.fmp12    0      Rebuilding field catalog 'Test' order list: name 
      2015-02-27 09:47:39.062 -0500    OIV_02162015.fmp12    0      Rebuilding field catalog 'Test' order list: custom 
      2015-02-27 09:47:39.062 -0500    OIV_02162015.fmp12    0      Rebuilding field catalog 'Test' order list: type 
      2015-02-27 09:47:39.062 -0500    OIV_02162015.fmp12    0      Recovering data for table 'Test'
      2015-02-27 09:47:39.078 -0500    OIV_02162015.fmp12    0      Evaluating library (159)
      2015-02-27 09:47:39.078 -0500    OIV_02162015.fmp12    0      Recovering: field 'g' (1)
      2015-02-27 09:47:39.078 -0500    OIV_02162015.fmp12    0      Recovering: field 'a' (2)
      2015-02-27 09:47:39.078 -0500    OIV_02162015.fmp12    0      Recovering: field 'b' (3)
      2015-02-27 09:47:39.093 -0500    OIV_02162015.fmp12    0      Recovering: field 'c' (4)
      2015-02-27 09:47:39.093 -0500    OIV_02162015.fmp12    0      Recovering: field 'd' (5)
      2015-02-27 09:47:39.093 -0500    OIV_02162015.fmp12    0      Recovering: field 'e' (6)
      2015-02-27 09:47:39.093 -0500    OIV_02162015.fmp12    0      Recovering: field 'f' (7)
      2015-02-27 09:47:39.093 -0500    OIV_02162015.fmp12    0      Recovering: field 'NEwTime' (8)
      2015-02-27 09:47:39.093 -0500    OIV_02162015.fmp12    0    Recovering fields for table 'ShiftTotal'
      2015-02-27 09:47:39.093 -0500    OIV_02162015.fmp12    0    Recovering: field catalog 'ShiftTotal'
      2015-02-27 09:47:39.093 -0500    OIV_02162015.fmp12    0      Rebuilding field catalog 'ShiftTotal' order list: name 
      2015-02-27 09:47:39.093 -0500    OIV_02162015.fmp12    0      Rebuilding field catalog 'ShiftTotal' order list: custom 
      2015-02-27 09:47:39.109 -0500    OIV_02162015.fmp12    0      Rebuilding field catalog 'ShiftTotal' order list: type 
      2015-02-27 09:47:39.109 -0500    OIV_02162015.fmp12    0      Recovering data for table 'ShiftTotal'
      2015-02-27 09:47:39.109 -0500    OIV_02162015.fmp12    0      Evaluating library (160)
      2015-02-27 09:47:39.109 -0500    OIV_02162015.fmp12    0      Recovering: field 'Shift' (2)
      2015-02-27 09:47:39.109 -0500    OIV_02162015.fmp12    0      Recovering: field '_c_CountID' (3)
      2015-02-27 09:47:39.140 -0500    OIV_02162015.fmp12    0    Recovering indexes for table 'OIV_Alrm_Data'
      2015-02-27 09:47:42.744 -0500    OIV_02162015.fmp12    0      Rebuilt value index for field '_OIV_ID'; 207578 item(s) now exist, difference from old index is 0
      2015-02-27 09:47:45.724 -0500    OIV_02162015.fmp12    0      Rebuilt value index for field 'Acknowledged_by_User'; 29 item(s) now exist, difference from old index is 0
      2015-02-27 09:47:45.739 -0500    OIV_02162015.fmp12    0      Rebuilt word index for field 'Acknowledged_by_User'; 27 item(s) now exist, difference from old index is 0
      2015-02-27 09:47:49.548 -0500    OIV_02162015.fmp12    0      Rebuilt value index for field 'Alarm_ID'; 9623 item(s) now exist, difference from old index is 0
      2015-02-27 09:47:57.628 -0500    OIV_02162015.fmp12    0      Rebuilt value index for field 'Application_Name'; 174 item(s) now exist, difference from old index is 0
      2015-02-27 09:47:57.628 -0500    OIV_02162015.fmp12    0      Rebuilt word index for field 'Application_Name'; 274 item(s) now exist, difference from old index is 0
      2015-02-27 09:48:02.792 -0500    OIV_02162015.fmp12    0      Rebuilt value index for field 'Brouha_Incident_ID'; 28833 item(s) now exist, difference from old index is 0
      2015-02-27 09:48:02.792 -0500    OIV_02162015.fmp12    0      Rebuilt word index for field 'Brouha_Incident_ID'; 26619 item(s) now exist, difference from old index is 0
      2015-02-27 09:48:06.942 -0500    OIV_02162015.fmp12    0      Rebuilt value index for field 'Brouha_Incident_Status'; 10 item(s) now exist, difference from old index is 0
      2015-02-27 09:48:06.957 -0500    OIV_02162015.fmp12    0      Rebuilt word index for field 'Brouha_Incident_Status'; 15 item(s) now exist, difference from old index is 0
      2015-02-27 09:48:11.200 -0500    OIV_02162015.fmp12    0      Rebuilt value index for field 'Created_At'; 207285 item(s) now exist, difference from old index is 0
      2015-02-27 09:49:08.344 -0500    OIV_02162015.fmp12    0      Rebuilt value index for field 'Description'; 42675 item(s) now exist, difference from old index is 0
      2015-02-27 09:49:08.344 -0500    OIV_02162015.fmp12    0      Rebuilt word index for field 'Description'; 71317 item(s) now exist, difference from old index is 0
      2015-02-27 09:49:23.337 -0500    OIV_02162015.fmp12    0      Rebuilt value index for field 'HostImpacted'; 6624 item(s) now exist, difference from old index is 0
      2015-02-27 09:49:23.337 -0500    OIV_02162015.fmp12    0     &nbsp

      rebuild.PNG

        • 1. Re: Trying to recover a Database
          TracyBogans

          same when opening the recovered file that filemaker made

          • 2. Re: Trying to recover a Database
            philmodjunk

            I'm a bit puzzled by the calculation you posted. IT does not have correct syntax. Is this a direct copy/paste of your calculation or might it have some typos?

            If you remove the global field, does the file still "hang"?

            Things to keep in mind about Recover:

            While Recover almost always detects and fully corrects any problems with your file...

                   
            1. The recovered copy may behave differently even if recover reports "no problems found".
            2.      
            3. Recover does not detect all problems
            4.      
            5. Recover doesn't always fix all problems correctly
            6.      
            7. Best Practice is to never put a recovered copy back into regular use or development. Instead, replace the damaged file with an undamaged back up copy if this is at all possible. You may have to save a clone of the back up copy and import all data from your recovered copy to get a working copy with the most up to date information possible.

             

            And here's a knowledgebase article that you may find useful: What to do when your file is corrupt (KB5421).

            • 3. Re: Trying to recover a Database
              TracyBogans

              The Calculation I posted before  had a typos... just want to give you an Idea of the last thing that was done.  The recovered copy will not open.. it hangs like the orginal file.. not sure, is there anything else I can try. cant complete the KB5421 ... because I can not even get the database to open

              • 4. Re: Trying to recover a Database
                philmodjunk

                And you do not have a back up copy of the file? (this is why one should always make and keep lots of back up copies...)

                Do you have FileMaker ADvanced?

                It's a bit of a long shot, but if the "hang" is due to other issues like a looping script, you can launch FileMaker Advanced without opening this file, open the script debugger and then try to open the file. If a script is the culprit, the script pops up in the debugger and you can use the debugger to halt or even edit the script in order to fix the problem.

                If it's a script and you don't have Advanced, you might be able to interrupt such a script by pressing Esc (Windows) or Command-Period (macs). This doesn't always work as the script might be set up to prevent user aborts of this type.

                • 5. Re: Trying to recover a Database
                  schamblee

                  I have seen something similar from another user that posted, several months ago.  I don't remember all the details about the file, but the file would open in fmp12 and would freeze in fmp13.   I don't know if the user got it resolved.  I'm sure it was some kind of corruption that  caused the file to hang.  I assumed it was something added new in 13 because it would run in 12.   I will see if I can find the old post.