My Oracle Support Banner

E-BIP/XMLP: BI Publisher Query Report Viewer Page Issue With Error "ORA-01691: unable to extend lob segment " in Application Server Log File. (Doc ID 2496189.1)

Last updated on DECEMBER 20, 2019

Applies to:

PeopleSoft Enterprise PT PeopleTools - Version 8.52 and later
Information in this document applies to any platform.

Symptoms

The issue can be reproduced with the following steps:

1. Navigate to Reporting tools-->BI Publisher--> Query report viewer

2. Provide required data to after clicking "view report" hyper link

3. After clicking "ok" button spinning wheel occurring later PIA is sign out.

 Below error is captured in application server log file.

PSAPPSRV.28135 (263) [01/18/19 08:23:34 <OPRID>@<IP> (CHROME 71.0.3578.98; WINNT) ICPanel](3) File: /vob/peopletools/src/pspcm/pcmeweb.cppSQL error. Stmt #: 9917 Error Position: 0 Return: 1691 - ORA-01691: unable to extend lob segment SYSADM.SYS_LOB0000105809C00007$$ by 8192 in tablespace PSIMAGE

Failed SQL stmt:INSERT INTO PSFILE_ATTDET (ATTACHSYSFILENAME, FILE_SEQ, VERSION, FILE_SIZE, LASTUPDDTTM, LASTUPDOPRID, FILE_DATA) VALUES (:1,:2,:3,:4,TO_TIMESTAMP(:5,'YYYY-MM-DD-HH24.MI.SS.FF'),:6,:7)

PSAPPSRV.28135 (263) [01/18/19 08:23:34 <OPRID>@<IP> (CHROME 71.0.3578.98; WINNT) ICPanel](1) While processing:

PSAPPSRV.28135 (263) [01/18/19 08:23:34 <OPRID>@<IP> (CHROME 71.0.3578.98; WINNT) ICPanel](1) ExecutePutAttachmentDB (error): SamExec failed.

PSAPPSRV.28135 (263) [01/18/19 08:23:34 <OPRID>@<IP> (CHROME 71.0.3578.98; WINNT) ICPanel](1) More information regarding preceding error may follow.

PSAPPSRV.28135 (263) [01/18/19 08:23:34 <OPRID>@<IP> (CHROME 71.0.3578.98; WINNT) ICPanel](1) While processing where:

PSAPPSRV.28135 (263) [01/18/19 08:23:34 <OPRID>@<IP> (CHROME 71.0.3578.98; WINNT) ICPanel](1) specified (masked) URL = "record://PSFILE_ATTDET".

PSAPPSRV.28135 (263) [01/18/19 08:23:34 <OPRID>@<IP> (CHROME 71.0.3578.98; WINNT) ICPanel](1) specified system file name = "vaxmlp_4adf2b7a-1ab7-11e9-ac35-8c5cdad59e70".

PSAPPSRV.28135 (263) [01/18/19 08:23:34 <OPRID>@<IP> (CHROME 71.0.3578.98; WINNT) ICPanel](1) specified local file name = "%PS_HOME%/XMLP/496c1d8e-1ab7-11e9-ac35-8c5cdad59e70/E_EOR_REPORT.pdf".

PSAPPSRV.28135 (263) [01/18/19 08:23:34 <OPRID>@<IP> (CHROME 71.0.3578.98; WINNT) ICPanel](1) EvalPutAttachment (error): return code (1) indicates attempt to upload file to storage failed.

PSAPPSRV.28135 (263) [01/18/19 08:23:34 <OPRID>@<IP> (CHROME 71.0.3578.98; WINNT) ICPanel](0) PCodeWTL(1/3): PSXP_RPTDEFNMANAGER:Utility.ViewXMLPAttachment failed. PutAttachment error: 1 vaxmlp_4adf2b7a-1ab7-11e9-ac35-8c5cdad59e70%PS_HOME%/XMLP/496c1d8e-1ab7-11e9-ac35-8c5cdad59e70/E_EOR_REPORT.pdf

PSAPPSRV.28117 (267) [01/18/19 08:23:50 GetCertificate](0) LDAP Search Transaction: SUCCESS

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Changes
Cause
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.