topic Re: Random failed generation error in Qlik NPrinting

Random failed generation error

er77 — Sat, 17 Nov 2018 14:01:14 GMT

I'm often facing issues to generate nPrinting reports (excel) from a QlikSense app.

The strange thing is that if I restart the report after the issue, the report work fine.

Also, having a daily scheduled task, sometimes is working, some not, and teh report is always the same!

On the image below the error I get randomly; on logs error is:

ERROR: CEF rendering exception. GRPC rendering request failed, error: request with id a33893919eab4aad9d1b75797308b83a failed with remote error ErrorGenericResult.

Re: Random failed generation error

Lech_Miszkiewicz — Sun, 18 Nov 2018 22:41:18 GMT

I suggest to start with telling us first the version and configuration of the environment.

Second i would ensure NPrinitng is installed according to all requirements from https://help.qlik.com as there is a lot of them and very often people just install NPrinitng without following reuirements and documentation. Have you done installation "by the book"

regards

Lech

Re: Random failed generation error

Ruggero_Piccoli — Mon, 19 Nov 2018 09:21:49 GMT

Hi,

In case of error in the Task executions page you should also check the logs https://help.qlik.com/en-US/nprinting/September2018/Content/NPrinting/AdministeringQVNprinting/Logging.htm.

From the error you posted it seems that there is an issue in opening the Qlik Sense app from the Qlik NPrinting Engine. So be sure that firewall is open and the user has access to the app.

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: Random failed generation error

er77 — Mon, 19 Nov 2018 12:48:08 GMT

@Ruggero_Piccoli wrote:
Hi,

In case of error in the Task executions page you should also check the logs https://help.qlik.com/en-US/nprinting/September2018/Content/NPrinting/AdministeringQVNprinting/Logging.htm.

From the error you posted it seems that there is an issue in opening the Qlik Sense app from the Qlik NPrinting Engine. So be sure that firewall is open and the user has access to the app.

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.

Let me provide an update: same reports that get errors last week, today works fine with no issues.

Then like mentioned on my first post, is random and qlik sense app is always the same and all servers are running on same Vmware environment with same firewall configuration

Re: Random failed generation error

er77 — Mon, 19 Nov 2018 20:18:17 GMT

@Lech_Miszkiewicz wrote:
I suggest to start with telling us first the version and configuration of the environment.
Second i would ensure NPrinitng is installed according to all requirements from https://help.qlik.com as there is a lot of them and very often people just install NPrinitng without following reuirements and documentation. Have you done installation "by the book"
regards
Lech

Our entire environment installed from Qlik COnsultant group last year!

Re: Random failed generation error

Lech_Miszkiewicz — Mon, 19 Nov 2018 20:52:24 GMT

Ok then. How big is the Qlik senseapp?Do you monitor Qlik server resources? What is the user experience when browsing the Qlik Sense app? Is it responsive and calculates all objects instantly? It might be that your app is not build optimal and does time out on some objects?

This becomes an environmnent based case where your errors are not generic ones but can be related to your setup and qlik sense app.

I suggest that the consultant who installedNprinting shoul look at it first.

Regards
Lech

Re: Random failed generation error

Ruggero_Piccoli — Tue, 20 Nov 2018 11:09:06 GMT

Hi,

I agree with Lech, it seems something related to your specific installation/application. You could ask the help of the Qlik Consultant that installed it or open a support ticket. In any case I think at this point that it is necessary to check directly your installation.

Re: Random failed generation error

er77 — Fri, 23 Nov 2018 14:44:40 GMT

Installed all latest Nov 2018 versions and today happened again.

I found on the Sense machine (event viewer) from where we are pulling data (Connection Proxy Address) this error at same time reports failed:

Faulting application name: Engine.exe, version: 12.244.6.0, time stamp: 0x5bec2296
Faulting module name: ntdll.dll, version: 6.3.9600.17031, time stamp: 0x530895af
Exception code: 0xc0000374
Fault offset: 0x00000000000f8c9c
Faulting process id: 0x1dc4
Faulting application start time: 0x01d481a106797ff9
Faulting application path: C:\Program Files\Qlik\Sense\Engine\Engine.exe
Faulting module path: C:\Windows\SYSTEM32\ntdll.dll
Report Id: c197aed5-eefd-11e8-80c9-005056941df6
Faulting package full name:
Faulting package-relative application ID:

and this is what I found on engine log:

