Hi Experts,
i am getting the below error when i was upgrading from dell 7.0 to 7.1.1
Processing step 'QBM 2016.0008.0003.0000 (JobeventGen)' failed.
at ConfigWizard.Pages.PageMigration.<StartMigration>d__17.MoveNext()
at System.Threading.Tasks.Task.Execute()
at Quantum.Migrator.Migrator.RunInstallation(Boolean bUpdate)
1 - SqlFile command failed.
at Quantum.Migrator.Base.ExtensionMethods.ExecuteWithLogging(IMigrationStep step, MigrationContext context)
at Quantum.Migrator.Base.ExtensionMethods.ExecuteWithLogging(IList`1 lCommands, MigrationContext context)
Error processing sql command line 29 in file Migration\2016.0008.0003.0000.sql
at Quantum.Migrator.Base.ExtensionMethods.ExecuteWithLogging(IList`1 lCommands, MigrationContext context)
at Quantum.Migrator.Base.CommandBase.Execute(MigrationContext context)
at Quantum.Migrator.SqlFileCommand.OnExecute(MigrationContext context)
[810023] Error during execution of statement: declare @Puffer QBM_YParameterList insert into @Puffer (Parameter1, Parameter2, Parameter3) select dbo.QBM_FCVGUIDToModuleOwner(e.UID_JobEventGen)
, t.TableName, e.Event from JobEventGen e join DialogTable t on e.UID_DialogTable = t.UID_DialogTable declare @XUser nvarchar(64) = 'Migration' declare
@Xdate datetime = getUtcdate() insert into QBMEvent(UID_QBMEvent, EventName, UID_DialogTable , XDateInserted , XDateUpdated, XUserInserted, XUserUpdated
, XObjectKey ) select x.UID_QBMEvent,upper( x.EventName), x.UID_DialogTable , @Xdate, @Xdate, @XUser, @XUser , dbo.QBM_FCVElementToObjectKey1('QBMEvent'
, 'UID_QBMEvent', x.UID_QBMEvent ) from ( select distinct dbo.QBM_FCVStringToGUID(p.Parameter1, t.UID_DialogTable + p.Parameter3 ) as UID_QBMEvent , p.Parameter3
as EventName, t.UID_DialogTable from @Puffer p join DialogTable t on p.Parameter2 = t.TableName join QBMModuleDef m on m.ModuleName = p.Parameter1 ) as
x where not exists (select top 1 1 from QBMEvent e where e.UID_QBMEvent = x.UID_QBMEvent or (e.UID_DialogTable = x.UID_DialogTable and e.EventName = x.EventName
) )
at VI.DB.DataAccess.ReadWriteDbSession.<SqlExecuteNonQueryAsync>d__13.MoveNext()
[810143] Database error 515: Cannot insert the value NULL into column 'EventName', table 'D1IM.dbo.QBMEvent'; column does not allow nulls. INSERT fails.
The statement has been terminated.
at VI.DB.DataAccess.ReadWriteDbSession.<SqlExecuteNonQueryAsync>d__13.MoveNext()
at VI.DB.DataAccess.ReadWriteDbSession.<IgnoreBrokenConnectionAsync>d__42`1.MoveNext()
at System.Runtime.CompilerServices.ConfiguredTaskAwaitable`1.ConfiguredTaskAwaiter.GetResult()
at VI.DB.DataAccess.ReadWriteDbSession.<_SqlExecuteNonQueryAsync>d__14.MoveNext()
at VI.DB.DataAccess.ReadOnlyDbSession.<ExecuteAndLogAsync>d__92`1.MoveNext()
at System.Runtime.CompilerServices.ConfiguredTaskAwaitable`1.ConfiguredTaskAwaiter.GetResult()
at VI.DB.DataAccess.ReadOnlyDbSession.<ExecuteAndLogAsync>d__93`1.MoveNext()
at System.Runtime.CompilerServices.ConfiguredTaskAwaitable`1.ConfiguredTaskAwaiter.GetResult()
at VI.DB.DataAccess.SafeDbCommand.<ExecuteNonQueryAsync>d__16.MoveNext()
at System.Runtime.CompilerServices.ConfiguredTaskAwaitable`1.ConfiguredTaskAwaiter.GetResult()
at VI.DB.DataAccess.SafeDbCommand.<_CheckedAsync>d__40`1.MoveNext()
Cannot insert the value NULL into column 'EventName', table 'D1IM.dbo.QBMEvent'; column does not allow nulls. INSERT fails.
The statement has been terminated.
at VI.DB.DataAccess.SafeDbCommand.<_CheckedAsync>d__40`1.MoveNext()
at VI.DB.DataAccess.PhysicalMsSqlConnection._AsyncSqlCommand.<ExecuteNonQueryAsync>d__31.MoveNext()
at System.Data.SqlClient.SqlCommand.EndExecuteNonQuery(IAsyncResult asyncResult)
at System.Data.SqlClient.SqlCommand.EndExecuteNonQueryInternal(IAsyncResult asyncResult)
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)