setupSearchIndex task fails on remote SOLR server

Technote (troubleshooting)


Problem(Abstract)

The setupSearchIndex task fails on the remote SOLR server with a data source cannot be loaded exception.

Cause

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.

at com.ibm.commerce.search.indexsetup.database.DBManager.getDataSourceClass(DBManager.java:279)

at com.ibm.commerce.search.indexsetup.database.DBManager.newConnection(DBManager.java:227)

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
. /home/db2_user/sqllib/db2profile
fi


Then run the setupSearchIndex script again.

Note: The user mentioned above is the user running the setupSearchIndex script.


Rate this page:

(0 users)Average rating

Document information


More support for:

WebSphere Commerce Enterprise

Software version:

7.0

Operating system(s):

AIX, Linux

Reference #:

1626659

Modified date:

2013-04-25

Translate my page

Machine Translation

Content navigation