#1 Place for Craft Supplies, Art Supplies, Artist Materials and Kids Crafts


Problem with item sku 22545. Item is found in Solr index but not found in vAvailQtyTbl.

SOLR Query: http://10.100.22.71:8888/solr2/select?q=q%3did%3a1019 1019&wt=json&indent=on&fl=*&rows=1000&fq=group_id:1019&sort=col1_sortorder asc&qt=dismax&hl=on

ItemIDList: 17861
AvailQtyList: 8.000000000000

struct
FLAGS 0
VIP_member_discount 30
barcode 717968108203
barcode_type UPC
col1 black
col1_sortorder 402
col2 2 oz. shaker bottle
col2_sortorder 1219
col3 [empty string]
color_swatch 0-0-0.jpg
cost 0.98
deal_of_the_week NO
description black, 2 oz. shaker bottle
group_id 1019
group_uname advantus-corp-glitter
id 22545
list_price 2
map NO
mfr_num SUL51112
net_weight 0.16
non_member_discount 20
non_member_price 1.6
prop65 NO
ship_rule_desc STD
shipping STD
sku 22545
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.2
ta_dealer_c_price 1.14
ta_price 1.7
text
array
1 22545
2 SUL51112
3 black, 2 oz. shaker bottle
timestamp 2015-03-27T14:46:43.545Z
vip_member_price 1.4

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 8.000000000000 17861
CACHED false
EXECUTIONTIME 2
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '9213' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.159.140.37

URL: www.misterart.com:/index.cfm:module=crafts&catB=glitter&CatC=fp~0-3~&gr=advantus-corp-glitter.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-28 20:45:58'}
sessionid e0304e53fbd385ae8c89514f191d782e5f4f
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=sort~1~fp~0-7~&gr=cousin-round-nose-pliers.html
urltoken CFID=29781927&CFTOKEN=27569925&jsessionid=e0304e53fbd385ae8c89514f191d782e5f4f
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-28 20:45:58'}
sessionid e03050366d545fbb82c05a416e2536311719
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=glitter&CatC=fp~0-3~&gr=advantus-corp-glitter.html
urltoken CFID=29781926&CFTOKEN=38524499&jsessionid=e03050366d545fbb82c05a416e2536311719
validationerror [empty string]


Problem with item sku 32623. Item is found in Solr index but not found in vAvailQtyTbl.

SOLR Query: http://10.100.22.71:8888/solr2/select?q=q%3did%3a1019 1019&wt=json&indent=on&fl=*&rows=1000&fq=group_id:1019&sort=col1_sortorder asc&qt=dismax&hl=on

ItemIDList: 17861
AvailQtyList: 8.000000000000

struct
FLAGS 0
VIP_member_discount 30
barcode 717968510952
barcode_type UPC
col1 black
col1_sortorder 402
col2 0.6 oz. tube
col2_sortorder 135
col3 [empty string]
color_swatch 0-0-0.jpg
cost 0.48
deal_of_the_week NO
description black, 0.6 oz. tube
group_id 1019
group_uname advantus-corp-glitter
id 32623
list_price 0.99
map NO
mfr_num SUL51095
net_weight 0.06
non_member_discount 20
non_member_price 0.79
prop65 NO
ship_rule_desc STD
shipping STD
sku 32623
sku_pix YES
supplier_id 1
ta_dealer_a_price 0.59
ta_dealer_c_price 0.56
ta_price 0.84
text
array
1 32623
2 SUL51095
3 black, 0.6 oz. tube
timestamp 2015-03-27T14:46:58.622Z
vip_member_price 0.69

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 8.000000000000 17861
CACHED false
EXECUTIONTIME 2
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '9213' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.159.140.37

URL: www.misterart.com:/index.cfm:module=crafts&catB=glitter&CatC=fp~0-3~&gr=advantus-corp-glitter.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-28 20:45:58'}
sessionid e0304e53fbd385ae8c89514f191d782e5f4f
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=sort~1~fp~0-7~&gr=cousin-round-nose-pliers.html
urltoken CFID=29781927&CFTOKEN=27569925&jsessionid=e0304e53fbd385ae8c89514f191d782e5f4f
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-28 20:45:58'}
sessionid e03050366d545fbb82c05a416e2536311719
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=glitter&CatC=fp~0-3~&gr=advantus-corp-glitter.html
urltoken CFID=29781926&CFTOKEN=38524499&jsessionid=e03050366d545fbb82c05a416e2536311719
validationerror [empty string]


Problem with item sku 56880. Item is found in Solr index but not found in vAvailQtyTbl.

SOLR Query: http://10.100.22.71:8888/solr2/select?q=q%3did%3a1019 1019&wt=json&indent=on&fl=*&rows=1000&fq=group_id:1019&sort=col1_sortorder asc&qt=dismax&hl=on

ItemIDList: 17861
AvailQtyList: 8.000000000000

struct
FLAGS 0
VIP_member_discount 30
barcode 717968511454
barcode_type UPC
col1 black
col1_sortorder 402
col2 8 oz. shaker bottle
col2_sortorder 2323
col3 [empty string]
color_swatch 0-0-0.jpg
cost 2.93
deal_of_the_week NO
description black, 8 oz. shaker bottle
group_id 1019
group_uname advantus-corp-glitter
id 56880
list_price 6
map NO
mfr_num SUL51145
net_weight 0.6
non_member_discount 20
non_member_price 4.8
prop65 NO
ship_rule_desc STD
shipping STD
sku 56880
sku_pix YES
supplier_id 1
ta_dealer_a_price 3.6
ta_dealer_c_price 3.42
ta_price 5.1
text
array
1 56880
2 SUL51145
3 black, 8 oz. shaker bottle
timestamp 2015-03-27T14:47:31.979Z
vip_member_price 4.2

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 8.000000000000 17861
CACHED false
EXECUTIONTIME 2
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '9213' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.159.140.37

URL: www.misterart.com:/index.cfm:module=crafts&catB=glitter&CatC=fp~0-3~&gr=advantus-corp-glitter.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-28 20:45:58'}
sessionid e0304e53fbd385ae8c89514f191d782e5f4f
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=sort~1~fp~0-7~&gr=cousin-round-nose-pliers.html
urltoken CFID=29781927&CFTOKEN=27569925&jsessionid=e0304e53fbd385ae8c89514f191d782e5f4f
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-28 20:45:58'}
sessionid e03050366d545fbb82c05a416e2536311719
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=glitter&CatC=fp~0-3~&gr=advantus-corp-glitter.html
urltoken CFID=29781926&CFTOKEN=38524499&jsessionid=e03050366d545fbb82c05a416e2536311719
validationerror [empty string]


Problem with item sku 61287. Item is found in Solr index but not found in vAvailQtyTbl.

SOLR Query: http://10.100.22.71:8888/solr2/select?q=q%3did%3a1019 1019&wt=json&indent=on&fl=*&rows=1000&fq=group_id:1019&sort=col1_sortorder asc&qt=dismax&hl=on

ItemIDList: 17861
AvailQtyList: 8.000000000000

struct
FLAGS 0
VIP_member_discount 30
barcode 717968511287
barcode_type UPC
col1 black
col1_sortorder 402
col2 4 oz. shaker bottle
col2_sortorder 1812
col3 [empty string]
color_swatch 0-0-0.jpg
cost 1.46
deal_of_the_week NO
description black, 4 oz. shaker bottle
group_id 1019
group_uname advantus-corp-glitter
id 61287
list_price 2.99
map NO
mfr_num SUL51128
net_weight 0.12
non_member_discount 20
non_member_price 2.39
prop65 NO
ship_rule_desc STD
shipping STD
sku 61287
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.79
ta_dealer_c_price 1.7
ta_price 2.54
text
array
1 61287
2 SUL51128
3 black, 4 oz. shaker bottle
timestamp 2015-03-27T14:47:40.629Z
vip_member_price 2.09

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 8.000000000000 17861
CACHED false
EXECUTIONTIME 2
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '9213' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.159.140.37

URL: www.misterart.com:/index.cfm:module=crafts&catB=glitter&CatC=fp~0-3~&gr=advantus-corp-glitter.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-28 20:45:58'}
sessionid e0304e53fbd385ae8c89514f191d782e5f4f
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=sort~1~fp~0-7~&gr=cousin-round-nose-pliers.html
urltoken CFID=29781927&CFTOKEN=27569925&jsessionid=e0304e53fbd385ae8c89514f191d782e5f4f
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-28 20:45:58'}
sessionid e03050366d545fbb82c05a416e2536311719
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=glitter&CatC=fp~0-3~&gr=advantus-corp-glitter.html
urltoken CFID=29781926&CFTOKEN=38524499&jsessionid=e03050366d545fbb82c05a416e2536311719
validationerror [empty string]


Problem with item sku 45254. Item is found in Solr index but not found in vAvailQtyTbl.

