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

[Breck_Carter]

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

[Former Member · Accepted solution]

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

[Breck_Carter · Accepted solution]

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