Qlik Community

Deployment & Management

Discussion board where members learn more about Qlik Sense Installation, Deployment and Management.

Announcements
Read about the latest Qlik Community enhancements on the Community News blog!
cancel
Showing results for 
Search instead for 
Did you mean: 
adlisval
Contributor III
Contributor III

Upgrade to February 2018 "successful" - ERROR Fatal exception

Hi,

Tried to upgrade from Qlik Sense 3.2 SR5 (shared persistence, single node) to Qlik Sense February 2018. The upgrade said "successful", but I can't access  Qlik Sense.

For the error below I tried the following, without success: https://help.qlik.com/en-US/sense/February2018/Subsystems/PlanningQlikSenseDeployments/Content/Deplo...

Here is the error in C:\ProgramData\Qlik\Sense\Log\Repository\Trace\System_Repository.txt:

ERROR    qliksense    System.Repository.Repository.QRSMain     Fatal exception    update or delete on table "CompositeEvents" violates foreign key constraint "FK_CompositeEventTimeConstraints_CompositeEvents_ID" on table "CompositeEventTimeConstraints"↵↓Failed to execute query: 'DELETE FROM "CompositeEvents" WHERE "Deleted" = true'. Exception: update or delete on table "CompositeEvents" violates foreign key constraint "FK_CompositeEventTimeConstraints_CompositeEvents_ID" on table "CompositeEventTimeConstraints"↵↓Failed to remove soft deleted records↵↓An exception was thrown while invoking the constructor 'Void .ctor()' on type 'DatabaseContext'. ---> Failed to remove soft deleted records (See inner exception for details.)↵↓An exception was thrown while invoking the constructor 'Void .ctor(Qlik.Sense.Common.ITypeResolver, System.Func`1[Repository.Core.Repository.Database.Common.IDatabaseContext], Autofac.ILifetimeScope, Repository.Core.Repository.Common.ITransactionUtility, Repository.Core.Repository.Common.IRepositoryEntityCache, Repository.Core.INodeStaticInfo, Qlik.Sense.Logging.IQSLogManager, Repository.Core.Repository.Common.ILifetimeScopeEntityCache, Repository.Core.Repository.Common.IEntityFrameworkExtendedWrapper)' on type 'EntityTransactionRepository'. ---> An exception was thrown while invoking the constructor 'Void .ctor()' on type 'DatabaseContext'. ---> Failed to remove soft deleted records (See inner exception for details.) (See inner exception for details.)↵↓An exception was thrown while invoking the constructor 'Void .ctor(Qlik.Sense.Logging.IQSLogManager, Repository.Core.INodeStaticInfo, Qlik.Sense.Communication.Security.ICertSetup, Qlik.Sense.Common.Communication.REST.Server.IRESTEngineFactory, Repository.Core.ISystemInformation, Repository.Core.Certificates.ICertificatePasswordVerificationWebService, Qlik.Sense.Common.Logging.ILogMaster)' on type 'SetupService'. ---> An exception was thrown while invoking the constructor 'Void .ctor(Qlik.Sense.Common.ITypeResolver, System.Func`1[Repository.Core.Repository.Database.Common.IDatabaseContext], Autofac.ILifetimeScope, Repository.Core.Repository.Common.ITransactionUtility, Repository.Core.Repository.Common.IRepositoryEntityCache, Repository.Core.INodeStaticInfo, Qlik.Sense.Logging.IQSLogManager, Repository.Core.Repository.Common.ILifetimeScopeEntityCache, Repository.Core.Repository.Common.IEntityFrameworkExtendedWrapper)' on type 'EntityTransactionRepository'. ---> An exception was thrown while invoking the constructor 'Void .ctor()' on type 'DatabaseContext'. ---> Failed to remove soft deleted records (See inner exception for details.) (See inner exception for details.) (See inner exception for details.)   at Devart.Data.PostgreSql.PgSqlDataReader.f(Int32 A_0)↵↓   at Devart.Data.PostgreSql.PgSqlCommand.InternalExecute(CommandBehavior behavior, IDisposable stmt, Int32 startRecord, Int32 maxRecords)↵↓   at Devart.Common.DbCommandBase.ExecuteDbDataReader(CommandBehavior behavior, Boolean nonQuery)↵↓   at Devart.Common.DbCommandBase.ExecuteNonQuery()↵↓   at Repository.Core.Database.PgDatabase.DatabaseQuery.ExecuteNonQuery(PgSqlConnection connection, Int32 commandTimeout)↵↓NO-STACKTRACE↵↓   at Repository.Core.Migrations.Support.DataIntegritySupport.DbCleanSoftDeletedRecords()↵↓   at Repository.Core.Migrations.Support.DataIntegritySupport.CleanSoftDeletedRecords()↵↓   at Repository.Core.Migrations.Support.MigrationIoc.Using(Action`1 action)↵↓   at Repository.Core.Repository.Database.Common.AbstractDatabaseContext..ctor()↵↓   at lambda_method(Closure , Object[] )↵↓   at Autofac.Core.Activators.Reflection.ConstructorParameterBinding.Instantiate()↵↓   at Autofac.Core.Activators.Reflection.ConstructorParameterBinding.Instantiate()↵↓   at Autofac.Core.Activators.Reflection.ReflectionActivator.ActivateInstance(IComponentContext context, IEnumerable`1 parameters)↵↓   at Autofac.Core.Resolving.InstanceLookup.Activate(IEnumerable`1 parameters)↵↓   at Autofac.Core.Lifetime.LifetimeScope.GetOrCreateAndShare(Guid id, Func`1 creator)↵↓   at Autofac.Core.Resolving.InstanceLookup.Execute()↵↓   at Autofac.Core.Resolving.ResolveOperation.GetOrCreateInstance(ISharingLifetimeScope currentOperationScope, IComponentRegistration registration, IEnumerable`1 parameters)↵↓   at Autofac.Core.Resolving.ResolveOperation.Execute(IComponentRegistration registration, IEnumerable`1 parameters)↵↓   at lambda_method(Closure )↵↓   at Repository.Core.Repository.Common.EntityTransactionRepository..ctor(ITypeResolver typeResolver, Func`1 databaseContextProvider, ILifetimeScope containingScope, ITransactionUtility transactionUtility, IRepositoryEntityCache repositoryEntityCache, INodeStaticInfo nodeInfo, IQSLogManager logManager, ILifetimeScopeEntityCache lifetimeScopeEntityCache, IEntityFrameworkExtendedWrapper entityFrameworkExtendedWrapper)↵↓   at lambda_method(Closure , Object[] )↵↓   at Autofac.Core.Activators.Reflection.ConstructorParameterBinding.Instantiate()↵↓   at Autofac.Core.Activators.Reflection.ConstructorParameterBinding.Instantiate()↵↓   at Autofac.Core.Activators.Reflection.ReflectionActivator.ActivateInstance(IComponentContext context, IEnumerable`1 parameters)↵↓   at Autofac.Core.Resolving.InstanceLookup.Activate(IEnumerable`1 parameters)↵↓   at Autofac.Core.Resolving.InstanceLookup.Execute()↵↓   at Autofac.Core.Resolving.ResolveOperation.GetOrCreateInstance(ISharingLifetimeScope currentOperationScope, IComponentRegistration registration, IEnumerable`1 parameters)↵↓   at Autofac.Core.Activators.Reflection.ConstructorParameterBinding.Instantiate()↵↓   at Autofac.Core.Activators.Reflection.ReflectionActivator.ActivateInstance(IComponentContext context, IEnumerable`1 parameters)↵↓   at Autofac.Core.Resolving.InstanceLookup.Activate(IEnumerable`1 parameters)↵↓   at Autofac.Core.Resolving.InstanceLookup.Execute()↵↓   at Autofac.Core.Resolving.ResolveOperation.GetOrCreateInstance(ISharingLifetimeScope currentOperationScope, IComponentRegistration registration, IEnumerable`1 parameters)↵↓   at Autofac.Core.Resolving.ResolveOperation.Execute(IComponentRegistration registration, IEnumerable`1 parameters)↵↓   at Autofac.ResolutionExtensions.TryResolveService(IComponentContext context, Service service, IEnumerable`1 parameters, Object& instance)↵↓   at Autofac.ResolutionExtensions.ResolveService(IComponentContext context, Service service, IEnumerable`1 parameters)↵↓   at Autofac.ResolutionExtensions.Resolve[TService](IComponentContext context, IEnumerable`1 parameters)↵↓   at Repository.Core.Repository.Common.SecurityAwareRepository.<>c__DisplayClass51_0`1.<GetAllWithoutSecurity>b__0()↵↓   at Repository.Core.Repository.Common.SecurityAwareRepository.RunWithoutSecurity[TResult](Func`1 func)↵↓   at Repository.Core.Settings.LocalConfigStash.GetFromRepository(LocalConfigKey key, ISecurityAwareRepository repository)↵↓   at Qlik.Sense.Common.Ioc.WorkScope.Work[T,TResult](Func`2 func)↵↓   at System.Collections.Concurrent.ConcurrentDictionary`2.GetOrAdd(TKey key, Func`2 valueFactory)↵↓   at Repository.Core.Settings.LocalConfigStash.TryGet(LocalConfigKey key, LocalConfigCachePolicy cachePolicy, ISecurityAwareRepository repository, LocalConfig& localConfig)↵↓   at Repository.Core.Settings.LocalConfigStash.Get(LocalConfigKey key, LocalConfigCachePolicy cachePolicy)↵↓   at Repository.Core.Settings.LocalConfigStash.Get(LocalConfigKey key, T defaultValue, LocalConfigCachePolicy cachePolicy)↵↓   at Repository.Core.SystemInformation.<get_LocalNode>b__27_0(ISecurityAwareRepository repository)↵↓   at Qlik.Sense.Common.Ioc.WorkScope.Work(Action`1 action)↵↓   at Repository.Core.SystemInformation.get_LocalNode()↵↓   at Repository.Core.SystemInformation.GetTemporaryFolder()↵↓   at Repository.Core.Services.SetupService..ctor(IQSLogManager logManager, INodeStaticInfo nodeInfo, ICertSetup certSetup, IRESTEngineFactory restEngineFactory, ISystemInformation systemInformation, ICertificatePasswordVerificationWebService certificatePwdWebService, ILogMaster logMaster)↵↓   at lambda_method(Closure , Object[] )↵↓   at Autofac.Core.Activators.Reflection.ConstructorParameterBinding.Instantiate()↵↓   at Autofac.Core.Activators.Reflection.ConstructorParameterBinding.Instantiate()↵↓   at Autofac.Core.Activators.Reflection.ReflectionActivator.ActivateInstance(IComponentContext context, IEnumerable`1 parameters)↵↓   at Autofac.Core.Resolving.InstanceLookup.Activate(IEnumerable`1 parameters)↵↓   at Autofac.Core.Resolving.InstanceLookup.Execute()↵↓   at Autofac.Core.Resolving.ResolveOperation.GetOrCreateInstance(ISharingLifetimeScope currentOperationScope, IComponentRegistration registration, IEnumerable`1 parameters)↵↓   at Autofac.Core.Activators.Reflection.ConstructorParameterBinding.Instantiate()↵↓   at Autofac.Core.Activators.Reflection.ReflectionActivator.ActivateInstance(IComponentContext context, IEnumerable`1 parameters)↵↓   at Autofac.Core.Resolving.InstanceLookup.Activate(IEnumerable`1 parameters)↵↓   at Autofac.Core.Resolving.InstanceLookup.Execute()↵↓   at Autofac.Core.Resolving.ResolveOperation.GetOrCreateInstance(ISharingLifetimeScope currentOperationScope, IComponentRegistration registration, IEnumerable`1 parameters)↵↓   at Autofac.Core.Resolving.ResolveOperation.Execute(IComponentRegistration registration, IEnumerable`1 parameters)↵↓   at Autofac.ResolutionExtensions.TryResolveService(IComponentContext context, Service service, IEnumerable`1 parameters, Object& instance)↵↓   at Autofac.ResolutionExtensions.ResolveService(IComponentContext context, Service service, IEnumerable`1 parameters)↵↓   at Autofac.ResolutionExtensions.Resolve[TService](IComponentContext context, IEnumerable`1 parameters)↵↓   at Qlik.Sense.Common.Ioc.WorkScope.Work(Action`1 action)↵↓   at Repository.QRSMain.Main()
1 Solution

Accepted Solutions
adlisval
Contributor III
Contributor III
Author

It got solved. The problem was that when I pasted the copied code from the troubleshooting page (see link below), the code got pasted in one line only, and it was a commented line of code, so of course that the code didn't have any effect when it was run.

Conclusion: the troubleshooting works, be careful when pasting the code they provide in the troubleshooting.

https://help.qlik.com/en-US/sense/February2018/Subsystems/PlanningQlikSenseDeployments/Content/Deplo...

View solution in original post

1 Reply
adlisval
Contributor III
Contributor III
Author

It got solved. The problem was that when I pasted the copied code from the troubleshooting page (see link below), the code got pasted in one line only, and it was a commented line of code, so of course that the code didn't have any effect when it was run.

Conclusion: the troubleshooting works, be careful when pasting the code they provide in the troubleshooting.

https://help.qlik.com/en-US/sense/February2018/Subsystems/PlanningQlikSenseDeployments/Content/Deplo...

View solution in original post