SOLR Query: http://10.100.22.71:8888/solr2/select?q=q%3did%3a1019 1019&wt=json&indent=on&fl=*&rows=1000&fq=group_id:1019&sort=col1_sortorder asc&qt=dismax&hl=on

ItemIDList: 17861
AvailQtyList: 8.000000000000

struct
FLAGS 0
VIP_member_discount 30
barcode 717968107985
barcode_type UPC
col1 crystal
col1_sortorder 1624
col2 8 oz. shaker bottle
col2_sortorder 2323
col3 [empty string]
color_swatch 251-255-213.jpg
cost 2.93
deal_of_the_week NO
description crystal, 8 oz. shaker bottle
group_id 1019
group_uname advantus-corp-glitter
id 45254
list_price 6
map NO
mfr_num SUL51146
net_weight 0.56
non_member_discount 20
non_member_price 4.8
prop65 NO
ship_rule_desc STD
shipping STD
sku 45254
sku_pix YES
supplier_id 1
ta_dealer_a_price 3.6
ta_dealer_c_price 3.42
ta_price 5.1
text
array
1 45254
2 SUL51146
3 crystal, 8 oz. shaker bottle
timestamp 2015-03-27T14:47:18.267Z
vip_member_price 4.2

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 8.000000000000 17861
CACHED false
EXECUTIONTIME 2
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '9213' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.159.140.37

URL: www.misterart.com:/index.cfm:module=crafts&catB=glitter&CatC=fp~0-3~&gr=advantus-corp-glitter.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-28 20:45:58'}
sessionid e0304e53fbd385ae8c89514f191d782e5f4f
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=sort~1~fp~0-7~&gr=cousin-round-nose-pliers.html
urltoken CFID=29781927&CFTOKEN=27569925&jsessionid=e0304e53fbd385ae8c89514f191d782e5f4f
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-28 20:45:58'}
sessionid e03050366d545fbb82c05a416e2536311719
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=glitter&CatC=fp~0-3~&gr=advantus-corp-glitter.html
urltoken CFID=29781926&CFTOKEN=38524499&jsessionid=e03050366d545fbb82c05a416e2536311719
validationerror [empty string]


Problem with item sku 61288. Item is found in Solr index but not found in vAvailQtyTbl.

SOLR Query: http://10.100.22.71:8888/solr2/select?q=q%3did%3a1019 1019&wt=json&indent=on&fl=*&rows=1000&fq=group_id:1019&sort=col1_sortorder asc&qt=dismax&hl=on

ItemIDList: 17861
AvailQtyList: 8.000000000000

struct
FLAGS 0
VIP_member_discount 30
barcode 717968511133
barcode_type UPC
col1 crystal
col1_sortorder 1624
col2 2 oz. shaker bottle
col2_sortorder 1219
col3 [empty string]
color_swatch 251-255-213.jpg
cost 0.98
deal_of_the_week NO
description crystal, 2 oz. shaker bottle
group_id 1019
group_uname advantus-corp-glitter
id 61288
list_price 2
map NO
mfr_num SUL51113
net_weight 0.12
non_member_discount 20
non_member_price 1.6
prop65 NO
ship_rule_desc STD
shipping STD
sku 61288
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.2
ta_dealer_c_price 1.14
ta_price 1.7
text
array
1 61288
2 SUL51113
3 crystal, 2 oz. shaker bottle
timestamp 2015-03-27T14:47:40.632Z
vip_member_price 1.4

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 8.000000000000 17861
CACHED false
EXECUTIONTIME 2
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '9213' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.159.140.37

URL: www.misterart.com:/index.cfm:module=crafts&catB=glitter&CatC=fp~0-3~&gr=advantus-corp-glitter.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-28 20:45:58'}
sessionid e0304e53fbd385ae8c89514f191d782e5f4f
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=sort~1~fp~0-7~&gr=cousin-round-nose-pliers.html
urltoken CFID=29781927&CFTOKEN=27569925&jsessionid=e0304e53fbd385ae8c89514f191d782e5f4f
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-28 20:45:58'}
sessionid e03050366d545fbb82c05a416e2536311719
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=glitter&CatC=fp~0-3~&gr=advantus-corp-glitter.html
urltoken CFID=29781926&CFTOKEN=38524499&jsessionid=e03050366d545fbb82c05a416e2536311719
validationerror [empty string]


Problem with item sku 61289. Item is found in Solr index but not found in vAvailQtyTbl.

SOLR Query: http://10.100.22.71:8888/solr2/select?q=q%3did%3a1019 1019&wt=json&indent=on&fl=*&rows=1000&fq=group_id:1019&sort=col1_sortorder asc&qt=dismax&hl=on

ItemIDList: 17861
AvailQtyList: 8.000000000000

struct
FLAGS 0
VIP_member_discount 30
barcode 717968511294
barcode_type UPC
col1 crystal
col1_sortorder 1624
col2 4 oz. shaker bottle
col2_sortorder 1812
col3 [empty string]
color_swatch 251-255-213.jpg
cost 1.46
deal_of_the_week NO
description crystal, 4 oz. shaker bottle
group_id 1019
group_uname advantus-corp-glitter
id 61289
list_price 2.99
map NO
mfr_num SUL51129
net_weight 0.12
non_member_discount 20
non_member_price 2.39
prop65 NO
ship_rule_desc STD
shipping STD
sku 61289
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.79
ta_dealer_c_price 1.7
ta_price 2.54
text
array
1 61289
2 SUL51129
3 crystal, 4 oz. shaker bottle
timestamp 2015-03-27T14:47:40.635Z
vip_member_price 2.09

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 8.000000000000 17861
CACHED false
EXECUTIONTIME 2
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '9213' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.159.140.37

URL: www.misterart.com:/index.cfm:module=crafts&catB=glitter&CatC=fp~0-3~&gr=advantus-corp-glitter.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-28 20:45:58'}
sessionid e0304e53fbd385ae8c89514f191d782e5f4f
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=sort~1~fp~0-7~&gr=cousin-round-nose-pliers.html
urltoken CFID=29781927&CFTOKEN=27569925&jsessionid=e0304e53fbd385ae8c89514f191d782e5f4f
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-28 20:45:58'}
sessionid e03050366d545fbb82c05a416e2536311719
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=glitter&CatC=fp~0-3~&gr=advantus-corp-glitter.html
urltoken CFID=29781926&CFTOKEN=38524499&jsessionid=e03050366d545fbb82c05a416e2536311719
validationerror [empty string]


Problem with item sku 83178. Item is found in Solr index but not found in vAvailQtyTbl.

SOLR Query: http://10.100.22.71:8888/solr2/select?q=q%3did%3a1019 1019&wt=json&indent=on&fl=*&rows=1000&fq=group_id:1019&sort=col1_sortorder asc&qt=dismax&hl=on

ItemIDList: 17861
AvailQtyList: 8.000000000000

struct
FLAGS 0
VIP_member_discount 30
barcode 717968107411
barcode_type UPC
col1 crystal
col1_sortorder 1624
col2 0.6 oz. tube
col2_sortorder 135
col3 [empty string]
color_swatch 251-255-213.jpg
cost 0.48
deal_of_the_week NO
description crystal, 0.6 oz. tube
group_id 1019
group_uname advantus-corp-glitter
id 83178
list_price 0.99
map NO
mfr_num SUL51096
net_weight 0.06
non_member_discount 20
non_member_price 0.79
prop65 NO
ship_rule_desc STD
shipping STD
sku 83178
sku_pix YES
supplier_id 1
ta_dealer_a_price 0.59
ta_dealer_c_price 0.56
ta_price 0.84
text
array
1 83178
2 SUL51096
3 crystal, 0.6 oz. tube
timestamp 2015-03-27T14:48:13.594Z
vip_member_price 0.69

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 8.000000000000 17861
CACHED false
EXECUTIONTIME 2
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '9213' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.159.140.37

URL: www.misterart.com:/index.cfm:module=crafts&catB=glitter&CatC=fp~0-3~&gr=advantus-corp-glitter.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-28 20:45:58'}
sessionid e0304e53fbd385ae8c89514f191d782e5f4f
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=sort~1~fp~0-7~&gr=cousin-round-nose-pliers.html
urltoken CFID=29781927&CFTOKEN=27569925&jsessionid=e0304e53fbd385ae8c89514f191d782e5f4f
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-28 20:45:58'}
sessionid e03050366d545fbb82c05a416e2536311719
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=glitter&CatC=fp~0-3~&gr=advantus-corp-glitter.html
urltoken CFID=29781926&CFTOKEN=38524499&jsessionid=e03050366d545fbb82c05a416e2536311719
validationerror [empty string]


Problem with item sku 01523. Item is found in Solr index but not found in vAvailQtyTbl.

