Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
You can describe the detailed steps to solve the problem? Thank you in advance.
It is a bug in Sense 2.2, something was corrupting the database. Hopefully there will be a fix in the next feature release.
I'm use 2.2.4 and not fixed.
One alternative is to downgrade back to 2.1.
Edit: only an option if you have good backups of your 2.1 environment
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.
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 | 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 |
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 |
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