shopizer build search and run sign in exception

541 views

Skip to first unread message

Neeraj Bharti

unread,

Apr 5, 2016, 8:00:54 AM4/5/16

to Shopizer

I have 2 questions

when I build shopizer 2.0.3 I found this exception.

ERROR: com.shopizer.search.services.worker.ObjectIndexerImpl - org.apache.http.conn.HttpHostConnectException: Connect to localhost:9200 [localhost/127.0.0.1, localhost/0:0:0:0:0:0:0:1] failed: Connection refused: connect
ERROR: com.shopizer.search.services.worker.KeywordIndexerImpl - Cannot index keywords, maybe a timing ussue for no shards available

my search configuration is
<bean id="serverConfiguration" class="com.shopizer.search.utils.ServerConfiguration">
        <property name="clusterName" value="shopizer"/>
        <!-- local (embedded version, will create new indexes in the working directory) or remote (requires existing server) -->
        <property name="mode" value="local"/>
        <!-- http interface to ES server -->
        <property name="clusterHost" value="http://localhost"/>
        <property name="clusterPort" value="9200"/>

        <property name="proxyUser" value=""/>
        <property name="proxyPassword" value=""/>
    </bean>

after running application i got these errors too
ERROR: com.salesmanager.web.filter.StoreFilter - Cannot get geo ip component 
com.salesmanager.core.business.generic.exception.ServiceException: com.maxmind.geoip2.exception.AddressNotFoundException: The address 127.0.0.1 is not in the database.


and I don't see any sign in option on home page (please see attached image for this).

sopizer-sig-in.png

carlo

unread,

Apr 5, 2016, 1:15:16 PM4/5/16

to Shopizer

Have you started an elastic search instance

Neeraj Bharti

unread,

Apr 5, 2016, 11:43:56 PM4/5/16

to Shopizer

Hi Carlo,

I didn't start an elastic search instance may be when i run the application it would started automatically.

I don't know the internal work flow or code of shopizer.

Neeraj Bharti

unread,

Apr 6, 2016, 8:15:46 AM4/6/16

to Shopizer

Should I install elastic search and then have to start its instance.

how can anyone explain?

I think there is no need to install external program as elastic search while running the shopizer application.

On Tuesday, April 5, 2016 at 5:30:54 PM UTC+5:30, Neeraj Bharti wrote:

umesha...@gmail.com

unread,

Apr 6, 2016, 11:13:31 AM4/6/16

to shop...@googlegroups.com

Yes, in order to use search feature of 2.0.3, you need to have elastic search up and running

Sent from my iPhone

--
You received this message because you are subscribed to the Google Groups "Shopizer" group.
To unsubscribe from this group and stop receiving emails from it, send an email to shopizer+u...@googlegroups.com.
To post to this group, send email to shop...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/shopizer/0f2f9519-bd81-4551-a766-6369db8c2be4%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Neeraj Bharti

unread,

Apr 7, 2016, 8:18:17 AM4/7/16

to Shopizer

Hi Umesh and Carlo

I have started externally elastic search instance and then try to search on shopizer application.

then i got these exceptions

ERROR: com.salesmanager.core.business.search.service.SearchServiceImpl - Error while searching keywords {"query":{"match":{"keyword":{"analyzer":"standard","query":"spring in action"}}}}

java.lang.UnsupportedOperationException: JsonObject

also i found this exception in middleware of application usage

ERROR: com.salesmanager.web.filter.StoreFilter - Cannot get geo ip component

com.salesmanager.core.business.generic.exception.ServiceException: com.maxmind.geoip2.exception.AddressNotFoundException: The address 127.0.0.1 is not in the database.

at com.salesmanager.core.business.customer.service.CustomerServiceImpl.getCustomerAddress(CustomerServiceImpl.java:78)

can you explain why Search is not working and this exception is coming????

On Tuesday, April 5, 2016 at 5:30:54 PM UTC+5:30, Neeraj Bharti wrote:

Carl Samson

unread,

Apr 7, 2016, 11:02:22 AM4/7/16

to shop...@googlegroups.com

Hi,

Just to make sure that you have set the elasticsearch.yml cluster name to shopizer

If so, what is the log traced in elastic search console

For the second error, geoip component cannot get conutry zone for ip 127.0.0.,1 this is normal when running localhost

--
You received this message because you are subscribed to the Google Groups "Shopizer" group.
To unsubscribe from this group and stop receiving emails from it, send an email to shopizer+u...@googlegroups.com.
To post to this group, send email to shop...@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/shopizer/8427a6e2-158c-4e42-a15b-7ae5c6f644f6%40googlegroups.com.

Neeraj Bharti

unread,

Apr 8, 2016, 12:22:52 AM4/8/16

to Shopizer

Hi Carlo and umesh

log for shopizer is as

[2016-04-08 09:48:09,935][INFO ][bootstrap ] running graceful exit on windows

[2016-04-08 09:48:09,936][INFO ][node ] [node-1] stopping ...

[2016-04-08 09:48:09,990][INFO ][node ] [node-1] stopped

[2016-04-08 09:48:09,990][INFO ][node ] [node-1] closing ...

[2016-04-08 09:48:10,017][INFO ][node ] [node-1] closed

[2016-04-08 09:48:19,795][INFO ][node ] [node-1] version[2.3.1], pid[7304], build[bd98092/2016-04-04T12:25:05Z]

[2016-04-08 09:48:19,796][INFO ][node ] [node-1] initializing ...

[2016-04-08 09:48:20,954][INFO ][plugins ] [node-1] modules [reindex, lang-expression, lang-groovy], plugins [], sites []

[2016-04-08 09:48:21,082][INFO ][env ] [node-1] using [1] data paths, mounts [[(C:)]], net usable_space [122.8gb], net total_space [232.7gb], spins? [unknown], types [NTFS]

[2016-04-08 09:48:21,082][INFO ][env ] [node-1] heap size [910.5mb], compressed ordinary object pointers [true]

[2016-04-08 09:48:26,980][INFO ][node ] [node-1] initialized

[2016-04-08 09:48:26,980][INFO ][node ] [node-1] starting ...

[2016-04-08 09:48:27,542][INFO ][transport ] [node-1] publish_address {localhost/127.0.0.1:9300}, bound_addresses {127.0.0.1:9300}, {[::1]:9300}

[2016-04-08 09:48:27,551][INFO ][discovery ] [node-1] shopizer/qYYSFxJ4SbSHlwq8lbaQbQ

[2016-04-08 09:48:31,667][INFO ][cluster.service ] [node-1] new_master {node-1}{qYYSFxJ4SbSHlwq8lbaQbQ}{127.0.0.1}{localhost/127.0.0.1:9300}, reason: zen-disco-join(elected_as_master, [0] joins received)

