I can't install an extension without adding an entry in NAV App Installed App in SQL-manager

LoneMH
Member Posts: 2
I have a BC Fall 2018 RTM Runtime: CU4 hybrid, that gives me a lot of problems. Both production an test at the customer and 2 databases local, doesn't show the extension as installed, unless I add the corresponding record in NAV App Installed App in SQL, after using the following steps in Powershell:
Uninstall-NAVApp -ServerInstance $ServerInstanceName -Name $AppName -ErrorAction Stop
Unpublish-NAVApp -ServerInstance $ServerInstanceName -Name $AppName -ErrorAction Stop
Publish-NAVApp -ServerInstance $ServerInstanceName -Path $appPath -SkipVerification -ErrorAction Stop
Sync-NAVApp -ServerInstance $ServerInstanceName -Name $appName -ErrorAction Stop
Start-NAVAppDataUpgrade -ServerInstance $ServerInstanceName -Path $AppPath -ErrorAction Stop
Further more it doesn't in fact upgrade the system, leading to missing records in extension tables if new extension is made (not a problem for flow fields), in addition to NOT running the upgrade codeunits at all
.
CU upgrade to CU15 is tried without any luck. It is not possible for me to access the database with VSCode.
Any idea at all, how to solve this ?
My other customers does not have this issue. They are all BC fall 2018 RTM hybrids, at different Runtime CU - that is (CU4, CU10 and CU11)
Uninstall-NAVApp -ServerInstance $ServerInstanceName -Name $AppName -ErrorAction Stop
Unpublish-NAVApp -ServerInstance $ServerInstanceName -Name $AppName -ErrorAction Stop
Publish-NAVApp -ServerInstance $ServerInstanceName -Path $appPath -SkipVerification -ErrorAction Stop
Sync-NAVApp -ServerInstance $ServerInstanceName -Name $appName -ErrorAction Stop
Start-NAVAppDataUpgrade -ServerInstance $ServerInstanceName -Path $AppPath -ErrorAction Stop
Further more it doesn't in fact upgrade the system, leading to missing records in extension tables if new extension is made (not a problem for flow fields), in addition to NOT running the upgrade codeunits at all

CU upgrade to CU15 is tried without any luck. It is not possible for me to access the database with VSCode.
Any idea at all, how to solve this ?
My other customers does not have this issue. They are all BC fall 2018 RTM hybrids, at different Runtime CU - that is (CU4, CU10 and CU11)
0
Answers
-
When using OnAfterCompanyOpen or OnBeforeCompanyClose you need to prevent it to be activated if it's during install of apps - that is using this: if not NAVApp.IsInstalling then0
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