Archive Shuttle modules may log:

2018-07-12 05:37:17Z|8412|tvbazurecopy04| 51|ERROR| TransferImportResultsToCore|Error while transmitting items. Void Open(Boolean)
There is not enough memory on the device running SQL Server Compact to complete this operation.
at System.Data.SqlServerCe.SqlCeConnection.Open(Boolean silent)
at System.Data.SqlServerCe.SqlCeConnection.Open()
at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.Fill(DataTable[] dataTables, Int32 startRecord, Int32 maxRecords, IDbCommand command, CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.Fill(DataTable dataTable)
at ArchiveShuttle.Modules.Common.SQLCompact.SQLCompactBase.GetDataTable(String selectCommand, Dictionary`2 parameters)
at ArchiveShuttle.Module.NativeFormatImportModule.SQLCompact.SQLCENativeImport.<ReadRenameResultItems>d__2.MoveNext()
at System.Collections.Generic.List`1..ctor(IEnumerable`1 collection)
at System.Linq.Enumerable.ToList[TSource](IEnumerable`1 source)
at ArchiveShuttle.Module.NativeFormatImportModule.TransferOnline.TransferRenameResultsToCore(IModuleClient moduleClient)
at ArchiveShuttle.Module.NativeFormatImportModule.TransferOnline.TransferImportResultsToCore(IModuleClient moduleClient)

Archive Shuttle modules are using SQL CE database (.sdf) and the error above may be logged when:
1) The local SQL CE database is corrupted
2) Antivirus or other application is accessing/scanning it
3) It is on shared network folder
4) the database is in a folder that the application does not have sufficient privilege to access it

It could be resolved by:
1) Follow the steps below when the SQL CE database is corrupt:
a) Disable the Archive Shuttle module which is logging the issue
b) Wait until all items are sent to the Core (.sdf will have 192/128 kb and less)
c) Stop the Archive Shuttle module service
d) Remove all sdf files from module installation location
e) Start the Archive Shuttle module service
2) Exclude Archive Shuttle modules from scanning
3) Ensure that Archive Shuttle modules are not installed on shared network folders
4) Ensure that the account under which the module is running has access to the .sdf file in installation module locationto

Print Friendly, PDF & Email