SQL trigger - When an item is created not working

Like (0) Share

Report

Posted on 26 Jan 2023 09:19:33 by svarcas

Hello,

I have several SQL on-premises databases. Both of them is on Windows Server 2008 and both runs on SQL Server 2012 Express.

But a problem is, that one of them doesn't trigger "When an item is created" trigger. Besides I can't choose a table name in trigger settings - I get error:

Could not retrieve values. The dynamic invocation request failed with error: Unexpected error occurred when calling the ApiHubsRuntime API: 'System.Threading.Tasks.TaskCanceledException: A task was canceled.

So i entered that Table name manually, but that doesn't help.

On the other hand if I add just simple action on this database (get rows, etc) everything is fine, I can get Table name list.

On the other server everything works fine (same windows and DB versions), so I think that it's something with database configuration.

That problematic server runs Navision 2013 R2 database.

All responses (1)

Answers (0)

svarcas 2 on 26 Jan 2023 at 13:11:52

Like (0)

Report

Re: SQL trigger - When an item is created not working

A little bit update, the database that works with triggers is SQL Express with advanced services, so maybe that's the reason why it works. I'll try to upgrade non-working database with the same SQL server version, maybe it will help.