The setupSearchIndex task fails on the remote SOLR server with a data source cannot be loaded exception.
The setupSearchIndex.sh task fails on the remote solr server. You will see the following exception in the wc-search-index-setup.log:
com.ibm.commerce.search.indexsetup.exception.SearchIndexSetupSystemException: The data source class com.ibm.db2.jcc.DB2SimpleDataSource cannot be loaded. The error returned is com.ibm.db2.jcc.DB2SimpleDataSource.
Typically, a data source error has one of two causes:
1) The required jar is not in the classpath.
2) The user running the command does not have sufficient access to the Java™ files required.
Resolving the problem
First make sure the db2jcc4.jar exists at the classpath defined in the WebSphere Application Server administrative console. If it does you can source the db2profile to the user's .bash_profile
if [ -f "/home/db2_user/sqllib/db2profile" ]; then
Then run the setupSearchIndex script again.
Note: The user mentioned above is the user running the setupSearchIndex script.