topic Re: Sending emails by NPrinting task in Qlik NPrinting

Sending emails by NPrinting task

jasmina_karcic — Fri, 10 Aug 2018 11:50:43 GMT

Hi experts,

Why this is happening? Sometimes in production I have problem. Look, 2 hours nothing happen, then it continue...:/

Don't ask me how big app is, it is not solution.

Thanks,

Jasmina

Re: Sending emails by NPrinting task

bramkn — Fri, 10 Aug 2018 12:21:06 GMT

I won't ask you how big the app is. But I will ask what the normal time is between 2 tasks?

I would advice to restart the server if this has been a while. And send logs to Qlik Support to let them see whats up.

This is nothing we on the forum can really help you with is my guess.

Re: Sending emails by NPrinting task

jasmina_karcic — Fri, 10 Aug 2018 12:30:30 GMT

hehe,

Okay. No, this is one task, just sometimes stop. I cannot find what is problem. Restarting services is just partly solution...:/

This is risk for my report.

Thanks anyway,

Jasmina

Re: Sending emails by NPrinting task

Ruggero_Piccoli — Fri, 10 Aug 2018 12:30:35 GMT

Hi,

Check the Qlik NPrinting log files to see if there are more information because we have not enought details from the screenshot.

The app could be small, but check if the report template has a lot of Pages, Levels, cycles...

Be sure that all the Windows services are up and running. In particular check that the Engines are online.

Best Regards,

Ruggero

---------------------------------------------

When applicable please mark the appropriate replies as CORRECT https://community.qlik.com/docs/DOC-14806. This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution. Please mark threads as HELPFUL if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads as HELPFUL if you feel additional info is useful to others.

Re: Sending emails by NPrinting task

jasmina_karcic — Fri, 10 Aug 2018 12:50:50 GMT

First warning in nprinting_scheduler_log is:

Qlik.NPrinting.Scheduler 18.0.4.0 Qlik.NPrinting.Scheduler.SchedulerCore 20180810T075238.999+02:00 WARN BI Nprinting Task Identity 0 0 0 0 0 0 0 0 Engine 233fb149-df62-4787-adbb-24cf295026ec has reached heartbeat timeout. Last recorded heartbeat: 10.8.2018 5:52:21 - Offline thresold: 00:00:15

And other warnings...

Also has this:

Qlik.NPrinting.Scheduler 18.0.4.0 Qlik.NPrinting.Scheduler.Service.ContentRequestDispatcher 20180810T111500.225+02:00 WARN BI 0 0 00000000-0000-0000-0000-000000000000 0 83bdf8f4-95f9-4fb2-b23e-ef0fc40a9952 0 bca36f79-9b3f-456e-a46e-ad06dbd9175a 00000000-0000-0000-0000-000000000000 Cannot find an executor for response with request id bca36f79-9b3f-456e-a46e-ad06dbd9175a, type Qlik.NPrinting.Common.Scheduler.ArtifactGenerationResponse

Yes, this report is big, 10 pagest (take levels, take about 15 tables...)

But, this software should not have problem with size...:D

Jasmina

Re: Sending emails by NPrinting task

Ruggero_Piccoli — Fri, 10 Aug 2018 13:09:26 GMT

Hi,

In general, the software has not problem with size, but if, for example, you have not enough hardware resources, it can take a long time.

You are using 18.0.4.0. I would to suggest to keep your installation aligned with latest version in order to benefit of all solved bugs.

The message:

can be:

- the answer of an aborted task. I mean somebody pressed the Abort button in the task executions page

- you restarted the Scheduler service but some old stuff remained in the Messaging service queue so it re-appears. Restart also the Messaging service will remove all the old messages from the queue.

Best Regards,

Ruggero

---------------------------------------------

Re: Sending emails by NPrinting task

jasmina_karcic — Fri, 10 Aug 2018 13:14:46 GMT

Don't say me that.

I made upgrade to june 2018, and it has a bugs. So I turned back to version april 2018.

June 2018 made confusion for columns. I should make again reports, exactly create new tables, then import in template.

Other problem I had, reports were failing with message (failed to render, getlayout() method time out....something like this)

What I should do now? Restart services every day?

Jasmina

Re: Sending emails by NPrinting task

Ruggero_Piccoli — Fri, 10 Aug 2018 13:24:56 GMT

Hi,

June 2018 solved the bug about columns order:

Wrong column order, colors, and hyperlinks with Qlik Sense February and April 2018

Qlik Sense tables added to report templates from Qlik Sense February and April 2018 connections, with modified column orders would generate errors. Reports would show incorrect column order, and color or hyperlinks were applied to the wrong columns.

and this bug fix will be part of all next releases.

In general, all bug investigation and fixes are done starting from latest release. So, in case you are experiencing a bug, it will be solved in a newer version. We don't add bug fixes to old versions like April 2018.

If you have other issues you need to open a support ticket by adding all the details to reproduce them, the versions of the software you are using and the log files. We cannot do a good investigation with partial log files and without a remote connection.

