My Oracle Support Banner

E-RD/E-PRCS: "ORA-12899: value too large for column "SYSADM"."PS_CDM_FILE_LIST"."FILENAME" " When Running Processes (Doc ID 2830291.1)

Last updated on DECEMBER 27, 2021

Applies to:

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

Symptoms

Receiving the following error when running processes through process scheduler which generates output file name with more than 80 characters:

Failed SQL stmt: INSERT INTO PS_CDM_FILE_LIST ( PRCSINSTANCE,CONTENTID,FILENAME,CDM_FILE_TYPE,FILE_SIZE,DTTM_CREATED) VALUES (:1, :2, :3, :4, :5, TO_TIMESTAMP(:6,'YYYY-MM-DD-HH24.MI.SS.FF'))
PSDSTSRV.1864 (32) [2021-11-19T14:51:21.453 PostReport] - - - (1) =================================Error===============================
PSDSTSRV.1864 (32) [2021-11-19T14:51:21.453 PostReport] - - - (1) Database error encountered
PSDSTSRV.1864 (32) [2021-11-19T14:51:21.453 PostReport] - - - (2) Info:
PSDSTSRV.1864 (32) [2021-11-19T14:51:21.453 PostReport] - - - (2) Section:
PSDSTSRV.1864 (32) [2021-11-19T14:51:21.453 PostReport] - - - (2) Info:
PSDSTSRV.1864 (32) [2021-11-19T14:51:21.453 PostReport] - - - (2) SQL Stmt: INSERT INTO PS_CDM_FILE_LIST ( PRCSINSTANCE,CONTENTID,FILENAME,CDM_FILE_TYPE,FILE_SIZE,DTTM_CREATED) VALUES (:1, :2, :3, :4, :5, TO_TIMESTAMP(:6,'YYYY-MM-DD-HH24.MI.SS.FF'))
PSDSTSRV.1864 (32) [2021-11-19T14:51:21.454 PostReport] - - - (2) Explain: ORA-12899: value too large for column "SYSADM"."PS_CDM_FILE_LIST"."FILENAME" (actual: 84, maximum: 80)


In order to replicate the issue, follow the below steps:

1. Log into PIA.

2. Navigate to the application page.

3. Run a process that generates a file name that exceeds 80 characters (including output file extension).

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
Cause
Solution
References


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