BC: Service tier generating alot of errors

JesperTPJesperTP Member Posts: 3
edited 2022-08-29 in NAV Three Tier

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:
Sign In or Register to comment.