SOLR Query: http://10.100.22.71:8888/solr2/select?q=q%3did%3a1019 1019&wt=json&indent=on&fl=*&rows=1000&fq=group_id:1019&sort=col1_sortorder asc&qt=dismax&hl=on

ItemIDList: 17861
AvailQtyList: 8.000000000000

struct
FLAGS 0
VIP_member_discount 30
barcode 717968508799
barcode_type UPC
col1 glow in the dark
col1_sortorder 2478
col2 2 oz. shaker bottle
col2_sortorder 1219
col3 [empty string]
cost 2.44
deal_of_the_week NO
description glow in the dark, 2 oz. shaker bottle
group_id 1019
group_uname advantus-corp-glitter
id 01523
list_price 4.99
map NO
mfr_num SUL50879
net_weight 0.16
non_member_discount 20
non_member_price 3.99
prop65 NO
ship_rule_desc STD
shipping STD
sku 01523
sku_pix YES
supplier_id 1
ta_dealer_a_price 2.99
ta_dealer_c_price 2.84
ta_price 4.24
text
array
1 01523
2 SUL50879
3 glow in the dark, 2 oz. shaker bottle
timestamp 2015-03-27T14:46:01.713Z
vip_member_price 3.49

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 8.000000000000 17861
CACHED false
EXECUTIONTIME 2
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '9213' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.159.140.37

URL: www.misterart.com:/index.cfm:module=crafts&catB=glitter&CatC=fp~0-3~&gr=advantus-corp-glitter.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-28 20:45:58'}
sessionid e0304e53fbd385ae8c89514f191d782e5f4f
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=sort~1~fp~0-7~&gr=cousin-round-nose-pliers.html
urltoken CFID=29781927&CFTOKEN=27569925&jsessionid=e0304e53fbd385ae8c89514f191d782e5f4f
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-28 20:45:58'}
sessionid e03050366d545fbb82c05a416e2536311719
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=glitter&CatC=fp~0-3~&gr=advantus-corp-glitter.html
urltoken CFID=29781926&CFTOKEN=38524499&jsessionid=e03050366d545fbb82c05a416e2536311719
validationerror [empty string]


Problem with item sku 19007. Item is found in Solr index but not found in vAvailQtyTbl.

SOLR Query: http://10.100.22.71:8888/solr2/select?q=q%3did%3a1019 1019&wt=json&indent=on&fl=*&rows=1000&fq=group_id:1019&sort=col1_sortorder asc&qt=dismax&hl=on

ItemIDList: 17861
AvailQtyList: 8.000000000000

struct
FLAGS 0
VIP_member_discount 30
barcode 717968108111
barcode_type UPC
col1 gold
col1_sortorder 2486
col2 2 oz. shaker bottle
col2_sortorder 1219
col3 [empty string]
color_swatch 210-191-77.jpg
cost 0.98
deal_of_the_week NO
description gold, 2 oz. shaker bottle
group_id 1019
group_uname advantus-corp-glitter
id 19007
list_price 2
map NO
mfr_num SUL51106
net_weight 0.14
non_member_discount 20
non_member_price 1.6
prop65 NO
ship_rule_desc STD
shipping STD
sku 19007
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.2
ta_dealer_c_price 1.14
ta_price 1.7
text
array
1 19007
2 SUL51106
3 gold, 2 oz. shaker bottle
timestamp 2015-03-27T14:46:39.246Z
vip_member_price 1.4

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 8.000000000000 17861
CACHED false
EXECUTIONTIME 2
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '9213' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.159.140.37

URL: www.misterart.com:/index.cfm:module=crafts&catB=glitter&CatC=fp~0-3~&gr=advantus-corp-glitter.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-28 20:45:58'}
sessionid e0304e53fbd385ae8c89514f191d782e5f4f
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=sort~1~fp~0-7~&gr=cousin-round-nose-pliers.html
urltoken CFID=29781927&CFTOKEN=27569925&jsessionid=e0304e53fbd385ae8c89514f191d782e5f4f
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-28 20:45:58'}
sessionid e03050366d545fbb82c05a416e2536311719
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=glitter&CatC=fp~0-3~&gr=advantus-corp-glitter.html
urltoken CFID=29781926&CFTOKEN=38524499&jsessionid=e03050366d545fbb82c05a416e2536311719
validationerror [empty string]


Problem with item sku 24818. Item is found in Solr index but not found in vAvailQtyTbl.

SOLR Query: http://10.100.22.71:8888/solr2/select?q=q%3did%3a1019 1019&wt=json&indent=on&fl=*&rows=1000&fq=group_id:1019&sort=col1_sortorder asc&qt=dismax&hl=on

ItemIDList: 17861
AvailQtyList: 8.000000000000

struct
FLAGS 0
VIP_member_discount 30
barcode 717968107312
barcode_type UPC
col1 gold
col1_sortorder 2486
col2 0.6 oz. tube
col2_sortorder 135
col3 [empty string]
color_swatch 210-191-77.jpg
cost 0.48
deal_of_the_week NO
description gold, 0.6 oz. tube
group_id 1019
group_uname advantus-corp-glitter
id 24818
list_price 0.99
map NO
mfr_num SUL51089
net_weight 0.06
non_member_discount 20
non_member_price 0.79
prop65 NO
ship_rule_desc STD
shipping STD
sku 24818
sku_pix YES
supplier_id 1
ta_dealer_a_price 0.59
ta_dealer_c_price 0.56
ta_price 0.84
text
array
1 24818
2 SUL51089
3 gold, 0.6 oz. tube
timestamp 2015-03-27T14:46:46.4Z
vip_member_price 0.69

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 8.000000000000 17861
CACHED false
EXECUTIONTIME 2
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '9213' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.159.140.37

URL: www.misterart.com:/index.cfm:module=crafts&catB=glitter&CatC=fp~0-3~&gr=advantus-corp-glitter.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-28 20:45:58'}
sessionid e0304e53fbd385ae8c89514f191d782e5f4f
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=sort~1~fp~0-7~&gr=cousin-round-nose-pliers.html
urltoken CFID=29781927&CFTOKEN=27569925&jsessionid=e0304e53fbd385ae8c89514f191d782e5f4f
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-28 20:45:58'}
sessionid e03050366d545fbb82c05a416e2536311719
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=glitter&CatC=fp~0-3~&gr=advantus-corp-glitter.html
urltoken CFID=29781926&CFTOKEN=38524499&jsessionid=e03050366d545fbb82c05a416e2536311719
validationerror [empty string]


Problem with item sku 26018. Item is found in Solr index but not found in vAvailQtyTbl.

SOLR Query: http://10.100.22.71:8888/solr2/select?q=q%3did%3a1019 1019&wt=json&indent=on&fl=*&rows=1000&fq=group_id:1019&sort=col1_sortorder asc&qt=dismax&hl=on

ItemIDList: 17861
AvailQtyList: 8.000000000000

struct
FLAGS 0
VIP_member_discount 30
barcode 717968106544
barcode_type UPC
col1 gold
col1_sortorder 2486
col2 4 oz. shaker bottle
col2_sortorder 1812
col3 [empty string]
color_swatch 210-191-77.jpg
cost 1.46
deal_of_the_week NO
description gold, 4 oz. shaker bottle
group_id 1019
group_uname advantus-corp-glitter
id 26018
list_price 2.99
map NO
mfr_num SUL51122
net_weight 0.39
non_member_discount 20
non_member_price 2.39
prop65 NO
ship_rule_desc STD
shipping STD
sku 26018
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.79
ta_dealer_c_price 1.7
ta_price 2.54
text
array
1 26018
2 SUL51122
3 gold, 4 oz. shaker bottle
timestamp 2015-03-27T14:46:47.931Z
vip_member_price 2.09

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 8.000000000000 17861
CACHED false
EXECUTIONTIME 2
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '9213' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.159.140.37

URL: www.misterart.com:/index.cfm:module=crafts&catB=glitter&CatC=fp~0-3~&gr=advantus-corp-glitter.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-28 20:45:58'}
sessionid e0304e53fbd385ae8c89514f191d782e5f4f
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=sort~1~fp~0-7~&gr=cousin-round-nose-pliers.html
urltoken CFID=29781927&CFTOKEN=27569925&jsessionid=e0304e53fbd385ae8c89514f191d782e5f4f
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-28 20:45:58'}
sessionid e03050366d545fbb82c05a416e2536311719
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=glitter&CatC=fp~0-3~&gr=advantus-corp-glitter.html
urltoken CFID=29781926&CFTOKEN=38524499&jsessionid=e03050366d545fbb82c05a416e2536311719
validationerror [empty string]


Problem with item sku 56742. Item is found in Solr index but not found in vAvailQtyTbl.

SOLR Query: http://10.100.22.71:8888/solr2/select?q=q%3did%3a1019 1019&wt=json&indent=on&fl=*&rows=1000&fq=group_id:1019&sort=col1_sortorder asc&qt=dismax&hl=on

