How do I get past MobiLink wizard generating "ORA-00972: identifier is too long"?

How do I get past the MobiLink synchronization model wizard generating code that flops over the Oracle limit on identifier names?

MobiLink 12.0.0.2589

The synchronization model could not be deployed.
[Sybase][iAnywhere Solutions - Oracle][Oracle]ORA-00972: identifier is too long

[Sybase][iAnywhere Solutions - Oracle][Oracle]ORA-00972: identifier is too long

SQLCODE=972, ODBC 3 State="42000"
SQL:
CREATE OR REPLACE TRIGGER SILVER.CHANGECALLBACKREGISTRATIONS_UPD BEFORE UPDATE
ON SILVER.CHANGECALLBACKREGISTRATIONS
REFERENCING
    NEW AS inserted
    OLD AS deleted
FOR EACH ROW
BEGIN
    /* Update the column LAST_MODIFIED in modified row. */
    SELECT SYSTIMESTAMP INTO :inserted.LAST_MODIFIED FROM DUAL;

END;

Error while generating output from templates
ianywhere.ml.design.generate.ScriptGenerationException: Error while generating output from templates

mobilink

asked 24 Oct '10, 20:07

Breck Carter
32.5k●539●724●1050
accept rate: 20%

flat view

One Answer:

active answers oldest answers newest answers popular answers

Here's what the documentation says:

Long object names The database objects that are created when deploying may have names that are longer than the database supports (because the new object names are created by adding suffixes to the base table names). If this happens, deploy only to file (not directly to a database) and edit the generated SQL file to replace all occurrences of the name that is too long.

Cheers,

Graham

permanent link

answered 25 Oct '10, 15:57

Graham Hurst
2.7k●1●18●43
accept rate: 29%

edited 25 Oct '10, 17:35

ha ha I'm working my way thru that topic the hard way :)

(25 Oct '10, 16:03) Breck Carter

flat view

Your answer

toggle preview

community wiki:

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

*italic* or _italic_
**bold** or __bold__
link:[text](http://url.com/ "title")
image?![alt text](/path/img.jpg "title")
numbered list: 1. Foo 2. Bar
to add a line break simply add two spaces to where you would like the new line to be.
basic HTML tags are also supported

learn more about Markdown

Question tags:

mobilink ×370

question asked: 24 Oct '10, 20:07

question was seen: 4,968 times

last updated: 25 Oct '10, 17:35

SAP SQL Anywhere

How do I get past MobiLink wizard generating "ORA-00972: identifier is too long"?

Follow this question

Related questions