Skip to main content

 none
Problem with Data Migration Assistant - SQL RRS feed

  • General discussion

  • Hello,
    I am doing an assessment to migrate my SQL Server 2005 database, use DMA but it does not finish the full analysis, but it gives the error below. There is very little documentation on this, and I have not been able to obtain a solution.

    Can someone tell me what I can do, thank you in advance:

    The assessment of database 'basededatos' on server 'instanciaA' failed.
    Failed to collect data against Node 'basededatos' ('Database_SqlInstance__basededatos').  It was retried 0 time(s). The following error occurred:

    Generic SQL exception. Node=basededatos UniqueName=Database_SqlInstance__basededatos SqlError=195.
    Type=Microsoft.Sirona.Collection.CollectionException

    Server stack trace: 
       en Microsoft.Sirona.Collection.DataCollectorBase.Collect(INode node, IDataNodeReference existingReference)
       en Microsoft.Sirona.Workflow.Activities.Collection.DataCollectorActivity`1.ExecuteDataCollector(T dataCollector, INode node, IDataNodeReference existingReference)
       en System.Runtime.Remoting.Messaging.StackBuilderSink._PrivateProcessMessage(IntPtr md, Object[] args, Object server, Object[]& outArgs)
       en System.Runtime.Remoting.Messaging.StackBuilderSink.AsyncProcessMessage(IMessage msg, IMessageSink replySink)
    Exception rethrown at [0]: 
       en System.Runtime.Remoting.Proxies.RealProxy.EndInvokeHelper(Message reqMsg, Boolean bProxyCase)
       en System.Runtime.Remoting.Proxies.RemotingProxy.Invoke(Object NotUsed, MessageData& msgData)
       en Microsoft.Sirona.Workflow.Activities.Collection.DataCollectorActivity`1.CollectMethodCaller.EndInvoke(IAsyncResult result)
       en Microsoft.Sirona.Workflow.Activities.Collection.DataCollectorActivity`1.EndExecute(NativeActivityContext context, IAsyncResult result)
       en Microsoft.Sirona.Workflow.Activities.Core.AsyncNativeActivity.BookmarkResumeToComplete(NativeActivityContext context, Bookmark bookmark, Object state)
       en System.Activities.Runtime.BookmarkWorkItem.Execute(ActivityExecutor executor, BookmarkManager bookmarkManager)

    +Generic SQL exception. Node=basededatos UniqueName=Database_SqlInstance__basededatos SqlError=195
    +Type=Microsoft.Sirona.Collection.PrerequisiteException

    +   en Microsoft.Sirona.DataCollectors.SqlDataCollector.ExecuteSql(INode node, XmlWriter writer)
       en Microsoft.Sirona.DataCollectors.SqlDataCollector.LockNodeAndExecuteSql(INode node, XmlWriter writer)
       en Microsoft.Sirona.DataCollectors.SqlDataCollector.CollectInternal(INode node, IDataNodeReference reference)
       en Microsoft.Sirona.Collection.DataCollectorBase.ImpersonateAndCollect(INode node, IDataNodeReference reference)
       en Microsoft.Sirona.Collection.DataCollectorBase.Collect(INode node, IDataNodeReference existingReference)

    ++'object_schema_name' is not a recognized built-in function name.
    Incorrect syntax near the keyword 'AS'.
    Incorrect syntax near 'os'.
    ++Type=System.Data.SqlClient.SqlException
    ++   en System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
       en System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
       en System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
       en System.Data.SqlClient.SqlDataReader.TryConsumeMetaData()
       en System.Data.SqlClient.SqlDataReader.get_MetaData()
       en System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted)
       en System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest)
       en System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
       en System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
       en System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
       en Microsoft.Sirona.DataCollectors.SqlDataCollector.ExecuteSql(INode node, XmlWriter writer)

    Tuesday, October 15, 2019 6:29 PM