Hello everyone,
I've managed to come across a problem way above me and I really need some help.
Long story short, I needed to CLONE an existing database from where I deleted lots of data...
After deleting the data I went back to navision to test if everything still runs fine but I came across this error when trying to go to the Customers form.
The first row from the error says "The following SQL Server errors occured when accesing the Detailed Customer Ledger Entry".
To give more details of this matter, I've deleted all Customers that didn't had any entries into the Customer Ledger Entry table in the year 2021.
After cleaning the customers table, I've deleted all entries from the Customer Ledger Entry & Detailed Customer Ledger Entries tables.
This below is the view mentioned in the error above.
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
ALTER VIEW [dbo].[Dalkia Iasi$Detailed Cust_ Ledg_ Entry$VSIFT$4] WITH SCHEMABINDING AS SELECT "Customer No_","Initial Entry Due Date","Posting Date",COUNT_BIG(*) "$Cnt",SUM("Amount") "SUM$Amount",
SUM("Amount (LCY)") "SUM$Amount (LCY)" FROM dbo."Dalkia Iasi$Detailed Cust_ Ledg_ Entry" GROUP BY "Customer No_","Initial Entry Due Date","Posting Date"
I want to mention that I've tried the next:
1. I disabled all MaintainSIFTIndex properties to NO and then back to YES on the Customer table. I did save the changes on the table between disabling and enabling it again of course.
2. Recreating the view, with and without the WITH SCHEMABINDING property
3. Removing the view entirely, that went horrible as expected.
I have no problems with restoring the database with the old data or anything, solving this issue but I'm curious what should I do to get rid of this error?
Anyone knows more about this? I would really appreciate any kind of help!
Thanks for the time, have a great day!