E-FTP: Error 404 When Downloading File Attachments or Download Grid To Excel, Logs Show ORA-01843 (Doc ID 2164165.1)

Last updated on AUGUST 15, 2016

Applies to:

PeopleSoft Enterprise PT PeopleTools - Version 8.54 to 8.55 [Release 8.4]
Information in this document applies to any platform.

Symptoms

When downloading file attachments, or when using Download Grid to download a spreadsheet, users hit 404 errors.

In the application server log, we see an ORA-01830 error on statement:
UPDATE PSPTFILE_PRCS SET LASTUPDDTTM = :1 WHERE GUID = :2

Sample Errors:
-------------------------------
PSAPPSRV.11974 (2754) [2016-04-13T04:00:08.197 user@server (Others 0; WIN) ICPanel](3) File: /vob/peopletools/src/pspcm/pcmeweb.cppSQL error. Stmt #: 22043 Error Position: 40 Return: 1843 - ORA-01843: not a valid month Failed SQL stmt: UPDATE PSPTFILE_PRCS SET LASTUPDDTTM = :1 WHERE GUID = :2
PSAPPSRV.11974 (2754) [2016-04-13T04:00:08.197 user@server (Others 0; WIN) ICPanel](0) PcmCFileDownloadInfo::SaveFileDownloadInfo: SamExec failed attempting to update PSPTFILE_PRCS.

PSAPPSRV.5913 (6) [2016-05-13T06:42:03.079 user@server (IE 10.0; WIN7) ICPanel](3) File: /vob/peopletools/src/pspcm/pcmeweb.cppSQL error. Stmt #: 22043 Error Position: 40 Return: 1830 - ORA-01830: date format picture ends before converting entire input string
Failed SQL stmt: UPDATE PSPTFILE_PRCS SET LASTUPDDTTM = :1 WHERE GUID = :2
PSAPPSRV.5921 (8) [2016-05-13T06:42:03.583 user@server FileAttach](1) While processing:
PSAPPSRV.5921 (8) [2016-05-13T06:42:03.583 user@server FileAttach](1) PcmCFileDownloadInfo::IsAccessToFileAllowed (error): failed to read from security table.

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