SQL문 오류 :
spGoodsLog
데이터 처리 중 오류가 발생 했습니다.
오류 내용:
트랜잭션(프로세스 ID 150)이 잠금 | 통신 버퍼 리소스에서 다른 프로세스와의 교착 상태가 발생하여 실행이 중지되었습니다. 트랜잭션을 다시 실행하십시오.
위의 오류 내용을 사이트 관리자에게 문의해 주시기 바랍니다.

SELECT PartnerID ,QQ_LOGIN_APPID, QQ_LOGIN_APPKEY, WB_LOGIN_APPID, WB_LOGIN_APPKEY, WC_LOGIN_APPID, WC_LOGIN_APPKEY ,QQ_LOGIN_SECRET, WB_LOGIN_SECRET, WC_LOGIN_SECRET FROM T_CONFIG_DOMAIN WHERE DOMAIN='hizkorea.com'

spGetConfig

SELECT USDExchange, CNYExchange, JPYExchange FROM T_CONFIG_EXCHANGE WHERE SiteID='hanguoshopping' ORDER BY UID DESC

SELECT LanguageCode FROM T_CONFIG_LANGUAGE WHERE Flag=?

SELECT AgencyID, AgencyUse FROM T_PARTNER WHERE PartnerID = 'hizkorea'

SELECT Domain FROM T_PARTNER WHERE PartnerID = ''

SELECT SubDomain, BrowerTitle, Email, PartnerName, SiteName, EndDate, State,ServiceCode, IsFavicon, MetaTag, Description, Keyword, isGoodsWatermark, goodsWatermarkImg, IsSerial, SerialNum, IsAPP, googleTag FROM T_PARTNER WHERE SiteID='hanguoshopping' AND PartnerID=?

select CeoName, ChName, Email, PartnerName, Addr, AddrDetail, Tel, Fax, BizNo, MobileTopBgColor, MobileTopButtonColor, MobileTopTextColor ,joinType from T_PARTNER where siteID=? and partnerID=?

select CeoName, TongsinNo from T_CONFIG_COMPANY where siteID=?

select domain from T_CONFIG_DOMAIN where siteID='hanguoshopping' AND isBaseDomain='T'

SELECT ShippingPolicy FROM T_CONFIG_MANAGE WHERE SiteID = 'hanguoshopping'

SELECT goods_uid FROM T_GIVEID_LIST WHERE ( PartnerID is null OR PartnerID = 'hizkorea' ) AND guse='Y' ORDER BY gwid ASC

SELECT goods_uid FROM T_GIVEAWAY_LIST WHERE guse='Y' ORDER BY gwid ASC

select PartnerID from T_PARTNER where Uid>=105 order by Uid asc

SELECT BankName, BankAccount, BankDepositary FROM T_CONFIG_PAY WHERE SiteID='hanguoshopping'

SELECT ISNULL(PageSeq, 0) FROM T_MAIN_PAGE WHERE SiteID = 'hanguoshopping' AND PageCode = 'MAIN' AND IsFix = 'Y'

SELECT ImgM, ImgserverUrl, Title, Keyword FROM T_GOODS WHERE uid=403830

select count(*) as cnt from T_GOODS_TAG_SEARCH where RegDate>DATEADD(MINUTE, -5, GETDATE())

select TOP 3 tagName from T_GOODS_TAG_SEARCH order by Tmuid asc

SELECT TOP 10 * FROM T_ISSUMER_RANK2 where PartnerID is null ORDER BY RANK

SELECT Mobile_code, script_key FROM T_CONFIG_COUNSEL WHERE SiteID = 'hanguoshopping' AND PartnerID = 'hizkorea'

SELECT GoodsType, DealerID, GoodsCode, Title, Title_CH, SubTitle, ImgB, ImgM, ImgS, DollarMoney, Price, BuyPrice, OriginalPrice, dbo.fnGetFinalPrice(MemberPrice, G.Uid, '') As GMemberPrice, MarketPrice, PriceSplit, CmsType, Margin, Cmoney, Stock, Product, PlaceOfOrigin, ContentFile, IsDelContentFile, DeliveryPolicy, DeliveryMethod, DeliveryFee, DeliveryLimit, OptionKind, OptionTxt, IsIconA, IsIconB, IsIconC, IsIconD, IsIconE, IsIconF, IsDisplay, IsSoldOut, State, OrgUid, Content_ch, DeliveryContent, dbo.fnCheckEventDiscount(G.SiteID, G.Uid, GETDATE()) AS EventDiscountPrice, ImgserverUrl, ImgserverFolder, (SELECT Name_en FROM T_BRAND WHERE SiteID=G.SiteID AND Uid=G.BrandUid) AS Brand, content, weight, isOver, (select shippingType from T_CATEGORY where CateCode=GT.CateCode) as shippingType , title_en, weightUnit, eaUnit, modelNo, spec, element, effect, purpose, weight2, deliveryType, branduid, GC.player , G.isCount, G.goodsCount , G.DeliveryEach, G.barcode, G.StoreName , GC.Content_STEXT, GC.Cs_use FROM V_GOODS AS G JOIN T_GOODS_CONTENT AS GC ON G.Uid=GC.Uid JOIN T_GOODS_CATEGORY AS GT ON G.uid=GT.goodsUid AND GT.sort=1 WHERE G.SiteID='hanguoshopping' AND G.Uid=? AND GT.CateCode NOT IN (SELECT CateCode FROM fnGetCateChild('hanguoshopping', 1000000, 0)) AND G.Uid NOT IN (select goods_uid from T_GIVEAWAY_LIST where guse='Y')

select TB.Name_CH,TB.Name_EN,TB.Name from V_GOODS AS V INNER JOIN T_BRAND AS TB ON V.BrandUid=TB.Uid where V.SiteID=? and V.Uid=?

SELECT CateCode, Depth FROM T_CATEGORY WHERE CateCode=dbo.fnGetGoodsCate(?, ?, ?) and isHidden IN ('F','H')

select top 1 catecode from dbo.fnGetCateParent(?,?)

SELECT RejectCnt FROM T_MIM_MEMBER WHERE SiteID='hanguoshopping' AND DealerID=?

spGoodsLog