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

[alex]

Good morning everyone

Apologies, i hope i'm posting in the correct subforum.

A bit of background: we are using a web application creating with telerik controls. the SQL server that the application was connecting to died and we had to rebuild it using a new version of SQL. This changed causes the error - "Failed to retrieve the automatically incremented column value from the server. Possible reason: A trigger does not perform 'select ID from inserted'" when we try to create new items through the web app

i came accross this old post https://www.telerik.com/forums/telerik-bug-in-sql-server-2014-sp1 which shows that a number of hotfixes were made available at the time

We are using this version of telerik - Telerik.OpenAccess.Runtime, Version=2013.1.219.3, now with this version of SQL Microsoft SQL Server 2016 (SP3-GDR) (KB5014355) - 13.0.6419.1 (X64) 

I tried the 2013 hotfix version from the post which is a slightly different  from what we have.  ( i tired the newer ones to but unsurprisignly the broke the site.)The hot fix allowed the web app to load, but it couldnt load the  content of the web form.

I was wondering if you could please provide an hot fix for that version, if at all possible.

Thank you for your time

[Viktor Zhivkov]

Hello,

The earliest available hot-fix is for version 2013.2.611.1. The version you are using was already out of support by the time we have identified the bug and created the hot-fix.

You need to upgrade your whole Telerik DataAccess installation to that version. If you are doing an upgrade it may be better to jump to 2015.1.225.1 (and the corresponding hot-fix) as there are many fixes and improvements in the later versions.

As Telerik DataAccess has been retired several years ago, I strongly recommend to use different ORM tools that like EF Core.

Regards,
Viktor Zhivkov
Progress Telerik

[alex]

Hi Viktor

Thank you for the reply

Is there a place where we can download the updated versions of the old telerik data access? if so could you pass us the link? i can't seem to find them anywhere

or do we need a support contract to be able to get them?

[Viktor Zhivkov]

Hi,

You should be able to download Telerik DataAccess installer from Downloads on telerik.com.

After fixing the issue you are facing and if you have the time, I strongly advise to migrate to Code-Only mapping and use Telerik DataAccess Nuget packages instead of the installers as this will allow you to use even the latest Visual Studio 2022 and allows you to get a bit more recent version and extra fixes compared to versions with Visual Designer (.RLINQ).

 

Regards,
Viktor Zhivkov
Progress Telerik