Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.)
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.
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.
I solved this error by updating the different tables ( because the column names have been changed ) in the NPrinting template, as follows:
I hope that it can help you.
Thanks!! works for me