Oracle Fluent Model FK Name is too long

[JORGE]

Hi Telerik People

I have a fluent model attached to a Oracle Database but when I configure a new association between to tables I receive this error during the schema update "ORA-00972: identifier is too long".  This is because both tables have long names.

¿There is any way to specify a custom name for the FK before its creation?

Thanks for your help.

[Doroteya]

Hello Jorge,

Thank you for contacting us.

The issue you experience appears when any of the identifiers (table names, constraint names, sequence names, and etc.) in the generated DDL script are longer than 30 characters. In this connection, my best guess about the cause on your side is that the name of the constraint related to the created association becomes longer than that. The recommended way to resolve the error is to shorten the names of the participating tables in the mapping configuration. 

Another option is to update Telerik Data Access on Monday (December 15th, 2014), because in this upcoming release, we utilize a new algorithm for generating the constraint names. This algorithm makes sure that the constraint names never exceed the 30 character limitation but are unique.

I hope this helps. Do let us know if you need further information or assistance.


Regards,
Doroteya
Telerik

 

 

[JORGE]

Perfect, We'll wait for the update in order to resolve the issue.

Thanks for you response.

[Doroteya]

Hello Jorge,

Thank you for the feedback.

Currently the Q3 2014 SP1 version of Telerik Data Access is available for download from you Telerik account.

Do let us know how the things on your side are.


Regards,
Doroteya
Telerik

 

 

[JORGE]

Hi, we have just update our application to Q2 2015 and this error persists. ¿It's necesary to add any configuration in order to generate names of 30 characters less for foreign keys?

 

 Thanks in advance

[Doroteya]

Hello Jorge,

Thank you for your feedback.

In general, the new algorithm for generating constraint names automatically resolves this error for Oracle (without any further settings). To check what is going on on your side, I kindly ask you to send me the project that holds your model. To be able to do this, I am converting this forum thread to a General Feedback one. This way our communication becomes private.

I am looking forward to resolving the case with you.

Regards,
Doroteya
Telerik