Full migration issue from BI4.1 to BI4.2

Hi,

We installed BI4.2 SP3 on a plain machine, and we followed the administrator guide using CLI for the full migration.

The users and groups migration steps are:

1. Set –Xmx2g for APS in 4.1 and 4.2
2. Using below script to generate a lcmbiar file in 4.1:

   exportLocation=C:\BIexport\lcmUG.lcmbiar

   action=export

   LCM_CMS=sia1-dev:6400

   LCM_userName=Administrator

   LCM_password=xxxxxx

   LCM_authentication=secEnterprise

   Source_CMS=sia1-dev:6400

   Source_userName=Administrator

   Source_password=xxxxxx

   Source_authentication=secEnterprise

   exportQuery1=SELECT TOP 20000 static, relationships, SI_PARENT_FOLDER_CUID, SI_OWNER, SI_PATH FROM CI_INFOOBJECTS,CI_APPOBJECTS,CI_SYSTEMOBJECTS WHERE (SI_KIND='User' OR SI_KIND='UserGroup') AND NOT (SI_ID in (11,12, 501, 1, 2, 3))

   exportDependencies=false

   includeSecurity=true

3. Copied the lcmUG.lcmbiar file to 4.2 and used below script to promote users and groups to 4.2:

   importLocation=C:\BIexport\lcmUG.lcmbiar

   action=promote

   LCM_CMS=sia01-dev:6400

   LCM_userName=Administrator

   LCM_password=xxxxxx

   LCM_authentication=secEnterprise

   Destination_CMS=sia01-dev:6400

   Destination_userName=Administrator

   Destination_password=xxxxxx

   Destination_authentication=secEnterprise

   includeSecurity=true

The users and groups were promoted correctly but it could not promote groups with user security. Has anyone done the full migration? We really appreciate your advice.

Thanks,

Jiang