Datawarehouse connection error

Leire Torres

(36●7●21) edited

Jan 28 '16, 4:52 a.m.

Hi,

Yesterday I installed the Jazz Reporting Server (JRS) v5.0.2 in a computer and the setup runs without problems: data sources were connected succesfully and I was able to run some custom reports. Everything worked fine.

Today, I have followed the same installation procedure in other computer and I am getting the following error when attempting to connect to the datawarehouse:

A com.ibm.team.integration.reporting.db.exception.DbAccessException error has ocurred when validating the connection to the database, caused by !CRRGW6018E Server could not connect to database: "//localhost:1527/conf/jts/derby/warehouseDB" Exception: "CRRGW6003E Server could not connect to the database because the connection settings are not valid or because the database is not accessible (SQLSTATE:08004, SQLCODE :40,000). Check the connection values in the data source."!.

I have checked the connection parameters but I cannot find the problem source. All the parameters seems to be okey.

Does anyone knows which could be the solution?

Thanks in advance,
Leire.

0 votes

2 answers

5,387 views

0 votes

Accepted answer

Permanent link

Donald Nong

(14.5k●6●14) Jan 11 '16, 12:27 a.m.

You're using the embedded Derby database, so JTS should start the database automatically. If fails to connect, chances are the database cannot start. You can simply restart the machine and try again. Another thing to note is to ensure nproc and nofile are correctly set on a Linux environment.

Leire Torres selected this answer as the correct answer

0 votes

Comments

Leire Torres

Jan 12 '16, 3:17 a.m.

Thanks for the quick reply. How can I know if the database is started? The tomcat server is started from a windows scheduled task, might this have something to do with the problem?

Donald Nong

Jan 13 '16, 12:20 a.m.

I don't know any easy ways the check the status or the log files of the embedded Derby database, unfortunately. If the database is started, port 1527 should be open, according to the configuration. Starting Tomcat as a Windows service should not cause such problem.

Leire Torres

Jan 13 '16, 10:35 a.m.

It seems that restarting the machine solves the problem. Apparently, when the scheduled periodic task that stops the JTS is executed, something (as you said, probably the database connection) gets stuck. But each time the JTS is stopped, the connection breaks and the same error appears... What should I do? Thank you for all your assistance.

One other answer

Permanent link

Leire Torres

(36●7●21) Jan 26 '16, 3:09 a.m.

Every time the JTS (Jazz Team Server) is restarted, the connection with the data warehouse database breaks, and the JRS (Jazz Reporting Service) is not able to connect to it. Any idea?

0 votes

Comments

Donald Nong

Jan 26 '16, 5:58 p.m.

I think I missed your comment (follow-up question) two weeks ago. The Derby database that comes with CLM is an embedded one. It means that it only starts with the application (JTS in this case). So if the applications stops, the Derby database stops; if the application restarts, the Derby database restarts; and so on. Of course when the database stops/restarts, all existing database connections are lost. The Derby database is not intended for production use, and you should use an enterprise database (DB2, Oracle or SQL Server) for this purpose.

Leire Torres

Jan 28 '16, 4:33 a.m.

Thanks for your suggestion. I will take that into account! Just to make it clear for future deployments… I understand that the database that comes with CLM is an embedded one, and so, it starts with the JTS. The JRS also starts with the JTS. I also understand that if the JTS is stopped, the DB and the JRS are stopped too, and so, all the connections are lost. Until now everything is clear and coherent. What I cannot understand is why the database connection cannot be reestablished after restarting the JTS. As you said, after restarting the JTS, the DB and the JRS are restarted too. Even if the current connections are lost, the DB configuration is saved in the JTS (isn´t it?), and that is why I cannot understand why the connection cannot be reestablished. This does not happen when I restart the PC (in this case, the connection can be reestablished). To summarize the situation: Start the JTS/JRS/DB, after the first JTS setup the connection with the DB is OK. Stop and Start JTS/JRS/DB, the connection with DB is NOT OK. Stop JTS/JRS/DB, restart the PC and Start JTS/JRS/DB, the connection is OK again. My apologies for being so persistent and thanks a lot for the assistance.

Donald Nong

Jan 28 '16, 5:06 a.m.

I suspect that in your case 2, there are lingering network connections. Wait long enough and see if you still have the problems. To check connections connecting to a certain port (1527 in this case), run the below commands: On Windows: netstat -aon | findstr 1527 On Linux: netstat -pant | grep 1527

Leire Torres

Jan 29 '16, 7:01 a.m.

We didn´t realise that in this specific setup DWA was also running and it was using the port 1527 for its derby database. We have changed the JTS datawarehouse database port and the error is solved.

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.

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

installation

× 2,382

jazz-reporting-service

× 198

Question asked: Jan 08 '16, 10:26 a.m.

Question was seen: 5,387 times

Last updated: Jan 29 '16, 7:01 a.m.

Datawarehouse connection error

2 answers

5,387 views

0 votes

Accepted answer

Comments

One other answer

Comments

Your answer

Follow this question

Question details

Related questions