| Knowledge Base Article #162 - Recieving an "ORA-00972: Identifier is too Long" errror when copying relay settings. |
|---|
| Date | Jan 29, 2008 |
| By | ENOSERV |
| Filed Under | PowerBase Install |
| Class | General |
| |
| 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. |