sa_log字段超限，能否通过直接修改字段长度解决

sh13645181862

2018-12-19 11:19:23 执行sql: insert into SA_Log  (sCreatorPosName, sActivity, sAction, sCreatorFID, sProcess, sCreatorPersonName, sCreateTime, sParameters, sActionName, sIP, sDeviceType, sProcessName, sStatusName, sDescription, sCreatorFName, sCreatorPersonID, sCreatorOgnName, sOperatingSystem, version, SID, sResult, sCreatorPosID, sActivityName, sCreatorDeptID, sTypeName, sCreatorDeptName, sCreatorOgnID, $clientName) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, $clientValue), binds: [, mainActivity, logoutAction, /VErddmhLgcDbZTOrHJk.ogn/DsqwAQgJIvnF7Hwccaa.ogn/k9SUZKE5dFyopxGZXWc.ogn/a9nb3ddsZlxnCGosYiZ.dpt/Gal12srBBDG4oTdHjAC@a9nb3ddsZlxnCGosYiZ.psm, /SA/OPM/system/systemProcess, 监督联络人（TESTUSER01）, 2018-12-19 11:19:23.193, 参数名称: sessionID
参数值: {"value":"CDD53E0EF5CCCF0974CBE8589F802A38"}
, 退出, 0:0:0:0:0:0:0:1, Computer, 系统调用, 失败, null, /**********/江苏大区/**********/技术支持部/监督联络人（TESTUSER01）, Gal12srBBDG4oTdHjAC, *************, WINDOWS, 0, 6C0BFEB0F9424E72ADBE5E82556BC9FB, , , 系统, a9nb3ddsZlxnCGosYiZ, 操作日志, 技术支持部, k9SUZKE5dFyopxGZXWc]失败
java.sql.SQLException: ORA-12899: 列 "X5SYS"."SA_LOG"."SCREATORFID" 的值太大 (实际值: 140, 最大值: 100)

        at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
        at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
        at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
        at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:743)
        at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:213)
        at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:952)
        at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1160)
        at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3285)
        at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3368)
        at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
        at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
        at com.justep.system.log.LogUtils.execSqlUpdate(Unknown Source)
        at com.justep.system.log.LogUtils.log(Unknown Source)
        at com.justep.system.log.LogUtils.log(Unknown Source)
        at com.justep.system.interceptor.LogBefore.actionLog(Unknown Source)
        at com.justep.system.interceptor.LogBefore.doActionLog(Unknown Source)
        at com.justep.system.interceptor.LogBefore.execute(Unknown Source)
        at com.justep.system.action.EngineInterceptor.excute(Unknown Source)
        at com.justep.system.action.Engine.invokeActions(Native Method)
        at com.justep.system.action.Engine.invokeActions(Unknown Source)
        at com.justep.business.server.BusinessServer.doAction(Unknown Source)
        at com.justep.business.server.BusinessServer.doExcute(Unknown Source)
        at com.justep.business.server.BusinessServer.excute(Unknown Source)
        at com.justep.business.server.BusinessServer.excute(Unknown Source)
        at com.justep.business.server.BusinessServerServlet.execService(Unknown Source)
        at com.justep.business.server.BusinessServerServlet.service(Unknown Source)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:723)
        at com.justep.x.bs.BusinessServerServlet.service(Unknown Source)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:723)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
        at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
        at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
        at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
        at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)
        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)
        at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:861)
        at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:606)
        at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
        at java.lang.Thread.run(Thread.java:745)

jishuang

可以直接到数据库中修改SA_Log中字段长度的设置