Of course restarting the services every day is not a solution, but we ha a lot of installations that are working without this need.

Best Regards,

Ruggero

---------------------------------------------

Re: Sending emails by NPrinting task

jasmina_karcic — Fri, 10 Aug 2018 13:30:05 GMT

Thanks Ruggero,

I was writing to our regional support in Croatia, so I will wait to Monday for their response. If we don't get any feedback, I will write to official support page.

Thanks

Jasmina

Re: Sending emails by NPrinting task

Ruggero_Piccoli — Fri, 10 Aug 2018 13:31:50 GMT

Hi,

Ok. Paste the solution here if possible when solved.

Re: Sending emails by NPrinting task

bramkn — Mon, 13 Aug 2018 07:43:34 GMT

Hi,

The column bug was not fixed in the June release. It appeared for a client in this release(Windows update was also done with upgrade)

The bug then also appeared for an other client after windows update. And this client is still on last version because of that bug that first apeared for us in June release.

I have reported all info to Qlik Support. Did not get any info on it beeing fixed.

Re: Sending emails by NPrinting task

Ruggero_Piccoli — Mon, 13 Aug 2018 10:37:48 GMT

Hi,

Based on our tests the bug is solved in June 2018.

If it is not solved the colleagues of the support team will be able to verify and in case send it back to the developers.

Best Regards,

Ruggero

---------------------------------------------

Re: Sending emails by NPrinting task

BalaBhaskar_Qlik — Mon, 13 Aug 2018 14:12:25 GMT

May be this helps:

Nprinting jobs are scheduled but not Starting automatically

Re: Sending emails by NPrinting task

bramkn — Thu, 16 Aug 2018 14:08:37 GMT

I Opened a new support ticket about this. Apparently there were 2 bugs with the columns. The one I was thinking off wasn't fixed, but this one was.

Re: Sending emails by NPrinting task

jasmina_karcic — Mon, 20 Aug 2018 08:04:02 GMT

Hi, still is not solved.

They think problem is in a sintetic key on application.

But yesterday this happened to an another very simple report. It started in early morning, and just stopped. All day didn't move from 30%. Other reports was waiting, but we must kill them with aborting, and restart service, so today can come without problem.

The first showed error in engine log:

Qlik.NPrinting.Common 18.0.3.0 Qlik.NPrinting.Common.Messages.ContentResolutionRabbitTopology 20180819T065221.089+02:00 ERROR BI 0 0 0 0 0 0 0 0 Failed 3 times to prepare queue with exchange name cnrresponse_exchange and queue name cnrresponse_queue. ERROR: Pipelining of requests forbidden Exception type: System.NotSupportedException. Stack trace: at EasyNetQ.Producer.ClientCommandDispatcherSingleton.Invoke(Action`1 channelAction)↓↓ at EasyNetQ.RabbitAdvancedBus.ExchangeDeclare(String name, String type, Boolean passive, Boolean durable, Boolean autoDelete, Boolean internal, String alternateExchange, Boolean delayed)↓↓ at Qlik.NPrinting.Common.Messages.ContentResolutionRabbitTopology.InternalPrepareQueue(String exchangeName, String queueName, Boolean queueDurability, Nullable`1 maxPriority, IExchange& exchange) in c:\Jws\release-18.0.x\server\NPrinting\src\Common\Messages\ContentResolutionRabbitTopology.cs:line 69.

The first showed error in schedule log:

Qlik.NPrinting.Scheduler 18.0.4.0 Qlik.NPrinting.Scheduler.SchedulerCore 20180819T071311.314+02:00 WARN BI Nprinting Task Identity 0 0 0 0 0 0 0 0 Engine 233fb149-df62-4787-adbb-24cf295026ec has reached heartbeat timeout. Last recorded heartbeat: 19.8.2018 5:12:53 - Offline thresold: 00:00:15

