NAV Schema Synchronization kills the Service Tier

Klappstuhl
Member Posts: 9
Hello dear users,
in our database we have an error with the Schema Synchronization causing the Service Tier to die and using 100% of the CPU.
The error seems to be caused by our Upgrade Codeunit. However, when we comment out or delete the following lines everything works perfect.
With this seven lines of code in the codeunit, I try to edit Table18, Customer and add a new field.

After saving the changes with CTRL+S and selecting the validation - now option, I have to restart the service tier since it uses 100% of the machines CPU, as I already said.
Has anyone ever faced problems like these before or has an idea of how to fix it? When I tried to reproduce the error on a NAV90 Demo Database everything works as it should, the problem is that part of the codeunit.
Thanks in advance.
in our database we have an error with the Schema Synchronization causing the Service Tier to die and using 100% of the CPU.
The error seems to be caused by our Upgrade Codeunit. However, when we comment out or delete the following lines everything works perfect.
Object.GET(Object.Type::Table,'',DATABASE::"OUR TABLE"); IF (STRPOS(Object."Version List",'XXX9.03') > 0) OR (STRPOS(Object."Version List",'XXX9.04.00.00') > 0) THEN DataUpgradeMgt.SetTableSyncSetup(DATABASE::"OUR TABLE",0,TableSynchSetupVar.Mode::Force) ELSE IF ((STRPOS(Object."Version List",'XXX9.04') > 0) OR (STRPOS(Object."Version List",'XXX9.05.00.00') > 0)) AND (NOT FunctionExecuted('SBAT2','')) THEN DataUpgradeMgt.SetTableSyncSetup(DATABASE::"OUR TABLE",DATABASE::"OUR UPGRADE TABLE",TableSynchSetupVar.Mode::Copy) ELSE DataUpgradeMgt.SetTableSyncSetup(DATABASE::"OUR TABLE",0,TableSynchSetupVar.Mode::Check);
With this seven lines of code in the codeunit, I try to edit Table18, Customer and add a new field.

After saving the changes with CTRL+S and selecting the validation - now option, I have to restart the service tier since it uses 100% of the machines CPU, as I already said.
Has anyone ever faced problems like these before or has an idea of how to fix it? When I tried to reproduce the error on a NAV90 Demo Database everything works as it should, the problem is that part of the codeunit.
Thanks in advance.
0
Best Answer
-
Okay, the error has been found. One is not allowed to to do a GET; on tables, which are NOT a system table.
In other words, you can only use a GET; on system tables when it comes down to upgrade codeunits.5
Answers
-
Okay, the error has been found. One is not allowed to to do a GET; on tables, which are NOT a system table.
In other words, you can only use a GET; on system tables when it comes down to upgrade codeunits.5
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
- 116 Navision DOS
- 851 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 617 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 320 Dynamics CRM
- 111 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 990 SQL General
- 383 SQL Performance
- 34 SQL Tips & Tricks
- 35 Design Patterns (General & Best Practices)
- 1 Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.6K General
- 1.1K General Chat
- 1.6K Website
- 83 Testing
- 1.2K Download section
- 23 How Tos section
- 252 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions