Question

1
Replies
244
Views
nimmm Member since 2017 1 post
PEGA
Posted: March 20, 2018
Last activity: April 16, 2018
Closed

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 PCMClient.zip.
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, https://docs.oracle.com/cd/B28359_01/server.111/b28286/sql_elements008.htm#SQLRF00223, 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