ItemIDList: 17861
AvailQtyList: 8.000000000000

struct
FLAGS 0
VIP_member_discount 30
barcode 717968511393
barcode_type UPC
col1 gold
col1_sortorder 2486
col2 8 oz. shaker bottle
col2_sortorder 2323
col3 [empty string]
color_swatch 210-191-77.jpg
cost 2.93
deal_of_the_week NO
description gold, 8 oz. shaker bottle
group_id 1019
group_uname advantus-corp-glitter
id 56742
list_price 6
map NO
mfr_num SUL51139
net_weight 0.6
non_member_discount 20
non_member_price 4.8
prop65 NO
ship_rule_desc STD
shipping STD
sku 56742
sku_pix YES
supplier_id 1
ta_dealer_a_price 3.6
ta_dealer_c_price 3.42
ta_price 5.1
text
array
1 56742
2 SUL51139
3 gold, 8 oz. shaker bottle
timestamp 2015-03-27T14:47:31.845Z
vip_member_price 4.2

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 8.000000000000 17861
CACHED false
EXECUTIONTIME 2
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '9213' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.159.140.37

URL: www.misterart.com:/index.cfm:module=crafts&catB=glitter&CatC=fp~0-3~&gr=advantus-corp-glitter.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-28 20:45:58'}
sessionid e0304e53fbd385ae8c89514f191d782e5f4f
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=sort~1~fp~0-7~&gr=cousin-round-nose-pliers.html
urltoken CFID=29781927&CFTOKEN=27569925&jsessionid=e0304e53fbd385ae8c89514f191d782e5f4f
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-28 20:45:58'}
sessionid e03050366d545fbb82c05a416e2536311719
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=glitter&CatC=fp~0-3~&gr=advantus-corp-glitter.html
urltoken CFID=29781926&CFTOKEN=38524499&jsessionid=e03050366d545fbb82c05a416e2536311719
validationerror [empty string]


Problem with item sku 13586. Item is found in Solr index but not found in vAvailQtyTbl.

SOLR Query: http://10.100.22.71:8888/solr2/select?q=q%3did%3a1019 1019&wt=json&indent=on&fl=*&rows=1000&fq=group_id:1019&sort=col1_sortorder asc&qt=dismax&hl=on

ItemIDList: 17861
AvailQtyList: 8.000000000000

struct
FLAGS 0
VIP_member_discount 30
barcode 717968107947
barcode_type UPC
col1 Kelly
col1_sortorder 3186
col2 8 oz. shaker bottle
col2_sortorder 2323
col3 [empty string]
color_swatch 46-104-46.jpg
cost 2.93
deal_of_the_week NO
description Kelly, 8 oz. shaker bottle
group_id 1019
group_uname advantus-corp-glitter
id 13586
list_price 6
map NO
mfr_num SUL51142
net_weight 0.6
non_member_discount 20
non_member_price 4.8
prop65 NO
ship_rule_desc STD
shipping STD
sku 13586
sku_pix YES
supplier_id 1
ta_dealer_a_price 3.6
ta_dealer_c_price 3.42
ta_price 5.1
text
array
1 13586
2 SUL51142
3 Kelly, 8 oz. shaker bottle
timestamp 2015-03-27T14:46:29.074Z
vip_member_price 4.2

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 8.000000000000 17861
CACHED false
EXECUTIONTIME 2
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '9213' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.159.140.37

URL: www.misterart.com:/index.cfm:module=crafts&catB=glitter&CatC=fp~0-3~&gr=advantus-corp-glitter.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-28 20:45:58'}
sessionid e0304e53fbd385ae8c89514f191d782e5f4f
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=sort~1~fp~0-7~&gr=cousin-round-nose-pliers.html
urltoken CFID=29781927&CFTOKEN=27569925&jsessionid=e0304e53fbd385ae8c89514f191d782e5f4f
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-28 20:45:58'}
sessionid e03050366d545fbb82c05a416e2536311719
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=glitter&CatC=fp~0-3~&gr=advantus-corp-glitter.html
urltoken CFID=29781926&CFTOKEN=38524499&jsessionid=e03050366d545fbb82c05a416e2536311719
validationerror [empty string]


Problem with item sku 45445. Item is found in Solr index but not found in vAvailQtyTbl.

SOLR Query: http://10.100.22.71:8888/solr2/select?q=q%3did%3a1019 1019&wt=json&indent=on&fl=*&rows=1000&fq=group_id:1019&sort=col1_sortorder asc&qt=dismax&hl=on

ItemIDList: 17861
AvailQtyList: 8.000000000000

struct
FLAGS 0
VIP_member_discount 30
barcode 717968108142
barcode_type UPC
col1 Kelly
col1_sortorder 3186
col2 2 oz. shaker bottle
col2_sortorder 1219
col3 [empty string]
color_swatch 46-104-46.jpg
cost 0.98
deal_of_the_week NO
description Kelly, 2 oz. shaker bottle
group_id 1019
group_uname advantus-corp-glitter
id 45445
list_price 2
map NO
mfr_num SUL51109
net_weight 0.14
non_member_discount 20
non_member_price 1.6
prop65 NO
ship_rule_desc STD
shipping STD
sku 45445
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.2
ta_dealer_c_price 1.14
ta_price 1.7
text
array
1 45445
2 SUL51109
3 Kelly, 2 oz. shaker bottle
timestamp 2015-03-27T14:47:18.493Z
vip_member_price 1.4

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 8.000000000000 17861
CACHED false
EXECUTIONTIME 2
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '9213' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.159.140.37

URL: www.misterart.com:/index.cfm:module=crafts&catB=glitter&CatC=fp~0-3~&gr=advantus-corp-glitter.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-28 20:45:58'}
sessionid e0304e53fbd385ae8c89514f191d782e5f4f
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=sort~1~fp~0-7~&gr=cousin-round-nose-pliers.html
urltoken CFID=29781927&CFTOKEN=27569925&jsessionid=e0304e53fbd385ae8c89514f191d782e5f4f
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-28 20:45:58'}
sessionid e03050366d545fbb82c05a416e2536311719
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=glitter&CatC=fp~0-3~&gr=advantus-corp-glitter.html
urltoken CFID=29781926&CFTOKEN=38524499&jsessionid=e03050366d545fbb82c05a416e2536311719
validationerror [empty string]


Problem with item sku 77222. Item is found in Solr index but not found in vAvailQtyTbl.

SOLR Query: http://10.100.22.71:8888/solr2/select?q=q%3did%3a1019 1019&wt=json&indent=on&fl=*&rows=1000&fq=group_id:1019&sort=col1_sortorder asc&qt=dismax&hl=on

ItemIDList: 17861
AvailQtyList: 8.000000000000

struct
FLAGS 0
VIP_member_discount 30
barcode 717968106575
barcode_type UPC
col1 Kelly
col1_sortorder 3186
col2 4 oz. shaker bottle
col2_sortorder 1812
col3 [empty string]
color_swatch 46-104-46.jpg
cost 1.46
deal_of_the_week NO
description Kelly, 4 oz. shaker bottle
group_id 1019
group_uname advantus-corp-glitter
id 77222
list_price 2.99
map NO
mfr_num SUL51125
net_weight 0.43
non_member_discount 20
non_member_price 2.39
prop65 NO
ship_rule_desc STD
shipping STD
sku 77222
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.79
ta_dealer_c_price 1.7
ta_price 2.54
text
array
1 77222
2 SUL51125
3 Kelly, 4 oz. shaker bottle
timestamp 2015-03-27T14:48:07.05Z
vip_member_price 2.09

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 8.000000000000 17861
CACHED false
EXECUTIONTIME 2
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '9213' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.159.140.37

URL: www.misterart.com:/index.cfm:module=crafts&catB=glitter&CatC=fp~0-3~&gr=advantus-corp-glitter.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-28 20:45:58'}
sessionid e0304e53fbd385ae8c89514f191d782e5f4f
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=sort~1~fp~0-7~&gr=cousin-round-nose-pliers.html
urltoken CFID=29781927&CFTOKEN=27569925&jsessionid=e0304e53fbd385ae8c89514f191d782e5f4f
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-28 20:45:58'}
sessionid e03050366d545fbb82c05a416e2536311719
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=glitter&CatC=fp~0-3~&gr=advantus-corp-glitter.html
urltoken CFID=29781926&CFTOKEN=38524499&jsessionid=e03050366d545fbb82c05a416e2536311719
validationerror [empty string]


Problem with item sku 81027. Item is found in Solr index but not found in vAvailQtyTbl.

SOLR Query: http://10.100.22.71:8888/solr2/select?q=q%3did%3a1019 1019&wt=json&indent=on&fl=*&rows=1000&fq=group_id:1019&sort=col1_sortorder asc&qt=dismax&hl=on

