Article - CS270206

ThingWorx Analytics, ThingWatcher failes during training caused by "org.skife.jdbi.v2.exceptions.UnableToExecuteStatementException: org.h2.jdbc.JdbcSQLException"

Modified: 18-Jan-2018   

Applies To

  • ThingWorx Analytics 7.4

Description

  • Encounter below error message when running Anomaly Detection (ThingWatcher)
{Throwable=[RetryableTrainingRequestException: Received error from POST of Training request with Code(500)_Message(Internal Server Error)_Details:_{code=500, message=Failed during training, details=Caused by: org.skife.jdbi.v2.exceptions.UnableToExecuteStatementException: org.h2.jdbc.JdbcSQLException: Unique index or primary key violation: "CONSTRAINT_INDEX_C ON PUBLIC.JOB_EXEC_INFO(CLAIM_CHECK) VALUES...
A file path that is implicitly relative to the current working directory is not allowed in the database URL "jdbc:h2:file:/data/training/db:training"
org.apache.tomcat.jdbc.pool.ConnectionPool: Unable to create initial connections of pool.
​Causing: org.h2.jdbc.JdbcSQLException: IO Exception: "java.io.IOException:Filename, directory name or volume label syntax is incorrect."; "./data/training/db:training/db:training.mv.db"
  • Encounter below exception message when deploying training microservices from cmd
Exception in thread "main" org.flywaydb.core.api.FlywayException: Unable to obtain Jdbc connection from DataSource
Caused by: org.h2.jdbc.JdbcSQLException: A file path that is implicitly relative to the current working directory is not allowed in the database URL "jdbc:h2:file:/data/training/db:training". Use an absolute path, ~/name, ./name, or the baseDir setting instead. [90011-192]
at org.h2.message.DbException.getJdbcSQLException(DbException.java:345)
at org.h2.message.DbException.get(DbException.java:179)
at org.h2.message.DbException.get(DbException.java:155)
at org.h2.engine.ConnectionInfo.getName(ConnectionInfo.java:400)
This is a PDF version of Article CS270206 and may be out of date. For the latest version click https://www.ptc.com/en/support/article/CS270206