Support Request: SiteRemote install crash (KERNELBASE.dll) then rollback

Description

Configuration :
- Windows Server 2016 / IIS 10 fully patched (october 2019, fresh install)
- SQL Server Express 2017 fully patched (CU17)
- All dependancies (IIS URL Rewrite, .NET Framework 4.7, ...)
- SiteRemote Release : 6.2.0.5845 (latest)

During the setup of SiteRemote the installer abort and a rollback is established. Please find attached a screen capture with the error fired in event logs.
As a first remedy I tried to override your VC++ 2013 redist package by the latest release available (12.0.40664), without more success.

Answer: (4)

Re: SiteRemote install crash (KERNELBASE.dll) then rollback 11/1/2019 3:42 PM
I tried to install with log verbose (siteremoteserver.exe /exelog:SR.log /exenoupdates /L*V MSI.log). I can't send by this way the full logs but the problem seems here :

MSI (s) (C0:D8) [15:34:38:834]: Executing op: CustomActionSchedule(Action=ExecuteBcp,ActionType=1025,Source=BinaryData,Target=CreateExeProcess,CustomActionData=C:\Program Files (x86)\PROVISIO\SiteRemote\\Data>C:\Program Files (x86)\PROVISIO\SiteRemote\\Data\BulkImport.cmd "(local)" "SiteRemoteBackEndServer" "C:\Program Files (x86)\PROVISIO\SiteRemote\Data" "" "" "")
MSI (s) (C0:F4) [15:34:38:834]: Invoking remote custom action. DLL: C:\Windows\Installer\MSI9C21.tmp, Entrypoint: CreateExeProcess
C:\Program Files (x86)\PROVISIO\SiteRemote\Data>REM Usage: bulkImport.cmd localhost\SQLEXPRESS SiteRemoteBackendServer <DATA PATH> <BCP PATH> <USER> <PASSWORD>
C:\Program Files (x86)\PROVISIO\SiteRemote\Data>REM @ECHO OFF
C:\Program Files (x86)\PROVISIO\SiteRemote\Data>CD "C:\Program Files (x86)\PROVISIO\SiteRemote\Data"
C:\Program Files (x86)\PROVISIO\SiteRemote\Data>REM "" is a path to BCP.EXE
C:\Program Files (x86)\PROVISIO\SiteRemote\Data>SET BcpPathCheck=zzz--""--zzz
C:\Program Files (x86)\PROVISIO\SiteRemote\Data>REM No path given
C:\Program Files (x86)\PROVISIO\SiteRemote\Data>IF zzz--""--zzz == zzz----zzz GOTO NOBCPPATH
C:\Program Files (x86)\PROVISIO\SiteRemote\Data>IF "" == "" GOTO NOBCPPATH
C:\Program Files (x86)\PROVISIO\SiteRemote\Data>SET BCPPATH=
C:\Program Files (x86)\PROVISIO\SiteRemote\Data>SET UserCheck=zzz--""--zzz
C:\Program Files (x86)\PROVISIO\SiteRemote\Data>REM No user name given
C:\Program Files (x86)\PROVISIO\SiteRemote\Data>IF zzz--""
--zzz == zzz----zzz GOTO NOUSER
C:\Program Files (x86)\PROVISIO\SiteRemote\Data>IF "" == "" GOTO NOUSER
C:\Program Files (x86)\PROVISIO\SiteRemote\Data>SET EXEC_SQL=sqlcmd -E -S "(local)" -d "SiteRemoteBackEndServer" -Q
C:\Program Files (x86)\PROVISIO\SiteRemote\Data>SET EXEC_SQLSCRIPT=sqlcmd -E -S "(local)" -d "SiteRemoteBackEndServer" -i
C:\Program Files (x86)\PROVISIO\SiteRemote\Data>SET BCP_PARAM1= -S "(local)" -T -E -n -oNUL -m0 -CRAW
C:\Program Files (x86)\PROVISIO\SiteRemote\Data>SET BCP_PARAM2= -S "(local)" -T -E -b10000 -oNUL -m0 -CRAW
C:\Program Files (x86)\PROVISIO\SiteRemote\Data>REM Ensure that Build column is present in tblSystem
C:\Program Files (x86)\PROVISIO\SiteRemote\Data>sqlcmd -E -S "(local)" -d "SiteRemoteBackEndServer" -i V1\Migration01.sql
C:\Program Files (x86)\PROVISIO\SiteRemote\Data>IF -1073741701 NEQ 0 GOTO ERROR
C:\Program Files (x86)\PROVISIO\SiteRemote\Data>ECHO failed
failed
C:\Program Files (x86)\PROVISIO\SiteRemote\Data>EXIT /B 1
CustomAction ExecuteBcp returned actual error code 1603 (note this may not be 100% accurate if translation happened inside sandbox)
Action ended 15:34:38: InstallExecute. Return value 3.
Re: SiteRemote install crash (KERNELBASE.dll) then rollback 11/1/2019 4:07 PM
After analysis it seems that you embed in your own package the program "sqlcmd.exe". However it crash with error 0xC000007B (STATUS_INVALID_IMAGE_FORMAT).
That's the root problem. If I use sqlcmd.exe from SQL Server 2017 installation I've no problem to launch it and execute your SQL scripts.
Re: SiteRemote install crash (KERNELBASE.dll) then rollback 11/1/2019 4:26 PM
Finally I managed to install it but removed on the fly the file sqlcmd.exe (deployed by your installer) so that it is the latest version of the program provided by SQL Server 2017 that is used by your installer.
Could you investigate about this file that was not working on a fresh W2016 / SQL Server 2017 install ?
Re: SiteRemote install crash (KERNELBASE.dll) then rollback 11/4/2019 10:39 AM
Hello,

Thank you for your feedback. As far as I can see you solved that problem because you already requested a trial license via e-mail.

In general, SiteRemote was also tested on Windows Server 2016 with SQL Server 2017.
There is currently a known problem with SQLCMD and 32 / 64 bit SQL variants.
Actually a new SiteRemote Server installation version is in preparation that includes a different SQL Native Client (if required, a previous version of the new installer can be requested by e-mail).

Regards,
Michael Olbrich
My Account
Login
Language (Tickets):