Issue
Import module logs this error:

CheckIndexComplete|Error while checking for Index Complete. T
GetScalar[T](System.Data.SqlClient.SqlConnectionStringBuilder,
System.String, System.Collections.Generic.List`1[System.Data.SqlClient.SqlParameter])
Error SELECT COUNT_BIG(IndexCommited) FROM dbo.JournalArchive
WITH (NOLOCK) WHERE dbo.JournalArchive.IndexCommited = @NotCommited

Solution
This happens when the Import module is mapped to the Source, or the Export module is mapped to the Target, and there is missing permission for the account to get statistics from SQL. We recommend you map Import modules to the Target, and Export modules to the Source only.

Print Friendly, PDF & Email