It's all about the answers!

Ask a question

Can I use CLM 5.0 with MS SQL Server 2008?


June Chen (634) | asked Aug 12 '14, 5:58 a.m.
edited Aug 20 '14, 12:11 p.m. by Stephanie Taylor (24115)
I am plan to upgrade CLM 4.0 to CLM 5.0. But my Database is SQL server 2008. And I see CLM 5.0 doesn't support SQL server 2008. But My company no plan upgrade SQL server. So May I upgrade CLM 5.0 with SQL SERVER 2008? 

One answer



permanent link
Krzysztof Kaźmierczyk (7.4k375103) | answered Aug 12 '14, 7:16 a.m.
Hi June,
If you want to get official support, you should contact IBM support for that.

Anyway it should work for you. This is only what you need to do to make upgrade possible:

1. Navigate to <JazzServerInstallationDirectory>/server/conf/<app> for each of the individual CLM applications

2. Add the following lines to the teamserver.properties file:
com.ibm.team.repository.db.override.versioncheck=true
com.ibm.team.datawarehouse.db.override.versioncheck=true


3. Restart the server

Let us know if that helped.

Comments
June Chen commented Aug 13 '14, 9:59 p.m. | edited Aug 14 '14, 2:43 a.m.

When I upgrade , I got the following error . I aslo send to support center.

2014-08-13 13:55:27,236 CRJAZ2448I 未設定公用 URL 內容。這是用來判斷伺服器的執行中狀態。repotools 指令將跳過這項檢查,並繼續處理指令。
2014-08-13 13:55:38,783 CRJAZ1256I 需要 SQL Server 11.x 版或更新版本,但卻偵測到 "10.00.5788" 版。
com.ibm.team.repository.common.TeamRepositoryException: CRJAZ1256I 需要 SQL Server 11.x 版或更新版本,但卻偵測到 "10.00.5788" 版。
 at com.ibm.team.repository.jdbcdriver.internal.sqlserver.SqlServerProvider.assertRequiredVersion(SqlServerProvider.java:589)
 at com.ibm.team.repository.service.db.provider.AbstractDbProvider.assertRequiredVersion(AbstractDbProvider.java:1493)
 at com.ibm.team.repository.service.db.provider.AbstractDbProvider.checkDbVersion(AbstractDbProvider.java:1552)
 at com.ibm.team.repository.service.db.provider.AbstractDbProvider.checkDbVersion(AbstractDbProvider.java:1545)
 at sun.reflect.GeneratedMethodAccessor8.invoke(Unknown Source)


Krzysztof Kaźmierczyk commented Aug 14 '14, 2:44 a.m.

Hi June,
Did you perform the instructions from my answer?

Your answer


Register or 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.