Skip to main content

This content has been archived and is no longer being updated. Links may not function; however, this content may be relevant to outdated versions of the product.

Support Article

SQL Error: ORA-00972: identifier is too long

SA-76916

Summary



A Business Intelligence Exchange (BIX) Extract rule is configured to extract data to a target database. The Extract rule includes a property name which is greater than 30 characters. When generating a Data Definition Language (DDL) to create a schema structure in the target database, the DDL includes the lengthy property name.
Error occurs and the DDL is not executed correctly.




CREATE TABLE GCS_Mortgage_Work
(
    "PZINSKEY" VARCHAR2(256 CHAR) NULL,
    "PXEXTRACTIDENTIFIER" VARCHAR2(256 CHAR) NULL,
    "PXEXTRACTDATETIME" TIMESTAMP NULL,
    "DEPOSIT" VARCHAR2(32 CHAR) NULL,
    "INTERESTRATE" VARCHAR2(32 CHAR) NULL,
    "MORTGAGEAMOUNT" VARCHAR2(32 CHAR) NULL,
    "MORTGAGEAPPLICATIONID" VARCHAR2(32 CHAR) NULL,
    "MORTGAGEAPPLICATIONNAME" VARCHAR2(32 CHAR) NULL,
    "MORTGAGETERM" VARCHAR2(32 CHAR) NULL,
    "ABCDEFGHIJKLMNOPQRSTUVWXYZNOWIKNOWMYABCNEXTTIMEWONTYOUSINGWITHME" VARCHAR2(32 CHAR) NULL
);


Error Messages



SQL Error: ORA-00972: identifier is too long
00972. 00000 -  "identifier is too long"
*Cause: An identifier with more than 30 characters was specified.
*Action: Specify at most 30 characters.



Steps to Reproduce

  1. Configure an Extract rule.
  2. Add properties with names which are greater than 30 characters.
  3. Run the Extract rule to generate a DDL.
  4. Execute the query generated in the database.


Root Cause



A third-party product issue.
Oracle has a limitation of 30 characters for the column name. Hence, the DDL is not executed correctly.



Resolution



Perform the following local-change:

Map the property name, which is greater than 30 characters, to a shortname.


Published April 6, 2019 - Updated December 2, 2021

Was this useful?

0% found this useful

Have a question? Get answers now.

Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.

Did you find this content helpful?

Want to help us improve this content?

We'd prefer it if you saw us at our best.

Pega Community has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice
Contact us