Oracle Fluent Model FK Name is too long

6 posts, 0 answers
  1. JORGE
    JORGE avatar
    4 posts
    Member since:
    Jul 2014

    Posted 10 Dec 2014 Link to this post

    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.
  2. Doroteya
    Admin
    Doroteya avatar
    502 posts

    Posted 12 Dec 2014 Link to this post

    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
     
    OpenAccess ORM is now Telerik Data Access. For more information on the new names, please, check out the Telerik Product Map.
     
  3. DevCraft banner
  4. JORGE
    JORGE avatar
    4 posts
    Member since:
    Jul 2014

    Posted 12 Dec 2014 in reply to Doroteya Link to this post

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

    Thanks for you response.
  5. Doroteya
    Admin
    Doroteya avatar
    502 posts

    Posted 15 Dec 2014 Link to this post

    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
     
    OpenAccess ORM is now Telerik Data Access. For more information on the new names, please, check out the Telerik Product Map.
     
  6. JORGE
    JORGE avatar
    4 posts
    Member since:
    Jul 2014

    Posted 28 Aug 2015 Link to this post

    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

  7. Doroteya
    Admin
    Doroteya avatar
    502 posts

    Posted 02 Sep 2015 Link to this post

    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
     
    Check out the latest announcement about Telerik Data Access vNext as a powerful framework able to solve core development problems.
Back to Top
DevCraft banner