topic Re: Nprinting Error: Object Reference not set to an instance to an object in Qlik NPrinting

Nprinting Error: Object Reference not set to an instance to an object

bhargav_bhat — Wed, 25 Sep 2019 18:40:54 GMT

Hi All,

Currently I am creating a excel template in Nprinting. While previewing the document I am getting following error

I am went through the log files and I am not able to figure out the cause behind it

Need help to resolve this issue

Thanks and Regards,

Bhargav

Re: Nprinting Error: Object Reference not set to an instance to an object

Chanty4u — Wed, 04 Apr 2018 11:10:08 GMT

is any column name is added or updated?

select the object in designer tab leftside

and select table right click and update --if you found any rows/columns updated

re drag the columns and do preview

Re: Nprinting Error: Object Reference not set to an instance to an object

Ruggero_Piccoli — Wed, 04 Apr 2018 13:31:53 GMT

Hi,

I suggest you to upgrade your installation to February 2018 because the error message there is more clear due to a solved bug:

The error message "Error Object reference not set to an instance of an object" was not clear

Qlik NPrinting Engine log messages related to metadata reload failures due to wrong or missing Qlik Sense objects have been improved.

You can also check if you deleted a Qlik Sense object used in the report template.

Best Regards,

Ruggero

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

When applicable please mark the appropriate replies as CORRECT. 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: Nprinting Error: Object Reference not set to an instance to an object

bhargav_bhat — Thu, 05 Apr 2018 09:01:15 GMT

Hi Chanty,

Thanks for Replying

I updated the Table objects and also I recreated the tables in the Template.

The issue is that when I was applying Conditional Formatting rule it gives me the error

Regards,

Bhargav

Re: Nprinting Error: Object Reference not set to an instance to an object

bhargav_bhat — Thu, 05 Apr 2018 09:03:45 GMT

Hi Rugerro ,

Thanks for Replying

Currently I am having September 2017 version.So is this a known bug for this version.

The issue is that when I was applying Conditional Formatting rule it gives me the error and if I delete it the error does'nt appear

Regards,

Bhargav

Re: Nprinting Error: Object Reference not set to an instance to an object

Ruggero_Piccoli — Thu, 05 Apr 2018 10:17:25 GMT

Hi,

My suggestion is to upgrade your installation to latest version and then replicate before doing other investigations.

BR,

Ruggero

Re: Nprinting Error: Object Reference not set to an instance to an object

chris_andersson — Fri, 06 Apr 2018 12:37:10 GMT

You should check if you need to apply a filter in NPrint that corresponds to the conditional formatting you have.

Re: Nprinting Error: Object Reference not set to an instance to an object

Frank_S — Fri, 06 Apr 2018 20:02:16 GMT

Please follow Ruggero's advice above regarding the suggested to upgrade and to check if any objects have been removed or updated in the NP report.

You should also check the following as these can cause this error as well:

Invalid filters Error "Wrong content node response type" or report preview & task failures
Filters that contain no data
Master items moved to an app must remain in the app in order for NPrinting to process the object. When removed, errors will occur since master items do not have Sense IDs
An unsupported Qlik Sense extension is used in the App. This must be removed
Invalid formulas in public or private sheets. Try removing all sheets that are not needed. Private sheet with invalid formulas are read by NPrinting and can cause this issue.

Re: Nprinting Error: Object Reference not set to an instance to an object

bhargav_bhat — Sun, 08 Apr 2018 17:30:03 GMT

Hi Ruggero,

I have upgraded to the latest version i.e Nprinting February 2018. And I tried to replicate the same formatting in February version and I am getting same error .The below screenshot contains the details

Basically we want this kind of Conditional Formatting in Pivot table.If Dim1 value is suppose XYZ then its complete row should be highlighted in green as shown below

Now to achieve this we have applied conditional formatting rule as shown below

Also the below is the Nprinting template

the Conditional Formatting works perfectly for this Template but as soon as we add a Field in Page level as shown below we get an error.For example Dim3_page in this case

Can you please help me resolve this issue

Regards,

Bhargav

Re: Nprinting Error: Object Reference not set to an instance to an object

Ruggero_Piccoli — Mon, 09 Apr 2018 09:46:54 GMT

Hi,

Based on the screenshot of the template you posted, the issue is not generated by the conditional formatting.

Could you share a screenshot of the template with all the nodes on the left column expanded?

Based on what I sees I suppose you would that the tag Dim1 is expanded as different columns on the right. This doesn't work by design. Qlik NPrinting expand the rows, not the columns.

You should follow the instructions on the page https://help.qlik.com/en-US/nprinting/February2018/Content/ExcelReports/HowCreatePivotTableExcelTableColumns/Pivot-table… to create a native Excel pivot table in the report and format it by using Excel formatting features.

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: Nprinting Error: Object Reference not set to an instance to an object

bhargav_bhat — Mon, 09 Apr 2018 10:00:25 GMT

Hi Rugerro,

I have followed the instructions on the page mentioned above.The issue is that the conditional formatting rules work fine and we do not get an error when there is no Page level added into the Template.But as soon as we add the Page level we get the error

Below contains the expanded node screenshot of the template

Regards,

Bhargav

Re: Nprinting Error: Object Reference not set to an instance to an object

Ruggero_Piccoli — Mon, 09 Apr 2018 10:03:34 GMT

If you remove the Page and the conditional formatting what you you get?

Re: Nprinting Error: Object Reference not set to an instance to an object

bhargav_bhat — Mon, 09 Apr 2018 10:08:32 GMT

If we remove both the Page Level i.e Dim_3 Page and Conditional Formatting then we get the below table as shown below

Regards,

Bhargav

Re: Nprinting Error: Object Reference not set to an instance to an object

Ruggero_Piccoli — Mon, 09 Apr 2018 10:13:30 GMT

Ok, try to add only the Page and run a preview again to see if the Page generate the error.

Don't add the conditional formatting in this test.

Best Regards,

Ruggero

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

Re: Nprinting Error: Object Reference not set to an instance to an object

bhargav_bhat — Mon, 09 Apr 2018 10:22:16 GMT

Hi Ruggero,

I have added the Page Level i.e Dim3_Page and not the conditional formatting rule.I do not get an error and three tabs are generated as shown below

Regards,

Bhargav

Re: Nprinting Error: Object Reference not set to an instance to an object

Ruggero_Piccoli — Mon, 09 Apr 2018 12:18:24 GMT

Hi,

It seems a bug. I did a lot of tests with different Qlik NPrinting versions and different kind conditional formatting and I'm now able to reproduce. The issue appears only with Pages, if you remove the Page field the issue disappears.

I'll let you know when it will be solved.

Best Regards,

Ruggero

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