ItemIDList: 17861
AvailQtyList: 8.000000000000

struct
FLAGS 0
VIP_member_discount 30
barcode 717968107343
barcode_type UPC
col1 Kelly
col1_sortorder 3186
col2 0.6 oz. tube
col2_sortorder 135
col3 [empty string]
color_swatch 46-104-46.jpg
cost 0.48
deal_of_the_week NO
description Kelly, 0.6 oz. tube
group_id 1019
group_uname advantus-corp-glitter
id 81027
list_price 0.99
map NO
mfr_num SUL51092
net_weight 0.06
non_member_discount 20
non_member_price 0.79
prop65 NO
ship_rule_desc STD
shipping STD
sku 81027
sku_pix YES
supplier_id 1
ta_dealer_a_price 0.59
ta_dealer_c_price 0.56
ta_price 0.84
text
array
1 81027
2 SUL51092
3 Kelly, 0.6 oz. tube
timestamp 2015-03-27T14:48:11.693Z
vip_member_price 0.69

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 8.000000000000 17861
CACHED false
EXECUTIONTIME 2
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '9213' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.159.140.37

URL: www.misterart.com:/index.cfm:module=crafts&catB=glitter&CatC=fp~0-3~&gr=advantus-corp-glitter.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-28 20:45:58'}
sessionid e0304e53fbd385ae8c89514f191d782e5f4f
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=sort~1~fp~0-7~&gr=cousin-round-nose-pliers.html
urltoken CFID=29781927&CFTOKEN=27569925&jsessionid=e0304e53fbd385ae8c89514f191d782e5f4f
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-28 20:45:58'}
sessionid e03050366d545fbb82c05a416e2536311719
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=glitter&CatC=fp~0-3~&gr=advantus-corp-glitter.html
urltoken CFID=29781926&CFTOKEN=38524499&jsessionid=e03050366d545fbb82c05a416e2536311719
validationerror [empty string]


Problem with item sku 45253. Item is found in Solr index but not found in vAvailQtyTbl.

SOLR Query: http://10.100.22.71:8888/solr2/select?q=q%3did%3a1019 1019&wt=json&indent=on&fl=*&rows=1000&fq=group_id:1019&sort=col1_sortorder asc&qt=dismax&hl=on

ItemIDList: 17861
AvailQtyList: 8.000000000000

struct
FLAGS 0
VIP_member_discount 30
barcode 717968107435
barcode_type UPC
col1 lavender
col1_sortorder 3248
col2 0.6 oz. tube
col2_sortorder 135
col3 [empty string]
color_swatch 143-122-210.jpg
cost 0.48
deal_of_the_week NO
description lavender, 0.6 oz. tube
group_id 1019
group_uname advantus-corp-glitter
id 45253
list_price 0.99
map NO
mfr_num SUL51101
net_weight 0.07
non_member_discount 20
non_member_price 0.79
prop65 NO
ship_rule_desc STD
shipping STD
sku 45253
sku_pix YES
supplier_id 1
ta_dealer_a_price 0.59
ta_dealer_c_price 0.56
ta_price 0.84
text
array
1 45253
2 SUL51101
3 lavender, 0.6 oz. tube
timestamp 2015-03-27T14:47:18.265Z
vip_member_price 0.69

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 8.000000000000 17861
CACHED false
EXECUTIONTIME 2
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '9213' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.159.140.37

URL: www.misterart.com:/index.cfm:module=crafts&catB=glitter&CatC=fp~0-3~&gr=advantus-corp-glitter.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-28 20:45:58'}
sessionid e0304e53fbd385ae8c89514f191d782e5f4f
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=sort~1~fp~0-7~&gr=cousin-round-nose-pliers.html
urltoken CFID=29781927&CFTOKEN=27569925&jsessionid=e0304e53fbd385ae8c89514f191d782e5f4f
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-28 20:45:58'}
sessionid e03050366d545fbb82c05a416e2536311719
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=glitter&CatC=fp~0-3~&gr=advantus-corp-glitter.html
urltoken CFID=29781926&CFTOKEN=38524499&jsessionid=e03050366d545fbb82c05a416e2536311719
validationerror [empty string]


Problem with item sku 61291. Item is found in Solr index but not found in vAvailQtyTbl.

SOLR Query: http://10.100.22.71:8888/solr2/select?q=q%3did%3a1019 1019&wt=json&indent=on&fl=*&rows=1000&fq=group_id:1019&sort=col1_sortorder asc&qt=dismax&hl=on

ItemIDList: 17861
AvailQtyList: 8.000000000000

struct
FLAGS 0
VIP_member_discount 30
barcode 717968511348
barcode_type UPC
col1 lavender
col1_sortorder 3248
col2 4 oz. shaker bottle
col2_sortorder 1812
col3 [empty string]
color_swatch 143-122-210.jpg
cost 1.46
deal_of_the_week NO
description lavender, 4 oz. shaker bottle
group_id 1019
group_uname advantus-corp-glitter
id 61291
list_price 4.29
map NO
mfr_num SUL51134
net_weight 0.12
non_member_discount 20
non_member_price 3.43
prop65 NO
ship_rule_desc STD
shipping STD
sku 61291
sku_pix NO
supplier_id 1
ta_dealer_a_price 1.93
ta_dealer_c_price 1.72
ta_price 3.22
text
array
1 61291
2 SUL51134
3 lavender, 4 oz. shaker bottle
timestamp 2015-03-27T14:47:40.642Z
vip_member_price 3

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 8.000000000000 17861
CACHED false
EXECUTIONTIME 2
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '9213' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.159.140.37

URL: www.misterart.com:/index.cfm:module=crafts&catB=glitter&CatC=fp~0-3~&gr=advantus-corp-glitter.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-28 20:45:58'}
sessionid e0304e53fbd385ae8c89514f191d782e5f4f
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=sort~1~fp~0-7~&gr=cousin-round-nose-pliers.html
urltoken CFID=29781927&CFTOKEN=27569925&jsessionid=e0304e53fbd385ae8c89514f191d782e5f4f
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-28 20:45:58'}
sessionid e03050366d545fbb82c05a416e2536311719
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=glitter&CatC=fp~0-3~&gr=advantus-corp-glitter.html
urltoken CFID=29781926&CFTOKEN=38524499&jsessionid=e03050366d545fbb82c05a416e2536311719
validationerror [empty string]


Problem with item sku 27714. Item is found in Solr index but not found in vAvailQtyTbl.

SOLR Query: http://10.100.22.71:8888/solr2/select?q=q%3did%3a1019 1019&wt=json&indent=on&fl=*&rows=1000&fq=group_id:1019&sort=col1_sortorder asc&qt=dismax&hl=on

ItemIDList: 17861
AvailQtyList: 8.000000000000

struct
FLAGS 0
VIP_member_discount 30
barcode 717968107992
barcode_type UPC
col1 light blue
col1_sortorder 3310
col2 8 oz. shaker bottle
col2_sortorder 2323
col3 [empty string]
color_swatch 168-200-255.jpg
cost 2.93
deal_of_the_week NO
description light blue, 8 oz. shaker bottle
group_id 1019
group_uname advantus-corp-glitter
id 27714
list_price 6
map NO
mfr_num SUL51147
net_weight 0.6
non_member_discount 20
non_member_price 4.8
prop65 NO
ship_rule_desc STD
shipping STD
sku 27714
sku_pix YES
supplier_id 1
ta_dealer_a_price 3.6
ta_dealer_c_price 3.42
ta_price 5.1
text
array
1 27714
2 SUL51147
3 light blue, 8 oz. shaker bottle
timestamp 2015-03-27T14:46:50.916Z
vip_member_price 4.2

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 8.000000000000 17861
CACHED false
EXECUTIONTIME 2
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '9213' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.159.140.37

URL: www.misterart.com:/index.cfm:module=crafts&catB=glitter&CatC=fp~0-3~&gr=advantus-corp-glitter.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-28 20:45:58'}
sessionid e0304e53fbd385ae8c89514f191d782e5f4f
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=sort~1~fp~0-7~&gr=cousin-round-nose-pliers.html
urltoken CFID=29781927&CFTOKEN=27569925&jsessionid=e0304e53fbd385ae8c89514f191d782e5f4f
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-28 20:45:58'}
sessionid e03050366d545fbb82c05a416e2536311719
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=glitter&CatC=fp~0-3~&gr=advantus-corp-glitter.html
urltoken CFID=29781926&CFTOKEN=38524499&jsessionid=e03050366d545fbb82c05a416e2536311719
validationerror [empty string]


Problem with item sku 61292. Item is found in Solr index but not found in vAvailQtyTbl.

SOLR Query: http://10.100.22.71:8888/solr2/select?q=q%3did%3a1019 1019&wt=json&indent=on&fl=*&rows=1000&fq=group_id:1019&sort=col1_sortorder asc&qt=dismax&hl=on

