Jazz Forum Welcome to the Jazz Community Forum Connect and collaborate with IBM Engineering experts and users

Repotools -rebuildTextIndices throwing error

Hello,

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

Caused by: java.lang.IllegalStateException: CRJAZ1840W The driver "com.microsoft.sqlserver.jdbc.SQLServerDriver" 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 teamserver.properties file to absolute paths. I have also added a new environment variable called SQLSERVER_ABSPATH as the post suggests but no luck...

https://jazz.net/forum/questions/114171/repotools-cannot-find-jdbc-driver?redirect=%2Fforum%2Fquestions%2F114171%2Frepotools-cannot-find-jdbc-driver

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.

Thanks.

-NP


0 votes



One answer

Permanent link
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,

0 votes

Comments

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

Your answer

Register or log in to post your answer.

Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.

Search context
Follow this question

By Email: 

Once you sign in you will be able to subscribe for any updates here.

By RSS:

Answers
Answers and Comments
Question details
× 7,494
× 343

Question asked: Sep 09 '13, 2:12 p.m.

Question was seen: 6,823 times

Last updated: Sep 16 '13, 8:21 a.m.

Confirmation Cancel Confirm