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)

  • 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, '') = ''

  • 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)

     

  • You need to put your additional DLLs, used in some of your Scrips into the binary directory where you started the Config Wizard (I assume normal installation directory of OneIM).

    Please check if the mentioned DLL (and all other additional ones you have added in your 7.0 version) to the 7.1.1 directory.

  • Hi Marcus,

     

    These were the DLLS that were missing,

     

    Microsoft.Data.Services.Client.dll

    Microsoft.WindowsAzure.Configuration.dll

    Microsoft.Practices.EnterpriseLibrary.TransientFaultHandling.dll

    Microsoft.Practices.EnterpriseLibrary.TransientFaultHandling.ServiceBus.dll

     

     

    after adding these dlls compilation started but getting below error

     

     

     

  • Are you sure, that you have installed the binaries for all modules you are using in your installation? It sounds not like it.

    You are able to get a better error message when you close this error and when the compilation has finished, click on the database on the left, where the compilation is marked with the red text.

    You should get a list of the compilation steps including those with errors where you can get some details.