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 JULY 27, 2022

Applies to:

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

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