Issue Description
Special Characters in the Skill Group names cause issues. You can verify the error in the Chronicall/Tomcat logs. Removing the special characters will improve the Realtime Data you are getting.
2019-08-26 07:05:29.404 [ERROR] Query Error. Here is the stack trace but don't bounce out of the query thread. (ConnectionManager.java:498)
java.lang.RuntimeException: Error executing query: "UPDATE c_feature SET value1 = 'James' Group', end_time = CASE WHEN '2019-08-26 07:05:29.376' < start_time THEN start_time ELSE '2019-08-26 07:05:29.376' END WHERE feature_id = 2778758"
at com.ximasoft.chronicall.connection.ConnectionManager.execute(ConnectionManager.java:299)
at com.ximasoft.chronicall.connection.ConnectionManager.execute(ConnectionManager.java:262)
at com.ximasoft.chronicall.connection.ConnectionManager$2.run(ConnectionManager.java:487)
at java.lang.Thread.run(Thread.java:748)
Caused by: org.postgresql.util.PSQLException: ERROR: syntax error at or near "Group"
Position: 39
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2102)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1835)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:500)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:374)
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:366)
at com.ximasoft.chronicall.connection.ConnectionManager.execute(ConnectionManager.java:287)
... 3 more
2019-08-26 07:05:30.638 ERROR: Original Trace From Queued Query:
java.lang.Thread.getStackTrace(Thread.java:1559)
com.ximasoft.chronicall.connection.QueryWrapper.<init>(QueryWrapper.java:27)
com.ximasoft.chronicall.connection.QueryWrapper.<init>(QueryWrapper.java:17)
com.ximasoft.chronicall.connection.ConnectionManager.queueSQL(ConnectionManager.java:523)
com.ximasoft.chronicall.connection.DbFacade.postgres_EndFeatureInDatabase(DbFacade.java:152)
com.ximasoft.chronicall.connection.DbFacade.endFeatureInDatabase(DbFacade.java:119)
com.ximasoft.chronicall.realtime2.manager.feature.FeatureCenter.lambda$endFeatureInDatabase$13(FeatureCenter.java:1504)
java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
java.util.concurrent.FutureTask.run(FutureTask.java:266)
java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$201(ScheduledThreadPoolExecutor.java:180)
java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:293)
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
java.lang.Thread.run(Thread.java:748)
(ConnectionManager.java:496)
2019-08-26 07:05:30.638 [ERROR] Query Error. Here is the stack trace but don't bounce out of the query thread. (ConnectionManager.java:498)
java.lang.RuntimeException: Error executing query: "UPDATE c_feature SET value1 = 'James' Group', end_time = CASE WHEN '2019-08-26 07:05:30.617' < start_time THEN start_time ELSE '2019-08-26 07:05:30.617' END WHERE feature_id = 2778966"
at com.ximasoft.chronicall.connection.ConnectionManager.execute(ConnectionManager.java:299)
at com.ximasoft.chronicall.connection.ConnectionManager.execute(ConnectionManager.java:262)
at com.ximasoft.chronicall.connection.ConnectionManager$2.run(ConnectionManager.java:487)
at java.lang.Thread.run(Thread.java:748)
Caused by: org.postgresql.util.PSQLException: ERROR: syntax error at or near "Group"
Position: 39
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2102)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1835)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:500)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:374)
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:366)
at com.ximasoft.chronicall.connection.ConnectionManager.execute(ConnectionManager.java:287)