[2016-04-08 09:48:31,703][INFO ][http ] [node-1] publish_address {localhost/127.0.0.1:9200}, bound_addresses {127.0.0.1:9200}, {[::1]:9200}

[2016-04-08 09:48:31,703][INFO ][node ] [node-1] started

[2016-04-08 09:48:31,802][INFO ][gateway ] [node-1] recovered [0] indices into cluster_state

ans elasticsearch.yml configuration is as

# ======================== Elasticsearch Configuration =========================

# NOTE: Elasticsearch comes with reasonable defaults for most settings.

# Before you set out to tweak and tune the configuration, make sure you

# understand what are you trying to accomplish and the consequences.

# The primary way of configuring a node is via this file. This template lists

# the most important settings you may want to configure for a production cluster.

# Please see the documentation for further information on configuration options:

# <http://www.elastic.co/guide/en/elasticsearch/reference/current/setup-configuration.html>

# ---------------------------------- Cluster -----------------------------------

# Use a descriptive name for your cluster:

cluster.name: shopizer

# ------------------------------------ Node ------------------------------------

# Use a descriptive name for the node:

node.name: node-1

# Add custom attributes to the node:

# node.rack: r1

# ----------------------------------- Paths ------------------------------------

# Path to directory where to store the data (separate multiple locations by comma):

# path.data: /path/to/data

# Path to log files:

# path.logs: /path/to/logs

# ----------------------------------- Memory -----------------------------------

# Lock the memory on startup:

# bootstrap.mlockall: true

# Make sure that the `ES_HEAP_SIZE` environment variable is set to about half the memory

# available on the system and that the owner of the process is allowed to use this limit.

# Elasticsearch performs poorly when the system is swapping the memory.

# ---------------------------------- Network -----------------------------------

# Set the bind address to a specific IP (IPv4 or IPv6):

network.host: localhost

# Set a custom port for HTTP:

# http.port: 9200

# For more information, see the documentation at:

# <http://www.elastic.co/guide/en/elasticsearch/reference/current/modules-network.html>

# --------------------------------- Discovery ----------------------------------

# Pass an initial list of hosts to perform discovery when new node is started:

# The default list of hosts is ["127.0.0.1", "[::1]"]

# discovery.zen.ping.unicast.hosts: ["host1", "host2"]

# Prevent the "split brain" by configuring the majority of nodes (total number of nodes / 2 + 1):

# discovery.zen.minimum_master_nodes: 3

# For more information, see the documentation at:

# <http://www.elastic.co/guide/en/elasticsearch/reference/current/modules-discovery.html>

# ---------------------------------- Gateway -----------------------------------

# Block initial recovery after a full cluster restart until N nodes are started:

# gateway.recover_after_nodes: 3

# For more information, see the documentation at:

# <http://www.elastic.co/guide/en/elasticsearch/reference/current/modules-gateway.html>

# ---------------------------------- Various -----------------------------------

# Disable starting multiple nodes on a single system:

# node.max_local_storage_nodes: 1

# Require explicit names when deleting indices:

# action.destructive_requires_name: true

On Tuesday, April 5, 2016 at 5:30:54 PM UTC+5:30, Neeraj Bharti wrote:

elasticsearch.yml

shopizer.log

Neeraj Bharti

unread,

Apr 8, 2016, 5:04:19 AM4/8/16

to Shopizer

Hi Carlo and Umesh

I solved most of the issues with your helps.

but now stuck here with elastic search.

please see my log

[2016-04-08 14:28:13,308][DEBUG][action.search ] [node-1] [product_en_default][1], node[Cn6aNQmsRMmdxI3tr4Pfqw], [P], v[2], s[STARTED], a[id=XpvesZa_SJWH7-rbO5YPDQ]: Failed to execute [org.elasticsearch.action.search.SearchRequest@47a375a4] lastShard [true]

RemoteTransportException[[node-1][localhost/127.0.0.1:9300][indices:data/read/search[phase/query]]]; nested: SearchParseException[failed to parse search source [{"query":{"query_string" : {"fields" : ["name^3", "description", "tags"], "query" : "*Programming for PAAS*", "use_dis_max" : true }},"facets" : { "categories" : { "terms" : {"field" : "categories"}}}}]]; nested: SearchParseException[failed to parse search source. unknown search element [facets]];

Caused by: SearchParseException[failed to parse search source [{"query":{"query_string" : {"fields" : ["name^3", "description", "tags"], "query" : "*Programming for PAAS*", "use_dis_max" : true }},"facets" : { "categories" : { "terms" : {"field" : "categories"}}}}]]; nested: SearchParseException[failed to parse search source. unknown search element [facets]];

at org.elasticsearch.search.SearchService.parseSource(SearchService.java:855)

at org.elasticsearch.search.SearchService.createContext(SearchService.java:654)

at org.elasticsearch.search.SearchService.createAndPutContext(SearchService.java:620)

at org.elasticsearch.search.SearchService.executeQueryPhase(SearchService.java:371)

at org.elasticsearch.search.action.SearchServiceTransportAction$SearchQueryTransportHandler.messageReceived(SearchServiceTransportAction.java:368)

at org.elasticsearch.search.action.SearchServiceTransportAction$SearchQueryTransportHandler.messageReceived(SearchServiceTransportAction.java:365)

at org.elasticsearch.transport.TransportRequestHandler.messageReceived(TransportRequestHandler.java:33)

at org.elasticsearch.transport.RequestHandlerRegistry.processMessageReceived(RequestHandlerRegistry.java:75)

at org.elasticsearch.transport.TransportService$4.doRun(TransportService.java:376)

at org.elasticsearch.common.util.concurrent.AbstractRunnable.run(AbstractRunnable.java:37)

at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)

at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)

at java.lang.Thread.run(Thread.java:745)

Caused by: SearchParseException[failed to parse search source. unknown search element [facets]]

at org.elasticsearch.search.SearchService.parseSource(SearchService.java:836)

... 12 more

On Tuesday, April 5, 2016 at 5:30:54 PM UTC+5:30, Neeraj Bharti wrote:

Carl Samson - GMail

unread,

Apr 8, 2016, 10:33:17 AM4/8/16

to shop...@googlegroups.com

Please install and run elasticsearch 1.7

Since es 2.3 they replaced facets with buckets!!

I'll open a bug on shopizer bug tracker

--
You received this message because you are subscribed to the Google Groups "Shopizer" group.
To unsubscribe from this group and stop receiving emails from it, send an email to shopizer+u...@googlegroups.com.
To post to this group, send email to shop...@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/shopizer/2166386c-8cdd-4980-b047-d2f429eb946a%40googlegroups.com.

Neeraj Bharti

unread,

Apr 11, 2016, 12:44:04 AM4/11/16

