AIP Console - Upgrade - Failing while importing Custom Environment Profiles

The purpose of this page is to address the below error observed while upgrading an app to the latest AIP CORE, where It is failing while importing Custom Environment Profiles : 

  

Error during CAST-Servman-Utilities command execution (error code: 2).\r\n"Importing custom environment profiles from 'C:\ProgramData\CAST\CAST\Logs\Servman-20230323-035415\Env3C52.aex':Failed. FILE: {C:\ProgramData\CAST\CAST\Logs\Servman-20230323-035415\Env3C52.aex':Failed.}""Fail to import custom environment profiles 'C:\ProgramData\CAST\CAST\Logs\Servman-20230323-035415\Env3C52.aex' FILE: {C:\ProgramData\CAST\CAST\Logs\Servman-20230323-035415\Env3C52.aex'}"Error executing DLL

 
EPManager.exe -DATABASE(CASTStorageService) "-CONNECT_STRING('localhost:9090', 'operator', 'CastAIP', 'test_local')" "-LOG(C:\ProgramData\CAST\CAST\Logs\Servman-20230323-035415\Env3C52_import.log, USELOGFILE)" -IMPORT -FILE('C:\ProgramData\CAST\CAST\Logs\Servman-20230323-035415\Env3C52.aex')
 
 

 
 
 

1. Migrate AIP core from a lower version to a higher version as per the documentation here - Upgrade process

The issue occurs when the extension folder on the upgrade or migration machine is not containing all the extensions that is being installed in the schema of the application being upgraded.

EPManager is responsible for the import of all the environment profiles, the defaults and the ones from extensions, it can pass only if the required extensions are available and it is a prerequisite to synchronize your application with the available list of extensions before you perform an upgrade.

To solve the issue,  Perform the below actions

1. Check the content of the below query with the list of extensions present in the extension folder, and make sure the extensions with their specific version should be available.

   select * from <mngt_schema>.sys_package_version where package_name like '/com%';

2. If the problem you are facing does not match any case listed in this page, report your problem to CAST Technical Support and provide the below Relevant input for CAST Technical Support to reproduce the issue.    

Relevant input

• CAST AIP Console Logs CAST Management Studio - Information - How to find logs
• Detail of specific steps done
• Any applicable screenshots

Ticket # 40858

When you replicate the environment on another host you will need to copy all the storage folders mentioned in   Configure AIP Node storage folder locations - optional - v. 1.x   and    Configure AIP Node storage folder locations - optional - v. 2.x