locked
SSMA tester error RRS feed

  • Question

  • Hello Everyone

    I used SSMA to migrate data from Sybase ASE to SQL Server 2008, and I am trying to use SSMA Tester for testing migrated data.
     
    I have created a test case, selected only one table from a database but when I am trying to Run, getting following error message

    "Cannot connect to Sybase ASE via SQL Server tester extension."

    Following I can see in SSMA log file:

    [Tester: Error] [5364/6] [2009-09-22 14:33:28]: An error occurred while connecting to Sybase ASE via SSMA Tester extensions.
    [Tester: Error] [5364/6] [2009-09-22 14:33:28]: Exception: A .NET Framework error occurred during execution of user-defined routine or aggregate "ExecuteUnidimensionalCommand":
    System.NullReferenceException: Object reference not set to an instance of an object.
    System.NullReferenceException:
       at Microsoft.SSMA.Framework.Sybase.Tester.Extensions.SybaseTesterExtensionsUtils.IsConnectionAlive(IDbConnection connection)
       at Microsoft.SSMA.Framework.Sybase.SqlServer.Tester.Extensions.S2SSExecuteCommandExtensions`1.CheckSourceConnection()
       at Microsoft.SSMA.Framework.Generic.Testers.Extensions.Default.DefaultTesterExtensions`2.ExecuteBatch(String encryptedXml)
       at Microsoft.SSMA.Framework.Sybase.SqlServer.Tester.Extensions.S2SSExecuteCommandWithUnidimensionalResultExtensions.Run(String encryptedXml, String& result)
    .
     site: Void OnError(System.Data.SqlClient.SqlException, Boolean)
     source: .Net SqlClient Data Provider
     error code: -2146232060
     data: [HelpLink.ProdName] = [Microsoft SQL Server]
     data: [HelpLink.ProdVer] = [10.00.2531]
     data: [HelpLink.EvtSrc] = [MSSQLServer]
     data: [HelpLink.EvtID] = [6522]
     data: [HelpLink.BaseHelpUrl] = [http://go.microsoft.com/fwlink]
     data: [HelpLink.LinkId] = [20476]
       at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
       at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
       at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
       at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
       at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
       at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
       at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)
       at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
       at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
       at Microsoft.SSMA.Framework.Generic.Testers.Default.AbstractRunUtils.ExecuteUnidimentionalCommand(IRunOperationInfo operation, String sourceSql, String targetSql, UnidimensionalCommandResultProcessorDelegate resultProcessor, UnidimensionalCommandUnsuccessfulResultProcessorDelegate invalidResultProcessor, IDefaultRunTestCaseContext context, IDefaultRunTestCaseState state)

    Can anyone suggest some solution to this problem?

    Thanks
    Wednesday, September 23, 2009 6:37 AM

Answers

All replies