E-NV: Errors "Access Denied, unable to post files to repository", "No files found for process instance" While Performing Web Drilldown (Doc ID 636864.1)

Last updated on AUGUST 03, 2014

Applies to:

PeopleSoft Enterprise PT PeopleTools - Version 8.4 to 8.49 [Release 8.4]
Information in this document applies to any platform.
SPECIFIC TO: Tools 8.45, nvision web drilldown
** Currency check on 4th August 2014**
Checked for relevance on 12-Oct-2011

Symptoms

In order for Report Distribution to work with http protocol, the oprid that starts the Process Scheduler has to have the ProcessSchedulerAdmin Role.

However, a user that simply runs reports over the web also has to have this role in order to successfully run an nVision web drilldown. Without this role, the user can run regular nVision reports and they post successfully. But if the user attempts a web drilldown on a report, the drilldown goes to "No Success" if they do not have the ProcessSchedulerAdmin role, and generates the following error messages in the log:

OprId = JOE1 <--- (whatever the user ID is that is attempting the drilldown)
PS_TOKEN=oQAAAAQDAgEBAAAAvAIAAAAAAAAsAAAABABTaGRyAk4AaQg4AC4AMQ
AwABRy6sgLcscNcxugT6IGfxrrF1FjIGEAAAAFAFNkYXRhVXicJYpBDkAwFERfS8TKTUhLEQd
AYkET9tbu6HAmNS+Z//IzD5Bn1hjd15JSbhzMeIqZnZUqcrJwcesbCS1OBGpNvPp3J29kQd2Lhikx
MtDBBy/sCrg=

Access Denied, unable to post file(s) to repository. (63,124)
Message Set Number: 63
Message Number: 124
Message Reason: Access Denied, unable to post file(s) to repository. (63,124)

No files found for process instance: 5898 (63,105)
Message Set Number: 63
Message Number: 105
Message Reason: No files found for process instance: %1 (63,105)

'Excel interface exception [e:\pt845-903b-retail\peopletools\src\psnxl\gridapp.cpp:2006] 'D:\FILESERVER\DOMAINNAME\NVISION\INSTANCE\FSDETAIL.xls' could not be found. Check the spelling of the file name, and verify that the file location is correct.

If you are trying to open the file from your list of most recently used files on the File menu, make sure that the file has not been renamed, moved, or deleted.' Error for 'Microsoft Excel: '. (28,160)
Message Set Number: 28
Message Number: 160
Message Reason: 'Excel interface exception [e:\pt845-903b-retail\peopletools\src\psnxl\gridapp.cpp:2006] 'D:\FILESERVER\F880T845\NVISION\INSTANCE\FSDETAIL.xls' could not be found. Check the spelling of the file name, and verify that the file location is correct.

If you are trying to open the file from your list of most recently used files on the File menu, make sure that the file has not been renamed, moved, or deleted.' Error for 'Microsoft Excel: '. (28,160)

DrillDown only works at the intersection of an amount row and column. (28,123)
Message Set Number: 28
Message Number: 123
Message Reason: DrillDown only works at the intersection of an amount row and column. (28,123)

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms