nimmm Member since 2017 1 post
Posted: March 20, 2018
Last activity: April 16, 2018

Script for creating the table PCM_CONFIGURATION_BESTPRACTICE throws an error "ORA-00972: identifier is too long".

Hi Team,

We are unable to import Pega Configuration manager (PCM) . SQL scripts are failing and getting the following error:

"ORA-00972: identifier is too long"

Environment setup details:

Pega Version : 7.1.8,
DB : Oracle 12C 12.1.0

Steps to Reproduce:

1. Using the import wizard, import
2. Select Manual option for executing the SQL script.
3. Download the script files for PCMClient.
4. Execute the SQL Script using the SQLClient.
5. While executing the Script for creating the table PCM_CONFIGURATION_BESTPRACTICE, It throws an error, "ORA-00972: identifier is too long".

In reference to this article,, table name should be 1-30 bytes.

In this case, PCM_CONFIGURATION_BESTPRACTICE, increases the limitation of 30 bytes. Hence, the error occurs.

Can anyone help us out in this issue?

Low-Code App Development Upgrades
Moderation Team has archived post
Share this page LinkedIn