Severity ProductVersion Timestamp Description ProxySessionId ProxyPackageId RequestSequenceId UserDirectory UserId SessionId ObjectId ObjectName Service Origin Context Command Result Message
INFO 12.244.6.0 20181121T144930.015+0100 Command=Stop engine;Result=0;ResultText=Success 0 0 0 Internal Engine Engine Not available EngineMain::ShutDown Stop engine 0 Engine stopped with exit code 0
INFO 12.244.6.0 20181121T145021.816+0100 Command=Start engine;Result=0;ResultText=Success 0 0 0 Internal Engine Engine Not available INI Start engine 0 Reporting settings with non-default values...

Re: Random failed generation error

Ruggero_Piccoli — Fri, 23 Nov 2018 14:44:27 GMT

Hi,

At this point please open a support ticket and include the logs and a link to this conversation.

Re: Random failed generation error

andrewmo — Thu, 29 Nov 2018 17:44:49 GMT

Did you happen to get a solution to this issue?

Re: Random failed generation error

mayurg — Mon, 01 Jul 2019 14:12:51 GMT

Did you found the solution for the same. We are also facing same issue for NOv 2018 version.

Re: Random failed generation error

Ruggero_Piccoli — Tue, 02 Jul 2019 13:52:07 GMT

Hi,

Start by upgrading to latest version June 2019. There are many bug fixed between the two versions.

If the issue persist please provide the log files and any other useful detail.

Best Regards,

Ruggero

Re: Random failed generation error

mtamni — Mon, 19 Dec 2022 10:46:07 GMT

Hello,

I am facing nearly the same issue with Qlik NPrinting May 2021 SR2 connected to Qlik Sense February 2022 patch 4.

It happens two or three times per week, between 1:25am to 1:35am or 1:45am, all tasks failed generating.

Failed generation of report 29713a26-7ded-43f5-94c8-89231cafae42 for user 3da2f1d3-f95b-4b46-a10f-8258ea6ac4c3. ERROR: Cannot apply filter Filters: [Fields: [Name: F\flg_last_date_photo, ConnectionId: 9132d69e-5e52-4b9a-8a41-bc58cd3d82e5, Values: [Numeric:1], Override: False, Void: False, SelectExcluded: False, Name: F\MESURES, ConnectionId: 9132d69e-5e52-4b9a-8a41-bc58cd3d82e5, Values: [String:[Stock Résiduel], String:[Flux Relèves J-14], String:[Données], String:[Stock]], Override: False, Void: False, SelectExcluded: False, Name: F\DIMENSIONS, ConnectionId: 9132d69e-5e52-4b9a-8a41-bc58cd3d82e5, Values: [String:[Sous_Activite], String:[Flux_Prevision], String:[_ID_Code_UI], String:[Date_Cible_Initiale], String:[_Id_Date_Autre], String:[Motif_Sig_OT], String:[Centre], String:[Num_int_uniq], String:[Date_IA], String:[Unité_Intervention], String:[Code_Situation], String:[Date_Planif], String:[Typologie_Ilot], String:[Jour_Heure_Cible_Initiale], String:[Jour_IA], String:[Jour_Photo], String:[Type_Date_Cible_Initiale], String:[Date_Cible_Finale], String:[Code_Sst_Local], String:[Sous_Secteur], String:[Code_Produit], String:[Base_gpc], String:[Etat], String:[Date_Sig], String:[Code_Activite], String:[nd_calcule], String:[Ilot], String:[Priorite], String:[Origine], String:[Type_PC], String:[Engagement], String:[Type_Stock], String:[_ID_Chronologie], String:[Anciennete_Stock], String:[Domaine], String:[Secteur], String:[Direction_Regionale], String:[Support], String:[Jour_Planif], String:[Activite], String:[Cpt_Code_Situation], String:[Securite], String:[_id_cal_Date_Photo_Oce], String:[Num_Intervention], String:[_ID_Activite]], Override: False, Void: False, SelectExcluded: False, Name: F\Unité_Intervention, ConnectionId: 9132d69e-5e52-4b9a-8a41-bc58cd3d82e5, Values: [String:UNIC], Override: False, Void: False, SelectExcluded: False], Variables: [], Void: False Fields: [Name: F\Type_Contrat, ConnectionId: 9132d69e-5e52-4b9a-8a41-bc58cd3d82e5, Values: [AdvancedSearch:ICT?, AdvancedSearch:RCC*], Override: False, Void: False, SelectExcluded: False], Variables: [], Void: False], Bookmark: , Void: False to current document data.

the same tasks get generated successfully few moment later, without doing anything.

Any idea about what it can be ?

Thanks for helping,

Best Regards,

Mehdi

Re: Random failed generation error

Ruggero_Piccoli — Mon, 19 Dec 2022 13:38:25 GMT

Hi,

Please don't comment so old posts. Start a new conversation instead with the details of your question including the version of Qlik NPrinting you are using. The original post was written in 2018, and we changed many things in the software in five years. Thanks.

Best Regards,

Ruggero