Issue
The Archive Shuttle EV Import Module may log the following error:
2015-04-01 13:12:33Z|1646| 24|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
at ArchiveShuttle.DAL.EV.Wrapper.DatabaseHelpers.GetScalar[T](SqlConnectionStringBuilder connectionString, String sql, List`1 parameters)
at ArchiveShuttle.DAL.EV.Wrapper.VaultStore.EVVSDALBase.GetIndexIncompleteCount()
at ArchiveShuttle.Module.EVImportModule.CommandExecution.CheckIndexCompleteCommandExecutor.CheckIndexComplete(EVCheckIndexComplete checkIndexComplete)

Void OnError(System.Data.SqlClient.SqlException, Boolean)
Cannot generate SSPI context.
   at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParser.SSPIError(String error, String procedure)
at System.Data.SqlClient.TdsParser.SNISSPIData(Byte[] receivedBuff, UInt32 receivedLength, Byte[] sendBuff, UInt32& sendLength)
at System.Data.SqlClient.TdsParser.TdsLogin(SqlLogin rec)
at System.Data.SqlClient.SqlInternalConnectionTds.Login(ServerInfo server, Int64 timerExpire, String newPassword)
at System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo serverInfo, String newPassword, Boolean ignoreSniOpenTimeout, Int64 timerExpire, SqlConnection owningObject, Boolean withFailover)
at System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(String host, String newPassword, Boolean redirectedUserInstance, SqlConnection owningObject, SqlConnectionString connectionOptions, Int64 timerStart)
at System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance)
at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance)
at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection)
at System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options)
at System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject)
at System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject)
at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject)
at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)
at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
at System.Data.SqlClient.SqlConnection.Open()
at ArchiveShuttle.DAL.EV.Wrapper.DatabaseHelpers.GetScalar[T](SqlConnectionStringBuilder connectionString, String sql, List`1 parameters)

Solution
This issue is related to connection to SQL Server, check if the SQL ports are disabled in the firewall.
 

Print Friendly, PDF & Email