Request
=======
GET http://www.alihamsgiftoutlet.com/jewelryfine_jewelrycostume_jewelrybody HTTP/1.1
x-cc-id: ccc04-02
Host: www.alihamsgiftoutlet.com
User-Agent: CCBot/1.0 (+http://www.commoncrawl.org/bot.html)
Accept: text/html, application/xhtml+xml, text/xml;q=0.9, text/plain;q=0.8, image/png, */*;q=0.5
Accept-Language: en-us, en;q=0.5
Accept-Charset: ISO-8859-1, utf-8;q=0.7, *;q=0.7
X-Cnection: close
Cache-Control: no-cache
Pragma: no-cache
Cookie: account-proxy=7; sitecookie=cef6fc282dae46ca74dda3ac7c421f42
X-Forwarded-For: 38.107.179.241
HTTPS: off
X-Version-Shortcut: true
Account: 2096280
Server: sentinel5
Streamed Request. (Length: 0 Read: 0)
Parameters
==========
pathprefix = /
processInitRun = true
cache = 1327983523649
account = 2096280
siteCanHandle = true
pathid = 646121
remainingpath = jewelryfine_jewelrycostume_jewelrybody
Error
=====
select Price_P.ACCOUNT_ID as c1, Price_P.PRODUCT_ID as c2, Price_P.PRICESET_ID as c3, Price_P.PRICE as c4, Price_P.SALEPRICE as c5, Price_P.AVAILABLE as c6, Price_P.ONSALE as c7, Price_P.FEATURED as c8, Price_P.DIRTY as c9, Price_P.USEMAP as c10, Price_P.SUGGESTEDPRICE as c11, Product_P.ACCOUNT_ID as c12, Product_P.PRODUCT_ID as c13, Product_P.KIND as c14, Product_P.NAME as c15, Product_P.SKU as c16, Product_P.SUMMARY as c17, Product_P.IMAGEURL as c18, Product_P.BRAND as c19, Product_P.DIRTY as c20, Product_P.TAG as c21, Product_P.ICONURL as c22, Product_P.ICONTOLERANCE as c23, Product_P.SUPPLIER_ID as c24, Product_P.SHOWADDCART as c25 from Price_P, Product_P, (select distinct ProductCategory_P.PRODUCT_ID as PRODUCT_ID from ProductCategory_P where ProductCategory_P.ACCOUNT_ID = ? AND ProductCategory_P.CATEGORY_ID in (?)) v where Product_P.PRODUCT_ID = v.PRODUCT_ID AND Product_P.ACCOUNT_ID = ? AND Price_P.ACCOUNT_ID = Product_P.ACCOUNT_ID AND Price_P.PRODUCT_ID = Product_P.PRODUCT_ID AND Price_P.PRICESET_ID = ? AND Price_P.AVAILABLE = ? order by lower(Product_P.NAME) nulls last
1: 2096280
2: 646121
3: 2096280
4: 1
5: T
-------------
Database operation canceled. [ORA-01013: user requested cancel of current operation
]
imergent.database.Oracle.processException(Oracle.java:155)
imergent.database.Databases.processException(Databases.java:590)
imergent.database.SQL.query(SQL.java:222)
imergent.database.SQL.select(SQL.java:356)
imergent.product.Products.select(Products.java:837)
imergent.pageelement.AbstractProductList.validate(AbstractProductList.java:307)
imergent.page.Page.validate(Page.java:1738)
imergent.page.Page.validate(Page.java:1745)
imergent.page.Page.validate(Page.java:1703)
imergent.site.SiteHandler.processPage(SiteHandler.java:1231)
imergent.site.SiteHandler.process(SiteHandler.java:642)
imergent.http.HttpResponse.process(HttpResponse.java:483)
imergent.http.Worker.run(Worker.java:280)
Database operation canceled. [ORA-01013: user requested cancel of current operation
]
Error
 |
 The following error occurred:
- Database operation canceled. [ORA-01013: user requested cancel of current operation
]
|