to Shopizer

Hi Carlo and Umesh

I have replaced elastic search 2.3 to elastic search 1.7 again search is not working.

now auto suggestion on search box is working but when performs search action its not working.

please see attached log of elastic search and shopizer exception and provide some suggestion.

DEBUG: org.springframework.web.servlet.DispatcherServlet - DispatcherServlet with name 'appServlet' processing POST request for [/sm-shop/shop/search/search.html]

DEBUG: org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerMapping - Looking up handler method for path /shop/search/search.html

DEBUG: org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerMapping - Returning handler method [public java.lang.String com.salesmanager.web.shop.controller.search.SearchController.displaySearch(java.lang.String,org.springframework.ui.Model,javax.servlet.http.HttpServletRequest,javax.servlet.http.HttpServletResponse,java.util.Locale) throws java.lang.Exception]

****** http://localhost:8080/sm-shop/shop/search/search.html

****** /sm-shop/shop/search/search.html

*** user.dir ***D:\NEERAJ\apache-tomcat-8.0.26\bin

DEBUG: com.salesmanager.web.filter.StoreFilter - *** user.dir ***D:\NEERAJ\apache-tomcat-8.0.26\bin

Hibernate: select content0_.CONTENT_ID as CONTENT1_167_0_, descriptio1_.DESCRIPTION_ID as DESCRIPT1_168_1_, merchantst2_.MERCHANT_ID as MERCHANT1_133_2_, content0_.DATE_CREATED as DATE2_167_0_, content0_.DATE_MODIFIED as DATE3_167_0_, content0_.UPDT_ID as UPDT4_167_0_, content0_.CODE as CODE167_0_, content0_.CONTENT_POSITION as CONTENT6_167_0_, content0_.CONTENT_TYPE as CONTENT7_167_0_, content0_.MERCHANT_ID as MERCHANT10_167_0_, content0_.SORT_ORDER as SORT8_167_0_, content0_.VISIBLE as VISIBLE167_0_, descriptio1_.DATE_CREATED as DATE2_168_1_, descriptio1_.DATE_MODIFIED as DATE3_168_1_, descriptio1_.UPDT_ID as UPDT4_168_1_, descriptio1_.DESCRIPTION as DESCRIPT5_168_1_, descriptio1_.LANGUAGE_ID as LANGUAGE12_168_1_, descriptio1_.NAME as NAME168_1_, descriptio1_.TITLE as TITLE168_1_, descriptio1_.CONTENT_ID as CONTENT13_168_1_, descriptio1_.META_DESCRIPTION as META8_168_1_, descriptio1_.META_KEYWORDS as META9_168_1_, descriptio1_.META_TITLE as META10_168_1_, descriptio1_.SEF_URL as SEF11_168_1_, descriptio1_.CONTENT_ID as CONTENT13_167_0__, descriptio1_.DESCRIPTION_ID as DESCRIPT1_0__, merchantst2_.STORE_CODE as STORE2_133_2_, merchantst2_.CONTINUESHOPPINGURL as CONTINUE3_133_2_, merchantst2_.COUNTRY_ID as COUNTRY20_133_2_, merchantst2_.CURRENCY_ID as CURRENCY21_133_2_, merchantst2_.CURRENCY_FORMAT_NATIONAL as CURRENCY4_133_2_, merchantst2_.LANGUAGE_ID as LANGUAGE22_133_2_, merchantst2_.DOMAIN_NAME as DOMAIN5_133_2_, merchantst2_.IN_BUSINESS_SINCE as IN6_133_2_, merchantst2_.INVOICE_TEMPLATE as INVOICE7_133_2_, merchantst2_.SEIZEUNITCODE as SEIZEUNI8_133_2_, merchantst2_.STORE_EMAIL as STORE9_133_2_, merchantst2_.STORE_LOGO as STORE10_133_2_, merchantst2_.STORE_TEMPLATE as STORE11_133_2_, merchantst2_.STORE_ADDRESS as STORE12_133_2_, merchantst2_.STORE_CITY as STORE13_133_2_, merchantst2_.STORE_NAME as STORE14_133_2_, merchantst2_.STORE_PHONE as STORE15_133_2_, merchantst2_.STORE_POSTAL_CODE as STORE16_133_2_, merchantst2_.STORE_STATE_PROV as STORE17_133_2_, merchantst2_.USE_CACHE as USE18_133_2_, merchantst2_.WEIGHTUNITCODE as WEIGHTU19_133_2_, merchantst2_.ZONE_ID as ZONE23_133_2_ from SALESMANAGER.CONTENT content0_ left outer join SALESMANAGER.CONTENT_DESCRIPTION descriptio1_ on content0_.CONTENT_ID=descriptio1_.CONTENT_ID left outer join SALESMANAGER.MERCHANT_STORE merchantst2_ on content0_.MERCHANT_ID=merchantst2_.MERCHANT_ID where descriptio1_.LANGUAGE_ID=? and content0_.MERCHANT_ID=? and (content0_.CONTENT_TYPE in (? , ?)) order by content0_.SORT_ORDER asc

