Howdy, Stranger!
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.7K Microsoft Dynamics NAV
- 18.7K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 115 Navision DOS
- 854 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 615 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 317 Dynamics CRM
- 109 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 993 SQL General
- 384 SQL Performance
- 34 SQL Tips & Tricks
- 34 Design Patterns (General & Best Practices)
- Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.6K General
- 1.1K General Chat
- 1.6K Website
- 79 Testing
- 1.2K Download section
- 23 How Tos section
- 259 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
Cannot delete Corrupted Table.
Adux
Member Posts: 14
Hello,
Situation:
3.70
Navision Native Server
I found corrupted data in table in our client database.
I've restored this table from backup.
Some data was lost, but it is Ok.
Old corrupted Table was renamed to 99999
Problem:
It is not possible to delete data from corrupted Table.
DELETEALL - is not working.
INSERT - not working
DELETE - not working even on good records
Disabling keys - not possible
The only thing is possible - MODIFY on good (not corrupted) records.
And the main problem is that it is NOT possible to make backup (FBK).
](*,)
Do you have any ideas (tools) to delete this corrupted table.....
Situation:
3.70
Navision Native Server
I found corrupted data in table in our client database.
I've restored this table from backup.
Some data was lost, but it is Ok.
Old corrupted Table was renamed to 99999
Problem:
It is not possible to delete data from corrupted Table.
DELETEALL - is not working.
INSERT - not working
DELETE - not working even on good records
Disabling keys - not possible
The only thing is possible - MODIFY on good (not corrupted) records.
And the main problem is that it is NOT possible to make backup (FBK).
](*,)
Do you have any ideas (tools) to delete this corrupted table.....
Adux
Lithuania
Lithuania
0
Comments
MVP - Dynamics NAV
My BLOG
NAVERTICA a.s.
the tool is called C/DART.
It will be used only by MBS-Support personnel.
You have to contact your NSC (Navision Solution Center) which will contact his NTR (Navision Territorial Representative) to send a MBS-Support assistant to you.
And you have to sign a absorption of costs.
br
Josef Metz
Josef Metz
RIS Plus, LLC
I think there is an easiest way to do that, just try creating a form over the table Object (system table which contain the information about all the objects in the database), after that filter by Type = TableData and Id.=99999, and delete all the registers (one per company). It must finish with your problem.
Best Regards
Toni Jaume