Hi,
I'm trying to reload a Document on a Server but fail to. Here's the log:
<Root TaskID="1aa7c869-545c-68b0-2377-410a8b113397" OwnedByClusterID="1" RunID="5f0b546c-ff36-48c9-b93a-ebf203c03824" TaskManuallyAborted="False" TaskException=" " PreviousRunHadErrors="True" InternalError="True" LastExecution="8/9/2011 9:19:36 AM" StartedAt="8/9/2011 9:19:36 AM" FinishedAt="8/9/2011 9:19:36 AM" MaxRunTime="1.00:00:00" StartCount="10" HasWarnings="False" Status="Finished">
</LogFinalEntries>
</Root>
The following key information should suffice to describe the setup:
Server :
Document :
What have I tried / tested so far?
Can anyone give me a hint what else I could try?`
Cheers & TIA
Seb
Hi,
If you comment the section access and reload the document, then sure your document will not have anything, not even section access, but if you just delete the script and the sheet with object, then also your application will have data. Data will be erased only when you reload with nothing.
See if you have Section access in your document and you just have user access then it depends on the configuration done by Admin. Meaning your admin might have done setting to not to allow user to reload the document. in this case you will not be able to reload the document even on the desktop environment.
Regards,
Kaushik Solanki
Hi,
As log says, it is unable to open the document.
The reason is you have section access, so you need to specify the Admin username and password in reload tab.
I dont know where that setting resides in QS 9.
But in QV10 its in reload tab.
Regards,
Kaushik Solanki
@Kaushik : In order to check this, I turned off restrictive mode and commented out the section access part without any changes...
Here's some more detail :
LOAD if(UPPER(USERNAME) = 'TECHUSER','ADMIN',
if(UPPER(USERNAME) = 'MYUSER','ADMIN',
'USER')) as ACCESS,
UPPER(USERNAME) as NTNAME
SQL SELECT *
FROM USERS
Hi,
If you comment the section access and reload the document, then sure your document will not have anything, not even section access, but if you just delete the script and the sheet with object, then also your application will have data. Data will be erased only when you reload with nothing.
See if you have Section access in your document and you just have user access then it depends on the configuration done by Admin. Meaning your admin might have done setting to not to allow user to reload the document. in this case you will not be able to reload the document even on the desktop environment.
Regards,
Kaushik Solanki
So, maybe I have a little problem understanding the concept of section access.
If I reload my data, my section access information will be loaded as well.
If I truncate my data (using the option that removes all data) will my access information be discarded as well? Or does that happen only when you reload?
@Kaushik: you were right, I was plainly locked out.
As mentioned above, I load section access like so :
LOAD if(UPPER(USERNAME) = 'TECHUSER','ADMIN',
if(UPPER(USERNAME) = 'MYUSER','ADMIN',
'USER')) as ACCESS,
UPPER(USERNAME) as NTNAME
SQL SELECT *
FROM USERS
I have just checked the Users table, and the user wasn't in there. So, section access works as intended...
one possible reason is if your qlikview server disconnecting from network in that situation you reload fails.