topic Re: Request failed On-Demand, Pages limitations maybe? in Qlik NPrinting

Request failed On-Demand, Pages limitations maybe?

Diego_780 — Mon, 14 Mar 2022 10:59:48 GMT

Hi,

So I have this On-Demand Excel report (.xlsx) in which I create a new sheet for each person (with the feature: Pages) it finds in the filters in the QlikSense App, and put in each respective sheet, the persons data, calculations or whatever.

I have a problem in which if there is too much people, the On-Demand doesn´t generate it and it´s error says "Request failed", but if I filter with some of them, it generates it all good.

Is there a limitation to this feature or what could be happening?

Thanks in regards.

Re: Request failed On-Demand, Pages limitations maybe?

Lech_Miszkiewicz — Mon, 14 Mar 2022 11:08:58 GMT

Do you have any fields with "Always one selected values" in your Qlik Sense app?

If you do then those are not supported and must be removed.

check documentation here: https://help.qlik.com/en-US/nprinting/May2021/Content/NPrinting/GettingStarted/HowCreateConnections/Connect-to-QlikSense-apps.htm

cheers

Lech

Re: Request failed On-Demand, Pages limitations maybe?

Lech_Miszkiewicz — Mon, 14 Mar 2022 11:09:44 GMT

...Or if you have any filters set on report (other than selections applied by users) then those can result in empty set and cause similar error.

Re: Request failed On-Demand, Pages limitations maybe?

Diego_780 — Tue, 15 Mar 2022 08:19:02 GMT

I don´t have any filters applied to the report in NPrinting, I have 2 created but I´m not applying them. And I think I dont have anything of the unsupported qliksense objects but I´m not sure. I think it has to be with the number of persons as I mentioned before, because it´s the only logical thing I can figure.

Ok, if I get more than x persons, it just doens´t do it (limitations?) but if I select below the x amount of persons it does generate. So that´s why I don´t know, if NPrinting has this limitation, because it´s creating a lot of new sheets with tables and maybe theres a limit, or limitation in generating data in general, because theres a ton of data that I do filter (10 years).

Re: Request failed On-Demand, Pages limitations maybe?

Lech_Miszkiewicz — Tue, 15 Mar 2022 08:36:05 GMT

Hi,

It is not NPrinting but EXCEL limitation is 255 sheets. Is that the number of sheets you are creating or going over?

Re: Request failed On-Demand, Pages limitations maybe?

Diego_780 — Tue, 15 Mar 2022 08:44:06 GMT

Mmm then no, the maximum persons are 31 then it has to be something mentioned above I guess? But I don´t know why it works with some and not with all of them, it doesn´t make sense to me, why some?

Thanks

Re: Request failed On-Demand, Pages limitations maybe?

Lech_Miszkiewicz — Tue, 15 Mar 2022 08:50:54 GMT

Re: Request failed On-Demand, Pages limitations maybe?

Lech_Miszkiewicz — Tue, 15 Mar 2022 08:56:12 GMT

Excel sheets may not accept some characters. Are there any unusual characters in values you are using in <Page> node?

Re: Request failed On-Demand, Pages limitations maybe?

Frank_S — Tue, 15 Mar 2022 20:25:20 GMT

@Diego_780

It would be interesting to know if the same filters work in some instances but fails in others.

If you are able to reproduce the behavior ie I more than 30 users on the system or less that 30 users on the system (generating reports simultaneously) with failures with more than thirty and success with thirty or less., this would certainly merit opening a support case for deeper investigation.

Otherwise please have a look at these articles for known 'request failed' know issues and solutions:

Kind regards...

Re: Request failed On-Demand, Pages limitations maybe?

Diego_780 — Wed, 16 Mar 2022 08:29:45 GMT

I thought of that but all the "rare" characters show perfectly, for example: . , ñ, all of them are shown in the sheets name, so it´s not that.

Regardless, I´ll try to do it again from scratch as a new report because maybe there is something conflictive in the main one right now.

Re: Request failed On-Demand, Pages limitations maybe?

Lech_Miszkiewicz — Wed, 16 Mar 2022 08:46:59 GMT

Sure.
start maybe just with the page and let us know how it goes

Re: Request failed On-Demand, Pages limitations maybe?

Diego_780 — Mon, 21 Mar 2022 07:45:01 GMT

Okay so I think what´s happening is that it wasn´t working because I had 2 names that were practically the same, one just started with a capital letter and the other didn´t (eg: person x, Person x). When this two values are selected, nprinting gives me the Request failed but if I just select one of it, or none, it doesn´t, so I´m thinking it has to be that.

Re: Request failed On-Demand, Pages limitations maybe?

Lech_Miszkiewicz — Mon, 21 Mar 2022 08:05:48 GMT

sure - it is likely this.

Excel does not allow for 2 sheets with the same name and since excel is not case sensitive scenario you describe is likely the case.

solution would be to add numerical suffix to such field values to ensure they are unique also in excel.

cheers