EducationSoftwareStrategy.com
StrategyCommunity

Knowledge Base

Product

Community

Knowledge Base

TopicsBrowse ArticlesDeveloper Zone

Product

Download SoftwareProduct DocumentationSecurity Hub

Education

Tutorial VideosSolution GalleryEducation courses

Community

GuidelinesGrandmastersEvents
x_social-icon_white.svglinkedin_social-icon_white.svg
Strategy logoCommunity

© Strategy Inc. All Rights Reserved.

LegalTerms of UsePrivacy Policy
  1. Home
  3. Topics

KB20671: 'ORA-00972: identifier is too long' error appears when executing a report against an Oracle database

Community Admin

• Strategy

The following error appears when executing a report against an Oracle database: "ORA-00972: identifier is too long"

SYMPTOM:
The following error appears when executing a report against an Oracle database:


QueryEngine encountered error: Execute Query failed. Error type: Odbc error. Odbc operation attempted: SQLExecDirect. ORA-00972: identifier is too long Error in Process method of Component: QueryEngineServer, Project YYY, Job 3576, Error Code= -2147212544.

 
 
CAUSE:
Oracle has a 30 character restriction for all object names. A table or column name during the execution of the report exceeded the limit. By default Strategy will not create intermediate tables over 30 characters, however this can be affected by the table prefix specified in the VLDB properties of the report or the database instance as shown below.

ka04W000000Og0nQAC_0EM440000002UqA.jpeg

 
The report SQL will include the prefix as part of the table name:

ka04W000000Og0nQAC_0EM440000002Uq8.jpeg

 
ACTION:
Specify a table prefix that does not exceed the 30 character limit.  If the intended action was to create the temporary table in a user space include the '.' character after the prefix.
 

Comment

0 comments

Details

Knowledge Article

Published:

July 14, 2017

Last Updated:

July 14, 2017