Question

1
Replies
233
Views
nimmm Member since 2017 1 post
PEGA
Posted: 2 years ago
Last activity: 2 years 5 months ago
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…, 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