Jazz Reporting Service "Connect to Data Sources" error

Mike Shkolnik (980●8●160●143) | asked Jan 09 '15, 7:08 p.m.
edited Jan 09 '15, 7:14 p.m.

"The server was unable to connect to the database. Try entering the password again or confirm that the database is available."

I entered the correct password but it's not working. I can log into SQL Management Studio, RTC connects and runs data collection jobs without issue, and RRDI is working as well. I previously followed these instructions and to be sure restarted both Tomcat and WAS and tried again without luck. What step am I missing?

My Setup:

WAS Server with DCC, RRDI, and JRS on Windows 2012

TOMCAT server with JTS and CCM on Linux 6.4

SQL Server 2012 - all databases on same server

Everything is 64 bit

Steps I followed:

Add WAR file to WAS:

https://WASSERVER:PORT/ibm/console

Applications/Application Types/Websphere Enterprise Applications

Install

C:\Program Files\IBM\RRDI\jrs\JazzTeamServer\server\tomcat\webapps

Select rs.war

Next (wait), Next, Next, Next, Next

Make sure Context Root = rs

Next, Next, Finish (wait), Save

Environment/Shared Libraries

Scope = Cell (also tried Node)

New

Name: JRS Shared Libraries

Classpath:

C:\Program Files\IBM\RRDI\jrs\JazzTeamServer\server\conf\rs\WAS_SharedLibrary

Check use an isolated class loader

Save

Applications/Application Types/WebSphere Enterprise Applications

rs_war

Shared Library References

Click rs_war

Click Shared Library References

Check rs_war

Click Reference Shared Libraries

Select JRS Shared Libraries + right arrow,

OK, OK, Save

Servers/Server Types/Websphere Application Servers

Click RationalReportingServer

Java & Process Management/Process Definition

Click Java Virtual Machine/Custom Properties

New

JAZZ_HOME

file:///C:/Program Files/IBM/RRDI/jrs/JazzTeamServer/server/conf

OK, Save

Copy jdbc driver (sqljdbc4.jar) to WAS shared library folder

StartMenu/Stop the server (run as administrator)

Wait until cmd window closes

StartMenu/Start the server (run as administrator)

Wait until cmd window closes

https://TOMCATSERVER:PORT/jts/setup

Add Application

Instance = /rs

DiscoveryURL = https://WASSERVER:PORT/rs/scr

Application Type and Functional User ID will autofill

Click Register Applications

Add RTC Outbound Connection

https://TOMCATSERVER:PORT/jazz/admin

Friends

Click Add

Name: JRS

URI: https:WASSERVER:PORT/rs/rootservices

Secret: (use same as did for RRDI)

Check Trusted

Click Create Friend

Next, Finish

Add RTC Inbound Connection

https://TOMCATSERVER:PORT/jts/admin

Server

Consumers Inbound

Approve

Save

https://WASSERVER:PORT/rs

Connect to Data Sources

Prompted to enter password for JAZZDBUSER

Enter jazzDBuser password (FAILS)

Import Reports (didn't get there yet since prior step failed)

3 answers

Most liked answers ↑|Newest answers|Oldest answers

permanent link

Mike Shkolnik (980●8●160●143) | answered Jan 12 '15, 1:40 p.m.
edited Jan 12 '15, 1:45 p.m.

Due to the JRS setup not properly copying the database string from the JTS, I set up a data source manually on the Data Source tab (oddly enough by copy/pasting the string verbatim from the JTS data warehouse connection page). This seems to work. I was able to import the ready-to-use reports. Not sure why the JRS setup does this wrong when the string is clearly correct in JTS.

permanent link

Francesco Chiossi (5.7k●1●11●19) | answered Jan 12 '15, 4:35 a.m.

Hello Mike,

do you get any entry in the rs.log file when you get the error message in the WebUI?

Best Regards,

Francesco Chiossi

Comments

Mike Shkolnik commented Jan 12 '15, 12:19 p.m.

Indeed I did. And I see the problem. There is no slash of any kind between the server name and the instance name. This must be a bug in the RS setup since the data warehouse is not setup as part of the RS install - it pulls that data from JTS. So how do I fix this?

Mike Shkolnik commented Jan 12 '15, 12:55 p.m.

Here's another funny thing (aka bug) - the UI properly shows the backslash:

"Enter the password for the database user jazzDBuser of the data warehouse on SERVER\I01"

While the log file clearly doesn't:

!CRRGW6018E The server was unable to connect to the following database: "//SERVERI01:PORT;databaseName=DBNAME;user=xxxxxxxx;password=xxxxxxxx"

permanent link

Kevin Cornell (541●1) | answered Jan 12 '15, 9:48 a.m.

Can you please attach the rs.log file.

Above you indicate the topology as "WAS Server with DCC, RRDI, and JRS on Windows 2012". Are all three applications in the same WAS profile or are they in different profiles?

Comments

Mike Shkolnik commented Jan 12 '15, 12:20 p.m.

I believe all in one profile. But this is my first time using WAS. :-)

Kevin Cornell commented Jan 13 '15, 9:13 a.m.

If I recall, DCC, RRDI and JRS are installed on disk into different folders in 502 (or at least JRS was). If you go to <installDir>/server/conf do you see both application folders for dcc and rs? The JAZZ_HOME custom JVM property in WAS must be set to the server/conf folder that contains all of the applications deployed to that profile. If the applications are not in the same server/conf folder, then they cannot be in the same WAS profile.

As for the SQL Server database location, JRS obtains that location URL directly from JTS. It does not modify it in any way. I have not seen this "SERVER|instance" notation before. In any case, as a JRS administrator you can go to the Data Sources page in JRS and manually create or modify the data warehouse connection information.

It's all about the answers!

Related questions

Jazz Reporting Service "Connect to Data Sources" error

3 answers

Your answer