New-BcContainerBcUser -assignPremiumPlan, Incorrect syntax near ''.

[nhammonbsh]

PLEASE DO NOT INCLUDE ANY PASSWORDS OR TOKENS IN YOUR ISSUE!!!

Describe the issue
When calling New-BcContainerBcUser with assignPremiumPlan-Param the following error occurs:

INFO: Assigning Permission Set SUPER to bsh
INFO: Assigning Premium plan for BSH
TerminatingError(): "Der ausgeführte Befehl wurde beendet, da die Einstellungsvariable "ErrorActionPreference" oder ein allgemeiner Parameter auf "Stop" festgelegt ist: Fehlerhafte Syntax beim Analysieren von ''.."
Fehlerhafte Syntax beim Analysieren von ''.

Exception Script Stack Trace:
at <ScriptBlock>, <No file>: line 78
at <ScriptBlock>, <No file>: line 77

PowerShell Call Stack:
bei Invoke-ScriptInBcContainer, C:\Program Files\WindowsPowerShell\Modules\BcContainerHelper\6.0.33\ContainerHandling\Invoke-ScriptInNavContainer.ps1: Zeile 71
bei New-BcContainerBcUser, C:\Program Files\WindowsPowerShell\Modules\BcContainerHelper\6.0.33\UserHandling\New-NavContainerNavUser.ps1: Zeile 60
bei Update-NAVBCUser<Process>, C:\DockerMgt\modules\pre-and-post-build-operations.ps1: Zeile 446
bei Start-PostContainerOperations, C:\DockerMgt\modules\pre-and-post-build-operations.ps1: Zeile 338
bei Start-ContainerBuild<Process>, C:\DockerMgt\modules\container-build.ps1: Zeile 260
bei Get-FetchedCreatableContainer, C:\DockerMgt\modules\container-build.ps1: Zeile 120
bei <ScriptBlock>, C:\DockerMgt\mgt\start-container-build.ps1: Zeile 25
bei <ScriptBlock>, <Keine Datei>: Zeile 1
INFO: 
Container Free Physical Memory: 5.5Gb
INFO: Disk C: Free 124Gb from 127Gb
INFO: 
Services in container IGNORE-DBTL-UPG:
TerminatingError(): "Der ausgeführte Befehl wurde beendet, da die Einstellungsvariable "ErrorActionPreference" oder ein allgemeiner Parameter auf "Stop" festgelegt ist: Service 'DiagHost (DiagHost)' cannot be queried due to the following error: PermissionDenied."
TerminatingError(): "Fehlerhafte Syntax beim Analysieren von ''."
New-BcContainerBcUser Telemetry Correlation Id: c668e75b-b159-4f24-b746-dd9c8002e7bf
PS>TerminatingError(): "Fehlerhafte Syntax beim Analysieren von ''."
Fehlerhafte Syntax beim Analysieren von ''.

I went through the code for "New-BcContainerBcUser" and found that the following part of the code is responsible for the error:

Executing the code through a Enter-BcContainer-Session reveals the following:

All variables are setup the same as in the New-BcContainerBcUser-Code
The Container is connected to a database on an external sql server!!!

BcContainerHelper is version 6.0.33
BcContainerHelper is running as administrator
Host Version Microsoft Windows Server 2022 Standard
Version 10.0.20348 Build 20348

Docker Client Version is 27.5.1
Docker Server Version is 27.5.1

[freddydk]

What BC version are you using - maybe things have changed?

[nhammonbsh]

That was for BC25. But I would not exclude versions below that.
We create multiple container throughout the week with different bc versions > 20 and that error almost happens every time