ItemIDList: 17861
AvailQtyList: 8.000000000000

struct
FLAGS 0
VIP_member_discount 30
barcode 717968511140
barcode_type UPC
col1 light blue
col1_sortorder 3310
col2 2 oz. shaker bottle
col2_sortorder 1219
col3 [empty string]
color_swatch 168-200-255.jpg
cost 0.98
deal_of_the_week NO
description light blue, 2 oz. shaker bottle
group_id 1019
group_uname advantus-corp-glitter
id 61292
list_price 2
map NO
mfr_num SUL51114
net_weight 0.12
non_member_discount 20
non_member_price 1.6
prop65 NO
ship_rule_desc STD
shipping STD
sku 61292
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.2
ta_dealer_c_price 1.14
ta_price 1.7
text
array
1 61292
2 SUL51114
3 light blue, 2 oz. shaker bottle
timestamp 2015-03-27T14:47:40.648Z
vip_member_price 1.4

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 8.000000000000 17861
CACHED false
EXECUTIONTIME 2
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '9213' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.159.140.37

URL: www.misterart.com:/index.cfm:module=crafts&catB=glitter&CatC=fp~0-3~&gr=advantus-corp-glitter.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-28 20:45:58'}
sessionid e0304e53fbd385ae8c89514f191d782e5f4f
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=sort~1~fp~0-7~&gr=cousin-round-nose-pliers.html
urltoken CFID=29781927&CFTOKEN=27569925&jsessionid=e0304e53fbd385ae8c89514f191d782e5f4f
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-28 20:45:58'}
sessionid e03050366d545fbb82c05a416e2536311719
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=glitter&CatC=fp~0-3~&gr=advantus-corp-glitter.html
urltoken CFID=29781926&CFTOKEN=38524499&jsessionid=e03050366d545fbb82c05a416e2536311719
validationerror [empty string]


Problem with item sku 61294. Item is found in Solr index but not found in vAvailQtyTbl.

SOLR Query: http://10.100.22.71:8888/solr2/select?q=q%3did%3a1019 1019&wt=json&indent=on&fl=*&rows=1000&fq=group_id:1019&sort=col1_sortorder asc&qt=dismax&hl=on

ItemIDList: 17861
AvailQtyList: 8.000000000000

struct
FLAGS 0
VIP_member_discount 30
barcode 717968511300
barcode_type UPC
col1 light blue
col1_sortorder 3310
col2 4 oz. shaker bottle
col2_sortorder 1812
col3 [empty string]
color_swatch 168-200-255.jpg
cost 1.46
deal_of_the_week NO
description light blue, 4 oz. shaker bottle
group_id 1019
group_uname advantus-corp-glitter
id 61294
list_price 2.99
map NO
mfr_num SUL51130
net_weight 0.12
non_member_discount 20
non_member_price 2.39
prop65 NO
ship_rule_desc STD
shipping STD
sku 61294
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.79
ta_dealer_c_price 1.7
ta_price 2.54
text
array
1 61294
2 SUL51130
3 light blue, 4 oz. shaker bottle
timestamp 2015-03-27T14:47:40.652Z
vip_member_price 2.09

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 8.000000000000 17861
CACHED false
EXECUTIONTIME 2
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '9213' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.159.140.37

URL: www.misterart.com:/index.cfm:module=crafts&catB=glitter&CatC=fp~0-3~&gr=advantus-corp-glitter.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-28 20:45:58'}
sessionid e0304e53fbd385ae8c89514f191d782e5f4f
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=sort~1~fp~0-7~&gr=cousin-round-nose-pliers.html
urltoken CFID=29781927&CFTOKEN=27569925&jsessionid=e0304e53fbd385ae8c89514f191d782e5f4f
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-28 20:45:58'}
sessionid e03050366d545fbb82c05a416e2536311719
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=glitter&CatC=fp~0-3~&gr=advantus-corp-glitter.html
urltoken CFID=29781926&CFTOKEN=38524499&jsessionid=e03050366d545fbb82c05a416e2536311719
validationerror [empty string]


Problem with item sku 82253. Item is found in Solr index but not found in vAvailQtyTbl.

SOLR Query: http://10.100.22.71:8888/solr2/select?q=q%3did%3a1019 1019&wt=json&indent=on&fl=*&rows=1000&fq=group_id:1019&sort=col1_sortorder asc&qt=dismax&hl=on

ItemIDList: 17861
AvailQtyList: 8.000000000000

struct
FLAGS 0
VIP_member_discount 30
barcode 717968107428
barcode_type UPC
col1 light blue
col1_sortorder 3310
col2 0.6 oz. tube
col2_sortorder 135
col3 [empty string]
color_swatch 168-200-255.jpg
cost 0.48
deal_of_the_week NO
description light blue, 0.6 oz. tube
group_id 1019
group_uname advantus-corp-glitter
id 82253
list_price 0.99
map NO
mfr_num SUL51097
net_weight 0.06
non_member_discount 20
non_member_price 0.79
prop65 NO
ship_rule_desc STD
shipping STD
sku 82253
sku_pix YES
supplier_id 1
ta_dealer_a_price 0.59
ta_dealer_c_price 0.56
ta_price 0.84
text
array
1 82253
2 SUL51097
3 light blue, 0.6 oz. tube
timestamp 2015-03-27T14:48:12.938Z
vip_member_price 0.69

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 8.000000000000 17861
CACHED false
EXECUTIONTIME 2
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '9213' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.159.140.37

URL: www.misterart.com:/index.cfm:module=crafts&catB=glitter&CatC=fp~0-3~&gr=advantus-corp-glitter.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-28 20:45:58'}
sessionid e0304e53fbd385ae8c89514f191d782e5f4f
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=sort~1~fp~0-7~&gr=cousin-round-nose-pliers.html
urltoken CFID=29781927&CFTOKEN=27569925&jsessionid=e0304e53fbd385ae8c89514f191d782e5f4f
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-28 20:45:58'}
sessionid e03050366d545fbb82c05a416e2536311719
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=glitter&CatC=fp~0-3~&gr=advantus-corp-glitter.html
urltoken CFID=29781926&CFTOKEN=38524499&jsessionid=e03050366d545fbb82c05a416e2536311719
validationerror [empty string]


Problem with item sku 45251. Item is found in Solr index but not found in vAvailQtyTbl.

SOLR Query: http://10.100.22.71:8888/solr2/select?q=q%3did%3a1019 1019&wt=json&indent=on&fl=*&rows=1000&fq=group_id:1019&sort=col1_sortorder asc&qt=dismax&hl=on

ItemIDList: 17861
AvailQtyList: 8.000000000000

struct
FLAGS 0
VIP_member_discount 30
barcode 717968107374
barcode_type UPC
col1 lime
col1_sortorder 3460
col2 0.6 oz. tube
col2_sortorder 135
col3 [empty string]
color_swatch 110-164-0.jpg
cost 0.48
deal_of_the_week NO
description lime, 0.6 oz. tube
group_id 1019
group_uname advantus-corp-glitter
id 45251
list_price 0.99
map NO
mfr_num SUL51099
net_weight 0.07
non_member_discount 20
non_member_price 0.79
prop65 NO
ship_rule_desc STD
shipping STD
sku 45251
sku_pix YES
supplier_id 1
ta_dealer_a_price 0.59
ta_dealer_c_price 0.56
ta_price 0.84
text
array
1 45251
2 SUL51099
3 lime, 0.6 oz. tube
timestamp 2015-03-27T14:47:18.261Z
vip_member_price 0.69

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 8.000000000000 17861
CACHED false
EXECUTIONTIME 2
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '9213' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.159.140.37

URL: www.misterart.com:/index.cfm:module=crafts&catB=glitter&CatC=fp~0-3~&gr=advantus-corp-glitter.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-28 20:45:58'}
sessionid e0304e53fbd385ae8c89514f191d782e5f4f
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=sort~1~fp~0-7~&gr=cousin-round-nose-pliers.html
urltoken CFID=29781927&CFTOKEN=27569925&jsessionid=e0304e53fbd385ae8c89514f191d782e5f4f
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-28 20:45:58'}
sessionid e03050366d545fbb82c05a416e2536311719
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=glitter&CatC=fp~0-3~&gr=advantus-corp-glitter.html
urltoken CFID=29781926&CFTOKEN=38524499&jsessionid=e03050366d545fbb82c05a416e2536311719
validationerror [empty string]


Problem with item sku 45257. Item is found in Solr index but not found in vAvailQtyTbl.

SOLR Query: http://10.100.22.71:8888/solr2/select?q=q%3did%3a1019 1019&wt=json&indent=on&fl=*&rows=1000&fq=group_id:1019&sort=col1_sortorder asc&qt=dismax&hl=on

ItemIDList: 17861
AvailQtyList: 8.000000000000