Qlik.NPrinting.Scheduler 18.0.4.0 Qlik.NPrinting.Scheduler.SchedulerCore 20180819T071312.268+02:00 ERROR BI Nprinting Task Identity 0 0 0 0 0 0 0 0 Error running check unreachable engines. NHibernate.StaleObjectStateException: Row was updated or deleted by another transaction (or unsaved-value mapping was incorrect): [Qlik.NPrinting.Repo.Model.Engine#233fb149-df62-4787-adbb-24cf295026ec]↵↓ at NHibernate.Persister.Entity.AbstractEntityPersister.Update(Object id, Object[] fields, Object[] oldFields, Object rowId, Boolean[] includeProperty, Int32 j, Object oldVersion, Object obj, SqlCommandInfo sql, ISessionImplementor session)↵↓ at NHibernate.Persister.Entity.AbstractEntityPersister.UpdateOrInsert(Object id, Object[] fields, Object[] oldFields, Object rowId, Boolean[] includeProperty, Int32 j, Object oldVersion, Object obj, SqlCommandInfo sql, ISessionImplementor session)↵↓ at NHibernate.Persister.Entity.AbstractEntityPersister.Update(Object id, Object[] fields, Int32[] dirtyFields, Boolean hasDirtyCollection, Object[] oldFields, Object oldVersion, Object obj, Object rowId, ISessionImplementor session)↵↓ at NHibernate.Action.EntityUpdateAction.Execute()↵↓ at NHibernate.Engine.ActionQueue.Execute(IExecutable executable)↵↓ at NHibernate.Engine.ActionQueue.ExecuteActions(IList list)↵↓ at NHibernate.Engine.ActionQueue.ExecuteActions()↵↓ at NHibernate.Event.Default.AbstractFlushingEventListener.PerformExecutions(IEventSource session)↵↓ at NHibernate.Event.Default.DefaultAutoFlushEventListener.OnAutoFlush(AutoFlushEvent event)↵↓ at NHibernate.Impl.SessionImpl.AutoFlushIfRequired(ISet`1 querySpaces)↵↓ at NHibernate.Impl.SessionImpl.List(IQueryExpression queryExpression, QueryParameters queryParameters, IList results)↵↓ at NHibernate.Impl.AbstractSessionImpl.List(IQueryExpression queryExpression, QueryParameters parameters)↵↓ at NHibernate.Impl.AbstractQueryImpl2.List()↵↓ at NHibernate.Linq.DefaultQueryProvider.ExecuteQuery(NhLinqExpression nhLinqExpression, IQuery query, NhLinqExpression nhQuery)↵↓ at NHibernate.Linq.DefaultQueryProvider.Execute(Expression expression)↵↓ at NHibernate.Linq.DefaultQueryProvider.Execute[TResult](Expression expression)↵↓ at Remotion.Linq.QueryableBase`1.GetEnumerator()↵↓ at Qlik.NPrinting.Scheduler.SchedulerCore.<CheckUnreachableEngines>b__2b(ISession session) in c:\Jws\release-18.0.x\server\NPrinting\src\Scheduler\SchedulerCore.cs:line 466↵↓ at Qlik.NPrinting.Repo.Service.SessionManager.WithSession(Func`2 body, IsolationLevel isolationLevel, Boolean readOnly) in c:\Jws\release-18.0.x\server\NPrinting\src\Repo\Service\SessionManager.cs:line 99↵↓ at Qlik.NPrinting.Scheduler.SchedulerCore.CheckUnreachableEngines() in c:\Jws\release-18.0.x\server\NPrinting\src\Scheduler\SchedulerCore.cs:line 474↵↓ ↵↓=============↵↓ at Qlik.NPrinting.Common.Utils.NPLog.Error(String message, Exception ex, NPLoggingContext loggingContext)↵↓ at Qlik.NPrinting.Scheduler.SchedulerCore.CheckUnreachableEngines() in c:\Jws\release-18.0.x\server\NPrinting\src\Scheduler\SchedulerCore.cs:line 474↵↓ at System.Threading.Tasks.Task.Execute()↵↓ at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)↵↓ at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)↵↓ at System.Threading.Tasks.Task.ExecuteWithThreadLocal(Task& currentTaskSlot)↵↓ at System.Threading.Tasks.Task.ExecuteEntry(Boolean bPreventDoubleExecution)↵↓ at System.Threading.ThreadPoolWorkQueue.Dispatch()↵↓=============↵↓

Every day a new issue...

What is this?

Thanks,

Jasmina

Re: Sending emails by NPrinting task

Ruggero_Piccoli — Mon, 27 Aug 2018 08:36:17 GMT

Hi,

First of all from the logs it seems your Qlik NPrinting Engine is 18.0.3 February 2018 and your Qlik NPrinting Server is 18.0.4 February 2018 SR1. As general rule, you must keep your installation aligned to the same version.

Update Qlik NPrinting Server, Engines and Designers to June 2018 that has a lot of solved bugs compared with February 2018. Than try again and let us know if this solves.

Best Regards,

Ruggero

---------------------------------------------

Re: Sending emails by NPrinting task

jasmina_karcic — Mon, 27 Aug 2018 08:40:29 GMT

Ruggero,

Now I cannot make that, because of bug (changing column sort for some report) and I have failure in rendering some tables....:/ First, I must see what is problem here....

Thank you, this is useful information.

Jasmina

Re: Sending emails by NPrinting task

Ruggero_Piccoli — Mon, 27 Aug 2018 08:52:12 GMT

Ok. If you need open a support ticket so a support guy could connect with you.

Best,

Ruggero

Re: Sending emails by NPrinting task

Ruggero_Piccoli — Thu, 30 Aug 2018 10:35:16 GMT

Hi,

About the columns order issue in Qlik NPrinting June 2018. Try to switch the order in two columns of the object you are using fr reporting in the Qlik Sense source app. Save the app, regenerate the cache in Qlik NPrinting June 2018 and run the report again.

I just discovered that this workaround could resolve.

BR,

Ruggero