Sorting by Merchant on Orders Tab results in empty return set.

Click on the orders tab, then click on the sortable merchant's column and you will see a blank list returned. The following error is in the log:

-------------------------------------
2014-04-15 17:39:23,399-275041 [http-8080-22] INFO org.apache.cxf.interceptor.LoggingInInterceptor [] - Inbound Message
----------------------------
ID: 138
Address: http://127.0.0.1:8080/sapi/rest/orders?q=SELECT++ORDER+BY+associatedMerchant.name+DESC%2CmodificationDate+DESC+LIMIT+0%2C25
Http-Method: GET
Content-Type:
Headers:

{Accept=[application/json, text/plain], connection=[Keep-Alive], Content-Type=[null], host=[127.0.0.1:8080], user-agent=[Apache-HttpClient/4.2.1 (java 1.5)], x-tsa-authenticate=[LK3CYKUPKK2RXAULKS4LNYPLXHNF7AKRDRMH7JY5UK2KTIG4JKSL2GBRLEVWQU5ZXYX6SOHXGWDPHAIB5ECWALIBUYHWIEB2JMWQAVMOSEI4VHWGYEMWM2FGJRQB3QGVP2K6RL5HGDL5RN5GUCZIH6JL2NUCR7KBLYNA4EHEKKPNDWALKYPTY7MXINFUPKSCYXO5GHSTWPOAZ2Q5NXQ3YIGAEGEOOBQ67RHWD427LFZF4VD6GKOYKMO7Z67HO6K2DOMD2JTO3AD4YTDVWZUJF3XXWE4ISUNRAL6JFFGA5GP5PPJA2MLIEQ32V5AJ2SS2QAAEOCGRQE3G7D3WPEUBJTDWNJHNEMI34QZFAWI23UBJKJYCXPDCXVPXC6LEPH72ZOSQTR545HMJOOYSVNAGMTNN67NXJSI33LJZSQO3XG6SJZ46ZONWUYXJLFUYPHA6V2UVDS7GKNDKOAG64SE6EAK67FNQP2HO6Y2UIF663UH3DW7HUS66N2RWT3QH6JXRWVXXSWINKNNO6WYZ4N5ITY4VPRK4BACOW27JFWRZOYW55OFAT73BMHYOGIGTYYSVCQCDIEBAHOP6DXGWZ32KJBFMZUQ3JSPVLP4IHLMGTUZFKBYJ2FKLLMOBBZGSULSDOIHX76XI7KNTVP4LETKSESCDOJHS2UA2H2ZKPOPB656446AJXM2R3POK3JM35LO7EEMBRHPBCDS432AYQZPV635WO22TU7ABZOPJQXL2YNUFSESBPUPCNA72ITGASTR7KWEMUD6GVDODZ4KOGDFATQAWO6JR6DDJQ5QPHYKIK6FQELXE222G6J4EUMGDGACWUWUFEUZ7HO2PZMAYYMTDE5WH73FKPKVJWE6CZZSPM7RP7JBEQJSZAVVAWKC5MXAAYPRXFLKELUOGYI3V65DZSFAWTKUTDJMKDHCUIH4AOKNWNBWPMW3LQRGZ3NZPGITCKUTCHH7JOKIJJ5OX4Q4OCQPVCPLT5VVZ5CXIQW4JYBJBVAYQCLO6RNUCUYEPSDKPEGG7INK7QC73T5AXMICGSM2C3VL2EP7UZEQR5ZU3XFRONDLSPSYSAUKQP7Z7LZ6BSH4L7D3UDGYL6OGYFP32LS6FPGVLFVPCUEOF3JM3UYPQNKB24T6OYTVBYIT2CCQCTHR3LHCLXOTXJXDU4M6TVFP5AFTBNY6RUR6LPX55OFPKGFP4W26LUEQJBCBF2THPABW75DNZ4NF6BQAKTAXNPMI52DD6TGRKITAYLR3NDKPFC7E2UED6I4MQTOTFHPXUT2IPVEGMGVIKWHCLF6S2Y353MNFLFIJVN7DLAYZU2THTDKF7YAJGVNLZ5I4CUISBSIBHV2DJPWRVEVPCI634HJELLQFRSNQD655VPFQIGDLENAFRDG2I33ZDL4IY2V42LEA2DBOINO2SBOPWJHYUQKZXHS4R2T726JXTAJQ254HSRPSL3VR3A4GN7K2LRNRE7IKPQI7ABVUXB3IQ7RSZV7YIT2ORQKQCL3AZQ2N4AJ4O7D4HTD4IMZVM6RJRRRZXX6RRDVJNC6OJV4S4D2JORLX2TNOCOYS7US2IRZBKCYLPPED7A42N2ONL2UT4PJDN3PG5ASMMA5TIMFPZBLC742WPFBYMAJPVL7JHB5UGWW36IZS5XSSSTRYRWFBD4SJTJJDKAIL6D7VVGJPNHK36CU2LAJ56KEOYMUW4MATMQFW7N3KMSVF5G4NKGYHJQ7VS]}

--------------------------------------
2014-04-15 17:39:23,452-275094 [http-8080-22] WARN com.thesearchagency.services.search.internal.es.ElasticSearchIndex [timezone=Etc/UTC, principalId=77885f5d-d9b9-4728-a1a0-f329aa47d7df, requestId=c5588a74-704a-4ba5-8e67-7621233ea4bf, locale=en_US, authToken=LK3CYKUPKK2RXAULKS4LNYPLXHNF7AKRDRMH7JY5UK2KTIG4JKSL2GBRLEVWQU5ZXYX6SOHXGWDPHAIB5ECWALIBUYHWIEB2JMWQAVMOSEI4VHWGYEMWM2FGJRQB3QGVP2K6RL5HGDL5RN5GUCZIH6JL2NUCR7KBLYNA4EHEKKPNDWALKYPTY7MXINFUPKSCYXO5GHSTWPOAZ2Q5NXQ3YIGAEGEOOBQ67RHWD427LFZF4VD6GKOYKMO7Z67HO6K2DOMD2JTO3AD4YTDVWZUJF3XXWE4ISUNRAL6JFFGA5GP5PPJA2MLIEQ32V5AJ2SS2QAAEOCGRQE3G7D3WPEUBJTDWNJHNEMI34QZFAWI23UBJKJYCXPDCXVPXC6LEPH72ZOSQTR545HMJOOYSVNAGMTNN67NXJSI33LJZSQO3XG6SJZ46ZONWUYXJLFUYPHA6V2UVDS7GKNDKOAG64SE6EAK67FNQP2HO6Y2UIF663UH3DW7HUS66N2RWT3QH6JXRWVXXSWINKNNO6WYZ4N5ITY4VPRK4BACOW27JFWRZOYW55OFAT73BMHYOGIGTYYSVCQCDIEBAHOP6DXGWZ32KJBFMZUQ3JSPVLP4IHLMGTUZFKBYJ2FKLLMOBBZGSULSDOIHX76XI7KNTVP4LETKSESCDOJHS2UA2H2ZKPOPB656446AJXM2R3POK3JM35LO7EEMBRHPBCDS432AYQZPV635WO22TU7ABZOPJQXL2YNUFSESBPUPCNA72ITGASTR7KWEMUD6GVDODZ4KOGDFATQAWO6JR6DDJQ5QPHYKIK6FQELXE222G6J4EUMGDGACWUWUFEUZ7HO2PZMAYYMTDE5WH73FKPKVJWE6CZZSPM7RP7JBEQJSZAVVAWKC5MXAAYPRXFLKELUOGYI3V65DZSFAWTKUTDJMKDHCUIH4AOKNWNBWPMW3LQRGZ3NZPGITCKUTCHH7JOKIJJ5OX4Q4OCQPVCPLT5VVZ5CXIQW4JYBJBVAYQCLO6RNUCUYEPSDKPEGG7INK7QC73T5AXMICGSM2C3VL2EP7UZEQR5ZU3XFRONDLSPSYSAUKQP7Z7LZ6BSH4L7D3UDGYL6OGYFP32LS6FPGVLFVPCUEOF3JM3UYPQNKB24T6OYTVBYIT2CCQCTHR3LHCLXOTXJXDU4M6TVFP5AFTBNY6RUR6LPX55OFPKGFP4W26LUEQJBCBF2THPABW75DNZ4NF6BQAKTAXNPMI52DD6TGRKITAYLR3NDKPFC7E2UED6I4MQTOTFHPXUT2IPVEGMGVIKWHCLF6S2Y353MNFLFIJVN7DLAYZU2THTDKF7YAJGVNLZ5I4CUISBSIBHV2DJPWRVEVPCI634HJELLQFRSNQD655VPFQIGDLENAFRDG2I33ZDL4IY2V42LEA2DBOINO2SBOPWJHYUQKZXHS4R2T726JXTAJQ254HSRPSL3VR3A4GN7K2LRNRE7IKPQI7ABVUXB3IQ7RSZV7YIT2ORQKQCL3AZQ2N4AJ4O7D4HTD4IMZVM6RJRRRZXX6RRDVJNC6OJV4S4D2JORLX2TNOCOYS7US2IRZBKCYLPPED7A42N2ONL2UT4PJDN3PG5ASMMA5TIMFPZBLC742WPFBYMAJPVL7JHB5UGWW36IZS5XSSSTRYRWFBD4SJTJJDKAIL6D7VVGJPNHK36CU2LAJ56KEOYMUW4MATMQFW7N3KMSVF5G4NKGYHJQ7VS, hostname=127.0.0.1, ipAddress=127.0.0.1] -
org.elasticsearch.action.search.SearchPhaseExecutionException: Failed to execute phase [dfs], total failure; shardFailures {[xxlSDxFnQ1i_lfNp2V5PZw][com.thesearchagency_dd1e56af-fff2-4511-bc22-e1273d6038a9][1]: SearchParseException[[com.thesearchagency_dd1e56af-fff2-4511-bc22-e1273d6038a9][1]: from[0],size[25]: Parse Failure [Failed to parse source [{"from":0,"size":25,"sort":[

{"associatedMerchant.name.sortable":"desc"}

,

{"modificationDate":"desc"}

],"query":{"query_string":

{"query":"*"}

,"filtered":{"filter":{"type":

{"value":"order"}

}}}}]]]; nested: SearchParseException[[com.thesearchagency_dd1e56af-fff2-4511-bc22-e1273d6038a9][1]: from[0],size[25]: Parse Failure [No mapping found for [associatedMerchant.name.sortable] in order to sort on]]; }{[xxlSDxFnQ1i_lfNp2V5PZw][com.thesearchagency_dd1e56af-fff2-4511-bc22-e1273d6038a9][4]: SearchParseException[[com.thesearchagency_dd1e56af-fff2-4511-bc22-e1273d6038a9][4]: from[0],size[25]: Parse Failure [Failed to parse source [{"from":0,"size":25,"sort":[

{"associatedMerchant.name.sortable":"desc"}

,

{"modificationDate":"desc"}

],"query":{"query_string":

{"query":"*"}

,"filtered":{"filter":{"type":

{"value":"order"}

}}}}]]]; nested: SearchParseException[[com.thesearchagency_dd1e56af-fff2-4511-bc22-e1273d6038a9][4]: from[0],size[25]: Parse Failure [No mapping found for [associatedMerchant.name.sortable] in order to sort on]]; }{[xxlSDxFnQ1i_lfNp2V5PZw][com.thesearchagency_dd1e56af-fff2-4511-bc22-e1273d6038a9][3]: SearchParseException[[com.thesearchagency_dd1e56af-fff2-4511-bc22-e1273d6038a9][3]: from[0],size[25]: Parse Failure [Failed to parse source [{"from":0,"size":25,"sort":[

{"associatedMerchant.name.sortable":"desc"}

,

{"modificationDate":"desc"}

],"query":{"query_string":

{"query":"*"}

,"filtered":{"filter":{"type":

{"value":"order"}

}}}}]]]; nested: SearchParseException[[com.thesearchagency_dd1e56af-fff2-4511-bc22-e1273d6038a9][3]: from[0],size[25]: Parse Failure [No mapping found for [associatedMerchant.name.sortable] in order to sort on]]; }{[xxlSDxFnQ1i_lfNp2V5PZw][com.thesearchagency_dd1e56af-fff2-4511-bc22-e1273d6038a9][2]: SearchParseException[[com.thesearchagency_dd1e56af-fff2-4511-bc22-e1273d6038a9][2]: from[0],size[25]: Parse Failure [Failed to parse source [{"from":0,"size":25,"sort":[

{"associatedMerchant.name.sortable":"desc"}

,

{"modificationDate":"desc"}

],"query":{"query_string":

{"query":"*"}

,"filtered":{"filter":{"type":

{"value":"order"}

}}}}]]]; nested: SearchParseException[[com.thesearchagency_dd1e56af-fff2-4511-bc22-e1273d6038a9][2]: from[0],size[25]: Parse Failure [No mapping found for [associatedMerchant.name.sortable] in order to sort on]]; }{[xxlSDxFnQ1i_lfNp2V5PZw][com.thesearchagency_dd1e56af-fff2-4511-bc22-e1273d6038a9][0]: SearchParseException[[com.thesearchagency_dd1e56af-fff2-4511-bc22-e1273d6038a9][0]: from[0],size[25]: Parse Failure [Failed to parse source [{"from":0,"size":25,"sort":[

{"associatedMerchant.name.sortable":"desc"}

,

{"modificationDate":"desc"}

],"query":{"query_string":

{"query":"*"}

,"filtered":{"filter":{"type":

{"value":"order"}

}}}}]]]; nested: SearchParseException[[com.thesearchagency_dd1e56af-fff2-4511-bc22-e1273d6038a9][0]: from[0],size[25]: Parse Failure [No mapping found for [associatedMerchant.name.sortable] in order to sort on]]; }
at org.elasticsearch.action.search.type.TransportSearchTypeAction$BaseAsyncAction.onFirstPhaseResult(TransportSearchTypeAction.java:260) ~[elasticsearch-0.19.9.jar:na]
at org.elasticsearch.action.search.type.TransportSearchTypeAction$BaseAsyncAction$3.onFailure(TransportSearchTypeAction.java:213) ~[elasticsearch-0.19.9.jar:na]
at org.elasticsearch.search.action.SearchServiceTransportAction.sendExecuteDfs(SearchServiceTransportAction.java:107) ~[elasticsearch-0.19.9.jar:na]
at org.elasticsearch.action.search.type.TransportSearchDfsQueryThenFetchAction$AsyncAction.sendExecuteFirstPhase(TransportSearchDfsQueryThenFetchAction.java:86) ~[elasticsearch-0.19.9.jar:na]
at org.elasticsearch.action.search.type.TransportSearchTypeAction$BaseAsyncAction.performFirstPhase(TransportSearchTypeAction.java:205) ~[elasticsearch-0.19.9.jar:na]
at org.elasticsearch.action.search.type.TransportSearchTypeAction$BaseAsyncAction.performFirstPhase(TransportSearchTypeAction.java:192) ~[elasticsearch-0.19.9.jar:na]
at org.elasticsearch.action.search.type.TransportSearchTypeAction$BaseAsyncAction$2.run(TransportSearchTypeAction.java:178) ~[elasticsearch-0.19.9.jar:na]
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1146) ~[na:1.6.0_24]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) ~[na:1.6.0_24]
at java.lang.Thread.run(Thread.java:679) ~[na:1.6.0_24]
2014-04-15 17:39:23,456-275098 [http-8080-22] INFO org.apache.cxf.interceptor.LoggingOutInterceptor [] - Outbound Message
---------------------------
ID: 138
Response-Code: 200
Content-Type: application/json;charset=UTF-8;type=tsa-query-response;version=2.4.0-BETA16
Headers:

{Content-Type=[application/json;charset=UTF-8;type=tsa-query-response;version=2.4.0-BETA16], Date=[Tue, 15 Apr 2014 17:39:23 GMT], X-AML-API-ID=[c5588a74-704a-4ba5-8e67-7621233ea4bf], Expires=[-1], Cache-Control=[no-cache], Pragma=[no-cache]}

Payload:

{"total":0,"count":0,"pages":0,"current":1}

--------------------------------------