Hibernate: select content0_.CONTENT_ID as CONTENT1_167_0_, descriptio1_.DESCRIPTION_ID as DESCRIPT1_168_1_, merchantst2_.MERCHANT_ID as MERCHANT1_133_2_, content0_.DATE_CREATED as DATE2_167_0_, content0_.DATE_MODIFIED as DATE3_167_0_, content0_.UPDT_ID as UPDT4_167_0_, content0_.CODE as CODE167_0_, content0_.CONTENT_POSITION as CONTENT6_167_0_, content0_.CONTENT_TYPE as CONTENT7_167_0_, content0_.MERCHANT_ID as MERCHANT10_167_0_, content0_.SORT_ORDER as SORT8_167_0_, content0_.VISIBLE as VISIBLE167_0_, descriptio1_.DATE_CREATED as DATE2_168_1_, descriptio1_.DATE_MODIFIED as DATE3_168_1_, descriptio1_.UPDT_ID as UPDT4_168_1_, descriptio1_.DESCRIPTION as DESCRIPT5_168_1_, descriptio1_.LANGUAGE_ID as LANGUAGE12_168_1_, descriptio1_.NAME as NAME168_1_, descriptio1_.TITLE as TITLE168_1_, descriptio1_.CONTENT_ID as CONTENT13_168_1_, descriptio1_.META_DESCRIPTION as META8_168_1_, descriptio1_.META_KEYWORDS as META9_168_1_, descriptio1_.META_TITLE as META10_168_1_, descriptio1_.SEF_URL as SEF11_168_1_, descriptio1_.CONTENT_ID as CONTENT13_167_0__, descriptio1_.DESCRIPTION_ID as DESCRIPT1_0__, merchantst2_.STORE_CODE as STORE2_133_2_, merchantst2_.CONTINUESHOPPINGURL as CONTINUE3_133_2_, merchantst2_.COUNTRY_ID as COUNTRY20_133_2_, merchantst2_.CURRENCY_ID as CURRENCY21_133_2_, merchantst2_.CURRENCY_FORMAT_NATIONAL as CURRENCY4_133_2_, merchantst2_.LANGUAGE_ID as LANGUAGE22_133_2_, merchantst2_.DOMAIN_NAME as DOMAIN5_133_2_, merchantst2_.IN_BUSINESS_SINCE as IN6_133_2_, merchantst2_.INVOICE_TEMPLATE as INVOICE7_133_2_, merchantst2_.SEIZEUNITCODE as SEIZEUNI8_133_2_, merchantst2_.STORE_EMAIL as STORE9_133_2_, merchantst2_.STORE_LOGO as STORE10_133_2_, merchantst2_.STORE_TEMPLATE as STORE11_133_2_, merchantst2_.STORE_ADDRESS as STORE12_133_2_, merchantst2_.STORE_CITY as STORE13_133_2_, merchantst2_.STORE_NAME as STORE14_133_2_, merchantst2_.STORE_PHONE as STORE15_133_2_, merchantst2_.STORE_POSTAL_CODE as STORE16_133_2_, merchantst2_.STORE_STATE_PROV as STORE17_133_2_, merchantst2_.USE_CACHE as USE18_133_2_, merchantst2_.WEIGHTUNITCODE as WEIGHTU19_133_2_, merchantst2_.ZONE_ID as ZONE23_133_2_ from SALESMANAGER.CONTENT content0_ left outer join SALESMANAGER.CONTENT_DESCRIPTION descriptio1_ on content0_.CONTENT_ID=descriptio1_.CONTENT_ID left outer join SALESMANAGER.MERCHANT_STORE merchantst2_ on content0_.MERCHANT_ID=merchantst2_.MERCHANT_ID where descriptio1_.LANGUAGE_ID=? and content0_.MERCHANT_ID=? and content0_.CONTENT_TYPE=? and content0_.VISIBLE=? order by content0_.SORT_ORDER asc

Hibernate: select distinct category0_.CATEGORY_ID as CATEGORY1_165_0_, descriptio1_.DESCRIPTION_ID as DESCRIPT1_166_1_, merchantst2_.MERCHANT_ID as MERCHANT1_133_2_, category0_.DATE_CREATED as DATE2_165_0_, category0_.DATE_MODIFIED as DATE3_165_0_, category0_.UPDT_ID as UPDT4_165_0_, category0_.CATEGORY_IMAGE as CATEGORY5_165_0_, category0_.CATEGORY_STATUS as CATEGORY6_165_0_, category0_.CODE as CODE165_0_, category0_.DEPTH as DEPTH165_0_, category0_.LINEAGE as LINEAGE165_0_, category0_.MERCHANT_ID as MERCHANT12_165_0_, category0_.PARENT_ID as PARENT13_165_0_, category0_.SORT_ORDER as SORT10_165_0_, category0_.VISIBLE as VISIBLE165_0_, descriptio1_.DATE_CREATED as DATE2_166_1_, descriptio1_.DATE_MODIFIED as DATE3_166_1_, descriptio1_.UPDT_ID as UPDT4_166_1_, descriptio1_.DESCRIPTION as DESCRIPT5_166_1_, descriptio1_.LANGUAGE_ID as LANGUAGE13_166_1_, descriptio1_.NAME as NAME166_1_, descriptio1_.TITLE as TITLE166_1_, descriptio1_.CATEGORY_ID as CATEGORY14_166_1_, descriptio1_.CATEGORY_HIGHLIGHT as CATEGORY8_166_1_, descriptio1_.META_DESCRIPTION as META9_166_1_, descriptio1_.META_KEYWORDS as META10_166_1_, descriptio1_.META_TITLE as META11_166_1_, descriptio1_.SEF_URL as SEF12_166_1_, descriptio1_.CATEGORY_ID as CATEGORY14_165_0__, descriptio1_.DESCRIPTION_ID as DESCRIPT1_0__, merchantst2_.STORE_CODE as STORE2_133_2_, merchantst2_.CONTINUESHOPPINGURL as CONTINUE3_133_2_, merchantst2_.COUNTRY_ID as COUNTRY20_133_2_, merchantst2_.CURRENCY_ID as CURRENCY21_133_2_, merchantst2_.CURRENCY_FORMAT_NATIONAL as CURRENCY4_133_2_, merchantst2_.LANGUAGE_ID as LANGUAGE22_133_2_, merchantst2_.DOMAIN_NAME as DOMAIN5_133_2_, merchantst2_.IN_BUSINESS_SINCE as IN6_133_2_, merchantst2_.INVOICE_TEMPLATE as INVOICE7_133_2_, merchantst2_.SEIZEUNITCODE as SEIZEUNI8_133_2_, merchantst2_.STORE_EMAIL as STORE9_133_2_, merchantst2_.STORE_LOGO as STORE10_133_2_, merchantst2_.STORE_TEMPLATE as STORE11_133_2_, merchantst2_.STORE_ADDRESS as STORE12_133_2_, merchantst2_.STORE_CITY as STORE13_133_2_, merchantst2_.STORE_NAME as STORE14_133_2_, merchantst2_.STORE_PHONE as STORE15_133_2_, merchantst2_.STORE_POSTAL_CODE as STORE16_133_2_, merchantst2_.STORE_STATE_PROV as STORE17_133_2_, merchantst2_.USE_CACHE as USE18_133_2_, merchantst2_.WEIGHTUNITCODE as WEIGHTU19_133_2_, merchantst2_.ZONE_ID as ZONE23_133_2_ from SALESMANAGER.CATEGORY category0_ left outer join SALESMANAGER.CATEGORY_DESCRIPTION descriptio1_ on category0_.CATEGORY_ID=descriptio1_.CATEGORY_ID left outer join SALESMANAGER.MERCHANT_STORE merchantst2_ on category0_.MERCHANT_ID=merchantst2_.MERCHANT_ID where (category0_.DEPTH between ? and ?) and category0_.MERCHANT_ID=? and descriptio1_.LANGUAGE_ID=? order by category0_.SORT_ORDER asc, category0_.LINEAGE asc, category0_.LINEAGE asc, category0_.DEPTH asc, descriptio1_.LANGUAGE_ID desc

Hibernate: select language0_.LANGUAGE_ID as LANGUAGE1_138_0_, language0_.DATE_CREATED as DATE2_138_0_, language0_.DATE_MODIFIED as DATE3_138_0_, language0_.UPDT_ID as UPDT4_138_0_, language0_.CODE as CODE138_0_, language0_.SORT_ORDER as SORT6_138_0_ from SALESMANAGER.LANGUAGE language0_ where language0_.LANGUAGE_ID=?

