It's all about the answers!

Ask a question

Repotools -rebuildTextIndices throwing error

Namit Pande (6311318) | asked Sep 09 '13, 2:12 p.m.
retagged Sep 16 '13, 8:21 a.m. by Ralph Earle (25739)


I am receiving error when I try to rebuild the indexes:

Caused by: java.lang.IllegalStateException: CRJAZ1840W The driver "" could not be loaded and registered.  This JDBC driver jar must be provided in a path configured by the server scripts.  Please ensure that the driver is in the expected location of "D:\Progra~1\IBM\JazzTeamServer\server\sqlserver" or consult product setup instructions to change the location.

So far, I have changed the relative paths in the file to absolute paths. I have also added a new environment variable called SQLSERVER_ABSPATH as the post suggests but no luck...

Does anyone has any idea on how to fix this problem. This command ran without issue in test environment and has fixed the indexing issue I am facing in production. I am anxious to get it working. Please help.



One answer

permanent link
Benjamin Silverman (4.1k610) | answered Sep 09 '13, 2:52 p.m.
The variable you need to set is SQLSERVER_JDBC_DRIVER_FILE and it should point to the
sqljdbc4.jar file on your system.  Hope it helps,

Namit Pande commented Sep 10 '13, 2:00 p.m.

Thanks Benjamin. SQLSERVER_JDBC_DRIVER_FILE is already setup correctly and pointing to the sqljdbc4.jar.

Your answer

Register or to post your answer.