topic Re: failed to open document in QlikView

failed to open document

dseelam — Thu, 23 Jun 2016 17:31:10 GMT

Please help

not able to open document with section access and sheet access after checking strict execution in document properties

includes code

SECTION Access;

User:

LOAD

UPPER(ID) as USERNAME,

UPPER(IPNAME) & '\' & Upper(ID) as NTNAME,

UPPER(ACCESS) as ACCESS,

UPPER(SALESGROUP) as SALESGROUPNP

FROM

[$(vFldrSources)\SecAccess.xls]

(biff, embedded labels, table is Sheet1$);

SECTION Application;

[Sheet Access]:

LOAD

UPPER(ID) as USERNAME,

UPPER(SHEETACCESS) as SHEETACCESS

FROM

[$(vFldrSources)\SecAccess.xls]

(biff, embedded labels, table is Sheet1$);

left Join

SheetAccess:

LOAD

UPPER(SHEETACCESS) as SHEETACCESS,

SH01,

SH04,

SH07,

SH08,

SH10,

SH11,

SH12,

SH13,

SH14,

SH18,

SH15,

SH16,

SH17,

SH19

FROM

[$(vFldrProjDataSources)\SHEET_Access_Master.xls]

(biff, embedded labels, table is Sheet1$)

Where not IsNull(SHEETACCESS);

Sales:

LOAD

%CustNum

UPPER(SALESGROUPNAME) as SALESGROUPNAME ,

USERNAME as ACCT_NUM

FROM

[$(vFldrProjWorkspace)\HHF.qvd] (qvd);

dont see any errors in my code and its working perfectly alright in my local server but throwing error once its published in accesspoint

Re: failed to open document

krishnacbe — Thu, 23 Jun 2016 17:36:11 GMT

Hi,

Do you face the problem only in access point?

Re: failed to open document

dseelam — Thu, 23 Jun 2016 18:03:07 GMT

Yes Krishnapriya, i tried using different browsers and faced same error ?

Re: failed to open document

krishnacbe — Thu, 23 Jun 2016 18:10:22 GMT

you are able to open the file in QV desktop?

Re: failed to open document

dseelam — Thu, 23 Jun 2016 18:11:45 GMT

Yes

Re: failed to open document

krishnacbe — Thu, 23 Jun 2016 18:14:03 GMT

does your Browser is enabled with SSO? if so verify whether the NTNAME is same as you defined in Section access part.

UPPER(IPNAME) & '\' & Upper(ID) as NTNAME

Re: failed to open document

dseelam — Thu, 23 Jun 2016 18:21:49 GMT

I am not so experienced about sso

but these are my settings in attachment do you think need to be changed

Re: failed to open document

krishnacbe — Thu, 23 Jun 2016 18:24:48 GMT

Ok. Try this command =OSUser() in any QVW file that is the NTNAME. Please check whether your section access NTNAME and this matches.

Hopefully check whether you need to add your domain name + User ID as NTNAME.

Re: failed to open document

krishnacbe — Thu, 23 Jun 2016 18:28:29 GMT

In top right corner of your access point you can find the NTNAME.

Re: failed to open document

dseelam — Thu, 23 Jun 2016 18:30:50 GMT

YES They matched accept in section access it is capital letters

eg: section access: it is CISCO/DSEELAM

QVW: CISCO/dseelam

Accesspoint : CISCO/dseelam

think it doesn't matter

Re: failed to open document

krishnacbe — Thu, 23 Jun 2016 18:38:54 GMT

Ok. try to add the section access -- Section application part as your last part of script and check.

one more suggestion, try with USERID option first then go for NTNAME. If possible share me the application without section access I will try to troubleshoot.

Re: failed to open document

dseelam — Thu, 23 Jun 2016 19:08:51 GMT

Still the same issue

I cant send you document sorry its an executive

Re: failed to open document

krishnacbe — Thu, 23 Jun 2016 19:26:01 GMT

can you share the sample data for three tables that you have used for Section access.

Without knowing the data it will be very difficult to fix the issue.