Hibernate: select merchantco0_.MERCHANT_CONFIG_ID as MERCHANT1_147_0_, merchantst1_.MERCHANT_ID as MERCHANT1_133_1_, merchantco0_.DATE_CREATED as DATE2_147_0_, merchantco0_.DATE_MODIFIED as DATE3_147_0_, merchantco0_.UPDT_ID as UPDT4_147_0_, merchantco0_.CONFIG_KEY as CONFIG5_147_0_, merchantco0_.TYPE as TYPE147_0_, merchantco0_.MERCHANT_ID as MERCHANT8_147_0_, merchantco0_.VALUE as VALUE147_0_, merchantst1_.STORE_CODE as STORE2_133_1_, merchantst1_.CONTINUESHOPPINGURL as CONTINUE3_133_1_, merchantst1_.COUNTRY_ID as COUNTRY20_133_1_, merchantst1_.CURRENCY_ID as CURRENCY21_133_1_, merchantst1_.CURRENCY_FORMAT_NATIONAL as CURRENCY4_133_1_, merchantst1_.LANGUAGE_ID as LANGUAGE22_133_1_, merchantst1_.DOMAIN_NAME as DOMAIN5_133_1_, merchantst1_.IN_BUSINESS_SINCE as IN6_133_1_, merchantst1_.INVOICE_TEMPLATE as INVOICE7_133_1_, merchantst1_.SEIZEUNITCODE as SEIZEUNI8_133_1_, merchantst1_.STORE_EMAIL as STORE9_133_1_, merchantst1_.STORE_LOGO as STORE10_133_1_, merchantst1_.STORE_TEMPLATE as STORE11_133_1_, merchantst1_.STORE_ADDRESS as STORE12_133_1_, merchantst1_.STORE_CITY as STORE13_133_1_, merchantst1_.STORE_NAME as STORE14_133_1_, merchantst1_.STORE_PHONE as STORE15_133_1_, merchantst1_.STORE_POSTAL_CODE as STORE16_133_1_, merchantst1_.STORE_STATE_PROV as STORE17_133_1_, merchantst1_.USE_CACHE as USE18_133_1_, merchantst1_.WEIGHTUNITCODE as WEIGHTU19_133_1_, merchantst1_.ZONE_ID as ZONE23_133_1_ from SALESMANAGER.MERCHANT_CONFIGURATION merchantco0_ inner join SALESMANAGER.MERCHANT_STORE merchantst1_ on merchantco0_.MERCHANT_ID=merchantst1_.MERCHANT_ID where merchantco0_.MERCHANT_ID=? and merchantco0_.TYPE=?

DEBUG: org.springframework.web.servlet.DispatcherServlet - Rendering view [org.springframework.web.servlet.view.tiles2.TilesView: name 'search.bootstrap'; URL [search.bootstrap]] in DispatcherServlet with name 'appServlet'

DEBUG: org.springframework.web.servlet.view.tiles2.TilesView - Added model object 'q' of type [java.lang.String] to request in view with name 'search.bootstrap'

DEBUG: org.springframework.web.servlet.DispatcherServlet - Successfully completed request

DEBUG: org.springframework.web.servlet.DispatcherServlet - DispatcherServlet with name 'appServlet' processing GET request for [/sm-shop/shop/cart/displayMiniCartByCode.html]

DEBUG: org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerMapping - Looking up handler method for path /shop/cart/displayMiniCartByCode.html

DEBUG: org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerMapping - Returning handler method [public com.salesmanager.web.entity.shoppingcart.ShoppingCartData com.salesmanager.web.shop.controller.shoppingCart.MiniCartController.displayMiniCart(java.lang.String,javax.servlet.http.HttpServletRequest,org.springframework.ui.Model)]

DEBUG: org.springframework.web.servlet.DispatcherServlet - Last-Modified value for [/sm-shop/shop/cart/displayMiniCartByCode.html] is: -1

****** http://localhost:8080/sm-shop/shop/cart/displayMiniCartByCode.html

****** /sm-shop/shop/cart/displayMiniCartByCode.html

*** user.dir ***D:\NEERAJ\apache-tomcat-8.0.26\bin

DEBUG: com.salesmanager.web.filter.StoreFilter - *** user.dir ***D:\NEERAJ\apache-tomcat-8.0.26\bin

Hibernate: select content0_.CONTENT_ID as CONTENT1_167_0_, descriptio1_.DESCRIPTION_ID as DESCRIPT1_168_1_, merchantst2_.MERCHANT_ID as MERCHANT1_133_2_, content0_.DATE_CREATED as DATE2_167_0_, content0_.DATE_MODIFIED as DATE3_167_0_, content0_.UPDT_ID as UPDT4_167_0_, content0_.CODE as CODE167_0_, content0_.CONTENT_POSITION as CONTENT6_167_0_, content0_.CONTENT_TYPE as CONTENT7_167_0_, content0_.MERCHANT_ID as MERCHANT10_167_0_, content0_.SORT_ORDER as SORT8_167_0_, content0_.VISIBLE as VISIBLE167_0_, descriptio1_.DATE_CREATED as DATE2_168_1_, descriptio1_.DATE_MODIFIED as DATE3_168_1_, descriptio1_.UPDT_ID as UPDT4_168_1_, descriptio1_.DESCRIPTION as DESCRIPT5_168_1_, descriptio1_.LANGUAGE_ID as LANGUAGE12_168_1_, descriptio1_.NAME as NAME168_1_, descriptio1_.TITLE as TITLE168_1_, descriptio1_.CONTENT_ID as CONTENT13_168_1_, descriptio1_.META_DESCRIPTION as META8_168_1_, descriptio1_.META_KEYWORDS as META9_168_1_, descriptio1_.META_TITLE as META10_168_1_, descriptio1_.SEF_URL as SEF11_168_1_, descriptio1_.CONTENT_ID as CONTENT13_167_0__, descriptio1_.DESCRIPTION_ID as DESCRIPT1_0__, merchantst2_.STORE_CODE as STORE2_133_2_, merchantst2_.CONTINUESHOPPINGURL as CONTINUE3_133_2_, merchantst2_.COUNTRY_ID as COUNTRY20_133_2_, merchantst2_.CURRENCY_ID as CURRENCY21_133_2_, merchantst2_.CURRENCY_FORMAT_NATIONAL as CURRENCY4_133_2_, merchantst2_.LANGUAGE_ID as LANGUAGE22_133_2_, merchantst2_.DOMAIN_NAME as DOMAIN5_133_2_, merchantst2_.IN_BUSINESS_SINCE as IN6_133_2_, merchantst2_.INVOICE_TEMPLATE as INVOICE7_133_2_, merchantst2_.SEIZEUNITCODE as SEIZEUNI8_133_2_, merchantst2_.STORE_EMAIL as STORE9_133_2_, merchantst2_.STORE_LOGO as STORE10_133_2_, merchantst2_.STORE_TEMPLATE as STORE11_133_2_, merchantst2_.STORE_ADDRESS as STORE12_133_2_, merchantst2_.STORE_CITY as STORE13_133_2_, merchantst2_.STORE_NAME as STORE14_133_2_, merchantst2_.STORE_PHONE as STORE15_133_2_, merchantst2_.STORE_POSTAL_CODE as STORE16_133_2_, merchantst2_.STORE_STATE_PROV as STORE17_133_2_, merchantst2_.USE_CACHE as USE18_133_2_, merchantst2_.WEIGHTUNITCODE as WEIGHTU19_133_2_, merchantst2_.ZONE_ID as ZONE23_133_2_ from SALESMANAGER.CONTENT content0_ left outer join SALESMANAGER.CONTENT_DESCRIPTION descriptio1_ on content0_.CONTENT_ID=descriptio1_.CONTENT_ID left outer join SALESMANAGER.MERCHANT_STORE merchantst2_ on content0_.MERCHANT_ID=merchantst2_.MERCHANT_ID where descriptio1_.LANGUAGE_ID=? and content0_.MERCHANT_ID=? and content0_.CONTENT_TYPE=? and content0_.VISIBLE=? order by content0_.SORT_ORDER asc

