How can i start my tasks?

[#1]

Hi all,

I've created some task to reload my apps in Qlik Sense, but I can't start tasks manually.

First, I select Tasks on the QMC start page. Then I select the task I want to start and click start. The message "1 item was successfully instructed to start" is displayed at the bottom of the page, but never started.

Can anybody help me?

Thanks in advance.

[korsikov]

You can describe the detailed steps to solve the problem? Thank you in advance.

[Vegar]

It is a bug in Sense 2.2, something was corrupting the database. Hopefully there will be a fix in the next feature release.

[korsikov]

I'm use 2.2.4 and not fixed.

[Vegar]

1. Stop and set all Qlik Sense services to manual start.
2. Restart the server
3. Start the repository server
4. Wait a minute
5. Start the repository service
6. Wait a long time. You may check the repository service log in the trace folder. All date stamped xml should disappear from that folder and you sold have at least 4-5 xml without date stamp in the file name.
7. Start all other Qlik Sense services in any order.

[Vegar]

One alternative is to downgrade back to 2.1.

Edit: only an option if you have good backups of your 2.1 environment

[korsikov]

thx you for your clarification. i'll try do this now.

set all Qlik Sense service start manually, exclude Qlik Sense Repository database.

Then restart Server.

[korsikov]

find Error in System_repository.txt

53

20160513T114003.667+0300

ERROR

qsprozorro

System.Repository.Repository.QRSMain

14

1bffcf71-7314-40f0-b8ee-d0b2f58e6ca7

NT AUTHORITY\SYSTEM

Fatal exception

A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond↵↓Unable to read data from the transport connection: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond.↵↓Server did not respond within the specified timeout interval.↵↓Server did not respond within the specified timeout interval.↵↓An error occurred while executing the command definition. See the inner exception for details.↵↓Exception has been thrown by the target of an invocation.

at System.Net.Sockets.NetworkStream.Read(Byte[] buffer, Int32 offset, Int32 size)↵↓   at System.Net.Sockets.NetworkStream.Read(Byte[] buffer, Int32 offset, Int32 size)↵↓   at Devart.Common.au.a(Byte[] A_0, Int32 A_1, Int32 A_2)↵↓   at Devart.Common.au.a(Byte[] A_0, Int32 A_1, Int32 A_2)↵↓   at Devart.Common.j.c(Byte[] A_0, Int32 A_1, Int32 A_2)↵↓   at Devart.Common.z.d(Byte[] A_0, Int32 A_1, Int32 A_2)↵↓   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.Data.PostgreSql.Entity.t.a(CommandBehavior A_0)↵↓   at Devart.Common.Entity.ab.b(CommandBehavior A_0)↵↓   at Devart.Data.PostgreSql.Entity.t.b(CommandBehavior A_0)↵↓   at System.Data.Entity.Infrastructure.Interception.InternalDispatcher`1.Dispatch[TTarget,TInterceptionContext,TResult](TTarget target, Func`3 operation, TInterceptionContext interceptionContext, Action`3 executing, Action`3 executed)↵↓   at System.Data.Entity.Infrastructure.Interception.DbCommandDispatcher.Reader(DbCommand command, DbCommandInterceptionContext interceptionContext)↵↓   at System.Data.Entity.Core.EntityClient.Internal.EntityCommandDefinition.ExecuteStoreCommands(EntityCommand entityCommand, CommandBehavior behavior)↵↓   at System.Data.Entity.Core.EntityClient.Internal.EntityCommandDefinition.ExecuteStoreCommands(EntityCommand entityCommand, CommandBehavior behavior)↵↓   at System.Data.Entity.Core.Objects.Internal.ObjectQueryExecutionPlan.Execute[TResultType](ObjectContext context, ObjectParameterCollection parameterValues)↵↓   at System.Data.Entity.Core.Objects.ObjectContext.ExecuteInTransaction(Func`1 func, IDbExecutionStrategy executionStrategy, Boolean startLocalTransaction, Boolean releaseConnectionOnSuccess)↵↓   at System.Data.Entity.Core.Objects.ObjectQuery`1.<>c__DisplayClass7.<GetResults>b__5()↵↓   at System.Data.Entity.Core.Objects.ObjectQuery`1.GetResults(Nullable`1 forMergeOption)↵↓   at System.Data.Entity.Core.Objects.ObjectQuery`1.<System.Collections.Generic.IEnumerable<T>.GetEnumerator>b__0()↵↓   at System.Data.Entity.Internal.LazyEnumerator`1.MoveNext()↵↓   at Repository.Core.Repository.Common.RepositoryEntityCache.AddToCache(IEnumerable`1 items, Boolean includeNavigational)↵↓   at Repository.Core.Core.<>c__DisplayClass14`1.<>c__DisplayClass16.<LoadEntityIntoCache>b__13(IEnumerable`1 items)↵↓   at Repository.Core.Repository.Common.ModelRepository`1.InitializeRepositoryCache(Boolean loadFromDatabase, Func`2 f)↵↓   at Qlik.Sense.Common.Ioc.WorkScope.Work(Action`1 action)↵↓   at Repository.Core.Core.LoadEntityIntoCache(IModelRepository`1 repository)↵↓   at System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor)↵↓   at System.Reflection.RuntimeMethodInfo.UnsafeInvokeInternal(Object obj, Object[] parameters, Object[] arguments)↵↓   at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture)↵↓   at Repository.Core.Core.ReloadEntityCache()↵↓   at Repository.Core.Core.Setup_CentralNode()↵↓   at Repository.Core.Core.Setup()↵↓   at Repository.Core.Core.Inner(ManualResetEvent shutdownRequestedEvent)↵↓   at Repository.QRSMain.<Main>b__6(ICore core)↵↓   at Qlik.Sense.Common.Ioc.WorkScope.Work(Action`1 action)↵↓   at Repository.QRSMain.Main()

1bffcf71-7314-40f0-b8ee-d0b2f58e6ca7

54

20160513T114003.776+0300

INFO

qsprozorro

System.Repository.Repository.QRSMain

14

4946ecfe-e904-4d16-81f4-08fb1d51d79b

NT AUTHORITY\SYSTEM

Shutdown completed. Signing off..

4946ecfe-e904-4d16-81f4-08fb1d51d79b

[korsikov]

but i'm setup start Automatic (delayed ) and restart all services Server start.

but task not run. And i'm Can't delete old task. In QSRS logs record - delete task - succces but in QMC task is present.

Find intrested error in Security_repository:

Not possible to decrypt encrypted string in database; this is probably due to the secrets key on server certificate has been changed and the old database value hasn't; sending back empty result and leaving the value unchanged in database

Checksum error

And When i try do any change in database found in logs record like:

Error when committing.

Forbidden

Full error line

327

20160513T122619.846+0300

ERROR

qsprozorro

System.Repository.Repository.Core.Repository.Common.TransactionUtility

48

f281a7b0-cd47-4151-9789-0bb1f1ff6893

NT AUTHORITY\SYSTEM

Error when committing.

Forbidden

at Repository.Core.Repository.Common.ModelRepository`1.Add(T item, Boolean appendPrivileges, Int64 privilegesFilter)↵↓   at Repository.Core.Resource.AppResource.ProcessAppObjectChanges(IList`1 changes, EngineAppBundle result)↵↓   at Repository.Core.Resource.AppResource.<>c__DisplayClass3a.<Bulk>b__33()↵↓   at Repository.Core.Repository.Common.TransactionUtility.RunInTransaction(ITransaction transaction, IEnumerable`1 actions)

bfd23f45-c4be-4f07-bc55-61ce8a1dc850

f281a7b0-cd47-4151-9789-0bb1f1ff6893

[korsikov · Accepted solution]

good news!

i'm solved my problem with Qlik support advice.

Then provide to me SenseCleanupScript. After than i'm manualy in database cleanup problem task and problem application.

and everything ok now