struct
FLAGS 0
VIP_member_discount 30
barcode 717968511485
barcode_type UPC
col1 lime
col1_sortorder 3460
col2 8 oz. shaker bottle
col2_sortorder 2323
col3 [empty string]
color_swatch 110-164-0.jpg
cost 2.93
deal_of_the_week NO
description lime, 8 oz. shaker bottle
group_id 1019
group_uname advantus-corp-glitter
id 45257
list_price 8.57
map NO
mfr_num SUL6632-14
net_weight 0.58
non_member_discount 20
non_member_price 6.86
prop65 NO
ship_rule_desc STD
shipping STD
sku 45257
sku_pix YES
supplier_id 1
ta_dealer_a_price 3.86
ta_dealer_c_price 3.43
ta_price 6.43
text
array
1 45257
2 SUL6632-14
3 lime, 8 oz. shaker bottle
timestamp 2015-03-27T14:47:18.271Z
vip_member_price 6

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 8.000000000000 17861
CACHED false
EXECUTIONTIME 2
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '9213' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.159.140.37

URL: www.misterart.com:/index.cfm:module=crafts&catB=glitter&CatC=fp~0-3~&gr=advantus-corp-glitter.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-28 20:45:58'}
sessionid e0304e53fbd385ae8c89514f191d782e5f4f
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=sort~1~fp~0-7~&gr=cousin-round-nose-pliers.html
urltoken CFID=29781927&CFTOKEN=27569925&jsessionid=e0304e53fbd385ae8c89514f191d782e5f4f
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-28 20:45:58'}
sessionid e03050366d545fbb82c05a416e2536311719
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=glitter&CatC=fp~0-3~&gr=advantus-corp-glitter.html
urltoken CFID=29781926&CFTOKEN=38524499&jsessionid=e03050366d545fbb82c05a416e2536311719
validationerror [empty string]


Problem with item sku 61295. Item is found in Solr index but not found in vAvailQtyTbl.

SOLR Query: http://10.100.22.71:8888/solr2/select?q=q%3did%3a1019 1019&wt=json&indent=on&fl=*&rows=1000&fq=group_id:1019&sort=col1_sortorder asc&qt=dismax&hl=on

ItemIDList: 17861
AvailQtyList: 8.000000000000

struct
FLAGS 0
VIP_member_discount 30
barcode 717968511164
barcode_type UPC
col1 lime
col1_sortorder 3460
col2 2 oz. shaker bottle
col2_sortorder 1219
col3 [empty string]
color_swatch 110-164-0.jpg
cost 0.98
deal_of_the_week NO
description lime, 2 oz. shaker bottle
group_id 1019
group_uname advantus-corp-glitter
id 61295
list_price 2
map NO
mfr_num SUL51116
net_weight 0.12
non_member_discount 20
non_member_price 1.6
prop65 NO
ship_rule_desc STD
shipping STD
sku 61295
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.2
ta_dealer_c_price 1.14
ta_price 1.7
text
array
1 61295
2 SUL51116
3 lime, 2 oz. shaker bottle
timestamp 2015-03-27T14:47:40.656Z
vip_member_price 1.4

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 8.000000000000 17861
CACHED false
EXECUTIONTIME 2
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '9213' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.159.140.37

URL: www.misterart.com:/index.cfm:module=crafts&catB=glitter&CatC=fp~0-3~&gr=advantus-corp-glitter.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-28 20:45:58'}
sessionid e0304e53fbd385ae8c89514f191d782e5f4f
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=sort~1~fp~0-7~&gr=cousin-round-nose-pliers.html
urltoken CFID=29781927&CFTOKEN=27569925&jsessionid=e0304e53fbd385ae8c89514f191d782e5f4f
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-28 20:45:58'}
sessionid e03050366d545fbb82c05a416e2536311719
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=glitter&CatC=fp~0-3~&gr=advantus-corp-glitter.html
urltoken CFID=29781926&CFTOKEN=38524499&jsessionid=e03050366d545fbb82c05a416e2536311719
validationerror [empty string]


Problem with item sku 61297. Item is found in Solr index but not found in vAvailQtyTbl.

SOLR Query: http://10.100.22.71:8888/solr2/select?q=q%3did%3a1019 1019&wt=json&indent=on&fl=*&rows=1000&fq=group_id:1019&sort=col1_sortorder asc&qt=dismax&hl=on

ItemIDList: 17861
AvailQtyList: 8.000000000000

struct
FLAGS 0
VIP_member_discount 30
barcode 717968511324
barcode_type UPC
col1 lime
col1_sortorder 3460
col2 4 oz. shaker bottle
col2_sortorder 1812
col3 [empty string]
color_swatch 110-164-0.jpg
cost 1.46
deal_of_the_week NO
description lime, 4 oz. shaker bottle
group_id 1019
group_uname advantus-corp-glitter
id 61297
list_price 4.29
map NO
mfr_num SUL51132
net_weight 0.12
non_member_discount 20
non_member_price 3.43
prop65 NO
ship_rule_desc STD
shipping STD
sku 61297
sku_pix NO
supplier_id 1
ta_dealer_a_price 1.93
ta_dealer_c_price 1.72
ta_price 3.22
text
array
1 61297
2 SUL51132
3 lime, 4 oz. shaker bottle
timestamp 2015-03-27T14:47:40.659Z
vip_member_price 3

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 8.000000000000 17861
CACHED false
EXECUTIONTIME 2
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '9213' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.159.140.37

URL: www.misterart.com:/index.cfm:module=crafts&catB=glitter&CatC=fp~0-3~&gr=advantus-corp-glitter.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-28 20:45:58'}
sessionid e0304e53fbd385ae8c89514f191d782e5f4f
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=sort~1~fp~0-7~&gr=cousin-round-nose-pliers.html
urltoken CFID=29781927&CFTOKEN=27569925&jsessionid=e0304e53fbd385ae8c89514f191d782e5f4f
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-28 20:45:58'}
sessionid e03050366d545fbb82c05a416e2536311719
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=glitter&CatC=fp~0-3~&gr=advantus-corp-glitter.html
urltoken CFID=29781926&CFTOKEN=38524499&jsessionid=e03050366d545fbb82c05a416e2536311719
validationerror [empty string]


Problem with item sku 36767. Item is found in Solr index but not found in vAvailQtyTbl.

SOLR Query: http://10.100.22.71:8888/solr2/select?q=q%3did%3a1019 1019&wt=json&indent=on&fl=*&rows=1000&fq=group_id:1019&sort=col1_sortorder asc&qt=dismax&hl=on

ItemIDList: 17861
AvailQtyList: 8.000000000000

struct
FLAGS 0
VIP_member_discount 30
barcode 717968107329
barcode_type UPC
col1 multi color
col1_sortorder 3867
col2 0.6 oz. tube
col2_sortorder 135
col3 [empty string]
cost 0.48
deal_of_the_week NO
description multi color, 0.6 oz. tube
group_id 1019
group_uname advantus-corp-glitter
id 36767
list_price 0.99
map NO
mfr_num SUL51090
net_weight 0.06
non_member_discount 20
non_member_price 0.79
prop65 NO
ship_rule_desc STD
shipping STD
sku 36767
sku_pix YES
supplier_id 1
ta_dealer_a_price 0.59
ta_dealer_c_price 0.56
ta_price 0.84
text
array
1 36767
2 SUL51090
3 multi color, 0.6 oz. tube
timestamp 2015-03-27T14:47:08.107Z
vip_member_price 0.69

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 8.000000000000 17861
CACHED false
EXECUTIONTIME 2
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '9213' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.159.140.37

URL: www.misterart.com:/index.cfm:module=crafts&catB=glitter&CatC=fp~0-3~&gr=advantus-corp-glitter.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-28 20:45:58'}
sessionid e0304e53fbd385ae8c89514f191d782e5f4f
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=sort~1~fp~0-7~&gr=cousin-round-nose-pliers.html
urltoken CFID=29781927&CFTOKEN=27569925&jsessionid=e0304e53fbd385ae8c89514f191d782e5f4f
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-28 20:45:58'}
sessionid e03050366d545fbb82c05a416e2536311719
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=glitter&CatC=fp~0-3~&gr=advantus-corp-glitter.html
urltoken CFID=29781926&CFTOKEN=38524499&jsessionid=e03050366d545fbb82c05a416e2536311719
validationerror [empty string]


Problem with item sku 50313. Item is found in Solr index but not found in vAvailQtyTbl.

SOLR Query: http://10.100.22.71:8888/solr2/select?q=q%3did%3a1019 1019&wt=json&indent=on&fl=*&rows=1000&fq=group_id:1019&sort=col1_sortorder asc&qt=dismax&hl=on

ItemIDList: 17861
AvailQtyList: 8.000000000000

