【结贴】内网访问系统特别慢?

zfang

1、业务模型\系统空间\系统数据库\系统日志表
计算机 字段加长到255

2、修改  业务模型\系统空间\系统运行库\系统核心库
AddSystemLog函数为下面这样
static procedure TSystemCore.AddSystemLog(AContext: TContext;AType, ADescription: string);
const
  cSQL = 'insert into TSYSLOG(FTYPE, FDESCRIPTION, FCOMPUTER, FGUID, '+
         ' FDATE, FTIME, FUSER, FUSERCaption,'+
         ' FSTATION, FDEPT, FURL, FSTATIONCation, FDEPTCation) ' +
         'values(''%s'', ''%s'', ''%s'', ''%s'', '+
         ':t1, :t2,''%s'',''%s'','+
         '''%s'',''%s'',''%s'',''%s'',''%s'')';
var
  lQuery: TQuery;
  lComputerIP: string;
  IsSystemManager: Boolean;
  lOperatorPosition: TOperatorPosition;
begin
  if not TSettingLib.GetDefaultConfig.RecordSystemLog or not (SysUtils.AnsiPos('SYSTEM', TSettingLib.GetDefaultConfig.SystemLogKinds) > 0) then
    Exit;

  lOperatorPosition := TContextUtils.FindOperatorPosition(AContext);
  if (lOperatorPosition = nil) and not Opr.IsSystemManager(TSystemCore.Operator.ID) then
    lOperatorPosition := TSystemCore.Operator.DefaultPosition;
  lComputerIP := '计算机名：'+ JSSysUtils.GetComputerName + '('+ JSSysUtils.GetLocalIPStr+ ')';

  lQuery := TQuery.Create(AContext.Owner);
  try
    lQuery.ConnectionString := cSysDatabaseConnectionString;
    if Opr.IsSystemManager(TSystemCore.Operator.ID) then
      lQuery.CommandText := SysUtils.Format(cSQL,[AType, ADESCRIPTION, lComputerIP, jsCommon.CreateGUIDStr, 'System', '系统管理员' ,'','','','',''])
    else
      lQuery.CommandText := SysUtils.Format(cSQL, [AType, ADESCRIPTION, lComputerIP, jsCommon.CreateGUIDStr,
          TSystemCore.Operator.ID, TSystemCore.Operator.DisplayName , lOperatorPosition.PositionID,
          lOperatorPosition.DeptID, lOperatorPosition.PersonMember.BizURL.URL,
          lOperatorPosition.Position.DisplayName ,lOperatorPosition.PersonMember.Parent.Parent.DisplayName]);

    with lQuery do
    begin
      Close;
      Params.ParamByName('t1').AsDate := SysSrv.SysService.Time;
      Params.ParamByName('t2').AsDateTime := SysSrv.SysService.Time;
      Execute;
    end;

  finally
    lQuery.Free;
  end;
end;

huangyue

这样改了之后初始化调试很卡，用IE运行打开系统自带的功能还是慢。。。打开自己做的功能有些快有些慢。。。。

zfang

从你给的监控文件来看，就红色框内的慢（用时长）。按照31楼的做法修改后，可以解决这两个（其实是你们打开了系统日志功能，而这个在你们那个版本上是有这个缺陷的，按上面修改后缺陷就不存在了）

你说的打开系统自带的功能还是慢，具体是什么功能？
你重新抓一个监控日志包做一下分析。（最好是自己能按照15楼的链接学会分析，那里写的已经很详细的了）

另外请注意：打开监控记录完日志后，一定要关掉监控，否则会严重影响速度的。

huangyue

我就是打开系统自带邮件，计划中心，任务中心这些功能还是慢。。。重新抓一个监控包又多了一个用时长的。。。哪个连接那里说到我怎么看它是属于哪个功能的？或者是什么包的？

zfang

用sysmoniter.exe分析一下这个日志包，看他到底是在干什么。

huangyue

改了之后我去看了TOMCAT。。。发现里面会有些提示，会不会影响到服务？

at com.justep.service.action.database.ExecuteSQLAction.doExecute(Unknown
Source)
        at com.justep.service.action.base.SQLAction.doExec(Unknown Source)
        at com.justep.service.action.base.SupportAction.execute(Unknown Source)
        at com.justep.service.action.base.SupportAction.execute(Unknown Source)
        at com.justep.service.BizServiceImp.execute(Unknown Source)
        at sun.reflect.GeneratedMethodAccessor122.invoke(Unknown Source)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
sorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:585)
        at com.caucho.hessian.server.HessianSkeleton.invoke(HessianSkeleton.java
:157)
        at com.justep.hessian.HessianServlet.service(Unknown Source)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
icationFilterChain.java:252)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
ilterChain.java:173)
        at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperV
alve.java:213)
        at org.apache.catalina.core.StandardContextValve.invoke(StandardContextV
alve.java:178)
        at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.j
ava:126)
        at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.j
ava:105)
        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineVal
ve.java:107)
        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.jav
a:148)
        at org.apache.coyote.http11.Http11AprProcessor.process(Http11AprProcesso
r.java:831)
        at org.apache.coyote.http11.Http11AprProtocol$Http11ConnectionHandler.pr
ocess(Http11AprProtocol.java:652)
        at org.apache.tomcat.util.net.AprEndpoint$Worker.run(AprEndpoint.java:12
03)
        at java.lang.Thread.run(Thread.java:595)
java.sql.DataTruncation: Data truncation
        at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.j
ava:379)
        at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2781)
        at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2224)
        at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:633)
        at net.sourceforge.jtds.jdbc.JtdsStatement.processResults(JtdsStatement.
java:525)
        at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQL(JtdsStatement.java
:487)
        at net.sourceforge.jtds.jdbc.JtdsPreparedStatement.executeUpdate(JtdsPre
paredStatement.java:421)
        at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeUpdate
(DelegatingPreparedStatement.java:101)
        at com.justep.service.database.Query.doExecSpecSQL(Unknown Source)
        at com.justep.service.database.Query.doExecuteSQL(Unknown Source)
        at com.justep.service.database.Query.executeSQL(Unknown Source)
        at com.justep.service.action.database.ExecuteSQLAction.doExecute(Unknown
Source)
        at com.justep.service.action.base.SQLAction.doExec(Unknown Source)
        at com.justep.service.action.base.SupportAction.execute(Unknown Source)
        at com.justep.service.action.base.SupportAction.execute(Unknown Source)
        at com.justep.service.BizServiceImp.execute(Unknown Source)
        at sun.reflect.GeneratedMethodAccessor122.invoke(Unknown Source)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
sorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:585)
        at com.caucho.hessian.server.HessianSkeleton.invoke(HessianSkeleton.java
:157)
        at com.justep.hessian.HessianServlet.service(Unknown Source)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
icationFilterChain.java:252)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
ilterChain.java:173)
        at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperV
alve.java:213)
        at org.apache.catalina.core.StandardContextValve.invoke(StandardContextV
alve.java:178)
        at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.j
ava:126)
        at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.j
ava:105)
        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineVal
ve.java:107)
        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.jav
a:148)
        at org.apache.coyote.http11.Http11AprProcessor.process(Http11AprProcesso
r.java:831)
        at org.apache.coyote.http11.Http11AprProtocol$Http11ConnectionHandler.pr
ocess(Http11AprProtocol.java:652)
        at org.apache.tomcat.util.net.AprEndpoint$Worker.run(AprEndpoint.java:12
03)
        at java.lang.Thread.run(Thread.java:595)
CommandText: insert into TSYSLOG(FTYPE, FDESCRIPTION, FCOMPUTER, FGUID,  FDATE,
FTIME, FUSER, FUSERCaption, FSTATION, FDEPT, FURL, FSTATIONCation, FDEPTCation)
values('SYSTEM', '退出系统', '计算机名：PC-200902271114(192.168.1.131)', '65CBA0
39EDC64ECEAC672CDA70039E12', ?, ?,'HY','黄悦','RJJSGCS','RJB','Org:\ROOT\YTSJ.OG
N\RJB.DPT\RJJSGCS.PTM\HY.PSM','软件技术工程师','软件部')
2009-6-29 14:56:53 com.caucho.hessian.server.HessianSkeleton invoke
警告: java.lang.Exception: ExecuteSQL error: Data truncation
java.lang.Exception: ExecuteSQL error: Data truncation
        at com.justep.service.action.database.ExecuteSQLAction.doExecute(Unknown
Source)
        at com.justep.service.action.base.SQLAction.doExec(Unknown Source)
        at com.justep.service.action.base.SupportAction.execute(Unknown Source)
        at com.justep.service.action.base.SupportAction.execute(Unknown Source)
        at com.justep.service.BizServiceImp.execute(Unknown Source)
        at sun.reflect.GeneratedMethodAccessor122.invoke(Unknown Source)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
sorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:585)
        at com.caucho.hessian.server.HessianSkeleton.invoke(HessianSkeleton.java
:157)
        at com.justep.hessian.HessianServlet.service(Unknown Source)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
icationFilterChain.java:252)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
ilterChain.java:173)
        at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperV
alve.java:213)
        at org.apache.catalina.core.StandardContextValve.invoke(StandardContextV
alve.java:178)
        at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.j
ava:126)
        at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.j
ava:105)
        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineVal
ve.java:107)
        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.jav
a:148)
        at org.apache.coyote.http11.Http11AprProcessor.process(Http11AprProcesso
r.java:831)
        at org.apache.coyote.http11.Http11AprProtocol$Http11ConnectionHandler.pr
ocess(Http11AprProtocol.java:652)
        at org.apache.tomcat.util.net.AprEndpoint$Worker.run(AprEndpoint.java:12
03)
        at java.lang.Thread.run(Thread.java:595)
java.sql.DataTruncation: Data truncation
        at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.j
ava:379)
        at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2781)
        at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2224)
        at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:633)
        at net.sourceforge.jtds.jdbc.JtdsStatement.processResults(JtdsStatement.
java:525)
        at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQL(JtdsStatement.java
:487)
        at net.sourceforge.jtds.jdbc.JtdsPreparedStatement.executeUpdate(JtdsPre
paredStatement.java:421)
        at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeUpdate
(DelegatingPreparedStatement.java:101)
        at com.justep.service.database.Query.doExecSpecSQL(Unknown Source)
        at com.justep.service.database.Query.doExecuteSQL(Unknown Source)
        at com.justep.service.database.Query.executeSQL(Unknown Source)
        at com.justep.service.action.database.ExecuteSQLAction.doExecute(Unknown
Source)
        at com.justep.service.action.base.SQLAction.doExec(Unknown Source)
        at com.justep.service.action.base.SupportAction.execute(Unknown Source)
        at com.justep.service.action.base.SupportAction.execute(Unknown Source)
        at com.justep.service.BizServiceImp.execute(Unknown Source)
        at sun.reflect.GeneratedMethodAccessor122.invoke(Unknown Source)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
sorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:585)
        at com.caucho.hessian.server.HessianSkeleton.invoke(HessianSkeleton.java
:157)
        at com.justep.hessian.HessianServlet.service(Unknown Source)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
icationFilterChain.java:252)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
ilterChain.java:173)
        at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperV
alve.java:213)
        at org.apache.catalina.core.StandardContextValve.invoke(StandardContextV
alve.java:178)
        at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.j
ava:126)
        at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.j
ava:105)
        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineVal
ve.java:107)
        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.jav
a:148)
        at org.apache.coyote.http11.Http11AprProcessor.process(Http11AprProcesso
r.java:831)
        at org.apache.coyote.http11.Http11AprProtocol$Http11ConnectionHandler.pr
ocess(Http11AprProtocol.java:652)
        at org.apache.tomcat.util.net.AprEndpoint$Worker.run(AprEndpoint.java:12
03)
        at java.lang.Thread.run(Thread.java:595)
CommandText: insert into TSYSLOG(FTYPE, FDESCRIPTION, FCOMPUTER, FGUID,  FDATE,
FTIME, FUSER, FUSERCaption, FSTATION, FDEPT, FURL, FSTATIONCation, FDEPTCation)
values('SYSTEM', '退出系统', '计算机名：PC-200902271114(192.168.1.131)', '65CBA0
39EDC64ECEAC672CDA70039E12', ?, ?,'HY','黄悦','RJJSGCS','RJB','Org:\ROOT\YTSJ.OG
N\RJB.DPT\RJJSGCS.PTM\HY.PSM','软件技术工程师','软件部')
2009-6-29 14:56:53 com.caucho.hessian.server.HessianSkeleton invoke
警告: java.lang.Exception: ExecuteSQL error: Data truncation
java.lang.Exception: ExecuteSQL error: Data truncation
        at com.justep.service.action.database.ExecuteSQLAction.doExecute(Unknown
Source)
        at com.justep.service.action.base.SQLAction.doExec(Unknown Source)
        at com.justep.service.action.base.SupportAction.execute(Unknown Source)
        at com.justep.service.action.base.SupportAction.execute(Unknown Source)
        at com.justep.service.BizServiceImp.execute(Unknown Source)
        at sun.reflect.GeneratedMethodAccessor122.invoke(Unknown Source)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
sorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:585)
        at com.caucho.hessian.server.HessianSkeleton.invoke(HessianSkeleton.java
:157)
        at com.justep.hessian.HessianServlet.service(Unknown Source)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
icationFilterChain.java:252)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
ilterChain.java:173)
        at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperV
alve.java:213)
        at org.apache.catalina.core.StandardContextValve.invoke(StandardContextV
alve.java:178)
        at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.j
ava:126)
        at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.j
ava:105)
        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineVal
ve.java:107)
        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.jav
a:148)
        at org.apache.coyote.http11.Http11AprProcessor.process(Http11AprProcesso
r.java:831)
        at org.apache.coyote.http11.Http11AprProtocol$Http11ConnectionHandler.pr
ocess(Http11AprProtocol.java:652)
        at org.apache.tomcat.util.net.AprEndpoint$Worker.run(AprEndpoint.java:12
03)
        at java.lang.Thread.run(Thread.java:595)
重新生成文件系统缓存。
*********************************************
生成分步缓存文件用时: 2187毫秒。
*********************************************
生成文件系统缓存完毕，耗时：13266毫秒。

zfang

这些是执行sql报错了。不会影响到服务。

你看一下这些sql，在数据库下是否可以执行通过。
检查一下字段的长度。

huangyue

那个SQL提示 t1 not found,,,在数据库下执行通过之后是..从字符串转换为 datetime 时发生语法错误...日志表的时间和日期字段长度不允许修改?

huangyue

这帖子先结了!