查看: 6546|回复: 9

流程应用创建出错

升级   5.1%

54

主题

173

回帖

510

积分

注册会员

Rank: 2

积分
510
发表于 2019-3-28 11:30:15 | 显示全部楼层 |阅读模式
报错:Failed to execute query "null". Check the query syntax for correctness. See nested exception for details.
请问下这是什么嵌套错误?
回复

使用道具 举报

升级   5.1%

54

主题

173

回帖

510

积分

注册会员

Rank: 2

积分
510
发表于 2019-4-4 11:55:51 | 显示全部楼层
1.您这边需要看数据库什么信息呢?
2.外网也无法访问,OA无法启动
回复

使用道具 举报

升级   5.1%

54

主题

173

回帖

510

积分

注册会员

Rank: 2

积分
510
发表于 2019-4-2 13:38:29 | 显示全部楼层
回复

使用道具 举报

Ray

升级   100%

31

主题

208

回帖

891

积分

管理员

Rank: 9Rank: 9Rank: 9

积分
891
发表于 2019-4-2 17:18:28 | 显示全部楼层
1.麻烦提供一下数据库的信息.
2.外网能否访问导致错误的环境?
回复

使用道具 举报

升级   5.1%

54

主题

173

回帖

510

积分

注册会员

Rank: 2

积分
510
发表于 2019-3-28 18:04:03 | 显示全部楼层
无法创建
回复

使用道具 举报

升级   100%

139

主题

1万

回帖

4万

积分

超级版主

Rank: 8Rank: 8

积分
41458
发表于 2019-4-1 09:39:23 | 显示全部楼层
通过这个无法定位到您的错误,请更新到最新版本您再尝试一下,并且将o2server/logs目录中最新的日志文件贴出来看一下。如果无法上传日志文件,您也可以再另起一个贴子以附件形式上传日志。
回复

使用道具 举报

升级   5.1%

54

主题

173

回帖

510

积分

注册会员

Rank: 2

积分
510
发表于 2019-4-1 10:41:41 | 显示全部楼层
谢谢。这是刚才我重新创建失败的日志文件
回复

使用道具 举报

升级   100%

139

主题

1万

回帖

4万

积分

超级版主

Rank: 8Rank: 8

积分
41458
发表于 2019-5-5 09:44:52 | 显示全部楼层
另外,也给出您的node_127.0.0.1.json和center.json的配置文件以便我们排查问题。
回复

使用道具 举报

升级   100%

139

主题

1万

回帖

4万

积分

超级版主

Rank: 8Rank: 8

积分
41458
发表于 2019-5-5 09:44:13 | 显示全部楼层
1、升级到最新版本
2、如果仍报错,请在操作后,上传日志 o2server/logs目录中
3、先保证在内网可以正常使用,再排查是否内外网切换的问题。
回复

使用道具 举报

升级   5.1%

54

主题

173

回帖

510

积分

注册会员

Rank: 2

积分
510
发表于 2019-4-1 10:41:13 | 显示全部楼层
2019-04-01 10:22:02 ERROR [f6ef0df5-8e04-4f08-8cfa-9598cb83314a] 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 <> ?)
} [code=1267, state=HY000]
        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 (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
        ?, ?, ?)
} [code=1366, state=HY000]
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 (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
        ?, ?, ?)
} [code=1366, state=HY000]
        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
回复

使用道具 举报

发表回复

您需要登录后才可以回帖 登录 | 立即注册

本版积分规则

联系客服 关注微信 下载APP 返回顶部 返回列表
viewthread