Howdy, Stranger!
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.6K Microsoft Dynamics NAV
- 18.6K 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
- 298 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
- 259 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
Odd loop problem in Setup Checklist Line
Sunset
Member Posts: 201
NAV 2009 SP1 running on SQL 2008
I have run into an odd loop when trying to setup a new company using the Setup Checklist.
After selecting the company I want to copy my setup from the system start looping (counts records) when getting to the Tariff numbers. Looking at the information through database information is no problem. Running the Setup Checklist Line Table is no problem; until I set a flowfilter on the company I want to copy from. Then it starts looping again
Selecting CRONUS gives no problem.
Looking at SQL profiler I saw that the SQL statements being repeated where counts for Tariff No, Transport Method and Payment Terms (Payment Terms I figured was because it is the numerical first table in the database) Have made a maximum test on the database; no error except printers not existing and G/L accounts not existing but referred to in historical data.
Not being the SQL expert I've used the wizard to create and run a maintenance plan that checked integrity, reorganized the indexes and updated statistics. No help
Then tried to remove the Tariff number and Transport method tables in the checklist codeunit, but that only moved the problem to the next 2 tables.
So now I'm a bit stomped. Anybody have any idea on what i should try next?
I have run into an odd loop when trying to setup a new company using the Setup Checklist.
After selecting the company I want to copy my setup from the system start looping (counts records) when getting to the Tariff numbers. Looking at the information through database information is no problem. Running the Setup Checklist Line Table is no problem; until I set a flowfilter on the company I want to copy from. Then it starts looping again
Selecting CRONUS gives no problem.Looking at SQL profiler I saw that the SQL statements being repeated where counts for Tariff No, Transport Method and Payment Terms (Payment Terms I figured was because it is the numerical first table in the database) Have made a maximum test on the database; no error except printers not existing and G/L accounts not existing but referred to in historical data.
Not being the SQL expert I've used the wizard to create and run a maintenance plan that checked integrity, reorganized the indexes and updated statistics. No help
Then tried to remove the Tariff number and Transport method tables in the checklist codeunit, but that only moved the problem to the next 2 tables.
So now I'm a bit stomped. Anybody have any idea on what i should try next?
Don't just take my word for it, test it yourself
0
Answers
viewtopic.php?f=23&t=12485&start=0