Data Access broken after 7/19 SQL update

31 posts, 0 answers
  1. Bill
    Bill avatar
    4 posts
    Member since:
    Sep 2008

    Posted 25 Jul 2016 Link to this post

    On 7/19 Microsoft pushed out "Microsoft SQL Server 2014 SP1 Cumulative Update (CU) 7 KB3162659". I'm running 2015 Express, and that update broke Data Access - any time I try to do an insert I get the error "Failed to retrieve the automatically incremented column value from the server". The insert does actually work, however, I checked.

    Suggestions? I'm completely down at the moment...

  2. Bill
    Bill avatar
    4 posts
    Member since:
    Sep 2008

    Posted 25 Jul 2016 in reply to Bill Link to this post

    Also, this is Q1 2015 Data Access.
  3. Bill
    Bill avatar
    4 posts
    Member since:
    Sep 2008

    Posted 25 Jul 2016 in reply to Bill Link to this post

    Also, this is Q1 2015 Data Access.
  4. Doroteya
    Admin
    Doroteya avatar
    500 posts

    Posted 27 Jul 2016 Link to this post

    Hi Bill,

    Attached to this message is the hot fix for the version on your side and a video tutorial how to upgrade your machine.

    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. Zdenek Plachy
    Zdenek Plachy avatar
    29 posts
    Member since:
    May 2007

    Posted 11 Nov 2016 in reply to Doroteya Link to this post

    Our working application suddenly crashed on same error today. Without any change in code application started to fail on all inserts with error: 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.

    It is possible that MSSQL server (11.0.6248.0) on Windows Server 2012R2 got some update today.

    We are using DataAccess Runtime 2015.1.255.1 with installed hotfix as described in video tutorial. No luck. Please help!

  6. Christina Faur
    Christina Faur avatar
    5 posts
    Member since:
    Aug 2009

    Posted 15 Nov 2016 in reply to Zdenek Plachy Link to this post

    Hello Zdenek,

    we have the same Problem with Microsoft SQL Server 2012 (SP3-GDR) (KB3194721) - 11.0.6248.0 (X64)

    Do you already have a solution for this problem?

    Thanks,

    Christina
     

  7. Christina Faur
    Christina Faur avatar
    5 posts
    Member since:
    Aug 2009

    Posted 15 Nov 2016 in reply to Doroteya Link to this post

    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.

    Microsoft SQL Server 2012 (SP3-GDR) (KB3194721) - 11.0.6248.0 (X64)

    Hotfix1.zip doesn't work.

    Please help,

    Christina

  8. Zdenek Plachy
    Zdenek Plachy avatar
    29 posts
    Member since:
    May 2007

    Posted 16 Nov 2016 in reply to Christina Faur Link to this post

    Hi Christina,

    we managed to make it working again somehow. Try to repat all steps in instructional video (don't forget to refresh GAC). Then PROBABLY helped server restart. Now we are back. At first attempt it didn't work then probably after that restart it is worknig.

    Anyway it's not generally good situation. I'm Telerik's paying customer for long years. I tried almost first time to send official support ticket. I got reply after two days. They told me simply that Telerik Open Access is not part of my (expensive!) DevCraft Complete license. No advice, no help.

    With all those changes with Telerik Data Access (no support, dropping designer from 2015.Q1, supporting only stupid code first approach...) I'm not sure to continue with TDA in future projects. It is or better it was best ORM but now I'm not sure.

  9. Christina Faur
    Christina Faur avatar
    5 posts
    Member since:
    Aug 2009

    Posted 16 Nov 2016 in reply to Zdenek Plachy Link to this post

    Hello Zdenek,

    thank you very much for your kind answer. Then I will also retry all the steps and will restart the server.

    We are also seriously thinking to replace Telerik.OpenAccess (Classic) with EntityFramework 6 because on my opinion switching on Telerik.DataAccess with code first approach needs the same programming effort.

    Best Regards,
  10. Christina Faur
    Christina Faur avatar
    5 posts
    Member since:
    Aug 2009

    Posted 16 Nov 2016 in reply to Zdenek Plachy Link to this post

    Hello Zdenek,

    thank you very much for your kind answer. Then I will also retry all the steps and will restart the server.

    We are also seriously thinking to replace Telerik.OpenAccess (Classic) with EntityFramework 6 because on my opinion switching on Telerik.DataAccess with code first approach
    needs the same effort.

    Best Regards,
  11. Doroteya
    Admin
    Doroteya avatar
    500 posts

    Posted 16 Nov 2016 Link to this post

    Hi,

    The video attached to this thread shows how to update the Runtime assembly on your machine. After you do so, you need to:
    1. Open your solution in Visual Studio and clean it up.
    2. Rebuild your solution making sure that it is configured as described in this blog post.

    At this point you can run the application for a test and if you need to you can deploy it to the server.

    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.
  12. Nicolo
    Nicolo avatar
    4 posts
    Member since:
    Dec 2012

    Posted 30 Jan in reply to Doroteya Link to this post

    Hello Doroteya

    I took me two days to find the cause of persisting problems within a LOB application, till i found this thread. As i understand this fix isn't listed within the official download at http://www.telerik.com/support/whats-new/data-access/release-history. Also i can't see it from within my Telerik user account.

    Tell me i'm wrong.

    Regards,
    Nicolo

  13. Viktor Zhivkov
    Admin
    Viktor Zhivkov avatar
    312 posts

    Posted 31 Jan Link to this post

    Hello Nicolo,

    What is the version that your are using at the moment?
    I might be able to get you a hotfix patch for the affected assembly.
    Another option is to use any Telerik Data Access NuGet packages with version greater or equal to 2015.3.926.1 (2015 Q3) as the fix is already integrated there.

    Regards,
    Viktor Zhivkov
    Telerik by Progress
     
    Check out the latest announcement about Telerik Data Access vNext as a powerful framework able to solve core development problems.
  14. Dave
    Dave avatar
    7 posts
    Member since:
    May 2013

    Posted 11 Feb in reply to Viktor Zhivkov Link to this post

    Viktor & Doroteya,

     

    Go back to your team manager|project manager or better yet, speak to your sales team and put a serious proposal that the marketplace and your customers are not being serviced by a solution that would take Telerik minimum effort to provide a solution that "existing" customers would gladly play for a subscription to have peace of mind.

    The proposal - to spin off the already invested work of the designer into a product put in an external container NOT in VSisual Studio that uses the same code but enables the "large" existing userbase which prefer the vastly superior domain model method (which many of us have created the easy method of upgrading our apps and have invested both code effort and mental effort to arrive at a solution to rapidly generate database/ORMs for our apps.

    You could easily charge $200 for the designer and we would pay it BUT this adhoc method of pushing us to the Fluent method (which is sucks by the way - providing no advantage over the competition other than to add yet another 3rd party concern) is not a solution.  It is a deterent and the existing vendor trying to make a designer is just plain horrible.  This is a valid need and low hanging fruit for you guys.

  15. Projects Computerra
    Projects Computerra avatar
    41 posts
    Member since:
    Aug 2009

    Posted 01 May Link to this post

    Hello Team,

    Even we have faced this issue recently after updating SQL Server 2012 patch. Our version is 2014.1.225.2. We have updated SQL Server 2012 SP3 with cumulative 8 update. This solution did not help though. Could you please assist us?

     

    Thank you in advance. 

  16. Viktor Zhivkov
    Admin
    Viktor Zhivkov avatar
    312 posts

    Posted 02 May Link to this post

    Hi,

    The closest available hot-fixed version to your version 2014.1.225.2 (2014 Q1 release) is 2014.1.403.2 Hotfix 1 (2014 Q1 SP1 release).
    Please upgrade to this version and then replace the Telerik.DataAccess.Runtime.dll with the patched one.
    You can find the patched assembly as attachment.

    Regards,
    Viktor Zhivkov
    Telerik by Progress
     
    Telerik Data Access is no longer being developed. For more information please refer to this page.
  17. Projects Computerra
    Projects Computerra avatar
    41 posts
    Member since:
    Aug 2009

    Posted 02 May in reply to Viktor Zhivkov Link to this post

    Hello Viktor,

    Thank you for the response. However, this hotfix does not seem to be working. We have tried to rebuild the Project after changing the assembly references, but somehow it is still using the older reference (with older version). We are using following Telerik dlls:\

    Telerik.OpenAccess.35.Extensions.dll

    Telerik.OpenAccess.35.Extensions.xml

    Telerik.OpenAccess.dll

    Telerik.OpenAccess.xml

    Telerik.OpenAccess.Runtime.dll

    Telerik.Reporting.dll

    Telerik.ReportViewer.WebForms.dll

    Telerik.Web.UI.dll

    Telerik.Web.UI.Skins.dll

     

    So, please let us know what needs to be done to resolve this issue?

     

    Thank you.

  18. Eric
    Eric avatar
    2 posts
    Member since:
    May 2017

    Posted 04 May Link to this post

    Hello Viktor,

    Any insight into the above issue posted by Projects Computerra?

  19. Viktor Zhivkov
    Admin
    Viktor Zhivkov avatar
    312 posts

    Posted 04 May Link to this post

    Hello,

    The only assembly that is patched is Telerik.DataAccess.Runtime.dll. All other assemblies are fine.
    The version of the patched assembly is the same as the unpatched (version 2014.1.403.2).
    You can check the text file in the zip attachment to see how to verify that the patched assembly is loaded.
    Also please make sure that you have:
    1. Replaced the Telerik.DataAccess.Runtime.dll in GAC (both 32 and 64 bit)
    2. Replaced the Telerik.DataAccess.Runtime.dll in Telerik.DataAccess Program Files folder
    3. Cleaned and rebuild your solution to avoid any locally cached references to the affected assembly

    After these steps I believe your CLR will load the patched version of the assembly and resolve the compatibility issues.

    Regards,
    Viktor Zhivkov
    Telerik by Progress
    Telerik Data Access is no longer being developed. For more information please refer to this page.
  20. Eric
    Eric avatar
    2 posts
    Member since:
    May 2017

    Posted 04 May in reply to Viktor Zhivkov Link to this post

    Thank you, Viktor.
  21. Projects Computerra
    Projects Computerra avatar
    41 posts
    Member since:
    Aug 2009

    Posted 08 May Link to this post

    Hello Viktor,

    Thank you for the response.

    First of all, we are using Telerik.OpenAccess.Runtime.dll (version: 2014.1.225.2) and it is not available in GAC irrespective of the directories is has (32, 64, OR MSIL) in it. We have taken care of your point 2 and 3. However on load, our project is being pointed to the older version of open access runtime even after updating the assembly reference to 2014.1.403.2 version. Can you please let us know what can be done here now?

    Thanks again for your help.

  22. Projects Computerra
    Projects Computerra avatar
    41 posts
    Member since:
    Aug 2009

    Posted 09 May Link to this post

    Hello Viktor,

    Can you please respond on our latest reply?

    Thank you in advance. 

  23. Viktor Zhivkov
    Admin
    Viktor Zhivkov avatar
    312 posts

    Posted 11 May Link to this post

    Hello,

    Here are some some useful resources that should give you required steps how to upgrade the references of Telerik Data Access:
    1. Upgrade References
    2. Deployment options
    If you are using source control you should be able to easily compare the changes that are made to your project files.
    If you are still experiencing the loading issue do not forget to check you app.config/web.config for Assembly binding redirects that force the CLR to load the wrong version.

    Regards,
    Viktor Zhivkov
    Telerik by Progress
    Telerik Data Access is no longer being developed. For more information please refer to this page.
  24. Projects Computerra
    Projects Computerra avatar
    41 posts
    Member since:
    Aug 2009

    Posted 11 May Link to this post

    Hello Viktor,

     

    Thank you for the response. We were finally able to build and load our project with the hot fix you provided. The site is working correcting with it now and it does not now look for the older reference. However, this HOT FIX does not resolve our actual issue reported here. Can you please let us know what can resolve this issue now?

     

    Thank you in advance.

     

  25. Projects Computerra
    Projects Computerra avatar
    41 posts
    Member since:
    Aug 2009

    Posted 12 May Link to this post

    Hello Viktor,

    Any insight on the latest reply posted by us?

    Please let us know.

    Thank you.

  26. Viktor Zhivkov
    Admin
    Viktor Zhivkov avatar
    312 posts

    Posted 12 May Link to this post

    Hi,

    What is the exact issue that you are experiencing?
    Exception details, code that triggers the exception and versions of both Telerik Data Access and Microsoft SQL Server will be required before I can help you any further.
    Can you do another upgrade to Telerik Data Access 2015.1.225.1 (last version support .RLINQ models) or even the latest one (with Code-Only mapping)?

    Regards,
    Viktor Zhivkov
    Telerik by Progress
    Telerik Data Access is no longer being developed. For more information please refer to this page.
  27. Projects Computerra
    Projects Computerra avatar
    41 posts
    Member since:
    Aug 2009

    Posted 15 May Link to this post

    Hello Viktor,

    Thank you for your response. 

    We are using following versions of SQL and Telerik Data Access respectively:

    SQL Version:

    Microsoft SQL Server 2012 (SP3-CU8) (KB4013104) - 11.0.6594.0 (X64) 
    Mar 15 2017 10:52:31 
    Copyright (c) Microsoft Corporation
    Enterprise Edition (64-bit) on Windows NT 6.3 <X64> (Build 14393: )

     

    Telerik Open Access:

    2014.1.403.2 (The hot fix provided by you earlier)

     

    This is the error we are getting with our application: 

    Message : 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.

     

    Could you please review and let us know what can be done for this now?

     

    Thank you.

  28. Projects Computerra
    Projects Computerra avatar
    41 posts
    Member since:
    Aug 2009

    Posted 16 May Link to this post

    Hello Viktor,

     

    Any idea on the response posted by us?

     

  29. Viktor Zhivkov
    Admin
    Viktor Zhivkov avatar
    312 posts

    Posted 17 May Link to this post

    Hello,

    I have prepared a small console app that demonstrates the difference in behavior of the patched and unpatched assembly.
    Please open the attached zip, extract it and open the solution in Visual Studio.
    Then Restore NuGet packages and build the solution.
    If you run it immediately you should see the problem with getting the value of an Auto-increment Id in the console together with a message that you are using an un-patched version.
    Now copy the Telerik.OpenAccess.Runtime.dll.hotfix file that sits next to the solution file to the bin/Debug folder and rename if to remove the .hotfix suffix. Run the console app through command prompt again (if you hit F5 the patched assembly will be overwritten by Visual Studio).
    You should see that the patch is applied and you are able to insert and get the Auto-increment Id value back.
    So far this proves that the patch works with your specific version (just as it does in our test environment).

    Next you have to make sure that the patched assembly has replaced all occurrences of the original one all over your product. This is a step where I can only give you hints where to look:
    1. Program Files (x86)
    2. GAC (x86, x64, MSIL)
    3. /packages folder under your solution if you are using NuGet packages
    4. /bin/Debug and /bin/Release or any other build output directory in your projects
    5. folders that collect all deployment artifacts
    Given that most work is done in team a test similar to the one in the console application can greatly reduce the likelihood of regression issues caused by a teammate with unpatched version.

    Regards,
    Viktor Zhivkov
    Telerik by Progress
    Telerik Data Access is no longer being developed. For more information please refer to this page.
  30. Projects Computerra
    Projects Computerra avatar
    41 posts
    Member since:
    Aug 2009

    Posted 17 May Link to this post

    Hello Viktor,

    We have also tried with Telerik Data Access 2015.1.225.1 version. That could not resolve our issue though. We have been trying to reach you since a couple of days by our queries. We have also contacted your support assistance number, however they informed us to reach out to you through forum only. Can you please review our responses and let us know what should we do to resolve this issue?

    Thank you.

Back to Top