フォーラム forum
homechevron_rightフォーラム

GroupSessionについての自由な情報交換の場としてご利用ください

GroupSessionフォーラム:投稿一覧

 
フォーラム:99_その他フォーラム
特定ユーザーのみ削除不可
[ 7888 ] 特定ユーザーのみ削除不可

特定ユーザー削除時にInternal Server Errorとなり削除できません。
他のユーザーは削除できます。
原因と対処がわかる方教えてください。

■システム情報
Version 5.3.3 (5.3.3)
OS Linux 64bit 3.10.0-1160.53.1.el7.x86_64
J2EEコンテナ Apache Tomcat/9.0.58
Java 11.0.14.1 Eclipse Adoptium (OpenJDK 64-Bit Server VM)

■エラーログ
2023-10-01 17:09:43,163 ERROR /user/usr031kn-1696147547275-gsDomain-50 jp.groupsession.v2.usr.usr031kn.Usr031knBiz: - ユーザ削除に失敗
org.h2.jdbc.JdbcSQLException: ステートメントがキャンセルされたか、セッションがタイムアウトしました
Statement was canceled or the session timed out; SQL statement:
update SML_JMEIS set SMJ_JKBN = ?, SMJ_EUID = ?, SMJ_EDATE = ? where SAC_SID = ? [57014-171]
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.message.DbException.get(DbException.java:135)
at org.h2.engine.Session.checkCanceled(Session.java:894)
at org.h2.command.Prepared.checkCanceled(Prepared.java:274)
at org.h2.table.Table.updateRows(Table.java:440)
at org.h2.command.dml.Update.update(Update.java:143)
at org.h2.command.CommandContainer.update(CommandContainer.java:75)
at org.h2.command.Command.executeUpdate(Command.java:230)
at org.h2.jdbc.JdbcPreparedStatement.executeUpdateInternal(JdbcPreparedStatement.java:156)
at org.h2.jdbc.JdbcPreparedStatement.executeUpdate(JdbcPreparedStatement.java:142)
at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
at jp.groupsession.v2.sml.dao.SmlJmeisDao.deleteMsgRonri(SmlJmeisDao.java:1653)
at jp.groupsession.v2.sml.SmlIUserGroupListenerImpl.deleteUser(SmlIUserGroupListenerImpl.java:91)

投稿者GS管理者
最新書き込み2023/10/01 17:44:54
[ 7889 ] Re: 特定ユーザーのみ削除不可

(続き)

at jp.groupsession.v2.usr.usr031kn.Usr031knBiz.delUser(Usr031knBiz.java:1054)
at jp.groupsession.v2.usr.usr031kn.Usr031knBiz.executeDel(Usr031knBiz.java:980)
at jp.groupsession.v2.usr.usr031kn.Usr031knAction.__doDel(Usr031knAction.java:506)
at jp.groupsession.v2.usr.usr031kn.Usr031knAction.executeAction(Usr031knAction.java:217)
at jp.groupsession.v2.struts.AbstractGsAction.execute(AbstractGsAction.java:219)
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 jp.co.sjts.util.struts.BaseServlet.process(BaseServlet.java:90)
at jp.groupsession.v2.cmn.GroupSession.process(GroupSession.java:1042)
at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:462)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:681)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:764)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:227)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)

投稿者GS管理者
最新書き込み2023/10/01 17:45:49
[ 7890 ] Re: 特定ユーザーのみ削除不可

(続き)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
at jp.co.sjts.util.http.filter.FilterEncoding.doFilter(FilterEncoding.java:96)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:197)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:97)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:540)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:135)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92)
at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:687)

投稿者GS管理者
最新書き込み2023/10/01 17:46:52
[ 7891 ] Re: 特定ユーザーのみ削除不可

(続き)

at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:78)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:359)
at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:433)
at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65)
at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:889)
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1735)
at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1191)
at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659)
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
at java.base/java.lang.Thread.run(Thread.java:829)
2023-10-01 17:09:43,189 ERROR /common/cmn001-1696147616718-gsDomain-58 jp.co.sjts.util.struts.BaseServlet: - javax.servlet.ServletException: java.lang.NullPointerException
2023-10-01 17:09:43,191 ERROR /common/cmn001-1696147616718-gsDomain-58 jp.co.sjts.util.struts.BaseServlet: - プロセスメソッドの実行に失敗

投稿者GS管理者
最新書き込み2023/10/01 17:47:17
スレッドURLhttps://groupsession.jp/wbs/bulletin/bbs080.do?bbs010forumSid=4&threadSid=2877
 
メールマガジン登録

vertical_align_top