has anyone ever got the following trying to retrieve a catalog search from B2C store

Spryker\Client\SearchElasticsearch\Exception\SearchResponseException - Exception: Search failed with the following
reason: failed to create query: {
"bool" : {
"must" : [
{
"match_all" : {
"boost" : 1.0
}
},
{
"match" : {
"type" : {
"query" : "product_abstract",
"operator" : "OR",
"prefix_length" : 0,
"max_expansions" : 50,
"fuzzy_transpositions" : true,
"lenient" : false,
"zero_terms_query" : "NONE",
"auto_generate_synonyms_phrase_query" : true,
"boost" : 1.0
}
}
},
{
"match" : {
"store" : {
"query" : "DE",
"operator" : "OR",
"prefix_length" : 0,
"max_expansions" : 50,
"fuzzy_transpositions" : true,
"lenient" : false,
"zero_terms_query" : "NONE",
"auto_generate_synonyms_phrase_query" : true,
"boost" : 1.0
}
}
},
{
"match" : {
"locale" : {
"query" : "en_US",
"operator" : "OR",
"prefix_length" : 0,
"max_expansions" : 50,
"fuzzy_transpositions" : true,
"lenient" : false,
"zero_terms_query" : "NONE",
"auto_generate_synonyms_phrase_query" : true,
"boost" : 1.0
}
}
},
{
"match" : {
"is-active" : {
"query" : true,
"operator" : "OR",
"prefix_length" : 0,
"max_expansions" : 50,
"fuzzy_transpositions" : true,
"lenient" : false,
"zero_terms_query" : "NONE",
"auto_generate_synonyms_phrase_query" : true,
"boost" : 1.0
}
}
},
{
"bool" : {
"should" : [
{
"match_none" : {
"boost" : 1.0
}
},
{
"bool" : {
"must_not" : [
{
"exists" : {
"field" : "active-from",
"boost" : 1.0
}
}
],
"adjust_pure_negative" : true,
"boost" : 1.0
}
}
],
"adjust_pure_negative" : true,
"boost" : 1.0
}
},
{
"bool" : {
"should" : [
{
"match_none" : {
"boost" : 1.0
}
},
{
"bool" : {
"must_not" : [
{
"exists" : {
"field" : "active-to",
"boost" : 1.0
}
}
],
"adjust_pure_negative" : true,
"boost" : 1.0
}
}
],
"adjust_pure_negative" : true,
"boost" : 1.0
}
}
],
"filter" : [
{
"nested" : {
"query" : {
"term" : {
"integer-facet.facet-name" : {
"value" : "price-DEFAULT-EUR-GROSS_MODE",
"boost" : 1.0
}
}
},
"path" : "integer-facet",
"ignore_unmapped" : false,
"score_mode" : "avg",
"boost" : 1.0
}
}
],
"adjust_pure_negative" : true,
"boost" : 1.0
}
} [index: spryker_b2c_dev_de_page] [reason: all shards failed]. Query:
{"query":{"bool":{"must":[{"match_all":{}},{"match":{"type":"product_abstract"}},{"match":{"store":"DE"}},{"match":{"locale":"en_US"}},{"match":{"is-active":true}},{"bool":{"should":[{"range":{"active-from":{"lte":"now"}}},{"bool":{"must_not":[{"exists":{"field":"active-from"}}]}}]}},{"bool":{"should":[{"range":{"active-to":{"gte":"now"}}},{"bool":{"must_not":[{"exists":{"field":"active-to"}}]}}]}}],"filter":[{"nested":{"query":{"term":{"integer-facet.facet-name":{"value":"price-DEFAULT-EUR-GROSS_MODE","boost":1}}},"path":"integer-facet"}}]}},"suggest":{"text":""},"_source":["search-result-data"],"from":0,"size":12,"aggs":{"category.all-parents.category":{"terms":{"field":"category.all-parents","size":1000}},"integer-facet":{"nested":{"path":"integer-facet"},"aggs":{"integer-facet-name":{"terms":{"field":"integer-facet.facet-name","size":10},"aggs":{"integer-facet-stats":{"stats":{"field":"integer-facet.facet-value"}}}}}},"string-facet":{"nested":{"path":"string-facet"},"aggs":{"string-facet-name":{"terms":{"field":"string-facet.facet-name","size":10},"aggs":{"string-facet-value":{"terms":{"field":"string-facet.facet-value"}}}}}}}}
in /data/vendor/spryker/search-elasticsearch/src/Spryker/Client/SearchElasticsearch/Search/Search.php (90)

Request URI: /catalog-search?q=

Trace:
#0 /data/vendor/spryker/search-elasticsearch/src/Spryker/Client/SearchElasticsearch/Search/Search.php(44):
Spryker\Client\SearchElasticsearch\Search\Search->executeQuery(Object(Spryker\Client\Catalog\Plugin\Elasticsearch\Query\ProductCatalogSearchQueryPlugin))
#1 /data/vendor/spryker/search-elasticsearch/src/Spryker/Client/SearchElasticsearch/Search/LoggableSearch.php(44):
Spryker\Client\SearchElasticsearch\Search\Search->search(Object(Spryker\Client\Catalog\Plugin\Elasticsearch\Query\ProductCatalogSearchQueryPlugin),
Array, Array)
#2 /data/vendor/spryker/search-elasticsearch/src/Spryker/Client/SearchElasticsearch/SearchElasticsearchClient.php(33):
Spryker\Client\SearchElasticsearch\Search\LoggableSearch->search(Object(Spryker\Client\Catalog\Plugin\Elasticsearch\Query\ProductCatalogSearchQueryPlugin),
Array, Array)
#3
/data/vendor/spryker/search-elasticsearch/src/Spryker/Client/SearchElasticsearch/Plugin/ElasticsearchSearchAdapterPlugin.php(40):
Spryker\Client\SearchElasticsearch\SearchElasticsearchClient->search(Object(Spryker\Client\Catalog\Plugin\Elasticsearch\Query\ProductCatalogSearchQueryPlugin),
Array, Array)
#4 /data/vendor/spryker/search/src/Spryker/Client/Search/Delegator/SearchDelegator.php(55):
Spryker\Client\SearchElasticsearch\Plugin\ElasticsearchSearchAdapterPlugin->search(Object(Spryker\Client\Catalog\Plugin\Elasticsearch\Query\ProductCatalogSearchQueryPlugin),
Array, Array)
#5 /data/vendor/spryker/search/src/Spryker/Client/Search/SearchClient.php(82):
Spryker\Client\Search\Delegator\SearchDelegator->search(Object(Spryker\Client\Catalog\Plugin\Elasticsearch\Query\ProductCatalogSearchQueryPlugin),
Array, Array)
#6 /data/vendor/spryker/catalog/src/Spryker/Client/Catalog/CatalogClient.php(48):
Spryker\Client\Search\SearchClient->search(Object(Spryker\Client\Catalog\Plugin\Elasticsearch\Query\ProductCatalogSearchQueryPlugin),
Array, Array)
#7
/data/vendor/spryker/catalog-search-rest-api/src/Spryker/Glue/CatalogSearchRestApi/Dependency/Client/CatalogSearchRestApiToCatalogClientBridge.php(33):
Spryker\Client\Catalog\CatalogClient->catalogSearch('', Array)
#8
/data/vendor/spryker/catalog-search-rest-api/src/Spryker/Glue/CatalogSearchRestApi/Processor/Catalog/CatalogSearchReader.php(103):
Spryker\Glue\CatalogSearchRestApi\Dependency\Client\CatalogSearchRestApiToCatalogClientBridge->catalogSearch('', Array)
#9
/data/vendor/spryker/catalog-search-rest-api/src/Spryker/Glue/CatalogSearchRestApi/Controller/CatalogSearchResourceController.php(48):
Spryker\Glue\CatalogSearchRestApi\Processor\Catalog\CatalogSearchReader->catalogSearch(Object(Spryker\Glue\GlueApplication\Rest\Request\Data\RestRequest))
#10 /data/vendor/spryker/glue-application/src/Spryker/Glue/GlueApplication/Rest/ControllerFilter.php(203):
Spryker\Glue\CatalogSearchRestApi\Controller\CatalogSearchResourceController->getAction(Object(Spryker\Glue\GlueApplication\Rest\Request\Data\RestRequest),
NULL)
#11 /data/vendor/spryker/glue-application/src/Spryker/Glue/GlueApplication/Rest/ControllerFilter.php(223):
Spryker\Glue\GlueApplication\Rest\ControllerFilter->processResource(Object(Spryker\Glue\CatalogSearchRestApi\Controller\CatalogSearchResourceController),
'getAction', Object(Spryker\Glue\GlueApplication\Rest\Request\Data\RestRequest))
#12 /data/vendor/spryker/glue-application/src/Spryker/Glue/GlueApplication/Rest/ControllerFilter.php(185):
Spryker\Glue\GlueApplication\Rest\ControllerFilter->executeAction(Object(Spryker\Glue\CatalogSearchRestApi\Controller\CatalogSearchResourceController),
'getAction', Object(Spryker\Glue\GlueApplication\Rest\Request\Data\RestRequest))
#13 /data/vendor/spryker/glue-application/src/Spryker/Glue/GlueApplication/Rest/ControllerFilter.php(155):
Spryker\Glue\GlueApplication\Rest\ControllerFilter->getRestResponse(Object(Spryker\Glue\GlueApplication\Rest\Request\Data\RestRequest),
NULL, Object(Spryker\Glue\CatalogSearchRestApi\Controller\CatalogSearchResourceController), 'getAction')
#14
/data/vendor/spryker/glue-application/src/Spryker/Glue/GlueApplication/Plugin/EventDispatcher/GlueRestControllerListenerEventDispatcherPlugin.php(69):
Spryker\Glue\GlueApplication\Rest\ControllerFilter->filter(Object(Spryker\Glue\CatalogSearchRestApi\Controller\CatalogSearchResourceController),
'getAction', Object(Symfony\Component\HttpFoundation\Request))
#15
/data/vendor/spryker/glue-application/src/Spryker/Glue/GlueApplication/Plugin/EventDispatcher/GlueRestControllerListenerEventDispatcherPlugin.php(54):
Spryker\Glue\GlueApplication\Plugin\EventDispatcher\GlueRestControllerListenerEventDispatcherPlugin->filter(Object(Spryker\Glue\CatalogSearchRestApi\Controller\CatalogSearchResourceController),
'getAction', Object(Symfony\Component\HttpFoundation\Request))
#16 /data/vendor/symfony/http-kernel/HttpKernel.php(157):
Spryker\Glue\GlueApplication\Plugin\EventDispatcher\GlueRestControllerListenerEventDispatcherPlugin->Spryker\Glue\GlueApplication\Plugin\EventDispatcher\{closure}()
#17 /data/vendor/symfony/http-kernel/HttpKernel.php(79):
Symfony\Component\HttpKernel\HttpKernel->handleRaw(Object(Symfony\Component\HttpFoundation\Request), 1)
#18 /data/vendor/spryker/application/src/Spryker/Shared/Application/Application.php(132):
Symfony\Component\HttpKernel\HttpKernel->handle(Object(Symfony\Component\HttpFoundation\Request))
#19 /data/vendor/spryker/application/src/Spryker/Shared/Application/Application.php(110):
Spryker\Shared\Application\Application->handle(Object(Symfony\Component\HttpFoundation\Request))
#20 /data/public/Glue/index.php(37): Spryker\Shared\Application\Application->run()
#21 {main}

