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

asked 24 Oct '10, 20:07

Breck%20Carter's gravatar image

Breck Carter
27.3k424585836
accept rate: 21%


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%20Hurst's gravatar image

Graham Hurst
2.6k11843
accept rate: 28%

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
Your answer
toggle preview

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

Question tags:

×284

question asked: 24 Oct '10, 20:07

question was seen: 1,007 times

last updated: 25 Oct '10, 17:35