Indexing

Owned by Rajeev Rai
Last updated: Aug 22, 2024
2 min read

Issue

Cause

Diagnosis

Resolution

Migration Utility error - Index out of range

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

Will see the below error message:
Error Message:
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)

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

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

String index out of range

Generally that error indicates an issue with your textual rule.

While creating a map and using primary key so that Adeptia inserts a new record if it doesn’t find the records with specific field values and updates if it has. Bellow is the map and query. While tring to save it it says ‘String index out of range: -1’.

WHEN CONDITION{DBQuery {'select CLIENTHCPLOCATIONID,CLIENTHCPID from HCP_STAGE where CLIENTHCPLOCATIONID = $Input_TEST_FERRING_HCP_STAGING_UPLOAD_TXT_SCHEMA/Root/Record/ClientHCPLocationID and CLIENTHCPID = $Input_TEST_FERRING_HCP_STAGING_UPLOAD_TXT_SCHEMA/Root/Record/ClientHCPID' ,$var1 ,'true' } = ''} VALUE=[DBQuery {'select HCP_STAGE_SEQ.nextval from dual' ,$var1 ,'true'} ] OTHERWISE VALUE=[DBQuery {'select max(HCP_STAGE_ID) from HCP_STAGE where CLIENTHCPLOCATIONID = $Input_TEST_FERRING_HCP_STAGING_UPLOAD_TXT_SCHEMA/Root/Record/ClientHCPLocationID and CLIENTHCPID = $Input_TEST_FERRING_HCP_STAGING_UPLOAD_TXT_SCHEMA/Root/Record/ClientHCPID' ,$var1 ,'true' } ]

Best Practice/Resolution:
Try storing the db queries within local variables

Error in updating web service publishing parameter

  1. Adeptia WSDL directory (\AdeptiaServer\ServerKernel\wsdl) expects files having extensions. Any file added with no extensions can cause issue and will generate this error. This error may occur if some files with no extension are manually added in the "..\AdeptiaServer\ServerKernel\wsdl" directory.

  1. This can be due to some invalid parameters being filled before submitting the WS provider page.

Will see the below error message:
Error Message:

While updating the web service provider, we must clear the existing web service and recreate otherwise we get the below error.

Error in updating web service publishing parameters: String index out of range: -1

  • Verify that all files in "..\AdeptiaServer\ServerKernel\wsdl" directory should have extensions.

  • Verify the parameters entered in the WS provider page are valid.

Error initializing activity MailSource

You are attempting to trigger a flow without setting eventContextEnabled set to true

Will see the below error message:
Error Message:
We have a process flow triggered by a mail trigger that fails intermittently, apparently on the trigger.

Invariably, the diagnostic message reads,

"Error initializing activity MailSource:<some mail trigger name>:0101000001091
31791171313500054[String index out of range: -1]".

Confirm that are you trying to pass the data from this mail trigger in the process flow. If yes, then eventContextEnabled property is set to true