struct
FLAGS 0
VIP_member_discount 30
barcode 717968108128
barcode_type UPC
col1 multi color
col1_sortorder 3867
col2 2 oz. shaker bottle
col2_sortorder 1219
col3 [empty string]
cost 0.98
deal_of_the_week NO
description multi color, 2 oz. shaker bottle
group_id 1019
group_uname advantus-corp-glitter
id 50313
list_price 2
map NO
mfr_num SUL51107
net_weight 0.14
non_member_discount 20
non_member_price 1.6
prop65 NO
ship_rule_desc STD
shipping STD
sku 50313
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.2
ta_dealer_c_price 1.14
ta_price 1.7
text
array
1 50313
2 SUL51107
3 multi color, 2 oz. shaker bottle
timestamp 2015-03-27T14:47:24.807Z
vip_member_price 1.4

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 8.000000000000 17861
CACHED false
EXECUTIONTIME 2
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '9213' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.159.140.37

URL: www.misterart.com:/index.cfm:module=crafts&catB=glitter&CatC=fp~0-3~&gr=advantus-corp-glitter.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-28 20:45:58'}
sessionid e0304e53fbd385ae8c89514f191d782e5f4f
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=sort~1~fp~0-7~&gr=cousin-round-nose-pliers.html
urltoken CFID=29781927&CFTOKEN=27569925&jsessionid=e0304e53fbd385ae8c89514f191d782e5f4f
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-28 20:45:58'}
sessionid e03050366d545fbb82c05a416e2536311719
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=glitter&CatC=fp~0-3~&gr=advantus-corp-glitter.html
urltoken CFID=29781926&CFTOKEN=38524499&jsessionid=e03050366d545fbb82c05a416e2536311719
validationerror [empty string]


Problem with item sku 51149. Item is found in Solr index but not found in vAvailQtyTbl.

SOLR Query: http://10.100.22.71:8888/solr2/select?q=q%3did%3a1019 1019&wt=json&indent=on&fl=*&rows=1000&fq=group_id:1019&sort=col1_sortorder asc&qt=dismax&hl=on

ItemIDList: 17861
AvailQtyList: 8.000000000000

struct
FLAGS 0
VIP_member_discount 30
barcode 717968107923
barcode_type UPC
col1 multi color
col1_sortorder 3867
col2 8 oz. shaker bottle
col2_sortorder 2323
col3 [empty string]
cost 2.93
deal_of_the_week NO
description multi color, 8 oz. shaker bottle
group_id 1019
group_uname advantus-corp-glitter
id 51149
list_price 6
map NO
mfr_num SUL51140
net_weight 0.6
non_member_discount 20
non_member_price 4.8
prop65 NO
ship_rule_desc STD
shipping STD
sku 51149
sku_pix YES
supplier_id 1
ta_dealer_a_price 3.6
ta_dealer_c_price 3.42
ta_price 5.1
text
array
1 51149
2 SUL51140
3 multi color, 8 oz. shaker bottle
timestamp 2015-03-27T14:47:25.321Z
vip_member_price 4.2

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 8.000000000000 17861
CACHED false
EXECUTIONTIME 2
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '9213' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.159.140.37

URL: www.misterart.com:/index.cfm:module=crafts&catB=glitter&CatC=fp~0-3~&gr=advantus-corp-glitter.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-28 20:45:58'}
sessionid e0304e53fbd385ae8c89514f191d782e5f4f
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=sort~1~fp~0-7~&gr=cousin-round-nose-pliers.html
urltoken CFID=29781927&CFTOKEN=27569925&jsessionid=e0304e53fbd385ae8c89514f191d782e5f4f
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-28 20:45:58'}
sessionid e03050366d545fbb82c05a416e2536311719
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=glitter&CatC=fp~0-3~&gr=advantus-corp-glitter.html
urltoken CFID=29781926&CFTOKEN=38524499&jsessionid=e03050366d545fbb82c05a416e2536311719
validationerror [empty string]


Problem with item sku 77232. Item is found in Solr index but not found in vAvailQtyTbl.

SOLR Query: http://10.100.22.71:8888/solr2/select?q=q%3did%3a1019 1019&wt=json&indent=on&fl=*&rows=1000&fq=group_id:1019&sort=col1_sortorder asc&qt=dismax&hl=on

ItemIDList: 17861
AvailQtyList: 8.000000000000

struct
FLAGS 0
VIP_member_discount 30
barcode 717968106551
barcode_type UPC
col1 multi color
col1_sortorder 3867
col2 4 oz. shaker bottle
col2_sortorder 1812
col3 [empty string]
cost 1.46
deal_of_the_week NO
description multi color, 4 oz. shaker bottle
group_id 1019
group_uname advantus-corp-glitter
id 77232
list_price 2.99
map NO
mfr_num SUL51123
net_weight 0.3
non_member_discount 20
non_member_price 2.39
prop65 NO
ship_rule_desc STD
shipping STD
sku 77232
sku_pix YES
supplier_id 1
ta_dealer_a_price 1.79
ta_dealer_c_price 1.7
ta_price 2.54
text
array
1 77232
2 SUL51123
3 multi color, 4 oz. shaker bottle
timestamp 2015-03-27T14:48:07.069Z
vip_member_price 2.09

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 8.000000000000 17861
CACHED false
EXECUTIONTIME 2
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '9213' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.159.140.37

URL: www.misterart.com:/index.cfm:module=crafts&catB=glitter&CatC=fp~0-3~&gr=advantus-corp-glitter.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-28 20:45:58'}
sessionid e0304e53fbd385ae8c89514f191d782e5f4f
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=sort~1~fp~0-7~&gr=cousin-round-nose-pliers.html
urltoken CFID=29781927&CFTOKEN=27569925&jsessionid=e0304e53fbd385ae8c89514f191d782e5f4f
validationerror [empty string]


EndSessionVariables:
struct
requeststarttime {ts '2015-03-28 20:45:58'}
sessionid e03050366d545fbb82c05a416e2536311719
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=crafts&catB=glitter&CatC=fp~0-3~&gr=advantus-corp-glitter.html
urltoken CFID=29781926&CFTOKEN=38524499&jsessionid=e03050366d545fbb82c05a416e2536311719
validationerror [empty string]


Problem with item sku 45252. Item is found in Solr index but not found in vAvailQtyTbl.

SOLR Query: http://10.100.22.71:8888/solr2/select?q=q%3did%3a1019 1019&wt=json&indent=on&fl=*&rows=1000&fq=group_id:1019&sort=col1_sortorder asc&qt=dismax&hl=on

ItemIDList: 17861
AvailQtyList: 8.000000000000

struct
FLAGS 0
VIP_member_discount 30
barcode 717968158482
barcode_type UPC
col1 orange
col1_sortorder 4215
col2 0.6 oz. tube
col2_sortorder 135
col3 [empty string]
color_swatch 164-63-31.jpg
cost 0.48
deal_of_the_week NO
description orange, 0.6 oz. tube
group_id 1019
group_uname advantus-corp-glitter
id 45252
list_price 0.99
map NO
mfr_num SUL51100
net_weight 0.07
non_member_discount 20
non_member_price 0.79
prop65 NO
ship_rule_desc STD
shipping STD
sku 45252
sku_pix YES
supplier_id 1
ta_dealer_a_price 0.59
ta_dealer_c_price 0.56
ta_price 0.84
text
array
1 45252
2 SUL51100
3 orange, 0.6 oz. tube
timestamp 2015-03-27T14:47:18.263Z
vip_member_price 0.69

SQL Query:
query
RESULTSET
query
  AVAILQTY ITEMID
1 8.000000000000 17861
CACHED false
EXECUTIONTIME 2
SQL SELECT [vAvailQtyTbl].[ItemID], [vAvailQtyTbl].[AvailQty] FROM [vAvailQtyTbl] INNER JOIN [els_InventViewTbl] ON [els_InventViewTbl].[els_SKU] = [vAvailQtyTbl].[ItemID] WHERE [els_InventViewTbl].[els_Group_ID] = '9213' AND els_vipmemberprice is not null AND els_columnvalue1 !='' AND (els_mfrnum!='BILL ONLY' or els_mfrnum is null)


DSN Used: MA_WEB

IP: 54.159.140.37

URL: www.misterart.com:/index.cfm:module=crafts&catB=glitter&CatC=fp~0-3~&gr=advantus-corp-glitter.html

StartSessionVariables:
struct
requeststarttime {ts '2015-03-28 20:45:58'}
sessionid e0304e53fbd385ae8c89514f191d782e5f4f
stformdata
struct [empty]
thispageurl www.misterart.com:/index.cfm:module=architecture-drafting&catB=sort~1~fp~0-7~&gr=cousin-round-nose-pliers.html
urltoken CFID=29781927&CFTOKEN=27569925&jsessionid=e0304e53fbd385ae8c89514f191d782e5f4f
validationerror [empty string]


EndSessionVariables: