Failed to retrieve the automatically incremented column value from the server. Possible reason: A trigger does not perform 'select ID from inserted' a

5 posts, 1 answers
  1. Marco
    Marco avatar
    11 posts
    Member since:
    Jan 2014

    Posted 26 Sep Link to this post

    Hello,

    since I changed the SQL Server to version 2016, sometimes I get an error after inserting rows:

    Failed to retrieve the automatically incremented column value from the server. Possible reason: A trigger does not perform 'select ID from inserted' as last operation.

    I replaced the openAccess.Runtime.dll with a hotfix version 2015.1.225.1 --> But also with this version the error still apperars.

    Any Ideas?

    Thanks for helping.

    Regards, Marco.

  2. Marco
    Marco avatar
    11 posts
    Member since:
    Jan 2014

    Posted 26 Sep Link to this post

    Additional informations:

    The select @@version command on SQL Server 2016 brings following response:

    Microsoft SQL Server 2016 (RTM-GDR) (KB3179258) - 13.0.1711.0 (X64)   Jul 29 2016 16:16:44   Copyright (c) Microsoft Corporation  Developer Edition (64-bit) on Windows Server 2012 R2 Standard 6.3 <X64> (Build 9600: ) (Hypervisor) 

    Has DataAccess a problem with the new Format??

  3. DevCraft banner
  4. Doroteya
    Admin
    Doroteya avatar
    502 posts

    Posted 29 Sep Link to this post

    Hello Marco,

    The error you experience is due to the lack of support for SQL Server 2016 in Data Access Q1 2016. Such support is added for the first time in Data Access Q2 2016; since today Data Access Q2 2016 is live and you can obtain the NuGet packages from here.

    I hope this helps.

    Regards,
    Doroteya
    Telerik by Progress
     
    Check out the latest announcement about Telerik Data Access vNext as a powerful framework able to solve core development problems.
  5. Marco
    Marco avatar
    11 posts
    Member since:
    Jan 2014

    Posted 29 Sep in reply to Doroteya Link to this post

    Thank You for answering.

    I'm using the domain model method. This method is not longer supportet on Data Access Q2 2016, is this correct?

    So if I have a SQL Server 2016, I need the Data Access Q2 2016 and then I change my persitend layer to the fluent model?

    Is this a possible solution?

    I heard that it gives an easy method to convert the domain model in an fluent model?

    Thanks for helping,

    Regards Marco.

  6. Answer
    Doroteya
    Admin
    Doroteya avatar
    502 posts

    Posted 04 Oct Link to this post

    Hi Marco,

    Both of your assumptions are correct:
    - Data Access Q2 2016 doesn't support the Visual Studio integration (it was deprecated in Data Access Q2 2016).
    - If you have SQL Server 2016, you need Data Access Q2 2016 and a fluent model.

    As for the workflow for converting .rlinq files to fluent models, this blog post contains it.

    Regards,
    Doroteya
    Telerik by Progress
     
    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