It's all about the answers!

Ask a question

CRJAZ0820I Failed to create the system schema


Jeff Taylor (7673) | asked Apr 15 '09, 10:41 a.m.
This morning I was unable to connect to my Jazz server. Yesterday, I was running an import from CVS that failed. I don't know if that was related, but I will follow up with another post when I get Jazz back up.

BTW: I am using RTC 2.0 beta 1 with DB2

My first step was restart my Jazz server on my RHEL 5 box. I ran the server.shutdown and server.startup scripts to make sure it came up.

I was then able to log into the Jazz server with the web interface, but saw the following issue:

Status Summary: Error fetching server status information. Expand the Database Status section for more information.

Under the Server Status section, it lists the Database Status as "UNAVAILABLE".

Under the Server License section, it says "Error fetching server status information".

Undert the second Database Status section, it says "CRAJAZ0820I Failed to create the system schema."

There is more information under the Service Error Summary, but I will wait to post that when someone asks for it.

9 answers



permanent link
Christophe Elek (2.9k13021) | answered Apr 15 '09, 4:39 p.m.
JAZZ DEVELOPER
Ummm :(
The only reference to CRJAZ0820I I found was Work Item 70519
This seems to imply an issue connecting to teh database and *usually* :) the jazz.log should give us the 'cause' as a stack trace...
Does the jazz.log state more info ?

permanent link
Christine Kim (7131) | answered Apr 15 '09, 9:14 p.m.
Hi Jeff,

Could you please check DB2 database is up and available ?

We can investigate further detail on the following logs.
1) Jazz logs
<Jazz_Server_Install_Dir>server\tomcat\logs\*.log
2) OS logs
3) DB logs

I will send you e-mail so that you can send us the log directly. I will check with our development team. Thanks.

Christine
Jazz/RTC Support

permanent link
Susan Wu (4712016) | answered Apr 21 '09, 2:34 p.m.
Hi Jeff,

Could you please check DB2 database is up and available ?

We can investigate further detail on the following logs.
1) Jazz logs
<Jazz_Server_Install_Dir>server\tomcat\logs\*.log
2) OS logs
3) DB logs

I will send you e-mail so that you can send us the log directly. I will check with our development team. Thanks.

Christine
Jazz/RTC Support


Hi Jeffrey,

As per our email communication, this issue has been resolved by restarting DB2 and Jazz team server.


Susan
Jazz/RTC Support

permanent link
Jeff Taylor (7673) | answered Apr 23 '09, 8:57 a.m.
Yes, the servers are up and running now. Although I feel I should point out that both servers had to but shutdown, and then DB2 must be restarted before the Jazz Team Server.

Earlier, I had tried to reboot the Jazz server then the DB2 server. Apparently the order in which the servers are brought up is important.

I just felt I should pass along this information in case it helps someone else.

Still no idea why the database went down in the first place...

permanent link
Anthony Kesterton (7.5k7180136) | answered Apr 24 '09, 5:17 a.m.
JAZZ DEVELOPER
Yes, the servers are up and running now. Although I feel I should point out that both servers had to but shutdown, and then DB2 must be restarted before the Jazz Team Server.

Earlier, I had tried to reboot the Jazz server then the DB2 server. Apparently the order in which the servers are brought up is important.

I just felt I should pass along this information in case it helps someone else.

Still no idea why the database went down in the first place...


Hi

Just another experience point on this. I usually use RTC on my laptop with Tomcat and DB2 (on the same laptop). My DB2 setup means that if I suspend my machine, DB2 often stops and needs to be started via the DB2 Control Center. The Jazz Team Server seems to come out of suspend quite happily. I sometimes forget to check DB2 is running and see an error come up on the server if it cannot access DB2 (it is not running). If you start up DB2, RTC carries on without any issues.

In general, while you do need the database running before the Jazz Team Server starts - it seems like the Team Server first talks to the database when a person logs in to the repository from a client. Bear in mind, this might be when you start an Eclipse client that previously had an RTC project open.

regards

anthony

permanent link
Milan Krivic (98010172140) | answered May 29 '09, 7:43 a.m.
Hi,

We are temporarly using Jazz Team Server v1.0.1.1 (Tomcat Users and DB2). Everything is working well.
I tried to make a backup of database JAZZ in DB2, and also backup of file tomcat-users.xml from ...server\tomcat\conf folder.

I installed Jazz Team Server v1.0.1.1 on some other work stations, to try previously mentioned backup of JAZZ and tomcat users. On some work stations, I succeeded to continue with my work, which means backup was succeessfully replaced.

But, on other work station, I got following message:


Under the Server Status section, it lists the Database Status as "UNAVAILABLE".

Under the Server License section, it says "Error fetching server status information".

Undert the second Database Status section, it says "CRAJAZ0820I Failed to create the system schema."

Can anyone help?

P.S. First, I used DB2 v9.5.0.808,
and now, I am using DB2 v9.5 fix 3 (which came bundled in RTC 1.0.1.1)
Can that be a reason of this error?

Thanks,

permanent link
Matt Lavin (2.7k2) | answered May 29 '09, 11:28 a.m.
FORUM MODERATOR / JAZZ DEVELOPER
When moving from Derby to DB2 you used repotools to migrate the data.
Did you have any errors when migrating the data?

Assuming you didn't see any errors during the migration, are you sure
that the DB2 connection spec is correctly configured in the new server?

Have you used the /jazz/setup wizard to walk through the DB setup (it
allows you to test your DB connection)

-
Matt Lavin
Jazz Server Team


On Fri, 2009-05-29 at 11:53 +0000, milan.krivic wrote:
Hi,

We are temporarly using Jazz Team Server v1.0.1.1 (Tomcat Users and
DB2). Everything is working well.
I tried to make a backup of database JAZZ in DB2, and also backup of
file tomcat-users.xml from ...server\tomcat\conf folder.

I installed Jazz Team Server v1.0.1.1 on some other work stations, to
try previously mentioned backup of JAZZ and tomcat users. On some
work stations, I succeeded to continue with my work, which means
backup was succeessfully replaced.

But, on other work station, I got following message:


Under the Server Status section, it lists the Database Status as
"UNAVAILABLE".

Under the Server License section, it says "Error fetching server
status information".

Undert the second Database Status section, it says "CRAJAZ0820I
Failed to create the system schema."

Can anyone help?

P.S. First, I used DB2 v9.5.0.808,
and now, I am using DB2 v9.5 fix 3 (which came bundled in RTC
1.0.1.1)
Can that be a reason of this error?

Thanks,

permanent link
Suchitra Maistrolu (1111) | answered Aug 09 '10, 9:23 a.m.
Hello,

While trying to configure SQLServer with RQM, below error is throwing up and database is displayed as "UNAVAILABLE".

CRJAZ0820I Failed to create the system schema.

Can anyone help us in resolving this issue?

Thanks in advance!!

permanent link
Suchitra Maistrolu (1111) | answered Aug 09 '10, 9:26 a.m.
Hello,

Can anyone help us in creating mandatory test case fields on RQM?

Thanks in advance!!

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.