I'm getting the attached errors when trying to perform a schema change. This was just an addition of a field to table PersonWantsOrg.
My system user account appears to be in the same permission groups as viadmin. Any ideas how to fix this?
Ellen
[810023] Error during execution of statement: exec QBM_PGrantNeededRightsTo 'basegroup' at VI.DB.DataAccess.ReadWriteDbSession.<SqlExecuteNonQueryAsync>d__14.MoveNext() [810143] Database error 50000: re-throw in Procedure QBM_PExecuteSQL, Line 9 at VI.DB.DataAccess.ReadWriteDbSession.<SqlExecuteNonQueryAsync>d__14.MoveNext() at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at VI.DB.DataAccess.ReadWriteDbSession.<IgnoreBrokenConnectionAsync>d__46`1.MoveNext() at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at VI.DB.DataAccess.ReadWriteDbSession.<_SqlExecuteNonQueryAsync>d__15.MoveNext() at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at VI.DB.DataAccess.ReadOnlyDbSession.<ExecuteAndLogAsync>d__95`1.MoveNext() at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at VI.DB.DataAccess.ReadOnlyDbSession.<ExecuteAndLogAsync>d__96`1.MoveNext() at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at VI.DB.DataAccess.SafeDbCommand.<ExecuteNonQueryAsync>d__16.MoveNext() at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at VI.DB.DataAccess.SafeDbCommand.<_CheckedAsync>d__40`1.MoveNext() [810143] Database error 15151: detected in Procedure QBM_PGrantNeededRightsTo, Line 2 Cannot find the object 'AccountNames', because it does not exist or you do not have permission. Code starting with: set quoted_identifier on grant insert, update, delete, select on "AccountNames" to basegroup
[810023] Error during execution of statement: insert into DialogColumn (Caption, ColumnName, IsCustomConfigurable, SortOrder, UID_DialogColumn, UID_DialogTable, xdateinserted, xuserinserted, xdateupdated, xuserupdated, xobjectkey) values (N'NetID PRO Email White Pages Searchable', N'CCC_NetIDPROEmailWhitePgSearch', 1, 1, 'CCC-0B0550D6125C97499202E373189B75E4', 'QER-T-PersonWantsOrg', GetUTCDate(), N'ellen-sys', GetUTCDate(), N'ellen-sys', '<Key><T>DialogColumn</T><P>CCC-0B0550D6125C97499202E373189B75E4</P></Key>') at VI.SchemaExtension.Base.DataObjects.ExtensionData.<ExecuteStepsAsync>d__43.MoveNext() at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at VI.SchemaExtension.Base.DataObjects.ExtensionData.<ExecuteStepsAsync>d__43.MoveNext() at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at VI.SchemaExtension.Base.Logic.CreateColumnsStep.<ExecuteInsideTransactionAsync>d__6.MoveNext() at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at VI.DB.Entities.UnitOfWorkImpl.<FlushAsync>d__40.MoveNext() at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at VI.DB.Entities.DbEntitySink.<FlushAsync>d__17.MoveNext() at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at VI.DB.Entities.DbOperations.ClusteringDbOperationsQueue.<FlushAsync>d__30.MoveNext() at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at VI.DB.Entities.DbOperations.ClusteringDbOperationsQueue.<_FlushInternalAsync>d__31.MoveNext() at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at VI.DB.Entities.DbOperations.ClusteringDbOperationsQueue.<_FlushInternalAsync>d__31.MoveNext() at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at VI.DB.Entities.DbOperations.ClusteringDbOperationsQueue.<_DoInsertsAsync>d__34.MoveNext() at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at VI.DB.Entities.DbOperations.ClusteringDbOperationsQueue.<_RunSingleAsync>d__41.MoveNext() at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at VI.DB.DataAccess.ReadWriteDbSession.<SqlExecuteNonQueryAsync>d__14.MoveNext() [810143] Database error 3616: An error was raised during trigger execution. The batch has been aborted and the user transaction, if any, has been rolled back. at VI.DB.DataAccess.ReadWriteDbSession.<SqlExecuteNonQueryAsync>d__14.MoveNext() at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at VI.DB.DataAccess.ReadWriteDbSession.<IgnoreBrokenConnectionAsync>d__46`1.MoveNext() at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at VI.DB.DataAccess.ReadWriteDbSession.<_SqlExecuteNonQueryAsync>d__15.MoveNext() at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at VI.DB.DataAccess.ReadOnlyDbSession.<ExecuteAndLogAsync>d__95`1.MoveNext() at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at VI.DB.DataAccess.ReadOnlyDbSession.<ExecuteAndLogAsync>d__96`1.MoveNext() at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at VI.DB.DataAccess.SafeDbCommand.<ExecuteNonQueryAsync>d__16.MoveNext() at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at VI.DB.DataAccess.SafeDbCommand.<_CheckedAsync>d__40`1.MoveNext() An error was raised during trigger execution. The batch has been aborted and the user transaction, if any, has been rolled back. at VI.DB.DataAccess.SafeDbCommand.<_CheckedAsync>d__40`1.MoveNext() at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at VI.DB.DataAccess.PhysicalMsSqlConnection._AsyncSqlCommand.<ExecuteNonQueryAsync>d__31.MoveNext() at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at System.Data.SqlClient.SqlCommand.EndExecuteNonQuery(IAsyncResult asyncResult) at System.Data.SqlClient.SqlCommand.EndExecuteNonQueryInternal(IAsyncResult asyncResult) at System.Data.SqlClient.SqlCommand.InternalEndExecuteNonQuery(IAsyncResult asyncResult, String endMethod, Boolean isInternal) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction