How to cache an SSIS+ license in Azure SSIS IR to prevent downtime issues with COZYROC License Server

How to cache an SSIS+ license in Azure SSIS IR to prevent downtime issues with COZYROC License Server

Action: 


When trying to run packages in Azure SSIS IR VM, the following licensing error message is received:

Error Message:

“License: 'License.dat' file not found.”
​

In the latest log folder of the BLOB storage, there are the following lines:

Downloading the license file ...

Unable to connect to the remote server


Solution:
​
Instead of using the simplest version of main.cmd script in  How to setup a new SSIS IR with SSIS+ via the Azure web UI , use a version that caches the latest retrieved version of the license.dat file. Then after the first successful startup of the Azure SSIS IR, move the file to the root directory that contains the main.cmd to be used as a backup in subsequent restarts. In that way in case of a failure retrieving the license from the COZYROC License server, a cached one will be used.

The enhanced version of the script is available at https://ssisplus.blob.core.windows.net/custom-azure-ssis-ir/main.cmd 

@REM After you purchase a COZYROC SSIS+ license, please replace TRIAL with your Licensee Identifier
set LICENSEE=TRIAL
 
set DAT_FILE="C:\Program Files (x86)\CozyRoc\SSIS\License.dat"
 
msiexec /i SSISPlus-x64.msi /quiet /l %CUSTOM_SETUP_SCRIPT_LOG_DIR%install.log
 
"C:\Program Files (x86)\CozyRoc\SSIS\License.exe" /azure /v /u %LICENSEE% /d /l "%CUSTOM_SETUP_SCRIPT_LOG_DIR%license.log"
if %ERRORLEVEL% equ 0 (
    copy %DAT_FILE% "%CUSTOM_SETUP_SCRIPT_LOG_DIR%License.dat"
    @REM NOTE: after a successful start, the license file needs to be manually copied from the corresponding log folder to the root of the container
) else (
    if exist "License.dat" (
        if not exist %DAT_FILE% (
            copy "License.dat" %DAT_FILE% /v
        )
    )
)

REM ---- Raise an error if the License.dat file STILL does not exist ----
if not exist %DAT_FILE% (
    echo ERROR: Failed to license COZYROC SSIS+. License.dat not found!
    exit /b 1
)


    Book a Presales Call


    Are you new to COZYROC and evaluating our solutions? 
    Book a Presales Call with us now and get 5% off SSIS+.