• State Suggested Answer
  • Locked Locked
  • Replies 18 replies
  • Answers 2 answers
  • Subscribers 93 subscribers
  • Views 19272 views
  • Users 0 members are here
Options
Related
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')

Pradeep Pola
over 7 years ago

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
  • 0 over 7 years ago

    Hi Tomi,

    Thanks for the update,it went through fine after that but getting below dll missing exception

     

     

    [810086] Error compiling script (0,0): could not find library 'CHK.Enterprise.dll'
    at VI.DB.Entities.SessionFactoryImpl.<OpenAsync>d__16.MoveNext()
    at VI.DB.Entities.SessionFactoryImpl.<_OpenAsync>d__19.MoveNext()
    at VI.DB.Entities.SessionFactoryImpl._CheckSession(ISession session)
    at VI.DB.Services.Resolve[T]()
    at VI.DB.Services.TryResolve[T](T& ret)
    at VI.DB.IoC.LifetimeScopeImpl.TryResolve[T](T& ret)
    at VI.DB.IoC.LifetimeScopeImpl._InternalResolve[T](LifetimeScopeImpl requestingScope, String name, T& ret)
    at VI.DB.IoC.LifetimeScopeImpl._InternalResolve[T](LifetimeScopeImpl requestingScope, String name, T& ret)
    at VI.DB.IoC.LifetimeScopeImpl._GetOrCreate[T](LifetimeScopeImpl requestingScope, ComponentRegistration registration)
    at VI.DB.IoC.ContainerBuilder.<>c__DisplayClass5_0`1.<Register>b__0(IComponentContext ctx)
    at VI.DB.BootStrapper.<>c.<RegisterCommon>b__1_13(IComponentContext ctx)
    at VI.DB.Scripting.ScriptEnvironment..ctor(IDialogSemaphorSupervisor semaphors, IScriptSupplier supplier)
    at VI.DB.Scripting.DialogCompilingScriptSupplier.GetProviders(String cacheDir)
    at VI.DB.Scripting.DialogCompilingScriptSupplier.CreateCompilingAssemblyProvider(Func`2 getProvider, String key, String cacheDir)
    at System.Collections.Concurrent.ConcurrentDictionary`2.GetOrAdd(TKey key, Func`2 valueFactory)
    at VI.DB.Scripting.DialogCompilingScriptSupplier.<>c.<_GetScriptClass>b__15_0(IDynamicAssemblyProvider p)
    at VI.DB.Scripting.DynamicAssemblyProviderBase.GetScriptAssembly()
    at VI.DB.Scripting.CompilingAssemblyProvider.CreateScriptAssembly()
    at VI.DB.Scripting.ScriptCompiler.Compile(String[] preprocessorDefines)
    at VI.DB.Scripting.ScriptAssemblyCompiler.CompileSource(IScriptAssembly assembly, String source, String[] preprocessorDefines)

     

Reply
  • 0 over 7 years ago

    Hi Tomi,

    Thanks for the update,it went through fine after that but getting below dll missing exception

     

     

    [810086] Error compiling script (0,0): could not find library 'CHK.Enterprise.dll'
    at VI.DB.Entities.SessionFactoryImpl.<OpenAsync>d__16.MoveNext()
    at VI.DB.Entities.SessionFactoryImpl.<_OpenAsync>d__19.MoveNext()
    at VI.DB.Entities.SessionFactoryImpl._CheckSession(ISession session)
    at VI.DB.Services.Resolve[T]()
    at VI.DB.Services.TryResolve[T](T& ret)
    at VI.DB.IoC.LifetimeScopeImpl.TryResolve[T](T& ret)
    at VI.DB.IoC.LifetimeScopeImpl._InternalResolve[T](LifetimeScopeImpl requestingScope, String name, T& ret)
    at VI.DB.IoC.LifetimeScopeImpl._InternalResolve[T](LifetimeScopeImpl requestingScope, String name, T& ret)
    at VI.DB.IoC.LifetimeScopeImpl._GetOrCreate[T](LifetimeScopeImpl requestingScope, ComponentRegistration registration)
    at VI.DB.IoC.ContainerBuilder.<>c__DisplayClass5_0`1.<Register>b__0(IComponentContext ctx)
    at VI.DB.BootStrapper.<>c.<RegisterCommon>b__1_13(IComponentContext ctx)
    at VI.DB.Scripting.ScriptEnvironment..ctor(IDialogSemaphorSupervisor semaphors, IScriptSupplier supplier)
    at VI.DB.Scripting.DialogCompilingScriptSupplier.GetProviders(String cacheDir)
    at VI.DB.Scripting.DialogCompilingScriptSupplier.CreateCompilingAssemblyProvider(Func`2 getProvider, String key, String cacheDir)
    at System.Collections.Concurrent.ConcurrentDictionary`2.GetOrAdd(TKey key, Func`2 valueFactory)
    at VI.DB.Scripting.DialogCompilingScriptSupplier.<>c.<_GetScriptClass>b__15_0(IDynamicAssemblyProvider p)
    at VI.DB.Scripting.DynamicAssemblyProviderBase.GetScriptAssembly()
    at VI.DB.Scripting.CompilingAssemblyProvider.CreateScriptAssembly()
    at VI.DB.Scripting.ScriptCompiler.Compile(String[] preprocessorDefines)
    at VI.DB.Scripting.ScriptAssemblyCompiler.CompileSource(IScriptAssembly assembly, String source, String[] preprocessorDefines)

     

Children
No Data