GroupSession
いつもお世話になっております。先日より試用させていただいておりますが、当初は表示されていた管理者設定[ファイル管理] - 基本設定が、環境構築を行っているうちにいつのまにかエラーが発生し表示されなくなりましたGS 2.4.1/Windows 200 Server SP4/jdk1.6.0_14/Tomcat 5.5.27/version 2.4.0 の時のキャビネット一覧が表示できなくなる問題は確認しましたがそれと同様の現象でしょうか？http://www.gs.sjts.co.jp/wbs/bulletin/bbs080.do?bbs010forumSid=1&threadSid=745以下エラー内容です-----------------サーバエラーが発生しました。回線が込み合っている可能性があります。時間をおいて再接続してください。 org.h2.jdbc.JdbcSQLException: SQLステートメントに文法エラーがあります SELECT GP.GRP_SID AS GRP_SID, GP.GRP_ID AS GRP_ID, GP.GRP_NAME AS GRP_NAME, MAX(GC1.GCL_SID1) AS LEVEL1, MAX(GC2.GCL_SID2) AS LEVEL2, MAX(GC3.GCL_SID3) AS LEVEL3, MAX(GC4.GCL_SID4) AS LEVEL4, MAX(GC5.GCL_SID5) AS LEVEL5 FROM CMN_GROUPM GP LEFT JOIN CMN_GROUP_CLASS GC1 ON GP.GRP_SID = GC1.GCL_SID1 LEFT JOIN CMN_GROUP_CLASS GC2 ON GP.GRP_SID = GC2.GCL_SID2 LEFT JOIN CMN_GROUP_CLASS GC3 ON GP.GRP_SID = GC3.GCL_SID3 LEFT JOIN CMN_GROUP_CLASS GC4 ON GP.GRP_SID = GC4.GCL_SID4 LEFT JOIN CMN_GROUP_CLASS GC5 ON GP.GRP_SID = GC5.GCL_SID5 WHERE GP.GRP_JKBN = ? GROUP BY GP.GRP_SID, GP.GRP_ID, GP.GRP_NAME ORDER BY GRP_ID ASC GRP_NAME[*] ASC Syntax error in SQL statement SELECT GP.GRP_SID AS GRP_SID, GP.GRP_ID AS GRP_ID, GP.GRP_NAME AS GRP_NAME, MAX(GC1.GCL_SID1) AS LEVEL1, MAX(GC2.GCL_SID2) AS LEVEL2, MAX(GC3.GCL_SID3) AS LEVEL3, MAX(GC4.GCL_SID4) AS LEVEL4, MAX(GC5.GCL_SID5) AS LEVEL5 FROM CMN_GROUPM GP LEFT JOIN CMN_GROUP_CLASS GC1 ON GP.GRP_SID = GC1.GCL_SID1 LEFT JOIN CMN_GROUP_CLASS GC2 ON GP.GRP_SID = GC2.GCL_SID2 LEFT JOIN CMN_GROUP_CLASS GC3 ON GP.GRP_SID = GC3.GCL_SID3 LEFT JOIN CMN_
エラーメッセージの続きです。GROUP_CLASS GC4 ON GP.GRP_SID = GC4.GCL_SID4 LEFT JOIN CMN_GROUP_CLASS GC5 ON GP.GRP_SID = GC5.GCL_SID5 WHERE GP.GRP_JKBN = ? GROUP BY GP.GRP_SID, GP.GRP_ID, GP.GRP_NAME ORDER BY GRP_ID ASC GRP_NAME[*] ASC ; SQL statement: select GP.GRP_SID as GRP_SID, GP.GRP_ID as GRP_ID, GP.GRP_NAME as GRP_NAME, max(GC1.GCL_SID1) as LEVEL1, max(GC2.GCL_SID2) as LEVEL2, max(GC3.GCL_SID3) as LEVEL3, max(GC4.GCL_SID4) as LEVEL4, max(GC5.GCL_SID5) as LEVEL5 from CMN_GROUPM GP left join CMN_GROUP_CLASS GC1 on GP.GRP_SID = GC1.GCL_SID1 left join CMN_GROUP_CLASS GC2 on GP.GRP_SID = GC2.GCL_SID2 left join CMN_GROUP_CLASS GC3 on GP.GRP_SID = GC3.GCL_SID3 left join CMN_GROUP_CLASS GC4 on GP.GRP_SID = GC4.GCL_SID4 left join CMN_GROUP_CLASS GC5 on GP.GRP_SID = GC5.GCL_SID5 where GP.GRP_JKBN = ? group by GP.GRP_SID, GP.GRP_ID, GP.GRP_NAME order by GRP_ID asc GRP_NAME asc [42000-116] at org.h2.message.Message.getSQLException(Message.java:105) at org.h2.message.Message.getSQLException(Message.java:116) at org.h2.message.Message.getSQLException(Message.java:75) at org.h2.message.Message.getSyntaxError(Message.java:128) at org.h2.command.Parser.getSyntaxError(Parser.java:469) at org.h2.command.Parser.prepareCommand(Parser.java:250) at org.h2.engine.Session.prepareLocal(Session.java:409) at org.h2.engine.Session.prepareCommand(Session.java:370) at org.h2.jdbc.JdbcConnection.prepareCommand(JdbcConnection.java:1049) at org.h2.jdbc.JdbcPreparedStatement.<init>(JdbcPreparedStatement.java:74) at org.h2.jdbc.JdbcConnection.prepareStatement(JdbcConnection.java:233) at org.apache.commons.dbcp.DelegatingConnection.prepareStatement(DelegatingConnection.java:185) at org.apache.commons.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.prepareStatement(PoolingDataSource.java:278)
エラーメッセージの続きです。 at jp.groupsession.v2.cmn.dao.GroupDao.getGroupList(GroupDao.java:716) at jp.groupsession.v2.cmn.biz.GroupBiz.getGroupList(GroupBiz.java:106) at jp.groupsession.v2.cmn.biz.GroupBiz.getGroupList(GroupBiz.java:83) at jp.groupsession.v2.cmn.biz.GroupBiz.getGroupLabelList(GroupBiz.java:60) at jp.groupsession.v2.cmn.biz.GroupBiz.getGroupLabelList(GroupBiz.java:41) at jp.groupsession.v2.fil.fil210.Fil210Biz.__setGroupCombo(Fil210Biz.java:216) at jp.groupsession.v2.fil.fil210.Fil210Biz.__setDsp(Fil210Biz.java:92) at jp.groupsession.v2.fil.fil210.Fil210Biz.setInitData(Fil210Biz.java:70) at jp.groupsession.v2.fil.fil210.Fil210Action.__doInit(Fil210Action.java:109) at jp.groupsession.v2.fil.fil210.Fil210Action.executeAction(Fil210Action.java:82) at jp.groupsession.v2.struts.AbstractGsAction.execute(AbstractGsAction.java:126) at org.apache.struts.chain.commands.servlet.ExecuteAction.execute(ExecuteAction.java:58) at org.apache.struts.chain.commands.AbstractExecuteAction.execute(AbstractExecuteAction.java:67) at org.apache.struts.chain.commands.ActionCommandBase.execute(ActionCommandBase.java:51) at org.apache.commons.chain.impl.ChainBase.execute(ChainBase.java:190) at org.apache.commons.chain.generic.LookupCommand.execute(LookupCommand.java:304) at org.apache.commons.chain.impl.ChainBase.execute(ChainBase.java:190) at org.apache.struts.chain.ComposableRequestProcessor.process(ComposableRequestProcessor.java:283) at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1913) at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:462) at javax.servlet.http.HttpServlet.service(HttpServlet.java:647) at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
エラーメッセージの続きです。 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188) at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:679) at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:461) at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:399) at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:301) at org.apache.struts.chain.commands.servlet.PerformForward.handleAsForward(PerformForward.java:113) at org.apache.struts.chain.commands.servlet.PerformForward.perform(PerformForward.java:96) at org.apache.struts.chain.commands.AbstractPerformForward.execute(AbstractPerformForward.java:54) at org.apache.struts.chain.commands.ActionCommandBase.execute(ActionCommandBase.java:51) at org.apache.commons.chain.impl.ChainBase.execute(ChainBase.java:190) at org.apache.commons.chain.generic.LookupCommand.execute(LookupCommand.java:304) at org.apache.commons.chain.impl.ChainBase.execute(ChainBase.java:190) at org.apache.struts.chain.ComposableRequestProcessor.process(ComposableRequestProcessor.java:283) at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1913) at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:462) at javax.servlet.http.HttpServlet.service(HttpServlet.java:647)
エラーメッセージの続きです。 at javax.servlet.http.HttpServlet.service(HttpServlet.java:729) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188) at jp.co.sjts.util.http.filter.FilterEncoding.doFilter(FilterEncoding.java:96) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:172) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:174) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:875) at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:665) at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:528) at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:81) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:689) at java.lang.Thread.run(Unknown Source)
これじゃないですか？version 2.4.1No3http://www.gs.sjts.co.jp/v2/seihin/bug_info.html
TOP