Migration Utility error - index out of range

Error:

Running migration utility from C:\Program Files\AdeptiaSuite\AdeptiaSuite-6.2\bin in test environment. Fails after I specify the target install directory. Error says it cannot connect to database on port 1433. Not sure where it is getting connect string from as the backend database does not run on port 1433.

 

Not able to connect to backend database. Reason: The TCP/IP connection to the hose:, port 1433 has failed. Error"null. Verify the connection properties, check that an instance of SQL server is running on the host and accepting TCP/IP connections at the port, and that no firewall is blocking TCP connections to the port.".

 

Error in migration.log is

java.lang.StringIndexOutOfBoundsException: String index out of range: -33
at java.lang.String.substring(Unknown Source)
at com.adeptia.migration.ExportImportUtil.updateMapWithConnectionInfo(Unknown Source)
at com.adeptia.migration.ExportImportUtil.getBackendDataBaseInfo(Unknown Source)
at com.adeptia.migration.RunMigration.setDatabaseInfo(Unknown Source)
at com.adeptia.ui.TargetLocationPanelDescriptor.validate(Unknown Source)
at com.adeptia.wizard.WizardController$1.run(Unknown Source)

 

Cause:

This indicates there is some issue with the backend database connection URL used by the migration utility. This URL can be identified in the server-configure.properties file (/ServerKernel/etc) property abpm.jdo.url

 

Solution: 

Verify the connection URL is in the correct format. For SQL server, this would be

jdbc:jtds:sqlserver://<<serverName>>:1433/DatabaseName;instance=INSTANCENAME;

 

 

Have more questions? Submit a request

0 Comments

Article is closed for comments.