Error Code : 2391 Error Message : ORA-02391: exceeded simultaneous SESSIONS_PER_USER limit ORA-02063: preceding line from FNF Position : 1629 Statement : SELECT a.brand, a.partcode, a.color, a.siz, a.stock, a.order_stock, a.store_stock , c.option_quantity_lack, c.option_quantity_fail, c.option_quantity_reserve, c.option_quantity_noti , FN_GET_IPGO(:season, a.partcode, a.color, a.siz) ipgo FROM ( SELECT BRAND, SEASON, PARTCODE, COLOR, SIZ, SUM (STOCK) AS STOCK, /* 물류 가용 재고 */ SUM (ORDER_STOCK) AS ORDER_STOCK, /* 쇼핑몰 배분중 재고 */ SUM (STORE_STOCK) AS STORE_STOCK /* 매장 재고 */ FROM ( SELECT A.BRAND, A.SEASON, A.PARTCODE, A.COLOR, A.SIZ, ( NVL (A.STOCK_QTY + A.ADJUST_QTY - A.ADJUST_CQTY, 0) - NVL (A.ORDER_QTY, 0) - NVL (A.ALLOCATE_QTY, 0) - NVL (A.PICK_QTY, 0) - NVL (A.INVOICE_QTY, 0) - (NVL (A.BADTAKEOUT_CQTY, 0) - NVL (A.BADTAKEOUT_QTY, 0))) AS STOCK, /* 물류 가용 재고 */ 0 ORDER_STOCK, 0 STORE_STOCK FROM SCS@fnf A WHERE 1=1 AND A.BRAND = :brandcd AND A.SEASON = :season and a.partcode = :prodcode and a.color = :colorcode UNION ALL SELECT A.BRAND, A.SEASON, A.PARTCODE, A.COLOR, A.SIZ, 0 STOCK , CASE WHEN shopcode IN ('050011','050002','050001') THEN (NVL (A.ORDER_QTY, 0)) ELSE 0 END AS ORDER_QTY -- 쇼핑몰 배분중 재고 , CASE WHEN shopcode IN ('050011','050002','050001') THEN 0 ELSE ( A.TAKEOUT_QTY - A.TAKEOUT_CQTY - A.SALE_QTY + A.SALE_CQTY) END AS STORE_STOCK /* 매장 재고 */ FROM SCSSHOP@fnf A WHERE 1=1 AND A.BRAND = :brandcd AND A.SEASON = :season and a.partcode = :prodcode and a.color = :colorcode and a.shopcode in (Select store_code From tblstore Where 1=1 and shop_div_code = :brandcd ) ) GROUP BY BRAND, SEASON, PARTCODE, COLOR, SIZ ) a JOIN tblproduct b ON a.brand = b.shop_div_code and a.season = b.c_season and a.partcode = b.prodcode and a.color = b.colorcode JOIN tblproduct_option c ON b.productcode = c.productcode and a.siz = c.option_code WHERE 1 = 1 ORDER BY a.siz Bindings : [25S,S,SAKC10511,SB] (SQL: SELECT a.brand, a.partcode, a.color, a.siz, a.stock, a.order_stock, a.store_stock , c.option_quantity_lack, c.option_quantity_fail, c.option_quantity_reserve, c.option_quantity_noti , FN_GET_IPGO(:season, a.partcode, a.color, a.siz) ipgo FROM ( SELECT BRAND, SEASON, PARTCODE, COLOR, SIZ, SUM (STOCK) AS STOCK, /* 물류 가용 재고 */ SUM (ORDER_STOCK) AS ORDER_STOCK, /* 쇼핑몰 배분중 재고 */ SUM (STORE_STOCK) AS STORE_STOCK /* 매장 재고 */ FROM ( SELECT A.BRAND, A.SEASON, A.PARTCODE, A.COLOR, A.SIZ, ( NVL (A.STOCK_QTY + A.ADJUST_QTY - A.ADJUST_CQTY, 0) - NVL (A.ORDER_QTY, 0) - NVL (A.ALLOCATE_QTY, 0) - NVL (A.PICK_QTY, 0) - NVL (A.INVOICE_QTY, 0) - (NVL (A.BADTAKEOUT_CQTY, 0) - NVL (A.BADTAKEOUT_QTY, 0))) AS STOCK, /* 물류 가용 재고 */ 0 ORDER_STOCK, 0 STORE_STOCK FROM SCS@fnf A WHERE 1=1 AND A.BRAND = :brandcd AND A.SEASON = :season and a.partcode = :prodcode and a.color = :colorcode UNION ALL SELECT A.BRAND, A.SEASON, A.PARTCODE, A.COLOR, A.SIZ, 0 STOCK , CASE WHEN shopcode IN ('050011','050002','050001') THEN (NVL (A.ORDER_QTY, 0)) ELSE 0 END AS ORDER_QTY -- 쇼핑몰 배분중 재고 , CASE WHEN shopcode IN ('050011','050002','050001') THEN 0 ELSE ( A.TAKEOUT_QTY - A.TAKEOUT_CQTY - A.SALE_QTY + A.SALE_CQTY) END AS STORE_STOCK /* 매장 재고 */ FROM SCSSHOP@fnf A WHERE 1=1 AND A.BRAND = :brandcd AND A.SEASON = :season and a.partcode = :prodcode and a.color = :colorcode and a.shopcode in (Select store_code From tblstore Where 1=1 and shop_div_code = :brandcd ) ) GROUP BY BRAND, SEASON, PARTCODE, COLOR, SIZ ) a JOIN tblproduct b ON a.brand = b.shop_div_code and a.season = b.c_season and a.partcode = b.prodcode and a.color = b.colorcode JOIN tblproduct_option c ON b.productcode = c.productcode and a.siz = c.option_code WHERE 1 = 1 ORDER BY a.siz ) 서버 에러
500
서버 에러