failed to open document

[dseelam]

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

[krishnacbe]

Hi,

Do you face the problem only in access point?

[dseelam]

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

[krishnacbe]

you are able to open the file in QV desktop?

[dseelam]

Yes

[krishnacbe]

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

[dseelam]

I am not so experienced about sso

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

[krishnacbe]

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.

[krishnacbe]

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

[dseelam]

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