topic Re: NPrinting Excel Designer Hungs when creating report in Qlik NPrinting

NPrinting Excel Designer Hungs when creating report

nadkalyan — Mon, 20 May 2019 19:02:59 GMT

Hello, While adding columns to the NPrinting designer excel format, Excel Hungs and does not allow me to add any additional Columns or move to different Cell. The connection to the App is active and I am able to Add new Images or tables from source Qlikview document, however i cannot navigate on the Excel interface. Can someone please provide some insight on the issue

NPrinting Designer Excel freeze

Re: NPrinting Excel Designer Hungs when creating report

Chris_Rice — Tue, 21 May 2019 08:16:59 GMT

Are you using Office 365?

https://support.qlik.com/articles/000047955

Re: NPrinting Excel Designer Hungs when creating report

Ruggero_Piccoli — Tue, 21 May 2019 08:34:44 GMT

Hi,

When you post a question, please, always specify what version of Qlik NPrinting you are using, what kind of connection and the QlikView or Qlik Sense version.

If you are not using latest version please upgrade to it and try to reproduce the issue.

You can also check the official release notes of newer versions than your to be sure that you are not experiencing a bug that is fixed or a know limitation.

Best Regards,

Ruggero

Re: NPrinting Excel Designer Hungs when creating report

nadkalyan — Tue, 21 May 2019 13:17:32 GMT

We are on Excel 2016.

Re: NPrinting Excel Designer Hungs when creating report

nadkalyan — Tue, 21 May 2019 13:19:23 GMT

Hi Ruggero, We are on latest release of NPrinting ver 19 (Qlik NPrinting April 2019). I am connecting to a Qlikview dashboard.

I will check official release if there is any bugs on this version. Thanks!!

Re: NPrinting Excel Designer Hungs when creating report

nadkalyan — Tue, 21 May 2019 13:19:35 GMT

Hi Ruggero, We are on latest release of NPrinting ver 19 (Qlik NPrinting April 2019). I am connecting to a Qlikview dashboard.

I will check official release if there is any bugs on this version. Thanks!!

Re: NPrinting Excel Designer Hungs when creating report

Ruggero_Piccoli — Tue, 21 May 2019 13:59:08 GMT

Hi,

I checked and I have nothing similar in April 2019 (I asked your version so I can check only the release notes that are newer than the version you are using).

Check if you have a zoom different than 100%.

Best Regards,

Ruggero

Re: NPrinting Excel Designer Hungs when creating report

Frank_S — Tue, 21 May 2019 14:54:10 GMT

Hello @nadkalyan

Please check the following video tutorial as normal file opening can be affected by this...

https://community.qlik.com/t5/Qlik-NPrinting-Documents/Qlik-NPrinting-Unsupported-Objects/ta-p/1578063

Re: NPrinting Excel Designer Hungs when creating report

nadkalyan — Tue, 21 May 2019 15:11:08 GMT

Yes Zoom is 100%. This is big data file, do you think that would cause any hung on Excel when changing it?

Thanks

Re: NPrinting Excel Designer Hungs when creating report

nadkalyan — Tue, 21 May 2019 15:12:13 GMT

This helps to confirm that if there are any unsupported items in the Qlikview. Upon checking there are none in our Qlikview document. Thanks!!

Re: NPrinting Excel Designer Hungs when creating report

Frank_S — Tue, 21 May 2019 15:52:00 GMT

Check the following points next:

Log on as the NPrinting service account on to the NPrinting server

Open the QVW only while logged on as the NPrinting service account. Do File>Open in Server to the QVW in order to open it. If not a QVP connection open the QVW in the same was as configured as the NPrinting connection is configured. ie: as a network path if the connection is configured as a network path.

Do you experience any hanging behavior? Is the QVW file quite large? Does it eventually open? Any macros?

Turn on Task Manager and view the CPU and Memory performance while opening the QVW as the NP service account.

How much RAM is installed on the NP server? How many CPUs?

Re: NPrinting Excel Designer Hungs when creating report

nadkalyan — Tue, 21 May 2019 16:42:09 GMT

Thanks for the Checkpoints on the things to check. I have followed the steps and here is my feedback-

Do you experience any hanging behavior? Is the QVW file quite large? Does it eventually open? Any macros? - No Hanging behavior when opened qvp file from Nprinting server. It opens fine and QVW is aroung 80MB. No Macros.

Turn on Task Manager and view the CPU and Memory performance while opening the QVW as the NP service account. – CPU and Memory is normal. Did not see much hike.

How much RAM is installed on the NP server? How many CPUs? – 128GB RAM and 16 Core CPU.

Thanks

Re: NPrinting Excel Designer Hungs when creating report

Frank_S — Tue, 21 May 2019 16:49:01 GMT

Thank you @nadkalyan but it is critical to do this test while logged on as the NP service account (same account that is used to run the NPrinting server services (NP engine, Scheduler and web engine).

Your response does not specifically address if you did this test while logged on as the NP service account.

If you log on as your own Active Directory account then the test is not valid. You must use the NPrinting service account.

If you have done so and you don't experience any issues while logged on as the NP service account, then please start a support request so we can investigate this for you more thoroughly.

Kind regards...

Re: NPrinting Excel Designer Hungs when creating report

nadkalyan — Tue, 21 May 2019 16:51:08 GMT

That is correct- all tests are done using Nprinting service account. I will open a ticket to address it more appropriately.

Thanks

Kalyan