Qlik Sense Reload fails randomly; Unknown LOAD statement error
Hello, as the title suggests, I am currently getting an "Unknown LOAD statement error" message when I am trying to reload my app. The strange part is that this doesn't happen on every reload. Most of the time, it reloads fine, but every once in a while it will give this error message. If you try to reload after getting the error, it will reload just fine. Even so, we have a reload task scheduled to execute nightly, so we don't want it failing during that.
It always fails at the same place, typically 10 seconds in when we are getting our Section Access set up.
'ADMIN' AS ACCESS,
userid AS USERID,
field1 AS FIELD_1,
field2 AS FIELD_2,
field3 AS FIELD_3
SQL SELECT * FROM Users;
Load * Inline [
It fails during the "Concatenate Load * Inline" statement. I have this included so that it will allow the reload task to run.
Re: Qlik Sense Reload fails randomly; Unknown LOAD statement error
Yes, I am giving ADMIN access to all the users. Our scripts are very similar, except when I am concatenating on the INTERNAL\SA_SCHEDULER user, I am doing so with an inline load rather than a normal load statement like you are. I am also not including the other reduction fields because it shouldn't matter when concatenating two tables together.
And like I said, the way I have it works a majority of the time, but it fails seemingly at random.