attachmentPC上传附件时文件名长度受限，如何扩展？

bianzhendong

用attachmentPC上传附件时，附件的文件名长度受到限制，超长就无法上传，希望增加文件名的长度，请问如何处理？

jishuang

修改数据库SA_DocNode中sDocName字段的长度

jishuang

超长就无法上传具体的提示信息是什么？

bianzhendong

jishuang 发表于 2018-1-22 17:26
超长就无法上传具体的提示信息是什么？

保存数据失败！ ,
执行KSQL出错, KSQL: INSERT INTO SA_DocLog SA_DocLog(SA_DocLog, SA_DocLog.version, SA_DocLog.sDocID, SA_DocLog.sPersonFID, SA_DocLog.sPersonName, SA_DocLog.sDeptName, SA_DocLog.sTime, SA_DocLog.sAccessType, SA_DocLog.sDocName, SA_DocLog.sDocVersionID, SA_DocLog.sSize) VALUES (:SA_DocLog, :version, :sDocID, :sPersonFID, :sPersonName, :sDeptName, :sTime, :sAccessType, :sDocName, :sDocVersionID, :sSize)
编码：JUSTEP150210

jishuang

发tomcat控制台完整的错误信息

bianzhendong

jishuang 发表于 2018-1-23 11:20
发tomcat控制台完整的错误信息

