Username/password prompt in access point after section access deleted

[jonathandienst]

Hi

I have an application which used to use section access. The section access has now been removed. The relevant script was deleted and the document reloaded. However, it still prompts for a username/password when loaded from the access point. Users cannot enter the document because no userIDs exist in the document.

When opened from the QV client, it does not prompt for a userID or password.

Anybody seen this? - it looks like a bug to me. Suggestions welcomed.

(Server is V9.00.7647, client is V10 IR)

Jonathan

[Miguel_Angel_Baeyens]

Hello Jonathan,

When something like that happened to me, I deleted all .shared and .meta files in the server folder where the new file is. If possible, restart QlikView services to get the document fresh loaded. In our case was the document was cached and there was a conflict between the old version with section access and the new one without it.

Hope that helps.

[jonathandienst]

Miguel

Thanks for the suggestion - this was a test server in a mounted folder and there was no meta/shared file for the affected model. Anyway, I deleted all the meta/shared files in the mounted folder and stopped the server and deleted the pgo files in the deployment root foder. There are currently no models in the deployment root folder.

But when I restarted the server, the model still prompted for a username password

Any other suggestions would be welcome.

Regards

Jonathan

[Miguel_Angel_Baeyens]

Hi Jonathan,

Any chance of a hidden script that stores some ADMIN access or something? Sounds like a section access using NTNAME so the credentials are passed on to the document when it's opened in Desktop, but not in accesspoint.

[jonathandienst]

Miguel

I agree with your reasoning, but there is no hidden script, and the include files have been commented out.

I think I may have to export the XML layout and build a new document with that! Unless you have any more ideas, of course.

Jonathan

[Miguel_Angel_Baeyens]

Jonathan,

Try with xml export, and maybe before doing just a "save as" witha different name.

Regards.

[prieper]

Just try it once to enter the below into your script and refresh:

SECTION ACCESS;
 LOAD
 *
 INLINE
 [USERID
 *];
SECTION APPLICATION;

Somehow QV still remembers the last settings, if not overwritten.

HTH
Peter

[Miguel_Angel_Baeyens]

Hello Peter,

Agreed also with that. Although in version 9, I experienced some issues when doing a partial reload instead of a reload, and then removing the section access.

Thanks!

[jonathandienst]

Peter

Do I need a Star Is *; statement with that?

Jonathan

[Miguel_Angel_Baeyens · Accepted solution]

Jonathan,

Besides that, is it possible that the document in its properties still has "Strict Exclusion" and "Reduce Data...". You will need to uncheck those to get the document working when there's no section access.

Hope that makes sense.