What is the recommended way to guard specific routes in Spryker? For example if user does not have role assigned, route is not accessible

Hey Spryks…! What’s the best way to log something out to the log files for when debugging the CLI? For instance… when running import commands and there are Writer exceptions etc.

I add additional permissions to

data/import/common/common/company_role_permission.csv

and specifically those permissions fail to import. The plugins are registered on both Zed and Client. What could be cause ?

Hey has anyone had issues with getting products to return on, “api.spryker.local/catalog-search?q=” ? It’s not returning any products which all seem to imported correctly with stores and prices etc… ?

Hey guys, has anyone encountered the issue that abstract-products are not getting synced to elasticsearch, they appear in both DB and Redis, but not ES. Concrete products and another custom item has arrived in elastic search but not abstract products? This is a blocker to getting a response on the catalogue-search endpoint, any ideas ?

Hi guys, i have a problem while trying to implement Unzer as payment provider. The issue is that on payment page on checkout the payment methods are shown somehow broken. I'm guessing that step 9 on this page is not described well because the method with the name "extendSubFormPluginCollection" is not called anywhere. I tried to replace this method with "addSubFormPluginCollection", but again it's not fully working as i described earlier. Please see this image on checkout/payment page:

Hey all… We’re having problems with data syncing to Elastic Search… we are getting both abstract and concrete products on the API endpoint when we ask for a single product, but when we run a catalog search, we get no Abstract product returned. It looks like the DB data is fine, but we are getting RabbitMQ errors on sync.search.product.error:

