topic Re: Autogenerate : Generate count is Negative in QlikView

Autogenerate : Generate count is Negative

dhasharadh — Sat, 16 Nov 2024 17:39:19 GMT

Getting this below error all of a sudden, it was fine till last friday and it suddenly failed today with below error.

Error : Autogenerate : Generate Count is Negative.

Error is coming in the below script lines :

DateField_tmp:
LOAD
Date($(vDateMinN)+RowNo()-1) AS DateField
AUTOGENERATE $(vDateMaxN) - $(vDateMinN) + 1;

------ script is executed till here.
DateFieldPro_tmp:
LOAD
Date(($(vDateMaxN)+1) +RowNo()-1) AS DateFieldPro
AUTOGENERATE $(vDateProN) - ($(vDateMaxN)+1) + 1;

--- getting an error in the above lines am littterally cluless why all of a sudden this error is coming in UAT and Prod causing jobs to fail.

Please suggest the possible reason @jonathandienst @tresB @petter

Any one else who have idea on this as well please.

Re: Autogenerate : Generate count is Negative

edwin — Mon, 04 Jan 2021 16:57:36 GMT

can you look up the values of

vDateMaxN and vDateMinN

Re: Autogenerate : Generate count is Negative

dhasharadh — Tue, 05 Jan 2021 04:38:31 GMT

Hi Edwin, thanks for the reply.

vDateMaxN = 04.01.2021

vDateMinN = 01.01.2000

is anything wrong in the above values, they created as variables in the app.

Re: Autogenerate : Generate count is Negative

tresB — Tue, 05 Jan 2021 05:05:10 GMT

Somehow '$(vDateMaxN) - $(vDateMinN) + 1' is resulting to a negative number. It could be because of misinterpretation of separator ('.'). Try to convert the date value to number in the variable itself and try. Also check how and which delimiters are being used for number presentation, like decimal, thousand separator.

Re: Autogenerate : Generate count is Negative

dhasharadh — Tue, 05 Jan 2021 05:19:04 GMT

Its fixed actually,

in one of the variable declaration they mentioned it as 31.12.2020 using make date function. w

which got expired and reason for negative number during autogenerate. changed it to future date now its sorted. 🙂