• State Suggested Answer
  • Locked Locked
  • Replies 18 replies
  • Answers 2 answers
  • Subscribers 93 subscribers
  • Views 19275 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)

  • 0 over 7 years ago

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

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

     

  • 0 over 7 years ago

    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.

  • 0 over 7 years ago

    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

     

     

     

  • 0 over 7 years ago
    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.
  • 0 over 7 years ago
    Hi Markus,

    This was the error message

    [810102] The script assembly could not be stored in 'DialogScriptAssembly'.
    at VI.Tools.DBCompiler.CompileScripts._CompileSection(DialogCompilingScriptSupplier supplier, DialogAssemblyStore store, _SectionData section, IDictionary`2 createdModules)
    at VI.DB.Scripting.DialogAssemblyStore.Save(IScriptAssembly assembly)
    [810086] Error compiling script Template of UNSGroupB.DistinguishedName (1,0): Error creating notification entries for UNSGroupB.DistinguishedName.
    at VI.DB.Scripting.DialogAssemblyStore.Save(IScriptAssembly assembly)
    at VI.DB.Scripting.DialogCompilingScriptSupplier._FillTemplatesMetaData(IConnection connection, IScriptAssembly assembly)
    [810001] Column UsesContainer was not found in object of type UNSRootB.
    at VI.DB.MetaData.MetaDataExtensions.<GetPathAsync>d__1.MoveNext()


    810102] The script assembly could not be stored in 'DialogScriptAssembly'.
    at VI.Tools.DBCompiler.CompileScripts._CompileSection(DialogCompilingScriptSupplier supplier, DialogAssemblyStore store, _SectionData section, IDictionary`2 createdModules)
    at VI.DB.Scripting.DialogAssemblyStore.Save(IScriptAssembly assembly)
    [810086] Error compiling script Template of UNSGroupB.DistinguishedName (1,0): Error creating notification entries for UNSGroupB.DistinguishedName.
    at VI.DB.Scripting.DialogAssemblyStore.Save(IScriptAssembly assembly)
    at VI.DB.Scripting.DialogCompilingScriptSupplier._FillTemplatesMetaData(IConnection connection, IScriptAssembly assembly)
    [810001] Column UsesContainer was not found in object of type UNSRootB.
    at VI.DB.MetaData.MetaDataExtensions.<GetPathAsync>d__1.MoveNext()
  • 0 over 7 years ago
    Please check, that in your database the column UNSRootB.UsesContainer is present.

    I assume, that your migration has not been completed as the property UNSRootB.UsesContainer has been introduced with 7.0 SP1.

    I suggest you try to restore your backup from 7.0 and redo your migration. Please check the upgrade information in the manuals as well.

    You can contact our support as well.
  • 0 over 7 years ago
    i dont see a UNSRootB.UsesContainer , but upgrade process should create the column if it does not exist right
  • 0 over 7 years ago
    It should yes. But according to your troubles with the empty event names the migration might not have been successful.

    Did you restored a backup of 7.0 and restarted the migration or did you just execute the workaround as mentioned by Tomi and restarted the migration?
  • 0 over 7 years ago
    i did not restore the back up of DB,after the work around stuck with this compilation issue