Navcontainerhelper: New-NavContainer with BCArtifactUrl: Invalid object name 'master.dbo.$ndo$srvproperty'.

[DanielGoehler]

Describe the issue
I get the error message Invalid object name 'master.dbo.$ndo$srvproperty' when creating a new NavContainer with BCArtifactUrl.

Scripts used to create container and cause the issue

$artifactUrl = Get-BCArtifactUrl -version 16.2 -select Latest -type onprem 
$credential = New-Object pscredential 'admin', (ConvertTo-SecureString -String '<complex password>' -AsPlainText -Force)
New-NavContainer `
    -accept_eula `
    -containerName test-artifact `
    -artifactUrl $artifactUrl `
     -Credential $credential `
     -PublicDnsName docker.company.tld `
     -auth UserPassword `
     -updateHosts `
     -imagename myown `
     -useTraefik `
     -shortcuts None

Full output of scripts

NavContainerHelper is version 0.7.0.8
NavContainerHelper is running as administrator
Host is Microsoft Windows Server 2019 Standard - ltsc2019
Docker Client Version is 19.03.5
Docker Server Version is 19.03.5
Removing C:\ProgramData\NavContainerHelper\Extensions\test-artifact
ArtifactUrl and ImageName specified
Image myown:onprem-16.2.13509.13779-w1 already exists
Enabling SSL as otherwise all clients will see mixed HTTP / HTTPS request, which will cause problems e.g. on the mobile and modern windows clients
Using image myown:onprem-16.2.13509.13779-w1
PublicDnsName is docker.company.tld
Creating Container test-artifact
Version: 16.2.13509.13779-w1
Style: onprem
Platform: 16.0.13440.13772
Generic Tag: 0.1.0.6
Container OS Version: 10.0.17763.1282 (ltsc2019)
Host OS Version: 10.0.17763.1282 (ltsc2019)
Using locale en-US
Using process isolation
Adding special CheckHealth.ps1 to enable Traefik support
Disabling the standard eventlog dump to container log every 2 seconds (use -dumpEventLog to enable)
Additional Parameters:
--hostname docker
-e webserverinstance=test-artifact
-e publicdnsname=docker.company.tld
-l "traefik.protocol=https"
-l "traefik.web.frontend.rule=PathPrefix:/test-artifact"
-l "traefik.web.port=443"
-l "traefik.soap.frontend.rule=PathPrefix:/test-artifactsoap;ReplacePathRegex: ^/test-artifactsoap(.*) /BC$1"
-l "traefik.soap.port=7047"
-l "traefik.rest.frontend.rule=PathPrefix:/test-artifactrest;ReplacePathRegex: ^/test-artifactrest(.*) /BC$1"
-l "traefik.rest.port=7048"
-l "traefik.dev.frontend.rule=PathPrefix:/test-artifactdev;ReplacePathRegex: ^/test-artifactdev(.*) /BC$1"
-l "traefik.dev.port=7049"
-l "traefik.dl.frontend.rule=PathPrefixStrip:/test-artifactdl"
-l "traefik.dl.port=8080"
-l "traefik.dl.protocol=http"
-l "traefik.enable=true"
-l "traefik.frontend.entryPoints=https"
--env customNavSettings=PublicODataBaseUrl=https://docker.company.tld/test-artifactrest/odata,PublicSOAPBaseUrl=https://docker.company.tld/test-artifactsoap/ws,PublicWebBaseUrl=https://docker.company.tld
e/test-artifact
Files in C:\ProgramData\NavContainerHelper\Extensions\test-artifact\my:
- AdditionalOutput.ps1
- CheckHealth.ps1
- MainLoop.ps1
- SetupVariables.ps1
- updatehosts.ps1
Creating container test-artifact from image myown:onprem-16.2.13509.13779-w1
10f86625b6455ec1c20ab70ceca31287ef75e86f98bacc357dc531384651d1c2
Waiting for container test-artifact to be ready
Initializing...
Setting host.containerhelper.internal to 172.18.208.1 in container hosts file
Starting Container
Hostname is docker
PublicDnsName is docker.company.tld
Using NavUserPassword Authentication
Starting Local SQL Server
Starting Internet Information Server
Creating Self Signed Certificate
Self Signed Certificate Thumbprint FFBC89EFCCFADEED079998EE79153986F269C46D
Modifying Service Tier Config File with Instance Specific Settings
Modifying Service Tier Config File with settings from environment variable
Setting PublicODataBaseUrl to https://docker.company.tld/test-artifactrest/odata
Setting PublicSOAPBaseUrl to https://docker.company.tld/test-artifactsoap/ws
Setting PublicWebBaseUrl to https://docker.company.tld/test-artifact
Starting Service Tier
Registering event sources
Creating DotNetCore Web Server Instance
Creating http download site
Setting SA Password and enabling SA
Creating admin as SQL User and add to sysadmin
Creating SUPER user
The following SQL error was unexpected:
Invalid object name 'master.dbo.$ndo$srvproperty'.

at <ScriptBlock>, C:\Run\SetupNavUsers.ps1: line 20
at <ScriptBlock>, C:\Run\navstart.ps1: line 184
at <ScriptBlock>, C:\Run\start.ps1: line 217
at <ScriptBlock>, <No file>: line 1Error
Initializing...
Setting host.containerhelper.internal to 172.18.208.1 in container hosts file
Starting Container
Hostname is docker
PublicDnsName is docker.company.tld
Using NavUserPassword Authentication
Starting Local SQL Server
Starting Internet Information Server
Creating Self Signed Certificate
Self Signed Certificate Thumbprint FFBC89EFCCFADEED079998EE79153986F269C46D
Modifying Service Tier Config File with Instance Specific Settings
Modifying Service Tier Config File with settings from environment variable
Setting PublicODataBaseUrl to https://docker.company.tld/test-artifactrest/odata
Setting PublicSOAPBaseUrl to https://docker.company.tld/test-artifactsoap/ws
Setting PublicWebBaseUrl to https://docker.company.tld/test-artifact
Starting Service Tier
Registering event sources
Creating DotNetCore Web Server Instance
Creating http download site
Setting SA Password and enabling SA
Creating admin as SQL User and add to sysadmin
Creating SUPER user
The following SQL error was unexpected:
Invalid object name 'master.dbo.$ndo$srvproperty'.

at <ScriptBlock>, C:\Run\SetupNavUsers.ps1: line 20
at <ScriptBlock>, C:\Run\navstart.ps1: line 184
at <ScriptBlock>, C:\Run\start.ps1: line 217
at <ScriptBlock>, <No file>: line 1
Initialization of container test-artifact failed
In C:\Program Files\WindowsPowerShell\Modules\navcontainerhelper\0.7.0.8\ContainerHandling\Wait-NavContainerReady.ps1:44 Zeichen:17
+ ...             throw "Initialization of container $containerName failed" ...
+                 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
    + CategoryInfo          : OperationStopped: (Initialization ...artifact failed:String) [], RuntimeException
    + FullyQualifiedErrorId : Initialization of container test-artifact failed
...

[freddydk]

typically that is something with a license file.
Maybe I don't get the license file added during build - could you try to specify a license file?

[DanielGoehler]

Thanks, with licence is works.

[freddydk]

I still think it is a bug somewhere - so I will reopen this issue - the cronus license should be applied during build.
Thanks for verifying that it was a license issue.

[freddydk]

I cannot repro the issue, I thought there was an issue during installation, but apparently not.