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

Sync-NAVApp : An unexpected error occurred after a database command was cancelled.

(1) Share

Report

Posted on by SD-06051333-0

While Sync the Application we are facing the below issue:

/The index 'IX_RRR_Inc$Sales_Invoice_Line' is dependent on column 'EE DD AA_'.
ALTER TABLE DROP COLUMN EDI Item Cross Ref_ failed because one or more objects access this column./

Kindly Provide a way to resolve this error.

Categories:

Dynamics 365 Business Central

All responses (3)

Answers (0)

SD-06051333-0 65 on at

Like (0)

Report

Sync-NAVApp : An unexpected error occurred after a database command was cancelled.

Dustin Wolf - Only need to drop constraints and Column or need to drop Index also

FYI : "IX_RRR_Inc$Sales_Invoice_Line" - This is Index name not a table name
gdrenteria 12,851 Most Valuable Professional on at

Like (0)

Report

Sync-NAVApp : An unexpected error occurred after a database command was cancelled.

Hi

¿By chance they have made some updates directly through SQL?

Best regards

Gerardo
Suggested answer

Dustin Wolf 30 on at

Like (0)

Report
Sync-NAVApp : An unexpected error occurred after a database command was cancelled.

You need to remove all of the constraints before you can drop the column. alter table [IX_RRR_Inc$Sales_Invoice_Line] drop constraint [EE DD AA_]; alter table [IX_RRR_Inc$Sales_Invoice_Line] drop column [EDI Item Cross Ref_];

Dustin Wolf, MS

Senior Developer

Accent Software, Inc.