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

Difficulties migrating from Tomcat to WebSphere

Hi,

We have an existing instance running on tomcat. We are not moving it to websphere and have gone through the configuration steps as outlined in the doc. We have security etc configured in WebSphere so that we can authenticate and Jazz starts up. However it does not appear to be seeing our database configuration as evidenced by these entries in the jazz.log file:

19:42:08,324 [WebContainer : 6]  INFO uration.OverridablePropertyFileServerConfiguration  - Loading configuration from "com.ibm.team.repository.common/teamserver.properties".

19:42:09,766 [WebContainer : 6] WARN m.team.fulltext.service.internal.index.IndexConfig - CRJAZ8180E: Using temporary directory as index location. Please set the configuration parameter com.ibm.team.fulltext.indexLocation
19:42:09,774 [WebContainer : 6] INFO m.team.fulltext.service.internal.index.IndexConfig - Fulltext Index Location: /tmp/fulltext_index/
19:42:10,667 [WebContainer : 6] INFO .repository.service.internal.rdb.ConnectionFactory - Initial database connection successful
Db Product Name: Apache Derby
Db Product Version: 10.3.2.2 - (650004)
Db Name/Location: /tmp/apollo-repo

Here are the same entries when starting up with tomcat:

12:19:37,617 [http-9443-Processor24]  INFO uration.OverridablePropertyFileServerConfiguration  - Loading configuration from "file:///opt/IBM/JazzTeamServer/server/teamserver.properties".

12:19:40,908 [http-9443-Processor24] INFO m.team.fulltext.service.internal.index.IndexConfig - Fulltext Index Location: workitemindex/fulltext_index/
12:19:42,451 [http-9443-Processor24] INFO .repository.service.internal.rdb.ConnectionFactory - Initial database connection successful
Db Product Name: DB2/LINUX
Db Product Version: SQL09051
Db Name/Location: //localhost:50001/JAZZ:fullyMaterializeLobData=false;user=xxxxxxxx;password=xxxxxxxx;


Here is the contents of teamserver.profile (XXXX = blanked out for privacy)

com.ibm.team.repository.user.registry.type=LDAP

com.ibm.team.repository.db.vendor=DB2
com.ibm.team.repository.db.jdbc.location=//localhost\:50001/JAZZ\:fullyMaterializeLobData\=false;user\=db2inst1;password\={password};
com.ibm.team.repository.db.jdbc.password=XXXX
com.ibm.team.repository.db.db2.content.tablespace.location=content_tablespace
com.ibm.team.repository.db.db2.content.tablespace.numpages=250000
com.ibm.team.repository.changeEvent.expirationDefault=1209600
com.ibm.team.repository.ws.allow.admin.access=true
com.ibm.team.repository.web.suppressedPages={"com.ibm.team.repository.web.admin"\: ["com.ibm.team.repository.provision"]}
com.ibm.team.repository.web.pageorder={"com.ibm.team.repository.web.admin"\: ["com.ibm.team.repository.server", "com.ibm.team.process.admin"], "com.ibm.team.process.web.projectArea"\: ["com.ibm.team.dashboard", "com.ibm.team.workitem", "com.ibm.team.apt", "com.ibm.team.scm", "com.ibm.team.reports"],"com.ibm.team.process.web.projectAreaList"\: ["com.ibm.team.repository.web.projectAreaList"]}
com.ibm.team.repository.changeEvent.expirationByType=com.ibm.team.workitem.WorkItem\:5184000 com.ibm.team.build.BuildResult\:172800
com.ibm.team.repository.changeEvent.expirationByCategory=SystemLog\:259200
com.ibm.team.fulltext.indexLocation=workitemindex
com.ibm.team.repository.ws.allow.identity.assertion=false
com.ibm.team.repository.web.helpuri=http\://publib.boulder.ibm.com/infocenter/rtc/v1r0m0/index.jsp

com.ibm.team.repository.ldap.findUsersByUserIdQuery=preferredIdentity\=?1
com.ibm.team.repository.ldap.baseGroupDN=ou\=memberlist,ou\=ibmgroups,o\=ibm.com
com.ibm.team.repository.ldap.findGroupsForUserQuery=uniquemember\={USER-DN}
com.ibm.team.repository.ldap.userAttributesMapping=userId\=preferredIdentity,name\=cn,emailAddress\=preferredIdentity
com.ibm.team.repository.ldap.membersOfGroup=uniquemember
com.ibm.team.repository.ldap.registryLocation=ldap\://XXXXXX\:389
com.ibm.team.repository.ldap.groupMapping=JazzAdmins\=XXXXXX,JazzUsers\=XXXXXX,JazzDWAdmins\=XXXXXX,JazzGuests\=XXXXXX
com.ibm.team.repository.ldap.baseUserDN=ou\=bluepages,o\=ibm.com

