org.springframework.jdbc.BadSqlGrammarException:
### Error querying database. Cause: org.postgresql.util.PSQLException: ERROR: function func_tag_closeout_shipment_item_aggregate(unknown, unknown, text[], unknown, unknown, unknown) does not exist
ヒント: No function matches the given name and argument types. You might need to add explicit type casts.
位置: 5153
### The error may exist in file [D:\SY22BNEC31\03_PJ開発_密\0306_SourceStep3\item-tag-information-api-sana-application\bin\main\jp\co\sej\ssc\an\Sana0817MP001.xml]
### The error may involve jp.co.sej.ssc.an.SANA0817selectNormalAchievementByTrack-Inline
### The error occurred while setting parameters
### SQL: WITH t_analysis_date AS ( SELECT GENERATE_SERIES::DATE AS analysis_date FROM GENERATE_SERIES('2025-01-25'::DATE, '2025-02-01'::DATE, '1 days') ), t_shipment(shipment) AS ( VALUES ('1'),('2'),('3') -- 3便 ), v_item_tag_info(item_tag_code, employee_number) AS ( VALUES (?, ?) ), t_item_tag_daily_shipment_inf AS ( SELECT T21.item_tag_code AS item_tag_code ,T21.employee_number AS employee_number ,T21.item_code AS item_code ,T21.system_item_code AS system_item_code ,T21.original_store_code AS original_store_code ,T22.analysis_date AS analysis_date ,T23.shipment AS shipment FROM m_item_tagged T21 -- 商品タグ商品紐づけマスタ INNER JOIN m_item_tag T011 -- 商品タグマスタ ON T011.original_store_code = '123456' AND T011.item_tag_code = T21.item_tag_code AND T011.employee_number = T21.employee_number CROSS JOIN t_analysis_date T22 CROSS JOIN t_shipment T23 INNER JOIN v_item_tag_info T24 --商品タグ検索条件マスタ ON T21.item_tag_code = T24.item_tag_code AND T21.employee_number = T24.employee_number WHERE T21.original_store_code = '123456' AND T21.system_item_code IN ( '0001' ) GROUP BY T21.item_tag_code, T21.employee_number, T21.item_code, T21.system_item_code, T21.original_store_code, T22.analysis_date, T23.shipment ), t_item_tag_nodaily_shipment_inf AS ( SELECT T21.item_tag_code AS item_tag_code ,T21.employee_number AS employee_number ,T21.item_code AS item_code ,T21.system_item_code AS system_item_code ,T21.original_store_code AS original_store_code ,T22.analysis_date AS analysis_date FROM m_item_tagged T21 -- 商品タグ商品紐づけマスタ INNER JOIN m_item_tag T011 -- 商品タグマスタ ON T011.original_store_code = '123456' AND T011.item_tag_code = T21.item_tag_code AND T011.employee_number = T21.employee_number CROSS JOIN t_analysis_date T22 INNER JOIN v_item_tag_info T23 --商品タグ検索条件マスタ ON T21.item_tag_code = T23.item_tag_code AND T21.employee_number = T23.employee_number WHERE T21.original_store_code = '123456' AND T21.system_item_code IN ( '' ) GROUP BY T21.item_tag_code, T21.employee_number, T21.item_code, T21.system_item_code, T21.original_store_code, T22.analysis_date ), daily_nodaily_result AS ( SELECT -- デイリー品の実績取得 T01.item_tag_code AS item_tag_code ,T01.employee_number AS employee_number ,T01.analysis_date AS analysis_date ,T01.shipment AS shipment ,COALESCE(SUM(T02.delivery_quantity), 0) AS delivery_quantity ,COALESCE(SUM(T02.delivery_amount), 0) AS delivery_amount ,COALESCE(SUM(T02.sales_quantity), 0) AS sales_quantity ,COALESCE(SUM(T02.sales_amount), 0) AS sales_amount ,COALESCE(SUM(T02.gross_amount), 0) AS gross_amount ,COALESCE(SUM(T02.disposal_quantity), 0) AS disposal_quantity ,COALESCE(SUM(T02.disposal_amount), 0) AS disposal_amount ,0 AS ethical_sales_quantity ,0 AS ethical_sales_amount ,COALESCE(SUM(T05.closeout_sales_quantity), 0) AS forsake_sales_quantity ,COALESCE(SUM(T05.closeout_sales_amount), 0) AS forsake_sales_amount FROM t_item_tag_daily_shipment_inf T01 LEFT JOIN -- 便別単品集計 func_shipment_item_aggregate ('123456', NULL, ARRAY [ '0001' ] , '2025-01-25', '2025-02-01', '2024-01-16') T02 ON T02.system_item_code = T01.system_item_code AND T02.shipment = T01.shipment AND T02.analysis_date = T01.analysis_date LEFT JOIN -- 見切り便別単品集計 func_tag_closeout_shipment_item_aggregate ('123456', NULL, ARRAY [ '0001' ] , '2025-01-25', '2025-02-01', '2024-01-16') T05 ON T05.system_item_code = T01.system_item_code AND T05.shipment = T01.shipment AND T05.analysis_date = T01.analysis_date GROUP BY T01.item_tag_code, T01.employee_number, T01.analysis_date, T01.shipment UNION ALL SELECT -- 非デイリー品の実績取得 T01.item_tag_code AS item_tag_code ,T01.employee_number AS employee_number ,T01.analysis_date AS analysis_date ,'1' AS shipment ,COALESCE(SUM(T02.delivery_quantity), 0) AS delivery_quantity ,COALESCE(SUM(T02.delivery_amount), 0) AS delivery_amount ,COALESCE(SUM(T02.sales_quantity), 0) AS sales_quantity ,COALESCE(SUM(T02.sales_amount), 0) AS sales_amount ,COALESCE(SUM(T02.gross_amount), 0) AS gross_amount ,COALESCE(SUM(T02.disposal_quantity), 0) AS disposal_quantity ,COALESCE(SUM(T02.disposal_amount), 0) AS disposal_amount ,0 AS ethical_sales_quantity ,0 AS ethical_sales_amount ,COALESCE(SUM(T05.closeout_sales_quantity), 0) AS forsake_sales_quantity ,COALESCE(SUM(T05.closeout_sales_amount), 0) AS forsake_sales_amount FROM t_item_tag_nodaily_shipment_inf T01 LEFT JOIN -- 日別単品集計 func_daily_item_aggregate ('123456', NULL, ARRAY [ '' ] , '2025-01-25', '2025-02-01', '2024-01-16') T02 ON T02.system_item_code = T01.system_item_code AND T02.analysis_date = T01.analysis_date LEFT JOIN -- 見切り日別単品集計 func_tag_closeout_daily_item_aggregate ('123456', NULL, ARRAY [ '' ] , '2025-01-25', '2025-02-01', '2024-01-16') T05 ON T05.system_item_code = T01.system_item_code AND T05.analysis_date = T01.analysis_date GROUP BY T01.item_tag_code, T01.employee_number, T01.analysis_date ) SELECT T06.item_tag_code ,T06.employee_number ,T06.analysis_date ,T06.shipment ,COALESCE(SUM(T06.delivery_quantity), 0) AS delivery_quantity ,COALESCE(SUM(T06.delivery_amount), 0) AS delivery_amount ,COALESCE(SUM(T06.sales_quantity), 0) AS sales_quantity ,COALESCE(SUM(T06.sales_amount), 0) AS sales_amount ,COALESCE(SUM(T06.gross_amount), 0) AS gross_amount ,COALESCE(SUM(T06.disposal_quantity), 0) AS disposal_quantity ,COALESCE(SUM(T06.disposal_amount), 0) AS disposal_amount ,0 AS ethical_sales_quantity ,0 AS ethical_sales_amount ,COALESCE(SUM(T06.forsake_sales_quantity), 0) AS forsake_sales_quantity ,COALESCE(SUM(T06.forsake_sales_amount), 0) AS forsake_sales_amount FROM daily_nodaily_result T06 GROUP BY T06.item_tag_code ,T06.employee_number ,T06.analysis_date ,T06.shipment ORDER BY T06.item_tag_code ,T06.employee_number ,T06.analysis_date ,T06.shipment
### Cause: org.postgresql.util.PSQLException: ERROR: function func_tag...