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:
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?
JPMorgan Chase & Company
US
Hi,
Prior to Oracle version 12.2, identifiers are not allowed to exceed 30 characters in length. See the Oracle SQL Language Reference.
Hi,
Prior to Oracle version 12.2, identifiers are not allowed to exceed 30 characters in length. See the Oracle SQL Language Reference.
However, from version 12.2 they can be up to 128 bytes long. (Note: bytes, not characters)