Troubleshooting
Problem
Part of deploying the IBM i2 iBase Connector for IBM i2 Analyze involves applying a schema from one application to another. In the case of applying the IBM i2 Analyze schema to an IBM i2 iBase database, you need to configure the environment.properties file from the toolkit\configuration\environment\iBase folder. One of the properties in this file is called the path.to.jtds.jar and the error occurs when this path is not correctly configured to use / (forwardslash) characters but instead contains \ (backslash) characters .
Symptom
Error msg Execution failed for task ':replaceIBaseSchemaFromI2Analyze'.
> java.net.URISyntaxException: Illegal character in opaque part at index 14: C:I
BMi2analyze oolkitconfigurationenvironmentcommonjdbc-drivers
Cause
You have set the path.to.jtds.jar property to a value that does not conform to the correct syntax expected. Most likely you have not changed the file path \ (backslash) characters to be / (forwardslash) instead
Diagnosing The Problem
You attempt to run setup -t replaceIBaseSchemaFromI2Analyze command as part of deploying the IBM i2 iBase Connector for IBM i2 Analyze. The command fails with the error details as above.
Resolving The Problem
Ensure the file value to the path.to.jtds.jar file contains only / (forwardslashes) and not \ (backslashes) like in this example: C:/IBM/i2analyze/toolkit/configuration/environment/common/jdbc-drivers.
Re-run the setup -t replaceIBaseSchemaFromI2Analyze command and you should not experience the error.
Was this topic helpful?
Document Information
Modified date:
16 June 2018
UID
swg21994393