Hi, I have upgraded my SQL SERVER 2014 to Microsoft SQL Server 2014 (SP1-CU5) (KB3130926) - 12.0.4439.1 (X64) and I am getting the following error where I want to insert a record in the database:
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.
The Telerik version that I am using is 2015.1.225.1
Thank´s a lot and regards.-
20 Answers, 1 is accepted
A hot fix for Data Access Q1 2015 that tackles with this issue is in the attachment of this forum post.
I hope this helps.
Regards,
Doroteya
Telerik
Rank 1
Telerik - as a long term customer across multiple companies, not just the account I am posting from currently - I have always recommended your products but around the Data Access - you have left many of us with in a very precarious situation.
I have implemented the Data Access, previously Open Access product in many legacy solutions and have implemented your patch but Microsoft continues to release updates which break the patch you published. The latest patch GDR 5203 For SQL Server 2014 (KB3194714) released on 7/17/17 breaks the database libraries once more.
If you discontinued support for it - why have you not open sourced the patch to the community? Why have you not released the entire project out on GitHub or equivalent? Telling the users they must migrate systems they have not touched in some instances 2-3 years is not a migration path. We chose you as a vendor because of your track record.
This places us in a very costly position.
Are you experiencing issues with getting back auto-increment primary key values after the update on SQL Server?
If you do, please let me know what version of Telerik Data Access are you using.
Regards,
Viktor Zhivkov
Progress Telerik
Rank 1
What is the latest version of SQL Server supported by Data Access 2015.1.225.1 ? We are stuck with this version also because we want to stick with the Database first approach.
I also vote for Telerik to open source DataAccess if you can't continue support. Very frustrated.
At the moment Telerik Data Access supports the latest official version - SQL Server 2016.
I believe you are more interested in the situation with Service Pack releases as we have version detection issue in 2015.1.225.1 that is surfacing when you are targeting Service Pack versions.
If this is the case you can replace Telerik.OpenAccess.Runtime.dll in your installation folder with the one found in the attached HotFix zip.
After applying the hotfix please run the tests outlined in the readme file to verify that the patch is OK.
Regards,
Viktor Zhivkov
Progress Telerik
Rank 1
Rank 1
Yes you can use SQL Server 2016 with Telerik Data Access 2015.1.225.1.
Without replacing the Runtime assembly with the hotfixed one you are risking failures to get Auto-Increment values after a security or service pack releases from Microsoft.
Regards,
Viktor Zhivkov
Progress Telerik
Rank 1
Viktor - I replaced it with the hotfix for Telerik Data Access 2015.1.225.1 - it breaks both the SQL Server 2014 and SQL Server 2016 versions.
Either post the hotfix source code or preferably the Data Access project to GitHub - otherwise we need a fix for latest patch GDR 5203
Rank 1
I'm currently testing the 2015.1.225.1-HotFix1 version on
"Microsoft SQL Server 2016 (SP1-CU2) (KB4013106) - 13.0.4422.0 (X64) Mar 6 2017 14:18:16 Copyright (c) Microsoft Corporation Express Edition (64-bit) on Windows Server 2012 R2 Standard 6.3 <X64> (Build 9600: ) (Hypervisor)"
And it's looking promising in here. We don't get the insert failure anymore.
Rank 1
I'm currently testing the 2015.1.225.1-HotFix1 version on
"Microsoft SQL Server 2016 (SP1-CU2) (KB4013106) - 13.0.4422.0 (X64) Mar 6 2017 14:18:16 Copyright (c) Microsoft Corporation Express Edition (64-bit) on Windows Server 2012 R2 Standard 6.3 <X64> (Build 9600: ) (Hypervisor)"
And it's looking promising in here. We don't get the insert failure anymore.
Rank 1
Rank 1
Rank 1
Can you share the specific versions of MS SQL Server and your OS so I can try to reproduce the issue?
I need the error messages (ideally with stack trace) as well.
You can get SQL Server version details using the following query:
select @@versionRegards,
Viktor Zhivkov
Progress Telerik
Rank 1
Hi, I just updated my 2012 SQL server to SP2 and got the same issue.
Microsoft SQL Server 2012 (SP2-GDR) (KB3194719) - 11.0.5388.0 (X64) Sep 23 2016 16:56:29 Copyright (c) Microsoft Corporation Enterprise Edition (64-bit) on Windows NT 6.3 <X64> (Build 9600: ) (Hypervisor)
I am using Telerik OpenAccess 2014.3.1209.1
I override the file in the my projects bin folder with the hotfix above but got the below error.
Exception message: Could not load file or assembly 'Telerik.OpenAccess.Runtime, Version=2014.3.1209.1, Culture=neutral, PublicKeyToken=7ce17eeaf1d59342' or one of its dependencies. The located assembly's manifest definition does not match the assembly reference. (Exception from HRESULT: 0x80131040) (\\KICSFILES\KICSWebsites\staging.kics.com.au\web.config line 107)
I'm installing SP3 on the server now to see if it resolves it.
You should use hotfix assembly with the correct version for your project.
Please download the attached Telerik.OpenAccess.2014.3.1209.1-HotFix1.zip and replace the original Telerik.OpenAccess.Runtime.dll with the one from the attached zip file.
The other option is to upgrade to Q1 2015 (version 2015.1.225.1) and then apply the corresponding hotfix (liked several posts ago).
Regards,
Viktor Zhivkov
Progress Telerik
Rank 1
Thanks Viktor
The hotfix resolved the issue.
Will let you know if there are any other issues.
Rank 1
Hi, Viktor!
Could you please provide with the hotfix for version 2013.3.78.1835 (2013.3.1211.3) also?
Please download the attached ZIP file and replace Telerik.OpenAccess.Runtime.dll in your installation folder and project's BIN folder.
See the text file inside the ZIP for more information.
Regards,
Viktor Zhivkov
Progress Telerik