Thursday, October 27, 2016

SOlr configuration steps

SOlr configuration steps


The Following Steps should be followed to configure (Commands are case-sensitive)

1 Stop the server 

2 Go To Db2Console/CMD Prompt then click on the database and search for the store table and check the STORE_ID (DEFAULT IS 10001)

3 Then go to DB2CMD or CMD

4 Go to path "C:\IBM\WCDE_ENT70\components\foundation\subcomponents\search\bin"

5 And Run the following command(Without Quotes)
 "setupSearchIndex.bat -masterCatalogId 10001"

6 10001 is the STORE_ID

7 Start the Server now

8 Now again go to the path "C:\IBM\WCDE_ENT70\bin"

9 Execute the command (Without Quotes)
"di-preprocess.bat c:\IBM\WCDE_ENT70\search\pre-
processConfig\MC_10001\DB2"

10 Execute the command (Without Quotes)
"di-buildindex.bat -masterCatalogId 10001"

Note:
The exit code should be '0' for both the Commands or Batch processes... 

If the Exit code is '3' then Re-Run the command with the parameter "-force true" which means run this forcebily even if there is any other scheduled Preprocess/buildindex is running. Refer the below links for more information.

Reference Links:
Preprocessing:
http://www.ibm.com/support/knowledgecenter/SSZLC2_8.0.0/com.ibm.commerce.search.doc/tasks/tsdsearchbuildpre.htm


BuildIndex:
http://www.ibm.com/support/knowledgecenter/en/SSZLC2_8.0.0/com.ibm.commerce.search.doc/tasks/tsdsearchbuildindex.htm


Cheers!!!! You have completed the Preprocessing and Reindexing.


Sharing is Caring!!!!


WCS IBM Issue Fix: PricePending Issue even after the Di-preprocess and Di-build Index

If facing any Price Pending issue in the store front its normally because of the Di-preprocess and Di-buildIndex, But if its same even after performing the Di-preprocess and Di-buildIndex then it seems to be the issue because your currency is not being mentioned in the XML's and its taking the default/OOB currencies and your currency is not mentioned in the XML's.

Steps to fix this:
1. First select a currency that you feel you are not going to use it in the future for this project and search for it in the below mentioned three files and replace it with the currency you want to use.
2. Navigate to the below location>Open below files in any Text editor like Notepad++
  • For Solr:
          C:\IBM\WCDE80\search\solr\home\MC_10001\en_US\CatalogEntry\conf\wc-data-config.xml
  • For pre-processConfig:
          C:\IBM\WCDE80\search\pre-processConfig\MC_10001\DB2\wc-dataimport-preprocess-listprice.xml
          C:\IBM\WCDE80\search\pre-processConfig\MC_10001\DB2\wc-dataimport-preprocess-offerprice.xml

Eg:
    ILS is Israel Currency and i'm not going to use it in the future and i Need AUD currency which is Australian Dollar. 

3. Search for the Text "ILS" and Replace all of its OCCURANCES with "AUD"
Repeat the step for all the Three above mentioned Files and make sure you save Them.

4. Then Perform Di-Preprocess and Di-Build Index or Click here to Refer the Blog

 Cheers!!!! You have Done and It should work if the Issue is related to Currency...



Sharing is Caring!!!!



Thursday, October 13, 2016

Script to Reset the wcsadmin password in WCS IBM

To Reset the wcsadmin password in WCS IBM follow the below steps:

Step-1
Open the Db2 console center or any other db2 client to run sql's and go to query editor.

Step-2
Copy and paste the below queries one by one or together and execute them.

update userreg set logonpassword = x'74434f61354f51593862415655304d5268424e54723865685653356151374a2b353163506c4261363730633d202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020' where logonid='wcsadmin';

update userreg set salt = 'hsdbacehyoyn' where logonid='wcsadmin';

update userreg set status = 1 where logonid='wcsadmin';


update userreg set passwordexpired = 0 where logonid='wcsadmin';


Step-3 
The above scripts reset's the password of the wcsadmin user to "wcsadmin"

Navigate to the store in the browser and login to the site using the user name "wcsadmin" and password "wcsadmin".

After successful login change the password as required.



Sharing is Caring!!!!