システムエラー
何回か試してもエラーが解消しない場合は、下記の内容をコピーしてお問い合わせをお願いいたします。
問い合わせ先：kouhou●pmda.go.jp
※迷惑メール防止対策をしているため、送信の際は●を半角のアットマークに置き換えてください。
＝＝下記をコピーしてください＝＝
画面名 ：医療用医薬品 詳細画面
一般名・販売名 ：
エラーメッセージ：org.springframework.dao.RecoverableDataAccessException: PreparedStatementCallback; SQL [SELECT DISTINCT w1.CLM1, w1.CLM2, w1.CLM3, w1.CLM4, w1.CLM5, w1.CLM6, w2.CLM7, w2.CLM8, w2.CLM9, w2.CLM10
, w3.CLM11, w3.CLM12, w3.CLM13, w3.CLM14, w5.CLM15, w5.CLM16, w5.CLM17, w5.CLM18
, w10.CLM19, w10.CLM20, w10.CLM21, w10.CLM22, w23.CLM23, w23.CLM24, w23.CLM25, w23.CLM26, w1.CLM27
, w1.CLM28, w1.CLM29 , w1.CLM30 , w1.CLM31
, w2.CLM32, w2.CLM33, w2.CLM34
, w3.CLM35, w3.CLM36, w3.CLM37
, w5.CLM38, w5.CLM39, w5.CLM40
, w10.CLM41, w10.CLM42, w10.CLM43
, w23.CLM44, w23.CLM45, w23.CLM46
, w1.YJ_CODE CLM47
FROM(
SELECT DISTINCT DRAGM.D_NAME CLM1, TBOOK.CODE CLM2, TBOOK.BOOK_NO CLM3, TBOOK.VERSION CLM4, TBOOK.SALE_NAME_TRIM CLM5, DRAGM.NAME_R CLM6, TBOOK.YJ_CODE, KAISM.STOP CLM27, TBOOK.COMPANY CLM28,
NVL2(DRAGM.KOHATSU_FLG , 1 , 0) CLM29 , TO_CHAR( PINFO.EDIT_DATE , 'YYYY"年"MM"月"DD"日"') CLM30 , TBOOK.PDF_EN_FLG CLM31
FROM CP_IYAKU_T_BOOK TBOOK INNER JOIN CP_IYAKU_PACKINS_INFO PINFO ON TBOOK.BOOK_NO || '_' || TBOOK.VERSION = PINFO.FILENAME
INNER JOIN CP_IYAKU_T_BOOK_YJ TBYJ ON TBOOK.CODE = TBYJ.CODE AND TBOOK.BOOK_NO = TBYJ.BOOK_NO
INNER JOIN CP_IYAKU_DRAG_MAST DRAGM ON TBYJ.YJ_CODE = DRAGM.YJ_CODE
LEFT JOIN V_IYAKU_KAITEI_SHIJI_MITAIOU KAISM ON TBOOK.BOOK_NO = KAISM.BOOK_NO
WHERE TBOOK.STATUS IN ('4','5','7')
AND SUBSTR(DRAGM.YJ_CODE, 1, 7) = ?
) w1 left join
(
SELECT DISTINCT SIMPL.RD_KIND_NO CLM7, SIMPL.RD_KIND_NAME CLM8, CASE WHEN UPPER(SIMPL.RD_URI) LIKE '%.HTM%' THEN '【必須版】' || SIMPL.RD_NAME ELSE SIMPL.RD_NAME END CLM9, SIMPL.RD_URI CLM10, TBOOK.YJ_CODE , SIMPL.BOOK_NO
, SIMPL.RD_DATE CLM32 , SIMPL.FILE_SER_NO CLM33 , SIMPL.EDA_NO CLM34 FROM (SELECT CODE, BOOK_NO, YJ_CODE FROM CP_IYAKU_T_BOOK WHERE STATUS IN ('4','5','7')) TBOOK INNER JOIN CP_IYAKU_T_BOOK_YJ TBYJ ON TBOOK.CODE = TBYJ.CODE AND TBOOK.BOOK_NO = TBYJ.BOOK_NO INNER JOIN CP_IYAKU_DRAG_MAST DRAGM ON TBYJ.YJ_CODE = DRAGM.YJ_CODE INNER JOIN (SELECT IMPL.FILE_SER_NO, IMPL.YJ12, RFILE.RD_NAME, RFILE.RD_URI, MKIND.RD_KIND_NO, MKIND.RD_KIND_NAME , RFILE.RD_DATE , RFILE.EDA_NO , IMPL.BOOK_NO FROM D_IYAKU_SALE_RD_IMPL IMPL INNER JOIN (SELECT FILE_SER_NO, RD_NAME, RD_URI, RD_KIND_NO , RD_DATE , EDA_NO FROM D_IYAKU_RD_FILE WHERE RD_STATUS = '1') RFILE ON IMPL.FILE_SER_NO = RFILE.FILE_SER_NO INNER JOIN (SELECT RD_KIND_NO, RD_KIND_NAME FROM M_IYAKU_RD_KIND WHERE RD_KIND_NO = 2) MKIND ON RFILE.RD_KIND_NO = MKIND.RD_KIND_NO ) SIMPL ON DRAGM.YJ_CODE = SIMPL.YJ12 ) w2 on w1.CLM3 = w2.BOOK_NO left join (
SELECT DISTINCT SIMPL.RD_KIND_NO CLM11, SIMPL.RD_KIND_NAME CLM12, SIMPL.RD_NAME CLM13, SIMPL.RD_URI CLM14, TBOOK.YJ_CODE , SIMPL.BOOK_NO
, SIMPL.RD_DATE CLM35 , SIMPL.FILE_SER_NO CLM36 , SIMPL.EDA_NO CLM37 FROM (SELECT CODE, BOOK_NO, YJ_CODE FROM CP_IYAKU_T_BOOK WHERE STATUS IN ('4','5','7')) TBOOK INNER JOIN CP_IYAKU_T_BOOK_YJ TBYJ ON TBOOK.CODE = TBYJ.CODE AND TBOOK.BOOK_NO = TBYJ.BOOK_NO INNER JOIN CP_IYAKU_DRAG_MAST DRAGM ON TBYJ.YJ_CODE = DRAGM.YJ_CODE INNER JOIN (SELECT IMPL.FILE_SER_NO, IMPL.YJ12, RFILE.RD_NAME, RFILE.RD_URI, MKIND.RD_KIND_NO, MKIND.RD_KIND_NAME , RFILE.RD_DATE , RFILE.EDA_NO , IMPL.BOOK_NO FROM D_IYAKU_SALE_RD_IMPL IMPL INNER JOIN (SELECT FILE_SER_NO, RD_NAME, RD_URI, RD_KIND_NO , RD_DATE , EDA_NO FROM D_IYAKU_RD_FILE WHERE RD_STATUS = '1') RFILE ON IMPL.FILE_SER_NO = RFILE.FILE_SER_NO INNER JOIN (SELECT RD_KIND_NO, RD_KIND_NAME FROM M_IYAKU_RD_KIND WHERE RD_KIND_NO = 3) MKIND ON RFILE.RD_KIND_NO = MKIND.RD_KIND_NO ) SIMPL ON DRAGM.YJ_CODE = SIMPL.YJ12 ) w3 on w1.CLM3 = w3.BOOK_NO left join (
SELECT DISTINCT SIMPL.RD_KIND_NO CLM15, SIMPL.RD_KIND_NAME CLM16, SIMPL.RD_NAME CLM17, SIMPL.RD_URI CLM18, TBOOK.BOOK_NO , SIMPL.RD_DATE CLM38 , SIMPL.FILE_SER_NO CLM39 , SIMPL.EDA_NO CLM40 FROM (SELECT CODE, BOOK_NO, YJ_CODE FROM CP_IYAKU_T_BOOK WHERE STATUS IN ('4','5','7')) TBOOK INNER JOIN CP_IYAKU_T_BOOK_YJ TBYJ ON TBOOK.CODE = TBYJ.CODE AND TBOOK.BOOK_NO = TBYJ.BOOK_NO INNER JOIN CP_IYAKU_DRAG_MAST DRAGM ON TBYJ.YJ_CODE = DRAGM.YJ_CODE INNER JOIN (SELECT IMPL.FILE_SER_NO, IMPL.YJ12, RFILE.RD_NAME, RFILE.RD_URI, MKIND.RD_KIND_NO, MKIND.RD_KIND_NAME , RFILE.RD_DATE , RFILE.EDA_NO FROM D_IYAKU_SALE_RD_IMPL IMPL INNER JOIN (SELECT FILE_SER_NO, RD_NAME, RD_URI, RD_KIND_NO , RD_DATE , EDA_NO FROM D_IYAKU_RD_FILE WHERE RD_STATUS = '1') RFILE ON IMPL.FILE_SER_NO = RFILE.FILE_SER_NO INNER JOIN (SELECT RD_KIND_NO, RD_KIND_NAME FROM M_IYAKU_RD_KIND WHERE RD_KIND_NO = 5) MKIND ON RFILE.RD_KIND_NO = MKIND.RD_KIND_NO ) SIMPL ON DRAGM.YJ_CODE = SIMPL.YJ12 INNER JOIN CP_IYAKU_T_JUUTOKU TJ ON TJ.BOOK_NO=TBOOK.BOOK_NO INNER JOIN CP_IYAKU_M_JUUTOKU MJ ON MJ.JUUTOK_ID=TJ.JUUTOK_ID WHERE TJ.F_ANS='1' AND MJ.PDF_FILE=SIMPL.RD_URI ) w5 on w1.CLM3 = w5.BOOK_NO left join (
SELECT DISTINCT SIMPL.RD_KIND_NO CLM19, SIMPL.RD_KIND_NAME CLM20, SIMPL.RD_NAME CLM21, SIMPL.RD_URI CLM22, TBOOK.BOOK_NO , SIMPL.RD_DATE CLM41 , SIMPL.FILE_SER_NO CLM42 , SIMPL.EDA_NO CLM43 FROM (SELECT CODE, BOOK_NO, YJ_CODE FROM CP_IYAKU_T_BOOK WHERE STATUS IN ('4','5','7')) TBOOK INNER JOIN CP_IYAKU_T_BOOK_YJ TBYJ ON TBOOK.CODE = TBYJ.CODE AND TBOOK.BOOK_NO = TBYJ.BOOK_NO INNER JOIN CP_IYAKU_DRAG_MAST DRAGM ON TBYJ.YJ_CODE = DRAGM.YJ_CODE LEFT JOIN (SELECT IMPL.FILE_SER_NO, IMPL.BOOK_NO, RFILE.RD_NAME, RFILE.RD_URI, MKIND.RD_KIND_NO, MKIND.RD_KIND_NAME , RFILE.RD_DATE , RFILE.EDA_NO FROM D_IYAKU_SALE_RD_IMPL IMPL INNER JOIN (SELECT FILE_SER_NO, RD_NAME, RD_URI, RD_KIND_NO , RD_DATE , EDA_NO FROM D_IYAKU_RD_FILE WHERE RD_STATUS = '1') RFILE ON IMPL.FILE_SER_NO = RFILE.FILE_SER_NO INNER JOIN (SELECT RD_KIND_NO, RD_KIND_NAME FROM M_IYAKU_RD_KIND WHERE RD_KIND_NO = 10) MKIND ON RFILE.RD_KIND_NO = MKIND.RD_KIND_NO ) SIMPL ON TBOOK.BOOK_NO = SIMPL.BOOK_NO ) w10 on w1.CLM3 = w10.BOOK_NO left join (
SELECT DISTINCT SIMPL.RD_KIND_NO CLM23, SIMPL.RD_KIND_NAME CLM24, SIMPL.RD_NAME CLM25, PDF23.RD_URI CLM26, TBOOK.YJ_CODE , SIMPL.RD_DATE CLM44 , SIMPL.FILE_SER_NO CLM45 , SIMPL.EDA_NO CLM46 FROM (SELECT CODE, BOOK_NO, YJ_CODE FROM CP_IYAKU_T_BOOK WHERE STATUS IN ('4','5','7')) TBOOK INNER JOIN CP_IYAKU_T_BOOK_YJ TBYJ ON TBOOK.CODE = TBYJ.CODE AND TBOOK.BOOK_NO = TBYJ.BOOK_NO INNER JOIN CP_IYAKU_DRAG_MAST DRAGM ON TBYJ.YJ_CODE = DRAGM.YJ_CODE INNER JOIN (SELECT IMPL.FILE_SER_NO, IMPL.YJ12, RFILE.RD_NAME, MKIND.RD_KIND_NO, MKIND.RD_KIND_NAME , RFILE.RD_DATE , RFILE.EDA_NO FROM D_IYAKU_SALE_RD_IMPL IMPL INNER JOIN (SELECT FILE_SER_NO, RD_NAME, RD_KIND_NO , RD_DATE , EDA_NO FROM D_IYAKU_RD_FILE WHERE RD_STATUS = '1') RFILE ON IMPL.FILE_SER_NO = RFILE.FILE_SER_NO INNER JOIN (SELECT RD_KIND_NO, RD_KIND_NAME FROM M_IYAKU_RD_KIND WHERE RD_KIND_NO = 23) MKIND ON RFILE.RD_KIND_NO = MKIND.RD_KIND_NO ) SIMPL ON DRAGM.YJ_CODE = SIMPL.YJ12 INNER JOIN (SELECT FILE_SER_NO , RD_URI FROM D_IYAKU_PDF23 WHERE INNER_SER_NO = 1) PDF23 ON PDF23.FILE_SER_NO = SIMPL.FILE_SER_NO ) w23 on w1.YJ_CODE = w23.YJ_CODE ORDER BY CLM29 , CLM6, CLM47, CLM17]; ソケットから読み込むデータはこれ以上ありません。; nested exception is java.sql.SQLRecoverableException: ソケットから読み込むデータはこれ以上ありません。
現在時刻 ：2026/08/20 03:00:02
IPアドレス ：216.73.217.130
＝＝ここまで＝＝＝＝＝＝＝＝＝＝