Problem:
Remote Display stats are being collected and sent in by the Connector ID agent, but are not visible in the Remote Display Inspector of the Stratusphere WebUI.
Error found in contrast in the servicemix.log on the HUB or Collector
2022-10-13 18:28:19,833 | ERROR | Thread-1239 | InspectionDataBatch | 333 - lwl-objectbase - 0.16.0 | Failed to commit batch
org.postgresql.util.PSQLException: ERROR: invalid input syntax for integer: "15.684"
Where: COPY summaryreport_display_proto_stats_daily_20151013, line 1, column sent_avg_kbit: "15.684"
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2161)[262:postgresql94-jdbc.jar:0.0.0]
at org.postgresql.core.v3.QueryExecutorImpl.processCopyResults(QueryExecutorImpl.java:966)[262:postgresql94-jdbc.jar:0.0.0]
at org.postgresql.core.v3.QueryExecutorImpl.endCopy(QueryExecutorImpl.java:828)[262:postgresql94-jdbc.jar:0.0.0]
at org.postgresql.core.v3.CopyInImpl.endCopy(CopyInImpl.java:59)[262:postgresql94-jdbc.jar:0.0.0]
at org.postgresql.copy.CopyManager.copyIn(CopyManager.java:181)[262:postgresql94-jdbc.jar:0.0.0]
at org.postgresql.copy.CopyManager.copyIn(CopyManager.java:161)[262:postgresql94-jdbc.jar:0.0.0]
at com.liquidwarelabs.common.db.copy.impl.postgresql.PostgresqlSqlBulkCopierImpl.copyIn(PostgresqlSqlBulkCopierImpl.java:104)[279:lwl-common-database-copy-postgresql:0.14.0]
at Proxy23d71007_1e6c_4c40_8898_cab42461db63.copyIn(Unknown Source)[:]
at Proxyae29229b_085f_4a7a_80a0_b787ceb15a36.copyIn(Unknown Source)[:]
at com.liquidwarelabs.stratusphere.data.inspection.processor.copy.InspectionDataBatch.commit(InspectionDataBatch.java:176)[331:lwl-inspection-data-processor-copy:0.97.0]
at com.liquidwarelabs.stratusphere.data.inspection.processor.copy.InspectionDataBatch.lambda$new$0(InspectionDataBatch.java:65)[331:lwl-inspection-data-processor-copy:0.97.0]
at com.liquidwarelabs.stratusphere.data.inspection.processor.copy.InspectionDataBatch$$Lambda$12/546228897.run(Unknown Source)[331:lwl-inspection-data-processor-copy:0.97.0]
at com.google.common.util.concurrent.MoreExecutors$ScheduledListeningDecorator$NeverSuccessfulListenableFutureTask.run(MoreExecutors.java:648)[284:com.google.guava:18.0.0]
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)[:1.8.0_51]
at java.util.concurrent.FutureTask.runAndReset(FutureTask.java:308)[:1.8.0_51]
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$301(ScheduledThreadPoolExecutor.java:180)[:1.8.0_51]
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:294)[:1.8.0_51]
at com.liquidwarelabs.common.executorservice.ExecutorServiceScheduledExecutorServiceDecorator$DelegatingRunnableScheduledFuture$1.run(ExecutorServiceScheduledExecutorServiceDecorator.java:136)[260:lwl-executor-service:0.46.0]
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)[:1.8.0_51]
at com.liquidwarelabs.common.executorservice.PrioritizedCallableRunnable.run(PrioritizedCallableRunnable.java:40)[260:lwl-executor-service:0.46.0]
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)[:1.8.0_51]
at java.util.concurrent.FutureTask.run(FutureTask.java:266)[:1.8.0_51]
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)[:1.8.0_51]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)[:1.8.0_51]
at java.lang.Thread.run(Thread.java:745)[:1.8.0_51]
Possible resolution:
Contact support@liquidware.com, a database update may have to be ran manually to resolve the issue.
Product: Stratusphere FIT/UX
Product Version: N/A
Expires on: 365 days from publish date
Updated: June 15, 2022