{"write":{"key":"product_abstract:de:de_de:1","value":{"store":"DE","locale":"de_DE","type":"product_abstract","is-active":true,"search-result-data":{"id_product_abstract":1,"abstract_sku":"1","abstract_name":"Loose Brown Onions","url":"\/de\/1","type":"product_abstract","price":69,"prices":{"EUR":{"priceData":null,"priceDataByPriceType":{"DEFAULT":null,"":null},"GROSS_MODE":{"DEFAULT":69,"":69},"NET_MODE":{"DEFAULT":69,"":69}}},"images":[],"id_product_labels":[]},"full-text-boosted":["Loose Brown Onions","1"],"full-text":["Loose Brown Onions","1001","Great in soups, stews, stir fry\u0027s or even a salad. Delicious Caramelised.\nPacks flavour into any meal"],"suggestion-terms":["Loose Brown Onions"],"completion-terms":["Loose Brown Onions"],"string-sort":{"name":"Loose Brown Onions"},"integer-sort":{"price":69,"price-DEFAULT-EUR-NET_MODE":69,"price--EUR-NET_MODE":69,"price-DEFAULT-EUR-GROSS_MODE":69,"price--EUR-GROSS_MODE":69},"integer-facet":[{"facet-name":"price","facet-value":[69]},{"facet-name":"price-DEFAULT-EUR-NET_MODE","facet-value":[69]},{"facet-name":"price--EUR-NET_MODE","facet-value":[69]},{"facet-name":"price-DEFAULT-EUR-GROSS_MODE","facet-value":[69]},{"facet-name":"price--EUR-GROSS_MODE","facet-value":[69]}],"category":{"all-parents":[],"direct-parents":[]},"_timestamp":1656425330.955626},"resource":"product_abstract","params":{"type":"page"}},"errorMessage":"Error in one or more bulk request actions:\n\nindex: \/spryker_b2c_dev_de_page\/_doc\/product_abstract:de:de_de:1 caused failed to parse\nindex: \/spryker_b2c_dev_de_page\/_doc\/product_abstract:de:de_de:2 caused failed to parse\nindex: \/spryker_b2c_dev_de_page\/_doc\/product_abstract:de:de_de:3 caused failed to parse\nindex: \/spryker_b2c_dev_de_page\/_doc\/product_abstract:de:de_de:4 caused failed to parse\nindex: \/spryker_b2c_dev_de_page\/_doc\/product_abstract:de:de_de:5 caused failed to parse\nindex: 

etc etc....

....

We’ve checked over our data to make sure it’s good shape… (no non-UTF characters etc) … We’re at a loss as to why things aren’t syncing. It looks like there is some parsing errors when trying to create the abstract product.

Hello Everyone,

I am wondering how can I remove the default warehouses that comes with Spryker B2C marketplace. I have already removed them from the data import files but still there are few warehouses that are coming from somewhere which I am unable to locate. Tried searching these warehouse names in all the files but can't find them anywhere. Can anybody please help me out?

Hey guys! Does someone maybe has a SQL Query to remove orders and all related enities? I want to remove some testdata

Hi, Is there some reference docs on how to integrate Glue API with Spryker Middleware? Thank you!

Hello there! I have a question about OMS. Is it possible on Spryker to place an order with 2 different OMSs for specific products? In my case shop is selling digital product and physical products, and i want buyer to be able to place an order with mixed products digital and physical, but OMS should be deferent for each type.

Thank you!

Hi there,

I have query

can we add multiple row value in a single transfer ?

I have installed middleware and when I run import command for middleware, getting this error:

Spryker\Zed\Kernel\Exception\Container\ContainerKeyNotFoundException - Exception: Spryker Kernel Exception

Container does not contain the called "ANTELOPE_STAGE_PLUGIN_STACK"

You can fix this by adding the key "ANTELOPE_STAGE_PLUGIN_STACK" to your "AntelopeMiddlewareConnectorDependencyProvider"

in /data/vendor/spryker/kernel/src/Spryker/Zed/Kernel/BundleDependencyProviderResolverAwareTrait.php (51)

I have already defined constant in

AntelopeMiddlewareConnectorDependencyProvider

despite showing this error; can anyone help me please?

Hey there, 3 days ago the propel packages got updated and now using the latest propel/propel. Now the generated orm classes are different from the provided ModelCriteria. Can anyone confirm that?

Hello. Did some one faced with the error?

Command dependencies-install [vendor/bin/console frontend:project:install-dependencies] (In progress...)
Store: DE | Environment: docker
Error - Exception: Class "\Orm\Zed\AclStorage\Persistence\Map\PyzAclStorageTableMap" not found 
in /data/vendor/propel/propel/src/Propel/Runtime/Map/DatabaseMap.php (115)

Command: vendor/bin/console frontend:project:install-dependencies

Trace: 
#0 [internal function]: Propel\Runtime\Map\DatabaseMap->addTableFromMapClass('\\Orm\\Zed\\AclSto...')
#1 /data/vendor/propel/propel/src/Propel/Runtime/ServiceContainer/StandardServiceContainer.php(264): array_map(Array, Array)
#2 /data/data/cache/propel/generated-conf/loadDatabase.php(6): Propel\Runtime\ServiceContainer\StandardServiceContainer->initDatabaseMaps(Array)
#3 /data/vendor/spryker/propel/src/Spryker/Zed/Propel/Business/Model/PropelTableMapLoader.php(45): require('/data/data/cach...')
#4 /data/vendor/spryker/propel/src/Spryker/Zed/Propel/Business/PropelFacade.php(317): Spryker\Zed\Propel\Business\Model\PropelTableMapLoader->loadTableMap()
#5 /data/vendor/spryker/propel/src/Spryker/Zed/Propel/Communication/Plugin/Application/PropelApplicationPlugin.php(47): Spryker\Zed\Propel\Business\PropelFacade->loadPropelTableMap()
#6 /data/vendor/spryker/application/src/Spryker/Shared/Application/Application.php(81): Spryker\Zed\Propel\Communication\Plugin\Application\PropelApplicationPlugin->provide(Object(Spryker\Shared\Kernel\Container\ContainerProxy))
#7 /data/vendor/spryker/application/src/Spryker/Shared/Application/Application.php(70): Spryker\Shared\Application\Application->registerApplicationPlugin(Object(Spryker\Zed\Propel\Communication\Plugin\Application\PropelApplicationPlugin))
#8 /data/vendor/spryker/console/src/Spryker/Zed/Console/Communication/ConsoleCommunicationFactory.php(30): Spryker\Shared\Application\Application->__construct(Object(Spryker\Shared\Kernel\Container\ContainerProxy), Array)
#9 /data/vendor/spryker/console/src/Spryker/Zed/Console/Communication/Bootstrap/ConsoleBootstrap.php(104): Spryker\Zed\Console\Communication\ConsoleCommunicationFactory->createApplication()
#10 /data/vendor/symfony/console/Application.php(149): Spryker\Zed\Console\Communication\Bootstrap\ConsoleBootstrap->doRun(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))
#11 /data/vendor/spryker/console/bin/console(27): Symfony\Component\Console\Application->run()
#12 {main}
In CommandLineExecutable.php line 107:
            
 Aborted install...  
            

install [-r|--recipe RECIPE] [-d|--dry-run] [-s|--sections SECTIONS] [-g|--groups GROUPS] [-x|--exclude EXCLUDE] [-e|--include-excluded INCLUDE-EXCLUDED] [-i|--interactive] [-b|--breakpoint] [-a|--ask-before-continue] [-l|--log] [--] [<store>]

Looks some problem with vendor

Hello , Is it possible to import category Data using "QUEUE"? Thank You

Hi there, we recently updated our Spryker project, in specific we updated spryker/propel-orm and hence propel/propel from 2.0.0-beta1 to 2.0.0-beta2. Now all our demo data and testing fixture data fails where we have dates like '2050-12-31'. Propel tells us, that this is an invalid datetime format. '2037-12-31' works however. Anybody seen that and has a clue what is causing this?

Hi. Is there a way to change only a block on a Zed Gui module twig template without copying and overriding the whole file?

I think I’ve just noticed a typo in the column definition of the

spy_oauth_access_token

table: https://github.com/spryker/oauth/blob/master/src/Spryker/Zed/Oauth/Persistence/Propel/Schema/spy_oauth.schema.xml#L12 Should be

<column name="expiry_date" type="TIMESTAMP" required="true"/>

?

Is it possible to condition check if a slot is active or not in a twig template? Right now we have a jumbotron carousel that is rendered everytime, but it is only needed when a certain slot is active. Any chance to check that in the twig template?

Hello guys, Is there a way to define custom glue api url like orders/orderId/details/addressId? +orderId, addressId is path variable I check spryker document but can't find any article related to this feature. Thanks in advance

Hi everyone, I upgraded docker/sdk, than i upgraded elasticsearch and kibana to "7.10" version. Now both docker/sdk up and docker/sdk reset fail on command

vendor/bin/console propel:tables:drop

with error "Database not reachable." Has anyone encountered problem like this?

Hello everyone, we tried setting up out local development environment with a Mac M1 machine and our Project (Yves and Zed). For this we used both • 1 try: docker/sdk on master branch + update deploy.dev.yml like https://docs.spryker.com/docs/scos/dev/setup/installing-spryker-with-docker/installat[…]uides/installing-in-development-mode-on-macos-and-linux.html describes • and 2 try: on the m1-adjustments branch from docker/sdk So both seems been working, as the application starts without problems. Now we tried the frontend file generation / assets + static assets build from Yves — > which results into some issues caused by the node-sass problem with M1 (on arm machines). For that we had an information to update some packages in the package.json:

-    "@spryker/oryx-for-zed": "~2.10.1",
+    "@spryker/oryx-for-zed": "~2.11.5",

-    "node-sass": "~4.14.1",

+    "sass": "~1.32.13",

-    "sass-loader": "~8.0.0",
+    "sass-loader": "~10.2.0",

and a simple change at development.js like this page describes: https://docs.spryker.com/docs/scos/dev/setup/installing-spryker-with-docker/installat[…]uides/installing-in-development-mode-on-macos-and-linux.html - changing node-sass with sass package So now we were able to build our Yves frontend again and it was working, also with the watch script - working well so far. But now with the adjustments fron new npm packages, we’re face with an issue in the Zed backend. The publicPath for generating assets now changes from /public/Zed to /public/Backoffice --> this could be fixed by overwriting the configuration.path with zed-build.js - for our dev reasons okay so far.

// From this
api.getConfiguration(settings)
    .then(configuration => oryx.build(configuration))
    .catch(error => console.error('An error occurred while creating configuration', error));

// to this
api.getConfiguration(settings)
    .then(configuration => {
        configuration.output.path = '/data/public/Zed/assets/'
        oryx.build(configuration)
    })
    .catch(error => console.error('An error occurred while creating configuration', error));

This leads to a shiny Zed Backend with css and js. Well done or? The only thing we have problem currently is that dataTabels ain’t working again. And we couldn’t find the reason for this. So the question is, has anyone the same issue with Zed / Backoffice assets generation and has anyone an idea how to fix dataTables issues with this M1 setup and can us help?

Anyone had problem with

docker/sdk up

? `Getting `Service

database

is not running. Please check the name.`

Hello All, I need some help to extend user profile fields for spryker B2C. can anyone help?