Skip to main content
Announcements
Defect acknowledgement with Nprinting Engine May 2022 SR2, please READ HERE
cancel
Showing results for 
Search instead for 
Did you mean: 
kdmarkee
Specialist
Specialist

NPrinting 17 - Sequence contains no elements

I haven't found much in the Community but am hoping someone can offer some advice, solution or suggestion.  I am running an NP report via On Demand (QlikView) and the scenario I have results in "Error" in the On Demand window and no report is generated.  When I check the NP schedule log, it basically says "Sequence contains no elements" (full error below).  I thought it might do with the fact that I have a table box that ends up with no data, which is ok, but is NP choking on it?  So then I experimented with the NP report designer field objects/items in the properties for "Process Null Values" and also for "Null Value Text" but nothing I experiment with helps.  Any help would be greatly appreciated, thank you.

Failed report generation for report 6577985d-0705-47bb-b06a-4d67d4d5b6d1 user 872feae4-c912-4923-8073-6de23300014b exception System.Exception: An exception was thrown while invoking the constructor 'Void .ctor(Engine.Reporting.Legacy.DataAdapters.IDataParent, System.Collections.Generic.IEnumerable`1[Qlik.Reporting.Reports.Tree.Content.IContentNode], System.Collections.Generic.IEnumerable`1[Qlik.Reporting.Reports.Tree.Template.TemplateNodeSettings], Autofac.ILifetimeScope)' on type 'DataEntity'. ---> Sequence contains no elements (See inner exception for details.)

4 Replies
Frank_S
Support
Support

This is an edge case where this error can occur when you have a corrupted NPrinting service account or the service account does not have full administrative privileges on the NPrinting server.

1. Check that the NP service account is a domain account and ensure this account is added to the local administrators group. (Ensure that this account is also not shared with any other server service).

2. Check that it can make changes to the Local Security Policy editor. While in this editor, make sure you can add the NP service account to the local policies/user rights assignment/log on as a service right. (If it cannot make this change then this account does not have full administrative permissions. This can happen with Group Policy limits the behavior of certain accounts). This may also indicate that the account may have also become corrupted and will need to be replaced.

Please remember hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!
kdmarkee
Specialist
Specialist
Author

The issue is related to a tablebox that has no data in it, not even null values, because when I run other selections and scenarios where data populates the tablebox, it works find.  So I am trying to find a work around and will share that when/if I get something working.

alaya_mourad_90
Contributor
Contributor

I solved this error by updating the different tables ( because the column names have been changed ) in the NPrinting template, as follows:

capture nprinting.png

I hope that it can help you.

knhack
Contributor
Contributor

Thanks!! works for me