做个一个报表，在设计器中如下图所示92220
上半部分是已经填好的，下面的整改措施、责任人、三定时间填好后，点提交，可以正常更新。
由于这两部分是不同的用户在操作，所以在权限里就做了权限编辑，如图
92221
指定用户只能编辑下面的三个部分。
然后发布到决策系统中，出现如下问题
92222
应该不是数据库的问题，因为之前已经正常提交过，是没有问题的。
可是权限编辑后，用这个用户登录就报错了，不明白怎么回事。求大神帮忙。
下面附上日志。
2018-01-14 23:23:35
正常:SELECT id,userName,reportPath,data FROM FR_WRITE_TEMP_DATA WHERE reportPath=? AND userName=?
2018-01-14 23:23:35
正常:columnIndex:1columnValue:DangerInfoModify.cpt
2018-01-14 23:23:35
正常:columnIndex:2columnValue:chengwenliang
2018-01-14 23:23:36
正常:SQL: SELECT * FROM dbo. where 1 = 1 and dangerInfoID = 5
2018-01-14 23:23:36
正常:开始计算报表
2018-01-14 23:23:36
正常:SQL TIME:8ms! -DATA_SOURCE_POOL
2018-01-14 23:23:36
正常:完成报表计算 耗时:15ms!
2018-01-14 23:23:36
正常:columnIndex:1columnValue:DangerInfoModify.cpt
2018-01-14 23:23:36
正常:columnIndex:2columnValue:2
2018-01-14 23:23:36
正常:columnIndex:3columnValue:_ : 1515943319478, __FIT__ : true, __LOCALE__ : zh_CN, __STREAMCLOSED__ : , DANGERINFOID : 5, FR_AUTHORITY : , FR_CURRENT_PRIVILEGE_LOADER : com.fr.fs.privilege.base.FServicePrivilegeLoader@10e8e4b, FR_FS_AUTH_KEY : com.fr.fs.privilege.entity.DaoFSAuthentication@cdacba: Principal: chengwenliang; Password: ; Authenticated: true; Granted Authorities: com.fr.fs.base.entity.CompanyRole@cb, com.fr.fs.base.entity.CompanyRole@cc, com.fr.fs.base.entity.CompanyRole@93: User: chengwenliang; , FR_USERNAME : chengwenliang, FR_USERPOSITION : {"jobTitle":"队长","departments":"安装队"}, OP : write, ORIGINALURL : http://10.34.90.227:8075/WebRepo ... ntry_report&id=2414, REPORTLET : DangerInfoModify.cpt, REPORTNAME : DangerInfoModify.cpt
2018-01-14 23:23:36
正常:columnIndex:4columnValue:10.34.70.252
2018-01-14 23:23:36
正常:columnIndex:5columnValue:chengwenliang
2018-01-14 23:23:36
正常:columnIndex:6columnValue:安装队-队长
2018-01-14 23:23:36
正常:columnIndex:7columnValue:2018-01-14 23:23:36
2018-01-14 23:23:36
正常:columnIndex:8columnValue:15
2018-01-14 23:23:36
正常:columnIndex:9columnValue: where 1 = 1 and dangerInfoID = 5 ; rowcount : 1 ; time : 2018-01-14 23:23:36 ;]
2018-01-14 23:23:36
正常:columnIndex:10columnValue:19600
2018-01-14 23:23:36
正常:columnIndex:11columnValue:{"Agent":"mozilla/4.0 (compatible; msie 8.0; windows nt 5.1; trident/4.0; .net clr 2.0.50727; .net clr 3.0.4506.2152; .net clr 3.5.30729; .net4.0c; .net4.0e; infopath.2)","Version":"8.0","BoxModel":true,"Browser":"msie"}
2018-01-14 23:23:37
正常:SQL: SELECT * FROM dbo.
2018-01-14 23:23:38
正常:SQL: SELECT * FROM dbo.
2018-01-14 23:23:40
正常:SQL: SELECT * FROM dbo.
2018-01-14 23:23:41
正常:SQL: SELECT * FROM dbo.
2018-01-14 23:23:41
正常:SQL: SELECT * FROM dbo.
2018-01-14 23:23:56
正常:UPDATE SET =?,=?,=?,=?,=?,=?,=?,=?,=?,=?,=?,=?,=?,=?,=?,=?,=?,=? WHERE =?
2018-01-14 23:23:56
正常:columnIndex:1columnValue:安装队
2018-01-14 23:23:56
正常:columnIndex:2columnValue:日常小分队
2018-01-14 23:23:56
正常:columnIndex:3columnValue:机电
2018-01-14 23:23:56
正常:columnIndex:4columnValue:D级隐患
2018-01-14 23:23:56
正常:columnIndex:5columnValue:2018-01-14
2018-01-14 23:23:56
正常:columnIndex:6columnValue:0点班
2018-01-14 23:23:56
正常:columnIndex:7columnValue:2-118D2工作面
2018-01-14 23:23:56
正常:columnIndex:8columnValue:小分队
2018-01-14 23:23:56
正常:columnIndex:9columnValue:
2018-01-14 23:23:56
正常:columnIndex:10columnValue:
2018-01-14 23:23:56
正常:columnIndex:11columnValue:
2018-01-14 23:23:56
正常:columnIndex:12columnValue:
2018-01-14 23:23:56
正常:columnIndex:13columnValue:2-118D2工作面综掘机外喷损坏，需处理。
2018-01-14 23:23:56
正常:columnIndex:14columnValue:处理。
2018-01-14 23:23:56
正常:columnIndex:15columnValue:成文亮
2018-01-14 23:23:56
正常:columnIndex:16columnValue:2018-01-15
2018-01-14 23:23:56
正常:columnIndex:17columnValue:2018-01-14
2018-01-14 23:23:56
正常:columnIndex:18columnValue:chengwenliang
2018-01-14 23:23:56
正常:columnIndex:19columnValue:5
2018-01-14 23:23:56
警告:将截断字符串或二进制数据。
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PrepStmtExecCmd.doExecute(Unknown Source)
at com.microsoft.sqlserver.jdbc.TDSCommand.execute(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.executeUpdate(Unknown Source)
at com.fr.third.org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
at com.fr.third.org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
at com.fr.write.config.UpdateConfig.update(Unknown Source)
at com.fr.write.config.UpdateConfig.simpleSubmit(Unknown Source)
at com.fr.write.config.UpdateConfig.dmlSubmit(Unknown Source)
at com.fr.write.config.UpdateConfig.dmlSubmitBatch(Unknown Source)
at com.fr.write.config.DMLConfig$ExtractionSubmitter.run(Unknown Source)
at com.fr.write.cal.WB.runEachAction(Unknown Source)
at com.fr.write.cal.WB.setCurrentColumnRow(Unknown Source)
at com.fr.write.config.DMLConfig.extract(Unknown Source)
at com.fr.write.config.DMLConfig.extractGroup(Unknown Source)
at com.fr.write.config.DMLConfig.execute(Unknown Source)
at com.fr.write.DBCommitWrapper.commit(Unknown Source)
at com.fr.write.DBCommitWrapper.commit2db(Unknown Source)
at com.fr.report.write.BuiltInSQLSubmiter.execute(Unknown Source)
at com.fr.report.write.ReportWriteAttr.submit(Unknown Source)
at com.fr.report.write.SubmitHelper.submit(Unknown Source)
at com.fr.report.write.SubmitHelper.submit(Unknown Source)
at com.fr.web.core.A.DB.actionCMD(Unknown Source)
at com.fr.web.core.WebActionsDispatcher.dealForActionCMD(Unknown Source)
at com.fr.web.core.WebActionsDispatcher.dealForActionDefaultCmd(Unknown Source)
at com.fr.web.core.WebActionsDispatcher.dealForActionCMD(Unknown Source)
at com.fr.web.core.A.hC.process(Unknown Source)
at com.fr.web.core.ReportDispatcher.dealWithOp(Unknown Source)
at com.fr.web.core.ReportDispatcher.dealWeblet(Unknown Source)
at com.fr.web.core.ReportDispatcher.dealWithRequest(Unknown Source)
at com.fr.web.BaseServlet.doGet(Unknown Source)
at com.fr.web.BaseServlet.doPost(Unknown Source)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:616)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:689)
at org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:428)
at org.mortbay.jetty.servlet.WebApplicationHandler.dispatch(WebApplicationHandler.java:473)
at org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:568)
at org.mortbay.http.HttpContext.handle(HttpContext.java:1530)
at org.mortbay.jetty.servlet.WebApplicationContext.handle(WebApplicationContext.java:633)
at org.mortbay.http.HttpContext.handle(HttpContext.java:1482)
at org.mortbay.http.HttpServer.service(HttpServer.java:909)
at org.mortbay.http.HttpConnection.service(HttpConnection.java:820)
at org.mortbay.http.HttpConnection.handleNext(HttpConnection.java:986)
at org.mortbay.http.HttpConnection.handle(HttpConnection.java:837)
at org.mortbay.http.SocketListener.handleConnection(SocketListener.java:245)
at org.mortbay.util.ThreadedServer.handle(ThreadedServer.java:357)
at org.mortbay.util.ThreadPool$PoolThread.run(ThreadPool.java:534)
2018-01-14 23:23:56
2018-01-14 23:23:56
正常:Rollback Successfully
2018-01-14 23:23:56
正常:Rollback Successfully
正常:columnIndex:1columnValue:非模板触发错误
2018-01-14 23:23:56
正常:columnIndex:2columnValue:6
2018-01-14 23:23:56
正常:columnIndex:3columnValue:将截断字符串或二进制数据。
2018-01-14 23:23:56
正常:columnIndex:4columnValue:com.microsoft.sqlserver.jdbc.SQLServerException: 将截断字符串或二进制数据。
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PrepStmtExecCmd.doExecute(Unknown Source)
at com.microsoft.sqlserver.jdbc.TDSCommand.execute(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.executeUpdate(Unknown Source)
at com.fr.third.org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
at com.fr.third.org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
at com.fr.write.config.UpdateConfig.update(Unknown Source)
at com.fr.write.config.UpdateConfig.simpleSubmit(Unknown Source)
at com.fr.write.config.UpdateConfig.dmlSubmit(Unknown Source)
at com.fr.write.config.UpdateConfig.dmlSubmitBatch(Unknown Source)
at com.fr.write.config.DMLConfig$ExtractionSubmitter.run(Unknown Source)
at com.fr.write.cal.WB.runEachAction(Unknown Source)
at com.fr.write.cal.WB.setCurrentColumnRow(Unknown Source)
at com.fr.write.config.DMLConfig.extract(Unknown Source)
at com.fr.write.config.DMLConfig.extractGroup(Unknown Source)
at com.fr.write.config.DMLConfig.execute(Unknown Source)
at com.fr.write.DBCommitWrapper.commit(Unknown Source)
at com.fr.write.DBCommitWrapper.commit2db(Unknown Source)
at com.fr.report.write.BuiltInSQLSubmiter.execute(Unknown Source)
at com.fr.report.write.ReportWriteAttr.submit(Unknown Source)
at com.fr.report.write.SubmitHelper.submit(Unknown Source)
at com.fr.report.write.SubmitHelper.submit(Unknown Source)
at com.fr.web.core.A.DB.actionCMD(Unknown Source)
at com.fr.web.core.WebActionsDispatcher.dealForActionCMD(Unknown Source)
at com.fr.web.core.WebActionsDispatcher.dealForActionDefaultCmd(Unknown Source)
at com.fr.web.core.WebActionsDispatcher.dealForActionCMD(Unknown Source)
at com.fr.web.core.A.hC.process(Unknown Source)
at com.fr.web.core.ReportDispatcher.dealWithOp(Unknown Source)
at com.fr.web.core.ReportDispatcher.dealWeblet(Unknown Source)
at com.fr.web.core.ReportDispatcher.dealWithRequest(Unknown Source)
at com.fr.web.BaseServlet.doGet(Unknown Source)
at com.fr.web.BaseServlet.doPost(Unknown Source)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:616)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:689)
at org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:428)
at org.mortbay.jetty.servlet.WebApplicationHandler.dispatch(WebApplicationHandler.java:473)
at org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:568)
at org.mortbay.http.HttpContext.handle(HttpContext.java:1530)
at org.mortbay.jetty.servlet.WebApplicationContext.handle(WebApplicationContext.java:633)
at org.mortbay.http.HttpContext.handle(HttpContext.java:1482)
at org.mortbay.http.HttpServer.service(HttpServer.java:909)
at org.mortbay.http.HttpConnection.service(HttpConnection.java:820)
at org.mortbay.http.HttpConnection.handleNext(HttpConnection.java:986)
at org.mortbay.http.HttpConnection.handle(HttpConnection.java:837)
at org.mortbay.http.SocketListener.handleConnection(SocketListener.java:245)
at org.mortbay.util.ThreadedServer.handle(ThreadedServer.java:357)
at org.mortbay.util.ThreadPool$PoolThread.run(ThreadPool.java:534)
2018-01-14 23:23:56
2018-01-14 23:23:56
警告:submiter error happens.
数据提交出错
将截断字符串或二进制数据。
at com.fr.report.write.SubmitHelper.submit(Unknown Source)
at com.fr.web.core.A.DB.actionCMD(Unknown Source)
at com.fr.web.core.WebActionsDispatcher.dealForActionCMD(Unknown Source)
at com.fr.web.core.WebActionsDispatcher.dealForActionDefault at com.fr.web.core.WebActionsDispatcher.dealForActionCMD(Unknown Source)
Cmd(Unknown Source)
at com.fr.web.core.A.hC.process(Unknown Source)
正常:columnIndex:5columnValue:2018-01-14 23:23:56
at com.fr.web.core.ReportDispatcher.dealWithOp(Unknown Source)
at com.fr.web.core.ReportDispatcher.dealWeblet(Unknown Source)
at com.fr.web.core.ReportDispatcher.dealWithRequest(Unknown Source)
at com.fr.web.BaseServlet.doGet(Unknown Source)
at com.fr.web.BaseServlet.doPost(Unknown Source)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:616)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:689)
at org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:428)
at org.mortbay.jetty.servlet.WebApplicationHandler.dispatch(WebApplicationHandler.java:473)
at org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:568)
at org.mortbay.http.HttpContext.handle(HttpContext.java:1530)
at org.mortbay.jetty.servlet.WebApplicationContext.handle(WebApplicationContext.java:633)
at org.mortbay.http.HttpContext.handle(HttpContext.java:1482)
at org.mortbay.http.HttpServer.service(HttpServer.java:909)
at org.mortbay.http.HttpConnection.service(HttpConnection.java:820)
at org.mortbay.http.HttpConnection.handleNext(HttpConnection.java:986)
at org.mortbay.http.HttpConnection.handle(HttpConnection.java:837)
at org.mortbay.http.SocketListener.handleConnection(SocketListener.java:245)
at org.mortbay.util.ThreadedServer.handle(ThreadedServer.java:357)
at org.mortbay.util.ThreadPool$PoolThread.run(ThreadPool.java:534)
2018-01-14 23:23:57
正常:columnIndex:1columnValue:非模板触发错误
2018-01-14 23:23:57
正常:columnIndex:2columnValue:6
2018-01-14 23:23:57
正常:columnIndex:3columnValue:submiter error happens.
数据提交出错
将截断字符串或二进制数据。
2018-01-14 23:23:57
正常:columnIndex:4columnValue:com.fr.write.WriteSubmitException: submiter error happens.
数据提交出错
将截断字符串或二进制数据。
at com.fr.report.write.SubmitHelper.submit(Unknown Source)
at com.fr.web.core.A.DB.actionCMD(Unknown Source)
at com.fr.web.core.WebActionsDispatcher.dealForActionCMD(Unknown Source)
at com.fr.web.core.WebActionsDispatcher.dealForActionDefaultCmd(Unknown Source)
at com.fr.web.core.WebActionsDispatcher.dealForActionCMD(Unknown Source)
at com.fr.web.core.A.hC.process(Unknown Source)
at com.fr.web.core.ReportDispatcher.dealWithOp(Unknown Source)
at com.fr.web.core.ReportDispatcher.dealWeblet(Unknown Source)
at com.fr.web.core.ReportDispatcher.dealWithRequest(Unknown Source)
at com.fr.web.BaseServlet.doGet(Unknown Source)
at com.fr.web.BaseServlet.doPost(Unknown Source)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:616)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:689)
at org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:428)
at org.mortbay.jetty.servlet.WebApplicationHandler.dispatch(WebApplicationHandler.java:473)
at org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:568)
at org.mortbay.http.HttpContext.handle(HttpContext.java:1530)
at org.mortbay.jetty.servlet.WebApplicationContext.handle(WebApplicationContext.java:633)
at org.mortbay.http.HttpContext.handle(HttpContext.java:1482)
at org.mortbay.http.HttpServer.service(HttpServer.java:909)
at org.mortbay.http.HttpConnection.service(HttpConnection.java:820)
at org.mortbay.http.HttpConnection.handleNext(HttpConnection.java:986)
at org.mortbay.http.HttpConnection.handle(HttpConnection.java:837)
at org.mortbay.http.SocketListener.handleConnection(SocketListener.java:245)
at org.mortbay.util.ThreadedServer.handle(ThreadedServer.java:357)
at org.mortbay.util.ThreadPool$PoolThread.run(ThreadPool.java:534)
Caused by: com.fr.write.WriteSubmitException: 数据提交出错
将截断字符串或二进制数据。
at com.fr.report.write.ReportWriteAttr.submit(Unknown Source)
at com.fr.report.write.SubmitHelper.submit(Unknown Source)
... 26 more
Caused by: com.fr.write.WriteException: 将截断字符串或二进制数据。
at com.fr.write.DBCommitWrapper.commit(Unknown Source)
at com.fr.write.DBCommitWrapper.commit2db(Unknown Source)
at com.fr.report.write.BuiltInSQLSubmiter.execute(Unknown Source)
... 28 more
Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: 将截断字符串或二进制数据。
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PrepStmtExecCmd.doExecute(Unknown Source)
at com.microsoft.sqlserver.jdbc.TDSCommand.execute(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.executeUpdate(Unknown Source)
at com.fr.third.org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
at com.fr.third.org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
at com.fr.write.config.UpdateConfig.update(Unknown Source)
at com.fr.write.config.UpdateConfig.simpleSubmit(Unknown Source)
at com.fr.write.config.UpdateConfig.dmlSubmit(Unknown Source)
at com.fr.write.config.UpdateConfig.dmlSubmitBatch(Unknown Source)
at com.fr.write.config.DMLConfig$ExtractionSubmitter.run(Unknown Source)
at com.fr.write.cal.WB.runEachAction(Unknown Source)
at com.fr.write.cal.WB.setCurrentColumnRow(Unknown Source)
at com.fr.write.config.DMLConfig.extract(Unknown Source)
at com.fr.write.config.DMLConfig.extractGroup(Unknown Source)
at com.fr.write.config.DMLConfig.execute(Unknown Source)
... 31 more
2018-01-14 23:23:57
正常:columnIndex:5columnValue:2018-01-14 23:23:57
编辑于 2018-1-14 23:33
