topic Re: recover a document by removing the section access !! in QlikView

recover a document by removing the section access !!

ali_hijazi — Mon, 30 May 2011 07:33:48 GMT

Hello

I got a qlikview document in which I was trying the idea of access restriction

I added an inline section access load in which I put in the Access field the value 1 and of course a user name and a password

I reloaded the document and qlikview is asking for a user id; however it is not recognizing the username that I supplied!!!

is there a way to recover the document and remove the section access?!!!

Please help

recover a document by removing the section access !!

Anonymous — Mon, 30 May 2011 07:47:48 GMT

I don't think so.

I assume this advise will come to late for you but "ALWAYS backup before you start to work with section access"

recover a document by removing the section access !!

ali_hijazi — Mon, 30 May 2011 07:53:00 GMT

But what is wrong?

I didn't forget the password or username!

QlikView simply is not accepting the supplied user id

the Document is valuable !!

recover a document by removing the section access !!

Anonymous — Mon, 30 May 2011 07:54:35 GMT

I can't answer that question without reading your script.

Can you still access the script some how?

Re: recover a document by removing the section access !!

ali_hijazi — Mon, 30 May 2011 08:38:04 GMT

<div mcetmp="1"> I put the following on the first tab of the script<strong style="color: rgb(0, 0, 255); font-size: 8pt;" mcestyle="color: #0000ff; font-size: 8pt;"><div mcetmp="1"><span style="color: rgb(0, 0, 255); font-size: 8pt;" mcestyle="color: #0000ff; font-size: 8pt;"><div mcetmp="1">

LOAD * INLINE [
ACCESS, USERID, PASSWORD

1, alihijazi, alihijazi@1980
];
Section Application;

Re: recover a document by removing the section access !!

Mon, 30 May 2011 08:50:25 GMT

Ali_hijazi, Access Column in Session access table should always have either ADMIN or USER.qlikview never takes 1 as Access.

This has caused you the problem. As far as i know, I dont see any way to open your application.

- Sridhar

Re: recover a document by removing the section access !!

ali_hijazi — Mon, 30 May 2011 09:21:17 GMT

Isn't there any back door? the Document is valuable

Re: recover a document by removing the section access !!

Anonymous — Mon, 30 May 2011 09:31:35 GMT

I hope not. It wouldn't be much of a security if there was.

But maybe you can turn to the support department of Qliktech.

http://www.qlik.com/us/services/support/phone-email-support

Re: recover a document by removing the section access !!

erichshiino — Mon, 30 May 2011 11:02:11 GMT

As far as I know, not even QlikTech would be able to open it...

recover a document by removing the section access !!

stevedark — Tue, 14 Jun 2011 22:20:52 GMT

Another thing I always do (in addition to backing up - not instead of) is to keep the document I have just reloaded with Section Access open in QlikView and save it. I then open a new instance of QlikView and try and open the document into the new instance - keeping the orignal open.

If that works then happy days, however if you are locked out and can not open the document in the new instance the document is still open in the first instance. Section Access can then be tweaked and another reload can be done and the process repeated. You can not lock yourself out of a document without closing it first.