DEBUG: org.springframework.web.servlet.DispatcherServlet - DispatcherServlet with name 'appServlet' processing POST request for [/sm-shop/services/public/search/DEFAULT/en/0/12/term.html]

DEBUG: org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerMapping - Looking up handler method for path /services/public/search/DEFAULT/en/0/12/term.html

DEBUG: org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerMapping - Returning handler method [public com.salesmanager.web.entity.catalog.SearchProductList com.salesmanager.web.shop.controller.search.SearchController.search(java.lang.String,java.lang.String,java.lang.String,int,int,org.springframework.ui.Model,javax.servlet.http.HttpServletRequest,javax.servlet.http.HttpServletResponse)]

DEBUG: org.springframework.web.servlet.mvc.method.annotation.RequestResponseBodyMethodProcessor - Reading [java.lang.String] as "application/json;charset=UTF-8" using [org.springframework.http.converter.StringHttpMessageConverter@29d5b0cf]

Hibernate: select shoppingca0_.SHP_CART_ID as SHP1_191_0_, lineitems1_.SHP_CART_ITEM_ID as SHP1_193_1_, attributes2_.SHP_CART_ATTR_ITEM_ID as SHP1_192_2_, merchantst3_.MERCHANT_ID as MERCHANT1_133_3_, shoppingca0_.DATE_CREATED as DATE2_191_0_, shoppingca0_.DATE_MODIFIED as DATE3_191_0_, shoppingca0_.UPDT_ID as UPDT4_191_0_, shoppingca0_.CUSTOMER_ID as CUSTOMER5_191_0_, shoppingca0_.MERCHANT_ID as MERCHANT7_191_0_, shoppingca0_.SHP_CART_CODE as SHP6_191_0_, lineitems1_.DATE_CREATED as DATE2_193_1_, lineitems1_.DATE_MODIFIED as DATE3_193_1_, lineitems1_.UPDT_ID as UPDT4_193_1_, lineitems1_.PRODUCT_ID as PRODUCT5_193_1_, lineitems1_.QUANTITY as QUANTITY193_1_, lineitems1_.SHP_CART_ID as SHP7_193_1_, lineitems1_.SHP_CART_ID as SHP7_191_0__, lineitems1_.SHP_CART_ITEM_ID as SHP1_0__, attributes2_.DATE_CREATED as DATE2_192_2_, attributes2_.DATE_MODIFIED as DATE3_192_2_, attributes2_.UPDT_ID as UPDT4_192_2_, attributes2_.PRODUCT_ATTR_ID as PRODUCT5_192_2_, attributes2_.SHP_CART_ITEM_ID as SHP6_192_2_, attributes2_.SHP_CART_ITEM_ID as SHP6_193_1__, attributes2_.SHP_CART_ATTR_ITEM_ID as SHP1_1__, merchantst3_.STORE_CODE as STORE2_133_3_, merchantst3_.CONTINUESHOPPINGURL as CONTINUE3_133_3_, merchantst3_.COUNTRY_ID as COUNTRY20_133_3_, merchantst3_.CURRENCY_ID as CURRENCY21_133_3_, merchantst3_.CURRENCY_FORMAT_NATIONAL as CURRENCY4_133_3_, merchantst3_.LANGUAGE_ID as LANGUAGE22_133_3_, merchantst3_.DOMAIN_NAME as DOMAIN5_133_3_, merchantst3_.IN_BUSINESS_SINCE as IN6_133_3_, merchantst3_.INVOICE_TEMPLATE as INVOICE7_133_3_, merchantst3_.SEIZEUNITCODE as SEIZEUNI8_133_3_, merchantst3_.STORE_EMAIL as STORE9_133_3_, merchantst3_.STORE_LOGO as STORE10_133_3_, merchantst3_.STORE_TEMPLATE as STORE11_133_3_, merchantst3_.STORE_ADDRESS as STORE12_133_3_, merchantst3_.STORE_CITY as STORE13_133_3_, merchantst3_.STORE_NAME as STORE14_133_3_, merchantst3_.STORE_PHONE as STORE15_133_3_, merchantst3_.STORE_POSTAL_CODE as STORE16_133_3_, merchantst3_.STORE_STATE_PROV as STORE17_133_3_, merchantst3_.USE_CACHE as USE18_133_3_, merchantst3_.WEIGHTUNITCODE as WEIGHTU19_133_3_, merchantst3_.ZONE_ID as ZONE23_133_3_ from SALESMANAGER.SHOPPING_CART shoppingca0_ left outer join SALESMANAGER.SHOPPING_CART_ITEM lineitems1_ on shoppingca0_.SHP_CART_ID=lineitems1_.SHP_CART_ID left outer join SALESMANAGER.SHOPPING_CART_ATTR_ITEM attributes2_ on lineitems1_.SHP_CART_ITEM_ID=attributes2_.SHP_CART_ITEM_ID left outer join SALESMANAGER.MERCHANT_STORE merchantst3_ on shoppingca0_.MERCHANT_ID=merchantst3_.MERCHANT_ID where shoppingca0_.SHP_CART_CODE=? and shoppingca0_.MERCHANT_ID=?

WARN : org.hibernate.hql.internal.ast.QueryTranslatorImpl - HHH000104: firstResult/maxResults specified with collection fetch; applying in memory!

