I am gettng failed to open document error when i try to access document from web. Section access works fine on my desktop version, also i have given admin privileges to functional account which is running tasks on publisher.
Do you have enable "strict Exclusion", open document in developer>settings>document properties>Opening>Strict Exclusion, unchecked it and save document and try again.
Are you listed as Admin in the section access script? Also if you are restricting data based on some column then you should be having access to that column in the section access script.
A rule of thumb is to get the basic section access working before you start the data reduction. They you will know which part is causing an error.
Note: Always make sure you have a backup copy of the document. If you lock yourself out there is no way to open the document.
Retrieving data ...