[ 6922 ] Re: アンケート機能でタイムアウトしシステムダウンとなる
org.h2.jdbc.JdbcSQLException: ステートメントがキャンセルされたか、セッションがタイムアウトしました Statement was canceled or the session timed out; SQL statement: select GROUP_DATA.GRP_NAME as GRP_NAME, CMN_USRM.USR_SID as USR_SID, CMN_USRM_INF.USI_SEI as USI_SEI, CMN_USRM_INF.USI_MEI as USI_MEI, (case when CMN_USRM_INF.POS_SID = 0 then 1 else 0 end) as YAKUSYOKU_EXIST, (case when CMN_USRM_INF.POS_SID = 0 then 0 else (select POS_SORT from CMN_POSITION where CMN_USRM_INF.POS_SID = CMN_POSITION.POS_SID) end) as YAKUSYOKU_SORT, ENQ_ANS_MAIN.EAM_STS_KBN as EAM_STS_KBN, ANS_DATA.EQM_SEQ as EQM_SEQ, ANS_DATA.EQS_SEQ as EQS_SEQ, ANS_DATA.EAS_ANS as EAS_ANS, ANS_DATA.EAS_ANS_NUM as EAS_ANS_NUM, ANS_DATA.EQM_QUE_KBN as QUE_KBN from CMN_USRM, CMN_USRM_INF left join ( select CMN_GROUPM.GRP_NAME as GRP_NAME, CMN_GROUPM.GRP_NAME_KN as GRP_NAME_KN, CMN_GROUPM.GRP_JKBN as GRP_JKBN, CMN_BELONGM.USR_SID as USR_SID
投稿者GS運用中 最新書き込み2017/11/06 11:07:41
|
[ 6923 ] Re: アンケート機能でタイムアウトしシステムダウンとなる
from CMN_GROUPM, CMN_BELONGM where CMN_BELONGM.BEG_DEFGRP = ? and CMN_BELONGM.GRP_SID = CMN_GROUPM.GRP_SID ) GROUP_DATA on CMN_USRM_INF.USR_SID = GROUP_DATA.USR_SID, ENQ_ANS_MAIN left join ( select ENQ_QUE_MAIN.EMN_SID as EMN_SID, ENQ_QUE_MAIN.EQM_SEQ as EQM_SEQ, ENQ_QUE_MAIN.EQM_DSP_SEC as EQM_DSP_SEC, ENQ_ANS_SUB.USR_SID as USR_SID, ENQ_QUE_SUB.EQS_SEQ as EQS_SEQ, ENQ_ANS_SUB.EAS_ANS as EAS_ANS, ENQ_ANS_SUB.EAS_ANS_NUM as EAS_ANS_NUM, ENQ_QUE_SUB.EQS_DSP_SEC as EQS_DSP_SEC, ENQ_QUE_MAIN.EQM_QUE_KBN as EQM_QUE_KBN from ENQ_QUE_MAIN, ENQ_QUE_SUB left join ENQ_ANS_SUB on ENQ_ANS_SUB.EMN_SID = ? and ENQ_ANS_SUB.EMN_SID = ENQ_QUE_SUB.EMN_SID and ENQ_ANS_SUB.EQM_SEQ = ENQ_QUE_SUB.EQM_SEQ and ENQ_ANS_SUB.EQS_SEQ = ENQ_QUE_SUB.EQS_SEQ where ENQ_QUE_MAIN.EMN_SID = ? and ENQ_QUE_MAIN.EMN_SID = ENQ_QUE_SUB.EMN_SID and ENQ_QUE_MAIN.EQM_SEQ = ENQ_QUE_SUB.EQM_SEQ ) ANS_DATA on ENQ_ANS_MAIN.EMN_SID = ANS_DATA.EMN_SID and ENQ_ANS_MAIN.USR_SID = ANS_DATA.USR_SID where ENQ_ANS_MAIN.EMN_SID = ? and ENQ_ANS_MAIN.USR_SID = CMN_USRM.USR_SID and CMN_USRM.USR_SID = CMN_USRM_INF.USR_SID order by YAKUSYOKU_EXIST asc , YAKUSYOKU_SORT asc , CMN_USRM_INF.USI_BDATE asc ,ENQ_ANS_MAIN.USR_SID, case ANS_DATA.EQM_DSP_SEC when null then 1 else 0 end, EQM_DSP_SEC, case ANS_DATA.EQS_DSP_SEC when null then 1 else 0 end, EQS_DSP_SEC [57014-171]
投稿者GS運用中 最新書き込み2017/11/06 11:07:58
|