Skip to main content

Notifications

Announcements

No record found.

Small and medium business | Business Central, N...
Suggested answer

NAVISION 2009 VSIFT issue

Posted on by Microsoft Employee

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".

pastedimage1630067983955v1.png

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!

  • Suggested answer
    RE: NAVISION 2009 VSIFT issue

    Hello,

    Removing data directly for SQL is never recommended and being that this is occurring on an unsupported version what we can provide here is going to be limited. I will open this up to the community in case they have something to add but you might also want to pose this question within some of the development specific forums:

    www.yammer.com/dynamicsnavdev

    dynamicsuser.net/.../developers

    Thomas Brownell | Microsoft NAV/Business Central

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,269 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans