Setting up the inventory search index

In this lesson, the inventory index artifacts are created into the search server runtime. As a result, the inventory core is loaded when the search server is started.

Procedure

Run the SetupSearchIndex utility to deploy the Inventory index.
- setupSearchIndex.bat -masterCatalogId masterCatalogId -indexsubtype Inventory
- setupSearchIndex.bat -instance instance_name -masterCatalogId masterCatalogId -dbuser db_user -dbuserpwd db_password -indexsubtype Inventory
- setupSearchIndex.sh -instance instance_name -masterCatalogId masterCatalogId -dbuser db_user -dbuserpwd db_password -indexsubtype Inventory
For example: setupSearchIndex.bat -masterCatalogId 10001 -indexsubtype Inventory
To get the store ID of the AuroraEsite store:
1. Run the following SQL query:
```
select STOREENT_ID from STOREENT where IDENTIFIER='AuroraESite';
```
2. Run the following SQL query using the query response (STOREENT_ID 10152):
```
select RELATEDSTORE_ID from STOREREL where STORE_ID=10152 and STRELTYP_ID=-4 and RELATEDSTORE_ID not in (10152);
```
3. Run the following SQL query using the query response (RELATEDSTORE_ID 10051):
```
select CATALOG_ID from STORECAT where STOREENT_ID=10051 and MASTERCATALOG='1';
```
4. The resulting Master Catalog ID for the AuroraEsite store is 10001.
Start the test server.

Verify the inventory index at the following URL:

http://localhost/solr/MC_10051_CatalogEntry_Inventory_generic/select?q=*

The response from the URL should resemble the following snippet:


<?xml version="1.0" encoding="UTF-8"?>
-<response> 
   -<lst name="responseHeader">
      <int name="status">0</int>
      <int name="QTime">62</int>
      -<lst name="params">
         <str name="q">*</str>
      </lst>
   </lst>
   <result name="response" start="0" numFound="0"/> 
</response>