Copy device error - Unexpected VALUE_STRING, expected VALUE_NUMBER at location : (line no=1, column no=503, offset=502)
Sterpu Victor
I'm trying to copy the default device(dcm4chee-arc) and change the port 11112 to 804 but I receive the error "Unexpected VALUE_STRING, expected VALUE_NUMBER at location : (line no=1, column no=503, offset=502)" as in the images.
If I leave the original port 11112 unchanged then I can succesfully copy the device.
At wildfly log I have this error:
12:37:56,462 WARN [org.dcm4chee.arc.conf.rs.ConfigurationRS]
(default task-23) Response Bad Request caused by
{"errorMessage":"Unexpected VALUE_STRING, expected VALUE_NUMBER at
location : (line no=1, column no=503, offset=502)"}
12:38:01,925 INFO [org.dcm4chee.arc.monitor.rs.ArchiveMonitor]
(default task-23) Process GET /dcm4chee-arc/monitor/serverTime
from nu...@192.168.88.2
12:38:04,642 INFO [org.dcm4chee.arc.conf.rs.ConfigurationRS]
(default task-23) Process GET /dcm4chee-arc/devices/dcm4chee-arc
from nu...@192.168.88.2
12:38:07,004 INFO
[org.dcm4chee.arc.ups.process.impl.UPSProcessingScheduler]
(EE-ManagedScheduledExecutorService-default-Thread-1) start
UPSProcessingScheduler.execute()
12:38:07,005 WARN
[org.hibernate.engine.jdbc.spi.SqlExceptionHelper]
(EE-ManagedExecutorService-default-Thread-136) SQL Error: 0,
SQLState: 08003
12:38:07,005 WARN
[org.hibernate.engine.jdbc.spi.SqlExceptionHelper]
(EE-ManagedExecutorService-default-Thread-137) SQL Error: 0,
SQLState: 08003
12:38:07,006 ERROR
[org.hibernate.engine.jdbc.spi.SqlExceptionHelper]
(EE-ManagedExecutorService-default-Thread-137) This connection has
been closed.
12:38:07,006 ERROR
[org.hibernate.engine.jdbc.spi.SqlExceptionHelper]
(EE-ManagedExecutorService-default-Thread-136) This connection has
been closed.
12:38:07,006 INFO
[org.dcm4chee.arc.ups.process.impl.UPSProcessingScheduler]
(EE-ManagedScheduledExecutorService-default-Thread-1) finished
UPSProcessingScheduler.execute()
12:38:07,006 WARN
[org.dcm4chee.arc.ups.process.impl.UPSProcessingScheduler]
(EE-ManagedExecutorService-default-Thread-136) Failure on
processing UPSProcessingRule{cn='SEND_IAN'}:/n:
javax.persistence.PersistenceException:
org.hibernate.exception.JDBCConnectionException: could not prepare
statement
at
org.hi...@5.3.20.Final//org.hibernate.internal.ExceptionConverterImpl.convert(ExceptionConverterImpl.java:154)
at
org.hi...@5.3.20.Final//org.hibernate.query.internal.AbstractProducedQuery.list(AbstractProducedQuery.java:1575)
at
org.hi...@5.3.20.Final//org.hibernate.query.Query.getResultList(Query.java:132)
at
org.hi...@5.3.20.Final//org.hibernate.query.criteria.internal.compile.CriteriaQueryTypeQueryAdapter.getResultList(CriteriaQueryTypeQueryAdapter.java:74)
at
org.jbos...@24.0.1.Final//org.jboss.as.jpa.container.TypedQueryNonTxInvocationDetacher.getResultList(TypedQueryNonTxInvocationDetacher.java:58)
at
javax.pers...@2.2.3//javax.persistence.TypedQuery.getResultStream(TypedQuery.java:87)
at
deployment.dcm4chee-arc-ear-5.26.0-psql.ear.dcm4chee-arc-query-5.26.0.jar//org.dcm4chee.arc.query.impl.AbstractQuery.executeQuery(AbstractQuery.java:113)
at
deployment.dcm4chee-arc-ear-5.26.0-psql.ear.dcm4chee-arc-query-5.26.0.jar//org.dcm4chee.arc.query.impl.UPSQuery.executeQuery(UPSQuery.java:60)
at
deployment.dcm4chee-arc-ear-5.26.0-psql.ear.dcm4chee-arc-query-5.26.0.jar//org.dcm4chee.arc.query.impl.AbstractQuery.executeQuery(AbstractQuery.java:96)
at
deployment.dcm4chee-arc-ear-5.26.0-psql.ear.dcm4chee-arc-query-5.26.0.jar//org.dcm4chee.arc.query.impl.UPSQuery.executeQuery(UPSQuery.java:60)
at
deployment.dcm4chee-arc-ear-5.26.0-psql.ear//org.dcm4chee.arc.ups.process.impl.UPSProcessingScheduler$ProcessWorkitems.processMatching(UPSProcessingScheduler.java:187)
at
deployment.dcm4chee-arc-ear-5.26.0-psql.ear//org.dcm4chee.arc.ups.process.impl.UPSProcessingScheduler$ProcessWorkitems.run(UPSProcessingScheduler.java:171)
at
org.jbo...@24.0.1.Final//org.jboss.as.ee.concurrent.ControlPointUtils$ControlledRunnable.run(ControlPointUtils.java:125)
at
org.wildfly.secu...@1.16.1.Final//org.wildfly.security.auth.server.SecurityIdentity.runAsConsumer(SecurityIdentity.java:376)
at
org.wildfly.secu...@1.16.1.Final//org.wildfly.security.auth.server.Scoped.runAsConsumer(Scoped.java:112)
at
org.wildfly.secu...@1.16.1.Final//org.wildfly.security.auth.server.Scoped.runAs(Scoped.java:60)
at
org.jbo...@24.0.1.Final//org.jboss.as.ee.concurrent.SecurityIdentityUtils.lambda$doIdentityWrap$1(SecurityIdentityUtils.java:63)
at
java.base/java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:515)
at
java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264)
at
org.glassfish.javax.enterprise.concurrent//org.glassfish.enterprise.concurrent.internal.ManagedFutureTask.run(ManagedFutureTask.java:117)
at
java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128)
at
java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628)
at java.base/java.lang.Thread.run(Thread.java:829)
at
org.glassfish.javax.enterprise.concurrent//org.glassfish.enterprise.concurrent.ManagedThreadFactoryImpl$ManagedThread.run(ManagedThreadFactoryImpl.java:227)
Caused by: org.hibernate.exception.JDBCConnectionException: could
not prepare statement
at
org.hi...@5.3.20.Final//org.hibernate.exception.internal.SQLStateConversionDelegate.convert(SQLStateConversionDelegate.java:115)
at
org.hi...@5.3.20.Final//org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:42)
at
org.hi...@5.3.20.Final//org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:113)
at
org.hi...@5.3.20.Final//org.hibernate.engine.jdbc.internal.StatementPreparerImpl$StatementPreparationTemplate.prepareStatement(StatementPreparerImpl.java:186)
at
org.hi...@5.3.20.Final//org.hibernate.engine.jdbc.internal.StatementPreparerImpl.prepareQueryStatement(StatementPreparerImpl.java:151)
at
org.hi...@5.3.20.Final//org.hibernate.loader.Loader.prepareQueryStatement(Loader.java:2082)
at
org.hi...@5.3.20.Final//org.hibernate.loader.Loader.executeQueryStatement(Loader.java:2012)
at
org.hi...@5.3.20.Final//org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1990)
at
org.hi...@5.3.20.Final//org.hibernate.loader.Loader.doQuery(Loader.java:949)
at
org.hi...@5.3.20.Final//org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:351)
at
org.hi...@5.3.20.Final//org.hibernate.loader.Loader.doList(Loader.java:2787)
at
org.hi...@5.3.20.Final//org.hibernate.loader.Loader.doList(Loader.java:2770)
at
org.hi...@5.3.20.Final//org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2604)
at
org.hi...@5.3.20.Final//org.hibernate.loader.Loader.list(Loader.java:2599)
at
org.hi...@5.3.20.Final//org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:505)
at
org.hi...@5.3.20.Final//org.hibernate.hql.internal.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:395)
at
org.hi...@5.3.20.Final//org.hibernate.engine.query.spi.HQLQueryPlan.performList(HQLQueryPlan.java:220)
at
org.hi...@5.3.20.Final//org.hibernate.internal.SessionImpl.list(SessionImpl.java:1526)
at
org.hi...@5.3.20.Final//org.hibernate.query.internal.AbstractProducedQuery.doList(AbstractProducedQuery.java:1598)
at
org.hi...@5.3.20.Final//org.hibernate.query.internal.AbstractProducedQuery.list(AbstractProducedQuery.java:1566)
... 22 more
Caused by: org.postgresql.util.PSQLException: This connection has
been closed.
at
org.pos...@42.2.21//org.postgresql.jdbc.PgConnection.checkClosed(PgConnection.java:877)
at
org.pos...@42.2.21//org.postgresql.jdbc.PgConnection.setAutoCommit(PgConnection.java:806)
at
org.jboss.ironjac...@1.4.35.Final//org.jboss.jca.adapters.jdbc.BaseWrapperManagedConnection.checkTransaction(BaseWrapperManagedConnection.java:915)
at
org.jboss.ironjac...@1.4.35.Final//org.jboss.jca.adapters.jdbc.WrappedConnection.checkTransaction(WrappedConnection.java:1995)
at
org.jboss.ironjac...@1.4.35.Final//org.jboss.jca.adapters.jdbc.WrappedConnection.prepareStatement(WrappedConnection.java:472)
at
org.hi...@5.3.20.Final//org.hibernate.engine.jdbc.internal.StatementPreparerImpl$5.doPrepare(StatementPreparerImpl.java:149)
at
org.hi...@5.3.20.Final//org.hibernate.engine.jdbc.internal.StatementPreparerImpl$StatementPreparationTemplate.prepareStatement(StatementPreparerImpl.java:176)
... 38 more
Victor S
The error " Caused by: org.postgresql.util.PSQLException: This connection has been closed." can be ignored, I restarted postgresql while running wildfly... The log only shows this when the connection is fine: