BC: Service tier generating alot of errors

JesperTP
JesperTP Member Posts: 3
edited 2022-08-29 in NAV Three Tier
Hi,

In our environment, one of the service tier for our BC are generating alot of error messages in the event log.
The following SQL error was unexpected:
Cannot insert the value NULL into column 'id', table 'Database.dbo.$ndo$cachesync'; column does not allow nulls. INSERT fails.
The statement has been terminated.
SQL statement:
INSERT INTO [Database].[dbo].[$ndo$cachesync] ([Server Instance ID]) VALUES (@serverInstanceId); SELECT CAST(SCOPE_IDENTITY() AS INT)

I know that it's because it cannot insert NULL into the ID column but how can I determine from where the problem comes from?

We are running BC version: 19.0.31.889.32155

Categories