Knowledge Base Article #162 - Recieving an "ORA-00972: Identifier is too Long" errror when copying relay settings.
DateJan 29, 2008
ByENOSERV
Filed UnderPowerBase Install
ClassGeneral
 
Issue Addressed
When trying to perform the copy operation on a set of settings, the user recieves an "ORA-00972: Identifier is too Long" error.

The error seems to coorespond to a specific settings form, and setting creation and editing works as usual.
 
Causes of Issue
This issue is usually caused by parenthesis ( )'s used in column names either in the table or view. During the copy operation, the query can interpret these parenthesis as the start of a function call, resulting in the error.
 
Solution to this Issue
Removing or replacing the parenthesis from the view or table will resolve the problem. Replacing the parenthesis with brackets [ ]'s should work.

Login to Support
Email:
Password:
Contact Support to reset your password

Support Links
Support Main
Register for Support
Knowledge Base

Contact Support
Phone:
(918) 622-4530
. . . . . . . . . . . . . . . . .
Email:
[email protected]