Howdy, Stranger!
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.6K 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
- 305 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.7K General
- 1.1K General Chat
- 1.6K Website
- 79 Testing
- 1.2K Download section
- 23 How Tos section
- 260 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
Infinite loop on NAV sys.tables
bobvosedu
Member Posts: 5
Hi,
Same issue descrided here (viewtopic.php?f=23&t=51157&start=0&hilit=dynamics+nav+infinite+loop+sys.tables), however the conclusion and the suggestion is partially correct!
The issue exists without having "@" (or any other specific char) in company name. Renaming company seems to be a solution for the issue, (as it also was in the referred post) but I'm not convinced at all, that the sympthoms will not repeat.
The abnormal behaviour is easy to capture without any code. I just opens Database > Info > Tables, set the filter on the company, jump to its last record and press Down arrow. On the last line table 3 Payment Terms appears. And by continuing it it scrolls over and over the tables.
No inconsistency is shown by database test, optimization doesn't help either.
Anybody has a clue what the reason?
tnx
-e
Same issue descrided here (viewtopic.php?f=23&t=51157&start=0&hilit=dynamics+nav+infinite+loop+sys.tables), however the conclusion and the suggestion is partially correct!
The issue exists without having "@" (or any other specific char) in company name. Renaming company seems to be a solution for the issue, (as it also was in the referred post) but I'm not convinced at all, that the sympthoms will not repeat.
The abnormal behaviour is easy to capture without any code. I just opens Database > Info > Tables, set the filter on the company, jump to its last record and press Down arrow. On the last line table 3 Payment Terms appears. And by continuing it it scrolls over and over the tables.
No inconsistency is shown by database test, optimization doesn't help either.
Anybody has a clue what the reason?
tnx
-e
0
Comments
Could you give a bit more information, like version, and the companyname you filtered on?
|To-Increase|
Now we have NAV2009R2 client. We have NAV4 databases on SQL2K5, NAV2009 databases on SQL2K8.
We have more databases from each "type", and I observed the same sympthom in most of them regardless their name or size or whatever else.
The "stranges" characters in the company names are dots and numbers. We doesn't use country-specific letters either!
tnx,
What happens here is that some record within the filter moves the pointer back to the beginning of the list.
Check Table 2000000028. Create a new form for that table and preview it. Place no filter. Look for invisible characters, non existing objects, empty fields, anything out of the ordinary... Most probably it is the next record after the last one correctly displayed in Database > Info > Tables or it is your filter in combination with the company names.
FD Consulting
This is wehre I started the analsys from some days ago, but no visible sign of any inconsistency.
Then I went through the tables also in SQL. Nothing.
(Have I mentioned already, that restoring full backup on native engine cleans the DB from that bug?)
tnx,
-e
I'm still looking for the solution on SQL.
Anybody has any clue?
-e