This discussion has been locked.
You can no longer post new replies to this discussion. If you have a question you can start a new discussion

Upgrade error ([810143] Database error 515: Cannot insert the value NULL into column 'EventName', table 'D1IM.dbo.QBMEvent')

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)

Parents
  • You are running to an identified bug. Please contact the support and let them give the fix for Viper27263.

    The workaround is to run the following statement before migration.

    delete from JobEventGen where ISNULL(Event, '') = ''

Reply
  • You are running to an identified bug. Please contact the support and let them give the fix for Viper27263.

    The workaround is to run the following statement before migration.

    delete from JobEventGen where ISNULL(Event, '') = ''

Children
No Data