フォーラム：00_インストール・設定
gs3.2.1⇒gs4.0.1のデータ移行後、ログインができない
|
[ 4574 ] gs3.2.1⇒gs4.0.1のデータ移行後、ログインができない
掲題の件についてですが、http://www.gs.sjts.co.jp/v4/support/update/update_4.0.2.html
↑こちらを基にデータの移行をしたところ、エラーが出てログインができない状態です。
（エラー内容は長文のため返信で回答いたします）
環境
OS：CentOS5.2
tomcat：6.0.26
Java： 1.6.0_20
上記手順と異なる点は移行するデータはGroupsessionの自動バックアップで取得したデータで行っております。
上記エラーが出力せずにログインできる状態にするにはどのようにすればよいのでしょうか？
投稿者mst 最新書き込み2012/02/03 17:54:36
|
[ 4575 ] Re: gs3.2.1⇒gs4.0.1のデータ移行後、ログインができない
エラーログ
-----------------
org.h2.jdbc.JdbcSQLException: 列 "BIN_SID" が見つかりません
Column "BIN_SID" not found; SQL statement:
select ENI_NAME, ENI_NAME_KN, ENI_KISYU, ENI_URL, ENI_BIKO, BIN_SID, ENI_IMG_KBN, ENI_AUID, ENI_ADATE, ENI_EUID, ENI_EDATE from CMN_ENTER_INF [42122-159]
at org.h2.message.DbException.getJdbcSQLException(DbException.java:329)
at org.h2.message.DbException.get(DbException.java:169)
at org.h2.message.DbException.get(DbException.java:146)
at org.h2.expression.ExpressionColumn.optimize(ExpressionColumn.java:134)
at org.h2.command.dml.Select.prepare(Select.java:794)
at org.h2.command.Parser.prepareCommand(Parser.java:218)
at org.h2.engine.Session.prepareLocal(Session.java:415)
at org.h2.engine.Session.prepareCommand(Session.java:364)
at org.h2.jdbc.JdbcConnection.prepareCommand(JdbcConnection.java:1119)
at org.h2.jdbc.JdbcPreparedStatement.<init>(JdbcPreparedStatement.java:71)
at org.h2.jdbc.JdbcConnection.prepareStatement(JdbcConnection.java:267)
at org.apache.commons.dbcp.DelegatingConnection.prepareStatement(DelegatingConnection.java:281)
at org.apache.commons.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.prepareStatement(PoolingDataSource.java:313)
at jp.groupsession.v2.cmn.dao.base.CmnEnterInfDao.select(CmnEnterInfDao.java:390)
at jp.groupsession.v2.cmn.cmn001.Cmn001Biz.getEnterData(Cmn001Biz.java:34)
at jp.groupsession.v2.cmn.cmn001.Cmn001Action.__getImgBinSid(Cmn001Action.java:443)
at jp.groupsession.v2.cmn.cmn001.Cmn001Action.executeAction(Cmn001Action.java:121)
投稿者mst 最新書き込み2012/02/03 17:56:23
|
[ 4576 ] Re: gs3.2.1⇒gs4.0.1のデータ移行後、ログインができない
at jp.groupsession.v2.struts.AbstractGsAction.execute(AbstractGsAction.java:144)
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:191)
at org.apache.commons.chain.generic.LookupCommand.execute(LookupCommand.java:305)
at org.apache.commons.chain.impl.ChainBase.execute(ChainBase.java:191)
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:637)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
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.ApplicationDispatcher.invoke(ApplicationDispatcher.java:646)
at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:436)
at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:374)
at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:302)
at org.apache.struts.chain.commands.servlet.PerformForward.handleAsForward(PerformForward.java:113)
at org.apache.struts.chain.commands.servlet.PerformForward.perform(PerformForward.java:96)
投稿者mst 最新書き込み2012/02/03 17:57:00
|
[ 4577 ] Re: gs3.2.1⇒gs4.0.1のデータ移行後、ログインができない
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:191)
at org.apache.commons.chain.generic.LookupCommand.execute(LookupCommand.java:305)
at org.apache.commons.chain.impl.ChainBase.execute(ChainBase.java:191)
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:637)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at jp.co.sjts.util.http.filter.FilterEncoding.doFilter(FilterEncoding.java:96)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
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:102)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
投稿者mst 最新書き込み2012/02/03 17:57:18
|
[ 4578 ] Re: gs3.2.1⇒gs4.0.1のデータ移行後、ログインができない
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)
at org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:190)
at org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:291)
at org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:769)
at org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:698)
at org.apache.jk.common.ChannelSocket$SocketConnection.runIt(ChannelSocket.java:891)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:690)
at java.lang.Thread.run(Thread.java:619)
投稿者mst 最新書き込み2012/02/03 17:58:31
|
[ 4579 ] Re: gs3.2.1⇒gs4.0.1のデータ移行後、ログインができない
> org.h2.jdbc.JdbcSQLException: 列 "BIN_SID" が見つかりません
というエラーが発生しているので、データのコンバートに失敗しているのではないでしょうか。
データベースが破損しているのでなければ下記の方法でデータコンバートを行うと解決すると思います。
GroupSessionのデータを手動でコンバートする方法:
http://www.gs.sjts.co.jp/v4/support/update/update_4.0.2.html#manualConvert
投稿者アルミ 最新書き込み2012/02/03 18:08:49
|
[ 4580 ] Re: gs3.2.1⇒gs4.0.1のデータ移行後、ログインができない
アルミ様ご回答ありがとうございました！
コンバートを実施したところ途中でエラーが出力されてしまいました。
（再度長文のため分けて返信いたします）
WEBメーラー関連のデータ移行で失敗しているようですが、WEBメーラー自体はデータがない状態です。
WEBメーラーのコンバートを除外する方法はございますか？
投稿者mst 最新書き込み2012/02/03 19:17:17
|
[ 4581 ] Re: gs3.2.1⇒gs4.0.1のデータ移行後、ログインができない
エラーログ
-----------------------------
2012-02-03 18:56:11,063 INFO jp.groupsession.v2.cmn.DBUtilFactory:25 - DbUtil is jp.groupsession.v2.cmn.GSH2Util
2012-02-03 18:56:11,068 ERROR jp.groupsession.v2.convert.ConvertGsListenerImpl:487 - SQLExceptionが発生しました。
原因:
org.h2.jdbc.JdbcSQLException: 一般エラー: "java.lang.ArrayIndexOutOfBoundsException: 5"
General error: "java.lang.ArrayIndexOutOfBoundsException: 5"; SQL statement:
select WML_MAILDATA.WMD_MAILNUM as MAILNUM from WML_MAILDATA where WML_MAILDATA.WDR_SID in (15,16,17,18,19,20,21) and not exists ( select 1 from WML_MAILDATA_CONVERT where WML_MAILDATA_CONVERT.WAC_SID = 10 and WML_MAILDATA_CONVERT.WMD_MAILNUM = WML_MAILDATA.WMD_MAILNUM ) limit 100 offset 0 [50000-159]
at org.h2.message.DbException.getJdbcSQLException(DbException.java:329)
at org.h2.message.DbException.get(DbException.java:158)
at org.h2.message.DbException.convert(DbException.java:281)
at org.h2.command.Command.executeQuery(Command.java:185)
at org.h2.jdbc.JdbcStatement.executeQuery(JdbcStatement.java:76)
at org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:208)
at org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:208)
at jp.groupsession.v2.convert.convert350.dao.ConvWebmail350.__getMailAccountList(ConvWebmail350.java:439)
at jp.groupsession.v2.convert.convert350.dao.ConvWebmail350.convert(ConvWebmail350.java:138)
at jp.groupsession.v2.convert.ConvertGsListenerImpl.__convert350(ConvertGsListenerImpl.java:939)
at jp.groupsession.v2.convert.ConvertGsListenerImpl.__convert(ConvertGsListenerImpl.java:389)
at jp.groupsession.v2.convert.ConvertGsListenerImpl.gsInit(ConvertGsListenerImpl.java:114)
at jp.groupsession.v2.convert.ConvertGsListenerImpl.main(ConvertGsListenerImpl.java:1197)
Caused by: java.lang.ArrayIndexOutOfBoundsException: 5
投稿者mst 最新書き込み2012/02/03 19:18:21
|
[ 4582 ] Re: gs3.2.1⇒gs4.0.1のデータ移行後、ログインができない
at org.h2.index.PageDataLeaf.getRowAt(PageDataLeaf.java:327)
at org.h2.index.PageDataLeaf.getRowWithKey(PageDataLeaf.java:443)
at org.h2.index.PageDataNode.getRowWithKey(PageDataNode.java:270)
at org.h2.index.PageDataNode.getRowWithKey(PageDataNode.java:270)
at org.h2.index.PageDataIndex.getRowWithKey(PageDataIndex.java:405)
at org.h2.index.PageDataIndex.getRow(PageDataIndex.java:394)
at org.h2.table.RegularTable.getRow(RegularTable.java:118)
at org.h2.index.PageBtreeIndex.getRow(PageBtreeIndex.java:295)
at org.h2.index.PageBtreeCursor.get(PageBtreeCursor.java:45)
at org.h2.index.MultiVersionCursor.get(MultiVersionCursor.java:81)
at org.h2.index.IndexCursor.get(IndexCursor.java:220)
at org.h2.table.TableFilter.getValue(TableFilter.java:868)
at org.h2.expression.ExpressionColumn.getValue(ExpressionColumn.java:171)
at org.h2.index.IndexCondition.getCurrentValue(IndexCondition.java:120)
at org.h2.index.IndexCursor.find(IndexCursor.java:104)
at org.h2.table.TableFilter.next(TableFilter.java:321)
at org.h2.command.dml.Select.queryFlat(Select.java:512)
at org.h2.command.dml.Select.queryWithoutCache(Select.java:617)
at org.h2.command.dml.Query.query(Query.java:298)
at org.h2.command.dml.Query.query(Query.java:268)
投稿者mst 最新書き込み2012/02/03 19:18:59
|
[ 4583 ] Re: gs3.2.1⇒gs4.0.1のデータ移行後、ログインができない
at org.h2.expression.ConditionExists.getValue(ConditionExists.java:31)
at org.h2.expression.ConditionNot.getValue(ConditionNot.java:31)
at org.h2.expression.ConditionAndOr.getValue(ConditionAndOr.java:90)
at org.h2.expression.Expression.getBooleanValue(Expression.java:180)
at org.h2.command.dml.Select.queryFlat(Select.java:514)
at org.h2.command.dml.Select.queryWithoutCache(Select.java:617)
at org.h2.command.dml.Query.query(Query.java:298)
at org.h2.command.dml.Query.query(Query.java:268)
at org.h2.command.dml.Query.query(Query.java:37)
at org.h2.command.CommandContainer.query(CommandContainer.java:80)
at org.h2.command.Command.executeQuery(Command.java:181)
... 9 more
2012-02-03 18:56:11,087 ERROR jp.groupsession.v2.convert.ConvertGsListenerImpl:488 - デー タのコンバートに失敗
2012-02-03 18:56:11,088 ERROR jp.groupsession.v2.convert.ConvertGsListenerImpl:1203 - WEB メール コンバートに失敗
org.h2.jdbc.JdbcSQLException: 一般エラー: "java.lang.ArrayIndexOutOfBoundsException: 5"
General error: "java.lang.ArrayIndexOutOfBoundsException: 5"; SQL statement:
select WML_MAILDATA.WMD_MAILNUM as MAILNUM from WML_MAILDATA where WML_MAILDATA.WDR_SID in (15,16,17,18,19,20,21) and not exists ( select 1 from WML_MAILDATA_CONVERT where WML_MAILDATA_CONVERT.WAC_SID = 10 and WML_MAILDATA_CONVERT.WMD_MAILNUM = WML_MAILDATA.WMD_MAILNUM ) limit 100 offset 0 [50000-159]
at org.h2.message.DbException.getJdbcSQLException(DbException.java:329)
投稿者mst 最新書き込み2012/02/03 19:19:39
|
[ 4584 ] Re: gs3.2.1⇒gs4.0.1のデータ移行後、ログインができない
at org.h2.message.DbException.get(DbException.java:158)
at org.h2.message.DbException.convert(DbException.java:281)
at org.h2.command.Command.executeQuery(Command.java:185)
at org.h2.jdbc.JdbcStatement.executeQuery(JdbcStatement.java:76)
at org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:208)
at org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:208)
at jp.groupsession.v2.convert.convert350.dao.ConvWebmail350.__getMailAccountList(ConvWebmail350.java:439)
at jp.groupsession.v2.convert.convert350.dao.ConvWebmail350.convert(ConvWebmail350.java:138)
at jp.groupsession.v2.convert.ConvertGsListenerImpl.__convert350(ConvertGsListenerImpl.java:939)
at jp.groupsession.v2.convert.ConvertGsListenerImpl.__convert(ConvertGsListenerImpl.java:389)
at jp.groupsession.v2.convert.ConvertGsListenerImpl.gsInit(ConvertGsListenerImpl.java:114)
at jp.groupsession.v2.convert.ConvertGsListenerImpl.main(ConvertGsListenerImpl.java:1197)
Caused by: java.lang.ArrayIndexOutOfBoundsException: 5
投稿者mst 最新書き込み2012/02/03 19:20:13
|
[ 4585 ] Re: gs3.2.1⇒gs4.0.1のデータ移行後、ログインができない
at org.h2.index.PageDataLeaf.getRowAt(PageDataLeaf.java:327)
at org.h2.index.PageDataLeaf.getRowWithKey(PageDataLeaf.java:443)
at org.h2.index.PageDataNode.getRowWithKey(PageDataNode.java:270)
at org.h2.index.PageDataNode.getRowWithKey(PageDataNode.java:270)
at org.h2.index.PageDataIndex.getRowWithKey(PageDataIndex.java:405)
at org.h2.index.PageDataIndex.getRow(PageDataIndex.java:394)
at org.h2.table.RegularTable.getRow(RegularTable.java:118)
at org.h2.index.PageBtreeIndex.getRow(PageBtreeIndex.java:295)
at org.h2.index.PageBtreeCursor.get(PageBtreeCursor.java:45)
at org.h2.index.MultiVersionCursor.get(MultiVersionCursor.java:81)
at org.h2.index.IndexCursor.get(IndexCursor.java:220)
at org.h2.table.TableFilter.getValue(TableFilter.java:868)
at org.h2.expression.ExpressionColumn.getValue(ExpressionColumn.java:171)
at org.h2.index.IndexCondition.getCurrentValue(IndexCondition.java:120)
投稿者mst 最新書き込み2012/02/03 19:20:52
|
[ 4586 ] Re: gs3.2.1⇒gs4.0.1のデータ移行後、ログインができない
at org.h2.index.IndexCursor.find(IndexCursor.java:104)
at org.h2.table.TableFilter.next(TableFilter.java:321)
at org.h2.command.dml.Select.queryFlat(Select.java:512)
at org.h2.command.dml.Select.queryWithoutCache(Select.java:617)
at org.h2.command.dml.Query.query(Query.java:298)
at org.h2.command.dml.Query.query(Query.java:268)
at org.h2.expression.ConditionExists.getValue(ConditionExists.java:31)
at org.h2.expression.ConditionNot.getValue(ConditionNot.java:31)
at org.h2.expression.ConditionAndOr.getValue(ConditionAndOr.java:90)
at org.h2.expression.Expression.getBooleanValue(Expression.java:180)
at org.h2.command.dml.Select.queryFlat(Select.java:514)
at org.h2.command.dml.Select.queryWithoutCache(Select.java:617)
at org.h2.command.dml.Query.query(Query.java:298)
at org.h2.command.dml.Query.query(Query.java:268)
at org.h2.command.dml.Query.query(Query.java:37)
at org.h2.command.CommandContainer.query(CommandContainer.java:80)
at org.h2.command.Command.executeQuery(Command.java:181)
... 9 more
投稿者mst 最新書き込み2012/02/03 19:21:06
|