Uncaught Error: __justepServerErrorStart__{"message":"保存数据失败！ , \n执行KSQL出错, KSQL: INSERT INTO SA_DocLog SA_DocLog(SA_DocLog, SA_DocLog.version, SA_DocLog.sDocID, SA_DocLog.sPersonFID, SA_DocLog.sPersonName, SA_DocLog.sDeptName, SA_DocLog.sTime, SA_DocLog.sAccessType, SA_DocLog.sDocName, SA_DocLog.sDocVersionID, SA_DocLog.sSize) VALUES (:SA_DocLog, :version, :sDocID, :sPersonFID, :sPersonName, :sDeptName, :sTime, :sAccessType, :sDocName, :sDocVersionID, :sSize)","reason":"","code":"JUSTEP150210","stack":"java.lang.reflect.InvocationTargetException\r\n\tat sun.reflect.GeneratedMethodAccessor808.invoke(Unknown Source)\r\n\tat sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)\r\n\tat java.lang.reflect.Method.invoke(Method.java:497)\r\n\tat com.justep.system.action.Engine.invokeActions(Native Method)\r\n\tat com.justep.system.action.Engine.invokeActions(Unknown Source)\r\n\tat com.justep.business.server.BusinessServer.doAction(Unknown Source)\r\n\tat com.justep.business.server.BusinessServer.doExcute(Unknown Source)\r\n\tat com.justep.business.server.BusinessServer.excute(Unknown Source)\r\n\tat com.justep.business.server.BusinessServer.excute(Unknown Source)\r\n\tat com.justep.business.server.BusinessServerServlet.execService(Unknown Source)\r\n\tat com.justep.business.server.BusinessServerServlet.service(Unknown Source)\r\n\tat javax.servlet.http.HttpServlet.service(HttpServlet.java:723)\r\n\tat com.justep.x.bs.BusinessServerServlet.service(Unknown Source)\r\n\tat javax.servlet.http.HttpServlet.service(HttpServlet.java:723)\r\n\tat org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)\r\n\tat org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)\r\n\tat org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)\r\n\tat org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)\r\n\tat org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)\r\n\tat com.googlecode.psiprobe.Tomcat60AgentValve.invoke(Tomcat60AgentValve.java:40)\r\n\tat org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)\r\n\tat org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)\r\n\tat org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)\r\n\tat org.apache.coyote.http11.Http11NioProcessor.process(Http11NioProcessor.java:891)\r\n\tat org.apache.coyote.http11.Http11NioProtocol$Http11ConnectionHandler.process(Http11NioProtocol.java:750)\r\n\tat org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.run(NioEndpoint.java:2283)\r\n\tat java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)\r\n\tat java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)\r\n\tat java.lang.Thread.run(Thread.java:745)\r\nCaused by: com.justep.exception.BusinessException: 编码: JUSTEP150210; 提示: 执行KSQL出错, KSQL: INSERT INTO SA_DocLog SA_DocLog(SA_DocLog, SA_DocLog.version, SA_DocLog.sDocID, SA_DocLog.sPersonFID, SA_DocLog.sPersonName, SA_DocLog.sDeptName, SA_DocLog.sTime, SA_DocLog.sAccessType, SA_DocLog.sDocName, SA_DocLog.sDocVersionID, SA_DocLog.sSize) VALUES (:SA_DocLog, :version, :sDocID, :sPersonFID, :sPersonName, :sDeptName, :sTime, :sAccessType, :sDocName, :sDocVersionID, :sSize)\r\n\tat com.justep.exception.BusinessException.create(Unknown Source)\r\n\tat com.justep.system.data.impl.TableUtilsImplement.ksqlInsert(Unknown Source)\r\n\tat com.justep.system.data.impl.TableUtilsImplement.ksqlExecuteUpdate(Unknown Source)\r\n\tat com.justep.system.data.KSQL.executeUpdate(Unknown Source)\r\n\tat com.justep.system.data.KSQL.executeUpdate(Unknown Source)\r\n\tat com.justep.system.data.impl.TableImpl.insert(Unknown Source)\r\n\tat com.justep.system.data.impl.TableImpl.save(Unknown Source)\r\n\tat com.justep.system.data.impl.TableImpl.save(Unknown Source)\r\n\tat com.justep.system.data.impl.TableImpl.save(Unknown Source)\r\n\tat com.justep.system.data.impl.TableImpl.save(Unknown Source)\r\n\tat com.justep.doc.DocLogs.save(DocLogs.java:166)\r\n\tat com.justep.doc.attachment.Attachments.saveTable(Attachments.java:253)\r\n\tat com.justep.doc.attachment.Attachments.commitData(Attachments.java:353)\r\n\tat com.justep.doc.DocAdapter.saveCommAttach(DocAdapter.java:523)\r\n\tat com.justep.doc.DocAdapter.saveAttachAdapter(DocAdapter.java:446)\r\n\t... 29 more\r\nCaused by: com.justep.exception.BusinessException: 编码: JUSTEP150039; 提示: 执行sql: INSERT INTO SA_DocLog (SA_DocLog.sID, SA_DocLog.version, SA_DocLog.sDocID, SA_DocLog.sPersonFID, SA_DocLog.sPersonName, SA_DocLog.sDeptName, SA_DocLog.sTime, SA_DocLog.sAccessType, SA_DocLog.SDOCNAME, SA_DocLog.sDocVersionID, SA_DocLog.SSIZE) VALUES ( ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ), binds: [C88E0062422442AEBCF5B0D4D766771A, 0, C7D8A289A3900001212B19F0D1304210, /82.ogn/124.ogn/1160.dpt/xKqhFvJ52gMPOS01023.pos/Thbq0UqMc4MlFEx0hUu@xKqhFvJ52gMPOS01023.psm, test, null, 2018-01-23 13:24:18.385, new, 测试长度测试长度测试长度测试长度测试长度测试长度测试长度测试长度测试长度测试长度测试长度测试长度测试长度测试长度测试长度.docx, 1, 0.0]出错\r\n\tat com.justep.exception.BusinessException.create(Unknown Source)\r\n\tat com.justep.system.ksql.KSQLUtils.execSqlUpdate(Unknown Source)\r\n\t... 43 more\r\nCaused by: java.sql.SQLException: ORA-12899: 列 \"IPLATFORM_SYS_TEST\".\"SA_DOCLOG\".\"SDOCNAME\" 的值太大 (实际值: 185, 最大值: 128)\n\r\n\tat oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)\r\n\tat oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)\r\n\tat oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)\r\n\tat oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:743)\r\n\tat oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:213)\r\n\tat oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:952)\r\n\tat oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1160)\r\n\tat oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3285)\r\n\tat oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3368)\r\n\tat org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)\r\n\tat org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)\r\n\t... 44 more\r\n","messages":["编码: JUSTEP150210; 提示: 执行KSQL出错, KSQL: INSERT INTO SA_DocLog SA_DocLog(SA_DocLog, SA_DocLog.version, SA_DocLog.sDocID, SA_DocLog.sPersonFID, SA_DocLog.sPersonName, SA_DocLog.sDeptName, SA_DocLog.sTime, SA_DocLog.sAccessType, SA_DocLog.sDocName, SA_DocLog.sDocVersionID, SA_DocLog.sSize) VALUES (:SA_DocLog, :version, :sDocID, :sPersonFID, :sPersonName, :sDeptName, :sTime, :sAccessType, :sDocName, :sDocVersionID, :sSize)","编码: JUSTEP150039; 提示: 执行sql: INSERT INTO SA_DocLog (SA_DocLog.sID, SA_DocLog.version, SA_DocLog.sDocID, SA_DocLog.sPersonFID, SA_DocLog.sPersonName, SA_DocLog.sDeptName, SA_DocLog.sTime, SA_DocLog.sAccessType, SA_DocLog.SDOCNAME, SA_DocLog.sDocVersionID, SA_DocLog.SSIZE) VALUES ( ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ,  ? ), binds: [C88E0062422442AEBCF5B0D4D766771A, 0, C7D8A289A3900001212B19F0D1304210, /82.ogn/124.ogn/1160.dpt/xKqhFvJ52gMPOS01023.pos/Thbq0UqMc4MlFEx0hUu@xKqhFvJ52gMPOS01023.psm, test, null, 2018-01-23 13:24:18.385, new, 测试长度测试长度测试长度测试长度测试长度测试长度测试长度测试长度测试长度测试长度测试长度测试长度测试长度测试长度测试长度.docx, 1, 0.0]出错","ORA-12899: 列 \"IPLATFORM_SYS_TEST\".\"SA_DOCLOG\".\"SDOCNAME\" 的值太大 (实际值: 185, 最大值: 128)\n"],"url":"","param":""}__justepServerErrorEnd__
    at Object.create (core.min.js:71)
    at Object.Request.errorMessage (biz.common.min.js:12)
    at n.doSaveDataAfter (biz.common.min.js:12)
    at Object.callback (biz.common.min.js:12)
    at Object.Request._requestCallback (biz.common.min.js:12)
    at Object.<anonymous> (biz.common.min.js:12)
    at f (core.min.js:71)
    at Object.add (core.min.js:71)
    at Object.Request.endBatch (biz.common.min.js:12)
    at n._endBatch (biz.common.min.js:12)
mobileLogin.jsp Failed to load resource: the server responded with a status of 500 (Internal Server Error)

bianzhendong

jishuang 发表于 2018-1-23 13:30
修改数据库SA_DocNode中sDocName字段的长度

已解决，谢谢