An IndexOutOfBoundsException occurs when you run the SAS® Migration Utility


When you run the SAS Migration Utility, an IndexOutOfBoundsException similar to the following might occur when the getSASInfrastructureDataServerDatabaseCredentials macro runs:

2025-11-07 16:27:11,594 [FATAL ] Item-> Fatal SAS Visual Analytics Services Product  This extension threw an exception: "The following error occurred while executing this line:
/tmp/selfgz2051915745/utilities/webinfdsvrcTasks.xml:147: getSASInfrastructureDataServer failed: java.lang.IndexOutOfBoundsException: Index: 0
getSASInfrastructureDataServer failed: java.lang.IndexOutOfBoundsException: Index: 0
 
2025-11-07 16:27:15,330 [FATAL ] Item-> Fatal SAS Visual Data Builder Product  This extension threw an exception: "The following error occurred while executing this line:
/tmp/selfgz2051915745/utilities/webinfdsvrcTasks.xml:147: getSASInfrastructureDataServer failed: java.lang.IndexOutOfBoundsException: Index: 0
getSASInfrastructureDataServer failed: java.lang.IndexOutOfBoundsException: Index: 0
 
2025-11-07 16:27:18,804 [FATAL ] Item-> Fatal SAS HTML Application Themes Product  This extension threw an exception: "The following error occurred while executing this line:
/tmp/selfgz2051915745/utilities/webinfdsvrcTasks.xml:147: getSASInfrastructureDataServer failed: java.lang.IndexOutOfBoundsException: Index: 0
getSASInfrastructureDataServer failed: java.lang.IndexOutOfBoundsException: Index: 0
 
Note: It is possible that similar exceptions could occur for other products not listed in the messages above.

Possible causes of this issue are as follows:

  1. The dbmsowner login is no longer associated with the SAS Administrator account in the metadata.
  2. The value for smu.user in the smu.properties file is not an unrestricted user in the metadata.
  3. If the exception occurs for only SAS® HTML Application Themes (flexthemes), the SAS Administrator account is not a member of the ThemeDesigner Administrators group.

Workaround

To circumvent this issue, complete the following workaround. Note that each method below corresponds to one of the possible causes.

Scenario A Workaround

Complete these steps for scenario A above.

  1. Log on to SAS® Management Console.
  2. Navigate to the User Manager and select SAS Administrator ► Properties ► Accounts.
  3. If the dbmsowner login is missing, click New.
    1. For User ID, enter dbmsowner.
    2. For Password, enter the dbmsowner password
    3. For Authentication Domain, select WebInfrastructurePlatformDataServer9.4Admin.
    4. Then, click OK to exit the prompts.
  4. Rerun the SAS Migration Utility

Scenario B Workaround

Complete these steps for scenario B above.

  1. In your smu.properties file, update the value for smu.user to sasadm@saspw. If you use external accounts, enter an account that is an unrestricted user in the metadata.
  2. Update the smu.password to be the correct password for smu.user.
  3. Rerun the SAS Migration Utility

Scenario C Workaround

Complete these steps for scenario C above. 

  1. Log on to SAS® Management Console.
  2. Navigate to the User Manager and select ThemeDesigner Administrators ► Properties ► Members.
  3. Add the SAS Administrator account.
  4. Click OK to exit the prompts.
  5. Rerun the SAS Migration Utility.