Hibernate: select merchantst0_.MERCHANT_ID as MERCHANT1_133_0_, language1_.LANGUAGE_ID as LANGUAGE1_138_1_, currency2_.CURRENCY_ID as CURRENCY1_139_2_, country3_.COUNTRY_ID as COUNTRY1_134_3_, zone4_.ZONE_ID as ZONE1_136_4_, language6_.LANGUAGE_ID as LANGUAGE1_138_5_, merchantst0_.STORE_CODE as STORE2_133_0_, merchantst0_.CONTINUESHOPPINGURL as CONTINUE3_133_0_, merchantst0_.COUNTRY_ID as COUNTRY20_133_0_, merchantst0_.CURRENCY_ID as CURRENCY21_133_0_, merchantst0_.CURRENCY_FORMAT_NATIONAL as CURRENCY4_133_0_, merchantst0_.LANGUAGE_ID as LANGUAGE22_133_0_, merchantst0_.DOMAIN_NAME as DOMAIN5_133_0_, merchantst0_.IN_BUSINESS_SINCE as IN6_133_0_, merchantst0_.INVOICE_TEMPLATE as INVOICE7_133_0_, merchantst0_.SEIZEUNITCODE as SEIZEUNI8_133_0_, merchantst0_.STORE_EMAIL as STORE9_133_0_, merchantst0_.STORE_LOGO as STORE10_133_0_, merchantst0_.STORE_TEMPLATE as STORE11_133_0_, merchantst0_.STORE_ADDRESS as STORE12_133_0_, merchantst0_.STORE_CITY as STORE13_133_0_, merchantst0_.STORE_NAME as STORE14_133_0_, merchantst0_.STORE_PHONE as STORE15_133_0_, merchantst0_.STORE_POSTAL_CODE as STORE16_133_0_, merchantst0_.STORE_STATE_PROV as STORE17_133_0_, merchantst0_.USE_CACHE as USE18_133_0_, merchantst0_.WEIGHTUNITCODE as WEIGHTU19_133_0_, merchantst0_.ZONE_ID as ZONE23_133_0_, language1_.DATE_CREATED as DATE2_138_1_, language1_.DATE_MODIFIED as DATE3_138_1_, language1_.UPDT_ID as UPDT4_138_1_, language1_.CODE as CODE138_1_, language1_.SORT_ORDER as SORT6_138_1_, currency2_.CURRENCY_CODE as CURRENCY2_139_2_, currency2_.CURRENCY_CURRENCY_CODE as CURRENCY3_139_2_, currency2_.CURRENCY_NAME as CURRENCY4_139_2_, currency2_.CURRENCY_SUPPORTED as CURRENCY5_139_2_, country3_.GEOZONE_ID as GEOZONE4_134_3_, country3_.COUNTRY_ISOCODE as COUNTRY2_134_3_, country3_.COUNTRY_SUPPORTED as COUNTRY3_134_3_, zone4_.ZONE_CODE as ZONE2_136_4_, zone4_.COUNTRY_ID as COUNTRY3_136_4_, language6_.DATE_CREATED as DATE2_138_5_, language6_.DATE_MODIFIED as DATE3_138_5_, language6_.UPDT_ID as UPDT4_138_5_, language6_.CODE as CODE138_5_, language6_.SORT_ORDER as SORT6_138_5_, languages5_.stores_MERCHANT_ID as stores1_133_0__, languages5_.languages_LANGUAGE_ID as languages2_0__ from SALESMANAGER.MERCHANT_STORE merchantst0_ inner join SALESMANAGER.LANGUAGE language1_ on merchantst0_.LANGUAGE_ID=language1_.LANGUAGE_ID left outer join SALESMANAGER.CURRENCY currency2_ on merchantst0_.CURRENCY_ID=currency2_.CURRENCY_ID left outer join SALESMANAGER.COUNTRY country3_ on merchantst0_.COUNTRY_ID=country3_.COUNTRY_ID left outer join SALESMANAGER.ZONE zone4_ on merchantst0_.ZONE_ID=zone4_.ZONE_ID left outer join SALESMANAGER.MERCHANT_LANGUAGE languages5_ on merchantst0_.MERCHANT_ID=languages5_.stores_MERCHANT_ID left outer join SALESMANAGER.LANGUAGE language6_ on languages5_.languages_LANGUAGE_ID=language6_.LANGUAGE_ID where merchantst0_.STORE_CODE=?

DEBUG: org.springframework.web.servlet.mvc.method.annotation.RequestResponseBodyMethodProcessor - Written [com.salesmanager.web.entity.shoppingcart.ShoppingCartData@dc5b58c] as "application/json;charset=UTF-8" using [org.springframework.http.converter.json.MappingJackson2HttpMessageConverter@4e32d9a5]

DEBUG: org.springframework.web.servlet.DispatcherServlet - Null ModelAndView returned to DispatcherServlet with name 'appServlet': assuming HandlerAdapter completed request handling

DEBUG: org.springframework.web.servlet.DispatcherServlet - Successfully completed request

ERROR: org.hibernate.hql.internal.ast.ErrorCounter - <AST>:0:0: unexpected end of subtree

<AST>:0:0: unexpected end of subtree

at org.hibernate.hql.internal.antlr.HqlSqlBaseWalker.fromElementList(HqlSqlBaseWalker.java:3164)

at org.hibernate.hql.internal.antlr.HqlSqlBaseWalker.fromClause(HqlSqlBaseWalker.java:706)

at org.hibernate.hql.internal.antlr.HqlSqlBaseWalker.query(HqlSqlBaseWalker.java:562)

at org.hibernate.hql.internal.antlr.HqlSqlBaseWalker.collectionFunctionOrSubselect(HqlSqlBaseWalker.java:4485)

at org.hibernate.hql.internal.antlr.HqlSqlBaseWalker.inRhs(HqlSqlBaseWalker.java:4390)

at org.hibernate.hql.internal.antlr.HqlSqlBaseWalker.comparisonExpr(HqlSqlBaseWalker.java:4065)

at org.hibernate.hql.internal.antlr.HqlSqlBaseWalker.logicalExpr(HqlSqlBaseWalker.java:1935)

at org.hibernate.hql.internal.antlr.HqlSqlBaseWalker.logicalExpr(HqlSqlBaseWalker.java:1860)

at org.hibernate.hql.internal.antlr.HqlSqlBaseWalker.whereClause(HqlSqlBaseWalker.java:794)

at org.hibernate.hql.internal.antlr.HqlSqlBaseWalker.query(HqlSqlBaseWalker.java:595)

at org.hibernate.hql.internal.antlr.HqlSqlBaseWalker.selectStatement(HqlSqlBaseWalker.java:299)