The database page of the setup wizard appears to be confused at the start and if you switch it to db2 and enter the password and URL (//localhost:50001/JAZZ:fullyMaterializeLobData=false;user=db2inst1;password={password};) test connections works. However when you go to save you get this message:

An error occurred while saving the configuration properties. Please check your server log for more details.

Lots of database connection errors in the logs associated with this activity.

Any suggestions would be much appreciated.

0 votes



2 answers

Permanent link
It looks like the JVM is not finding the property
"com.ibm.team.server.configURL".

Double check the custom properties described in step 4 of the doc:

https://jazz.net/jazzdocs/topic/com.ibm.team.install.doc/topics/t_s_server_installation_setup_WAS.html

--
Ritchie Schacher
Jazz Server Development

"xdcx11" <daniel> wrote in message
news:gbelu8$nfc$1@localhost.localdomain...
Hi,

We have an existing instance running on tomcat. We are not moving it
to websphere and have gone through the configuration steps as
outlined in the doc. We have security etc configured in WebSphere so
that we can authenticate and Jazz starts up. However it does not
appear to be seeing our database configuration as evidenced by these
entries in the jazz.log file:

19:42:08,324
INFO uration.OverridablePropertyFileServerConfiguration - Loading
configuration from
"com.ibm.team.repository.common/teamserver.properties".
19:42:09,766 WARN
m.team.fulltext.service.internal.index.IndexConfig - CRJAZ8180E:
Using temporary directory as index location. Please set the
configuration parameter com.ibm.team.fulltext.indexLocation
19:42:09,774 INFO
m.team.fulltext.service.internal.index.IndexConfig - Fulltext Index
Location: /tmp/fulltext_index/
19:42:10,667 INFO
repository.service.internal.rdb.ConnectionFactory - Initial
database connection successful
Db Product Name: Apache Derby
Db Product Version: 10.3.2.2 - (650004)
Db Name/Location: /tmp/apollo-repo

Here are the same entries when starting up with tomcat:

12:19:37,617
INFO
uration.OverridablePropertyFileServerConfiguration - Loading
configuration from
"file:///opt/IBM/JazzTeamServer/server/teamserver.properties".
12:19:40,908 INFO
m.team.fulltext.service.internal.index.IndexConfig - Fulltext Index
Location: workitemindex/fulltext_index/
12:19:42,451 INFO
repository.service.internal.rdb.ConnectionFactory - Initial
database connection successful
Db Product Name: DB2/LINUX
Db Product Version: SQL09051
Db Name/Location:
//localhost:50001/JAZZ:fullyMaterializeLobData=false;user=xxxxxxxx;password=xxxxxxxx;


Here is the contents of teamserver.profile (XXXX = blanked out for
privacy)

com.ibm.team.repository.user.registry.type=LDAP
com.ibm.team.repository.db.vendor=DB2
com.ibm.team.repository.db.jdbc.location=//localhost\:50001/JAZZ\:fullyMaterializeLobData\=false;user\=db2inst1;password\={password};
com.ibm.team.repository.db.jdbc.password=XXXX
com.ibm.team.repository.db.db2.content.tablespace.location=content_tablespace
com.ibm.team.repository.db.db2.content.tablespace.numpages=250000
com.ibm.team.repository.changeEvent.expirationDefault=1209600
com.ibm.team.repository.ws.allow.admin.access=true
com.ibm.team.repository.web.suppressedPages={"com.ibm.team.repository.web.admin"\:
}
com.ibm.team.repository.web.pageorder={"com.ibm.team.repository.web.admin"\:
,
"com.ibm.team.process.web.projectArea"\:
,"com.ibm.team.process.web.projectAreaList"\:
}
com.ibm.team.repository.changeEvent.expirationByType=com.ibm.team.workitem.WorkItem\:5184000
com.ibm.team.build.BuildResult\:172800
com.ibm.team.repository.changeEvent.expirationByCategory=SystemLog\:259200
com.ibm.team.fulltext.indexLocation=workitemindex
com.ibm.team.repository.ws.allow.identity.assertion=false
com.ibm.team.repository.web.helpuri=http\://publib.boulder.ibm.com/infocenter/rtc/v1r0m0/index.jsp

com.ibm.team.repository.ldap.findUsersByUserIdQuery=preferredIdentity\=?1
com.ibm.team.repository.ldap.baseGroupDN=ou\=memberlist,ou\=ibmgroups,o\=ibm.com
com.ibm.team.repository.ldap.findGroupsForUserQuery=uniquemember\={USER-DN}
com.ibm.team.repository.ldap.userAttributesMapping=userId\=preferredIdentity,name\=cn,emailAddress\=preferredIdentity
com.ibm.team.repository.ldap.membersOfGroup=uniquemember
com.ibm.team.repository.ldap.registryLocation=ldap\://XXXXXX\:389
com.ibm.team.repository.ldap.groupMapping=JazzAdmins\=XXXXXX,JazzUsers\=XXXXXX,JazzDWAdmins\=XXXXXX,JazzGuests\=XXXXXX
com.ibm.team.repository.ldap.baseUserDN=ou\=bluepages,o\=ibm.com

The database page of the setup wizard appears to be confused at the
start and if you switch it to db2 and enter the password and URL
(//localhost:50001/JAZZ:fullyMaterializeLobData=false;user=db2inst1;password={password};)
test connections works. However when you go to save you get this
message:

An error occurred while saving the configuration properties. Please
check your server log for more details.

Lots of database connection errors in the logs associated with this
activity.

Any suggestions would be much appreciated.

0 votes


Permanent link
That was it - silly "typo" - I triple checked that the value was right and completely ignored the fact that the property name wasn't.

Thank you very much for your help!

0 votes

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

Question asked: Sep 24 '08, 8:20 p.m.

Question was seen: 6,267 times

Last updated: Sep 24 '08, 8:20 p.m.

Confirmation Cancel Confirm