流程应用创建出错
报错：Failed to execute query "null". Check the query syntax for correctness. See nested exception for details.请问下这是什么嵌套错误？ 1.您这边需要看数据库什么信息呢？
2.外网也无法访问，OA无法启动 顶 1.麻烦提供一下数据库的信息.
2.外网能否访问导致错误的环境? 无法创建 通过这个无法定位到您的错误，请更新到最新版本您再尝试一下，并且将o2server/logs目录中最新的日志文件贴出来看一下。如果无法上传日志文件，您也可以再另起一个贴子以附件形式上传日志。 谢谢。这是刚才我重新创建失败的日志文件 另外，也给出您的node_127.0.0.1.json和center.json的配置文件以便我们排查问题。 1、升级到最新版本
2、如果仍报错，请在操作后，上传日志 o2server/logs目录中
3、先保证在内网可以正常使用，再排查是否内外网切换的问题。 2019-04-01 10:22:02 ERROR com.x.processplatform.assemble.designer.jaxrs.application.ApplicationAction - Failed to execute query "null". Check the query syntax for correctness. See nested exception for details. > person:xadmin, method:POST, request:http://172.3.0.124:20020/x_processplatform_assemble_designer/jaxrs/application, remote host:172.2.0.230 address:172.2.0.230, head:Origin:https://172.3.0.124
Cookie:x-token=wqCcGzx65ixybpQSLsr3yGkmI9S1KdQf5aN3GcgxOIA
Accept:application/json
X-Requested-With:XMLHttpRequest
Connection:keep-alive
User-Agent:Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/71.0.3578.98 Safari/537.36
Referer:https://172.3.0.124/x_desktop/index.html
Host:172.3.0.124:20020
Accept-Encoding:gzip, deflate, br
Accept-Language:zh-CN,zh;q=0.9
Content-Length:120
Content-Type:application/json; charset=UTF-8, body:{
"name": "测速",
"alias": "",
"description": "",
"applicationCategory": "测速",
"id": "44e76ab7-1201-4e38-945e-fde2e5835ab5"
}.
<openjpa-3.0.1-SNAPSHOT-rb714dbae1876957a56133ff2aebb5d84919af79e nonfatal user error> org.apache.openjpa.persistence.ArgumentException: Failed to execute query "null". Check the query syntax for correctness. See nested exception for details.
at org.apache.openjpa.kernel.QueryImpl.execute(QueryImpl.java:921)
at org.apache.openjpa.kernel.QueryImpl.execute(QueryImpl.java:843)
at org.apache.openjpa.slice.DistributedQueryImpl.execute(DistributedQueryImpl.java:61)
at org.apache.openjpa.kernel.DelegatingQuery.execute(DelegatingQuery.java:601)
at org.apache.openjpa.persistence.QueryImpl.execute(QueryImpl.java:297)
at org.apache.openjpa.persistence.QueryImpl.getResultList(QueryImpl.java:314)
at org.apache.openjpa.persistence.QueryImpl.getSingleResult(QueryImpl.java:343)
at com.x.base.core.container.checker.StringValuePersistChecker.citationNotExists(StringValuePersistChecker.java:192)
at com.x.base.core.container.checker.StringValuePersistChecker.check(StringValuePersistChecker.java:53)
at com.x.base.core.container.EntityManagerContainer.check(EntityManagerContainer.java:82)
at com.x.base.core.container.EntityManagerContainer.persist(EntityManagerContainer.java:54)
at com.x.processplatform.assemble.designer.jaxrs.application.ActionCreate.execute(ActionCreate.java:40)
at com.x.processplatform.assemble.designer.jaxrs.application.ApplicationAction.post(ApplicationAction.java:139)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at org.glassfish.jersey.server.model.internal.ResourceMethodInvocationHandlerFactory$1.invoke(ResourceMethodInvocationHandlerFactory.java:81)
at org.glassfish.jersey.server.model.internal.AbstractJavaResourceMethodDispatcher$1.run(AbstractJavaResourceMethodDispatcher.java:144)
at org.glassfish.jersey.server.model.internal.AbstractJavaResourceMethodDispatcher.invoke(AbstractJavaResourceMethodDispatcher.java:161)
at org.glassfish.jersey.server.model.internal.JavaResourceMethodDispatcherProvider$VoidOutInvoker.doDispatch(JavaResourceMethodDispatcherProvider.java:143)
at org.glassfish.jersey.server.model.internal.AbstractJavaResourceMethodDispatcher.dispatch(AbstractJavaResourceMethodDispatcher.java:99)
at org.glassfish.jersey.server.model.ResourceMethodInvoker.invoke(ResourceMethodInvoker.java:389)
at org.glassfish.jersey.server.model.ResourceMethodInvoker.apply(ResourceMethodInvoker.java:347)
at org.glassfish.jersey.server.model.ResourceMethodInvoker.apply(ResourceMethodInvoker.java:102)
at org.glassfish.jersey.server.ServerRuntime$2.run(ServerRuntime.java:326)
at org.glassfish.jersey.internal.Errors$1.call(Errors.java:271)
at org.glassfish.jersey.internal.Errors$1.call(Errors.java:267)
at org.glassfish.jersey.internal.Errors.process(Errors.java:315)
at org.glassfish.jersey.internal.Errors.process(Errors.java:297)
at org.glassfish.jersey.internal.Errors.process(Errors.java:267)
at org.glassfish.jersey.process.internal.RequestScope.runInScope(RequestScope.java:317)
at org.glassfish.jersey.server.ServerRuntime.process(ServerRuntime.java:305)
at org.glassfish.jersey.server.ApplicationHandler.handle(ApplicationHandler.java:1154)
at org.glassfish.jersey.servlet.WebComponent.serviceImpl(WebComponent.java:473)
at org.glassfish.jersey.servlet.WebComponent.service(WebComponent.java:427)
at org.glassfish.jersey.servlet.ServletContainer.service(ServletContainer.java:388)
at org.glassfish.jersey.servlet.ServletContainer.service(ServletContainer.java:341)
at org.glassfish.jersey.servlet.ServletContainer.service(ServletContainer.java:228)
at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:865)
at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1655)
at org.eclipse.jetty.websocket.server.WebSocketUpgradeFilter.doFilter(WebSocketUpgradeFilter.java:215)
at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1642)
at com.x.base.core.project.jaxrs.ManagerUserJaxrsFilter.doFilter(ManagerUserJaxrsFilter.java:39)
at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1642)
at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:533)
at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:146)
at org.eclipse.jetty.security.SecurityHandler.handle(SecurityHandler.java:548)
at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:132)
at org.eclipse.jetty.server.handler.ScopedHandler.nextHandle(ScopedHandler.java:257)
at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:1595)
at org.eclipse.jetty.server.handler.ScopedHandler.nextHandle(ScopedHandler.java:255)
at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1253)
at org.eclipse.jetty.server.handler.ScopedHandler.nextScope(ScopedHandler.java:203)
at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:473)
at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:1564)
at org.eclipse.jetty.server.handler.ScopedHandler.nextScope(ScopedHandler.java:201)
at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1155)
at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:144)
at org.eclipse.jetty.server.handler.ContextHandlerCollection.handle(ContextHandlerCollection.java:219)
at org.eclipse.jetty.server.handler.HandlerList.handle(HandlerList.java:61)
at org.eclipse.jetty.server.handler.gzip.GzipHandler.handle(GzipHandler.java:674)
at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:132)
at org.eclipse.jetty.server.Server.handle(Server.java:531)
at org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:352)
at org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:260)
at org.eclipse.jetty.io.AbstractConnection$ReadCallback.succeeded(AbstractConnection.java:281)
at org.eclipse.jetty.io.FillInterest.fillable(FillInterest.java:102)
at org.eclipse.jetty.io.ssl.SslConnection.onFillable(SslConnection.java:291)
at org.eclipse.jetty.io.ssl.SslConnection$3.succeeded(SslConnection.java:151)
at org.eclipse.jetty.io.FillInterest.fillable(FillInterest.java:102)
at org.eclipse.jetty.io.ChannelEndPoint$2.run(ChannelEndPoint.java:118)
at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.runTask(EatWhatYouKill.java:333)
at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.doProduce(EatWhatYouKill.java:310)
at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.tryProduce(EatWhatYouKill.java:168)
at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.run(EatWhatYouKill.java:126)
at org.eclipse.jetty.util.thread.ReservedThreadExecutor$ReservedThread.run(ReservedThreadExecutor.java:366)
at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:760)
at org.eclipse.jetty.util.thread.QueuedThreadPool$2.run(QueuedThreadPool.java:678)
at java.lang.Thread.run(Thread.java:748)
Caused by: org.apache.openjpa.lib.jdbc.ReportingSQLException: Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8mb4_general_ci,COERCIBLE) for operation '=' {prepstmnt 923406678
SELECT COUNT(t0.xid)
FROM PP_E_APPLICATION t0
WHERE ((1 <> 1 OR t0.xid = ? OR t0.xname = ? OR t0.xalias = ?) AND
t0.xid <> ?)
}
at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.wrap(LoggingConnectionDecorator.java:219)
at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.wrap(LoggingConnectionDecorator.java:203)
at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.access$700(LoggingConnectionDecorator.java:58)
at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator$LoggingConnection$LoggingPreparedStatement.executeQuery(LoggingConnectionDecorator.java:1171)
at org.apache.openjpa.lib.jdbc.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:300)
at org.apache.openjpa.jdbc.kernel.JDBCStoreManager$CancelPreparedStatement.executeQuery(JDBCStoreManager.java:1866)
at org.apache.openjpa.lib.jdbc.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:290)
at org.apache.openjpa.jdbc.sql.SelectImpl.executeQuery(SelectImpl.java:530)
at org.apache.openjpa.jdbc.sql.SelectImpl.execute(SelectImpl.java:455)
at org.apache.openjpa.jdbc.sql.SelectImpl.execute(SelectImpl.java:422)
at org.apache.openjpa.jdbc.sql.LogicalUnion$UnionSelect.execute(LogicalUnion.java:472)
at org.apache.openjpa.jdbc.sql.LogicalUnion.execute(LogicalUnion.java:254)
at org.apache.openjpa.jdbc.sql.LogicalUnion.execute(LogicalUnion.java:243)
at org.apache.openjpa.jdbc.kernel.SelectResultObjectProvider.open(SelectResultObjectProvider.java:95)
at org.apache.openjpa.slice.jdbc.UniqueResultObjectProvider.open(UniqueResultObjectProvider.java:194)
at org.apache.openjpa.kernel.QueryImpl$PackingResultObjectProvider.open(QueryImpl.java:2183)
at org.apache.openjpa.kernel.QueryImpl.singleResult(QueryImpl.java:1380)
at org.apache.openjpa.kernel.QueryImpl.toResult(QueryImpl.java:1302)
at org.apache.openjpa.kernel.QueryImpl.execute(QueryImpl.java:1062)
at org.apache.openjpa.kernel.QueryImpl.execute(QueryImpl.java:912)
... 79 more
java.lang.Exception: commit error
at com.x.base.core.container.EntityManagerContainer.commit(EntityManagerContainer.java:703)
at com.x.program.center.LogQueue.concreteUnexpectedErrorLog(LogQueue.java:42)
at com.x.program.center.LogQueue.execute(LogQueue.java:21)
at com.x.program.center.LogQueue.execute(LogQueue.java:1)
at com.x.base.core.project.queue.QueueProcessThread.run(QueueProcessThread.java:17)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
at java.lang.Thread.run(Thread.java:748)
Caused by: <openjpa-3.0.1-SNAPSHOT-rb714dbae1876957a56133ff2aebb5d84919af79e fatal store error> org.apache.openjpa.persistence.RollbackException: The transaction has been rolled back.See the nested exceptions for details on the errors that occurred.
FailedObject: com.x.program.center.core.entity.UnexpectedErrorLog@76573a38
at org.apache.openjpa.persistence.EntityManagerImpl.commit(EntityManagerImpl.java:693)
at com.x.base.core.container.EntityManagerContainer.commit(EntityManagerContainer.java:699)
... 7 more
Caused by: <openjpa-3.0.1-SNAPSHOT-rb714dbae1876957a56133ff2aebb5d84919af79e fatal general error> org.apache.openjpa.persistence.PersistenceException: The transaction has been rolled back.See the nested exceptions for details on the errors that occurred.
FailedObject: com.x.program.center.core.entity.UnexpectedErrorLog@76573a38
at org.apache.openjpa.kernel.BrokerImpl.newFlushException(BrokerImpl.java:2470)
at org.apache.openjpa.kernel.BrokerImpl.flush(BrokerImpl.java:2308)
at org.apache.openjpa.slice.DistributedBrokerImpl.flush(DistributedBrokerImpl.java:159)
at org.apache.openjpa.kernel.BrokerImpl.flushSafe(BrokerImpl.java:2199)
at org.apache.openjpa.kernel.BrokerImpl.beforeCompletion(BrokerImpl.java:2116)
at org.apache.openjpa.kernel.LocalManagedRuntime.commit(LocalManagedRuntime.java:84)
at org.apache.openjpa.kernel.BrokerImpl.commit(BrokerImpl.java:1600)
at org.apache.openjpa.kernel.DelegatingBroker.commit(DelegatingBroker.java:1035)
at org.apache.openjpa.persistence.EntityManagerImpl.commit(EntityManagerImpl.java:669)
... 8 more
Caused by: <openjpa-3.0.1-SNAPSHOT-rb714dbae1876957a56133ff2aebb5d84919af79e fatal general error> org.apache.openjpa.persistence.PersistenceException: Incorrect string value: '\xE6\xB5\x8B\xE9\x80\x9F...' for column 'xrequestBody' at row 1 {prepstmnt 1650110174
INSERT INTO CTE_UNEXPECTEDERRORLOG (xid, xcreateTime, xscratchBoolean,
xscratchDate, xscratchInteger, xscratchString, xsequence,
xupdateTime, xdistributeFactor, xcollected, xexceptionClass,
xloggerName, xmessage, xoccurTime, xperson, xrequestBody,
xrequestBodyLength, xrequestHead, xrequestMethod,
xrequestRemoteAddr, xrequestRemoteHost, xrequestUrl,
xstackTrace, xversion)
VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
?, ?, ?)
}
FailedObject: com.x.program.center.core.entity.UnexpectedErrorLog@76573a38
at org.apache.openjpa.jdbc.sql.DBDictionary.narrow(DBDictionary.java:5244)
at org.apache.openjpa.jdbc.sql.DBDictionary.newStoreException(DBDictionary.java:5204)
at org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:134)
at org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:75)
at org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.flushAndUpdate(PreparedStatementManagerImpl.java:146)
at org.apache.openjpa.jdbc.kernel.BatchingPreparedStatementManagerImpl.flushAndUpdate(BatchingPreparedStatementManagerImpl.java:80)
at org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.flushInternal(PreparedStatementManagerImpl.java:102)
at org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.flush(PreparedStatementManagerImpl.java:90)
at org.apache.openjpa.jdbc.kernel.ConstraintUpdateManager.flush(ConstraintUpdateManager.java:554)
at org.apache.openjpa.jdbc.kernel.ConstraintUpdateManager.flush(ConstraintUpdateManager.java:110)
at org.apache.openjpa.jdbc.kernel.BatchingConstraintUpdateManager.flush(BatchingConstraintUpdateManager.java:61)
at org.apache.openjpa.jdbc.kernel.AbstractUpdateManager.flush(AbstractUpdateManager.java:108)
at org.apache.openjpa.jdbc.kernel.AbstractUpdateManager.flush(AbstractUpdateManager.java:81)
at org.apache.openjpa.jdbc.kernel.JDBCStoreManager.flush(JDBCStoreManager.java:757)
at org.apache.openjpa.slice.jdbc.DistributedJDBCStoreManager$Flusher.call(DistributedJDBCStoreManager.java:561)
at org.apache.openjpa.slice.jdbc.DistributedJDBCStoreManager$Flusher.call(DistributedJDBCStoreManager.java:550)
at java.util.concurrent.FutureTask.run(FutureTask.java:266)
... 3 more
Caused by: org.apache.openjpa.lib.jdbc.ReportingSQLException: Incorrect string value: '\xE6\xB5\x8B\xE9\x80\x9F...' for column 'xrequestBody' at row 1 {prepstmnt 1650110174
INSERT INTO CTE_UNEXPECTEDERRORLOG (xid, xcreateTime, xscratchBoolean,
xscratchDate, xscratchInteger, xscratchString, xsequence,
xupdateTime, xdistributeFactor, xcollected, xexceptionClass,
xloggerName, xmessage, xoccurTime, xperson, xrequestBody,
xrequestBodyLength, xrequestHead, xrequestMethod,
xrequestRemoteAddr, xrequestRemoteHost, xrequestUrl,
xstackTrace, xversion)
VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
?, ?, ?)
}
at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.wrap(LoggingConnectionDecorator.java:219)
at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.wrap(LoggingConnectionDecorator.java:195)
at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.access$1000(LoggingConnectionDecorator.java:58)
at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator$LoggingConnection$LoggingPreparedStatement.executeUpdate(LoggingConnectionDecorator.java:1188)
at org.apache.openjpa.lib.jdbc.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:308)
at org.apache.openjpa.jdbc.kernel.JDBCStoreManager$CancelPreparedStatement.executeUpdate(JDBCStoreManager.java:1856)
at org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.executeUpdate(PreparedStatementManagerImpl.java:271)
at org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.flushAndUpdate(PreparedStatementManagerImpl.java:121)
... 15 more
页:
[1]