search

iMMAP / OASISClientV4

1 stars 3 forks source link

Synch Engine - Subscript out of range [4.1.26] #41

Closed ppolphong closed 10 years ago

ppolphong commented 10 years ago

Once I keep OASIS running for synchronization, it will keep working until this errors show up

OpenServerResponseCompressed_Err: (108) The connection with the server was terminated abnormally

and it will keep displaying Subscript out of range error. I will have to restart OASIS again to continue synchronization processes

More Details here

[2:38:15 PM] _??Beginning schema scan of DD [ddFOCUSTrainingCERT] ...................... [2:38:16 PM] >>> Getting remote tables ...................... [2:38:25 PM] >>> Getting local tables ...................... [2:38:25 PM] >>> Comparing tables ...................... [2:38:25 PM] _?? Verifying table [dd_FOCUSTrainingCERTComboRelations] for integrity..... [2:38:26 PM] *?? Verifying table [dd_FOCUSTrainingCERTddEstablishment] for integrity..... [2:38:26 PM] *?? Verifying table [dd_FOCUSTrainingCERTddOccupation] for integrity..... [2:38:26 PM] *?? Verifying table [dd_FOCUSTrainingCERTddRole] for integrity..... [2:38:26 PM] *?? Verifying table [dd_FOCUSTrainingCERTlinkParticipant] for integrity..... [2:38:26 PM] *?? Verifying table [dd_FOCUSTrainingCERTmastertable] for integrity..... [2:38:26 PM] *?? Verifying table [dd_FOCUSTrainingCERTQueries] for integrity..... [2:38:26 PM] *?? Verifying table [dd_FOCUSTrainingCERT_Specification] for integrity..... [2:38:26 PM] <<< Finished schema scan of DD [ddFOCUSTrainingCERT] ...................... [2:38:26 PM] _??######################################################################################### [2:38:26 PM] _?? Beginning data sync for dynamic database: FOCUSTrainingCERT ...................... [2:38:29 PM] ### Matching server records for: dd_FOCUSTrainingCERTSynchHistory [2:38:30 PM] *?? Ending sync for dynamic database: ddFOCUSTrainingCERT ...................... [2:38:30 PM] *??######################################################################################### [2:38:30 PM] Connecting to connection string: Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Users\OASIS\Documents\iMMAP - OASIS\OASIS client\data\db\dynamicdata\FOCUS.MDB;Mode=ReadWrite|Share Deny None;Persist Security Info=False; [2:38:30 PM] >>>>>>>>>>>> [2:38:31 PM] _??Beginning schema scan of DD [ddFOCUSTrainingClusterCERT] ...................... [2:38:31 PM] >>> Getting remote tables ...................... [2:38:39 PM] >>> Getting local tables ...................... [2:38:39 PM] >>> Comparing tables ...................... [2:38:39 PM] _?? Verifying table [dd_FOCUSTrainingClusterCERTComboRelations] for integrity..... [2:38:39 PM] *?? Verifying table [dd_FOCUSTrainingClusterCERTddEstablishment] for integrity..... [2:38:39 PM] *?? Verifying table [dd_FOCUSTrainingClusterCERTddOccupation] for integrity..... [2:38:39 PM] *?? Verifying table [dd_FOCUSTrainingClusterCERTddRole] for integrity..... [2:38:39 PM] *?? Verifying table [dd_FOCUSTrainingClusterCERTmastertable] for integrity..... [2:38:39 PM] *?? Verifying table [dd_FOCUSTrainingClusterCERTQueries] for integrity..... [2:38:39 PM] *?? Verifying table [dd_FOCUSTrainingClusterCERT_Specification] for integrity..... [2:38:39 PM] <<< Finished schema scan of DD [ddFOCUSTrainingClusterCERT] ...................... [2:38:40 PM] _??######################################################################################### [2:38:40 PM] _?? Beginning data sync for dynamic database: FOCUSTrainingClusterCERT ...................... [2:38:43 PM] ### Matching server records for: dd_FOCUSTrainingClusterCERTSynchHistory [2:38:43 PM] *?? Ending sync for dynamic database: ddFOCUSTrainingClusterCERT ...................... [2:38:44 PM] *??######################################################################################### [2:38:44 PM] Connecting to connection string: Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Users\OASIS\Documents\iMMAP - OASIS\OASIS client\data\db\dynamicdata\FOCUS.MDB;Mode=ReadWrite|Share Deny None;Persist Security Info=False; [2:38:44 PM] >>>>>>>>>>>> [2:38:44 PM] *_??Beginning schema scan of DD [ddFOCUSTrainingCODAN] ...................... [2:38:45 PM] >>> Getting remote tables ...................... [2:39:08 PM] OpenServerResponseCompressed_Err: (108) The connection with the server was terminated abnormally

[2:39:30 PM] OpenServerResponseCompressed_Err: (108) The operation timed out

[2:39:30 PM] SynchWorker.GetRemoteTables_Err on line (156) Operation is not allowed when the object is closed. [2:39:30 PM] >>> Getting local tables ...................... [2:39:31 PM] >>> Comparing tables ...................... [2:39:31 PM] SynchWorker.LocateIndexOfTable_Err on line (102) Subscript out of range [2:39:31 PM] SynchWorker.LocateIndexOfTable_Err on line (102) Subscript out of range [2:39:32 PM] SynchWorker.LocateIndexOfTable_Err on line (102) Subscript out of range [2:39:32 PM] SynchWorker.LocateIndexOfTable_Err on line (102) Subscript out of range [2:39:32 PM] SynchWorker.LocateIndexOfTable_Err on line (102) Subscript out of range [2:39:33 PM] SynchWorker.LocateIndexOfTable_Err on line (102) Subscript out of range [2:39:33 PM] SynchWorker.LocateIndexOfTable_Err on line (102) Subscript out of range [2:39:33 PM] SynchWorker.LocateIndexOfTable_Err on line (102) Subscript out of range [2:39:33 PM] SynchWorker.LocateIndexOfTable_Err on line (102) Subscript out of range [2:39:34 PM] SynchWorker.CompareTablesErr on line (128) Subscript out of range [2:39:34 PM] SynchWorker.RunDDSchemaCompare on line (136) Subscript out of range [2:39:34 PM] *??######################################################################################### [2:39:35 PM] *_?? Beginning data sync for dynamic database: FOCUSTrainingCODAN ...................... [2:39:56 PM] OpenServerResponseCompressed_Err: (108) The operation timed out

[2:39:58 PM] SynchWorker.CompareSynchHashesErr on line (112) Object variable or With block variable not set [2:39:59 PM] *?? Ending sync for dynamic database: ddFOCUSTrainingCODAN ...................... [2:39:59 PM] *??######################################################################################### [2:39:59 PM] Connecting to connection string: Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Users\OASIS\Documents\iMMAP - OASIS\OASIS client\data\db\dynamicdata\FOCUS.MDB;Mode=ReadWrite|Share Deny None;Persist Security Info=False; [2:40:00 PM] **??Beginning schema scan of DD [ddFOCUSTrainingHospital] ...................... [2:40:00 PM] >>> Getting remote tables ...................... [2:40:21 PM] OpenServerResponseCompressed_Err: (108) The operation timed out

[2:40:43 PM] OpenServerResponseCompressed_Err: (108) The operation timed out

[2:40:43 PM] SynchWorker.GetRemoteTables_Err on line (120) Operation is not allowed when the object is closed. [2:40:43 PM] >>> Getting local tables ...................... [2:40:44 PM] >>> Comparing tables ...................... [2:40:44 PM] SynchWorker.LocateIndexOfTable_Err on line (102) Subscript out of range [2:40:44 PM] SynchWorker.LocateIndexOfTable_Err on line (102) Subscript out of range [2:40:45 PM] SynchWorker.LocateIndexOfTable_Err on line (102) Subscript out of range [2:40:45 PM] SynchWorker.LocateIndexOfTable_Err on line (102) Subscript out of range [2:40:45 PM] SynchWorker.LocateIndexOfTable_Err on line (102) Subscript out of range [2:40:46 PM] SynchWorker.LocateIndexOfTable_Err on line (102) Subscript out of range [2:40:46 PM] SynchWorker.LocateIndexOfTable_Err on line (102) Subscript out of range [2:40:46 PM] SynchWorker.LocateIndexOfTable_Err on line (102) Subscript out of range [2:40:47 PM] SynchWorker.CompareTables_Err on line (128) Subscript out of range

KeithDoyle commented 10 years ago

Fixed