Harriet_Kim_1764

Data Migrator permissions error

Discussion created by Harriet_Kim_1764 on Aug 25, 2017
The ARA utility, Data Migrator, is being used to upgrade the ARA database to use with a newer ARA version.

Error:
Warning! : Cannot find the object "dbo.StackWfInst" because it does not exist or you do not have permissions. ============ Error Detail ============
 Error in migration: ************ Cannot find the object "dbo.StackWfInst" because it does not exist or you do not have permissions. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at Migrator.Providers.TransformationProvider.ExecuteNonQuery(String sql) at Ventum.Bond2.DataMigrator.MigrationScripts._700.AddProvisioning.Up() in E:\BuildAgent\work\bondrelease\7.0.2.3@12.0.2\Projects\Ventum.Bond2.DataMigrator\MigrationScripts\700\02_AddProvisioning.cs:line 88 at Migrator.MigrateAnywhere.ApplyMigration(IMigration migration, MigrationAttribute attr) at Migrator.MigrateAnywhere.Migrate(IMigration migration) at Migrator.Migrator.MigrateTo(Int64 version) ======================================
 Rolling back to migration ************

Solution:
The Data Migrator tool must be ran by a user, who has DBOwner privilege.

Outcomes