at org.hibernate.hql.internal.antlr.HqlSqlBaseWalker.statement(HqlSqlBaseWalker.java:247)

at org.hibernate.hql.internal.ast.QueryTranslatorImpl.analyze(QueryTranslatorImpl.java:248)

at org.hibernate.hql.internal.ast.QueryTranslatorImpl.doCompile(QueryTranslatorImpl.java:183)

at org.hibernate.hql.internal.ast.QueryTranslatorImpl.compile(QueryTranslatorImpl.java:136)

at org.hibernate.engine.query.spi.HQLQueryPlan.<init>(HQLQueryPlan.java:105)

at org.hibernate.engine.query.spi.HQLQueryPlan.<init>(HQLQueryPlan.java:80)

at org.hibernate.engine.query.spi.QueryPlanCache.getHQLQueryPlan(QueryPlanCache.java:168)

at org.hibernate.internal.AbstractSessionImpl.getHQLQueryPlan(AbstractSessionImpl.java:216)

at org.hibernate.internal.SessionImpl.list(SessionImpl.java:1207)

at org.hibernate.internal.QueryImpl.list(QueryImpl.java:101)

at org.hibernate.ejb.QueryImpl.getResultList(QueryImpl.java:256)

at com.mysema.query.jpa.impl.AbstractJPAQuery.getResultList(AbstractJPAQuery.java:195)

at com.mysema.query.jpa.impl.AbstractJPAQuery.list(AbstractJPAQuery.java:243)

at com.salesmanager.core.business.catalog.category.dao.CategoryDaoImpl.getByCodes(CategoryDaoImpl.java:114)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

at java.lang.reflect.Method.invoke(Method.java:497)

at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317)

at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)

at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)

at org.springframework.dao.support.PersistenceExceptionTranslationInterceptor.invoke(PersistenceExceptionTranslationInterceptor.java:155)

at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)

at org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:96)

at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:260)

at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:94)

at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)

at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)

at com.sun.proxy.$Proxy216.getByCodes(Unknown Source)

at com.salesmanager.core.business.catalog.category.service.CategoryServiceImpl.listByCodes(CategoryServiceImpl.java:72)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

at java.lang.reflect.Method.invoke(Method.java:497)

at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317)

at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)

at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)

at org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:96)

at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:260)

at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:94)

at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:161)

at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:91)

at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)

at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)

at com.sun.proxy.$Proxy220.listByCodes(Unknown Source)

at com.salesmanager.web.shop.controller.search.SearchController.search(SearchController.java:239)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

at java.lang.reflect.Method.invoke(Method.java:497)

at org.springframework.web.method.support.InvocableHandlerMethod.invoke(InvocableHandlerMethod.java:215)

at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:132)

at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:104)

at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandleMethod(RequestMappingHandlerAdapter.java:743)

at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:672)

at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:82)

at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:933)

at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:867)

at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:951)

at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:853)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:648)

at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:827)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:291)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)

at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)

at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:330)

at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:118)

at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:84)

at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)

at org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:113)

at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)

at org.springframework.security.web.authentication.AnonymousAuthenticationFilter.doFilter(AnonymousAuthenticationFilter.java:113)

at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)

at org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:154)

at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)

at org.springframework.security.web.authentication.www.BasicAuthenticationFilter.doFilter(BasicAuthenticationFilter.java:150)

at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)

at org.springframework.security.web.authentication.ui.DefaultLoginPageGeneratingFilter.doFilter(DefaultLoginPageGeneratingFilter.java:155)

at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)

at org.springframework.security.web.authentication.AbstractAuthenticationProcessingFilter.doFilter(AbstractAuthenticationProcessingFilter.java:199)

at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)

at org.springframework.security.web.context.request.async.WebAsyncManagerIntegrationFilter.doFilterInternal(WebAsyncManagerIntegrationFilter.java:50)

at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:106)

at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)

at org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:87)

at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)

at org.springframework.security.web.FilterChainProxy.doFilterInternal(FilterChainProxy.java:192)

at org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:160)

at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:343)

at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:260)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)

at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:88)

at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:106)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)

at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:219)

at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:106)

at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:502)

at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:142)

at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:79)

at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:616)

at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:88)

at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:518)

at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1091)

at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:673)

at org.apache.tomcat.util.net.AprEndpoint$SocketProcessor.doRun(AprEndpoint.java:2503)

at org.apache.tomcat.util.net.AprEndpoint$SocketProcessor.run(AprEndpoint.java:2492)

at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)

at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)

at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)

at java.lang.Thread.run(Thread.java:745)

ERROR: com.salesmanager.web.shop.controller.search.SearchController - Exception occured while querying {"query":{"query_string" : {"fields" : ["name^3", "description", "tags"], "query" : "*Spring in Action*", "use_dis_max" : true }},"facets" : { "categories" : { "terms" : {"field" : "categories"}}}}

org.springframework.dao.InvalidDataAccessApiUsageException: org.hibernate.hql.internal.ast.QuerySyntaxException: unexpected end of subtree [select category

from com.salesmanager.core.business.catalog.category.model.Category category

left join fetch category.descriptions as categoryDescription

left join fetch category.merchantStore

where category.code in () and category.merchantStore.id = ?2 and categoryDescription.language.id = ?2

order by category.sortOrder asc, category.lineage asc, category.lineage asc, category.depth asc, categoryDescription.language.id desc]; nested exception is java.lang.IllegalArgumentException: org.hibernate.hql.internal.ast.QuerySyntaxException: unexpected end of subtree [select category

from com.salesmanager.core.business.catalog.category.model.Category category

left join fetch category.descriptions as categoryDescription

left join fetch category.merchantStore

where category.code in () and category.merchantStore.id = ?2 and categoryDescription.language.id = ?2

order by category.sortOrder asc, category.lineage asc, category.lineage asc, category.depth asc, categoryDescription.language.id desc]

at org.springframework.orm.jpa.EntityManagerFactoryUtils.convertJpaAccessExceptionIfPossible(EntityManagerFactoryUtils.java:296)

at org.springframework.orm.jpa.vendor.HibernateJpaDialect.translateExceptionIfPossible(HibernateJpaDialect.java:108)

at org.springframework.orm.jpa.AbstractEntityManagerFactoryBean.translateExceptionIfPossible(AbstractEntityManagerFactoryBean.java:403)

at org.springframework.dao.support.ChainedPersistenceExceptionTranslator.translateExceptionIfPossible(ChainedPersistenceExceptionTranslator.java:58)

at org.springframework.dao.support.DataAccessUtils.translateIfNecessary(DataAccessUtils.java:213)

at org.springframework.dao.support.PersistenceExceptionTranslationInterceptor.invoke(PersistenceExceptionTranslationInterceptor.java:163)