developerWorks > Tivoli > Forums > Tivoli Common Reporting - Specific Product Reports >

Connecting TCR to ITM for report


Search for within

My developerWorks

Welcome, Guest

	Sign in or register

This question is not answered.

Reply to this Thread

Post New Thread

Watch list

Forum settings

Help

	Replies: 4 - Pages: 1 - Last Post: Nov 10, 2009 8:31 AM Last Post By: @__@@	Threads: [ Previous \| Next ]

@__@@

Posts: 23
Registered: Feb 11, 2009 08:03:54 AM

Connecting TCR to ITM for report
Posted: Nov 05, 2009 05:43:12 AM

error.doc (247.5 KB)

Hi,

I installed tivoli common reporter for ITM report on my server, the tcr was installed and connected to my database successfully. but I am unable to generate report for ITM, each time I tried running the repor I kept on having the attached error.

my historigal data was configured as well from ITM portal.

my ITM version is 6.2 and tivoli common report is 2.2.2.

I am not really familiar with BIRT but I need to use it for this report.
Please, I need assiatance on how to go about it so I can be able to generate data for ITM using Tivoli common reporter.

I will be greatful for an assistance.

Please help.

tsekman

Posts: 66
Registered: Jul 14, 2008 04:42:56 PM

Re: Connecting TCR to ITM for report
Posted: Nov 05, 2009 07:07:20 AM

in response to: @__@@'s post

Hi,

It seems that there is a problem with loading DB2 JDBC driver classes.
Did you copy jar files suitable for you database into the BIRT drivers directory?

db2jcc.jar and db2jcc_license_cu.jar should be copied into the following directory

<install_dir>/products/tcr/lib/birt-runtime-2_2_1/ReportEngine/plugins/org.eclipse.birt.report.data.oda.jdbc_2.2.1.r22x_v20070919/drivers/

You will find these jars in your DB2 installation directory in the java subdirectory - for example C:\Program Files\IBM\SQLLIB\java. In some cases you can also use drivers provided with TIP <install_dir>/universalDriver/lib.

Kind regards,
Tomasz Sekman

tsekman

Posts: 66
Registered: Jul 14, 2008 04:42:56 PM

Re: Connecting TCR to ITM for report
Posted: Nov 05, 2009 07:19:25 AM

in response to: @__@@'s post

One more update.
I have missed that you are using TCR 1.1.1. In this case drivers directory is here.
<install_dir>lib\birt-runtime-2_2_1\ReportEngine\plugins\org.eclipse.birt.report.data.oda.jdbc_2.2.1.r22x_v20070919\drivers

BTW. Why are you using 1.1.1? I guess you should be able to get/download TCR 1.2.0.1 - part number for Windows is C1Y4HML.

Kind regards,
Tomasz Sekman

@__@@

Posts: 23
Registered: Feb 11, 2009 08:03:54 AM

Re: Connecting TCR to ITM for report
Posted: Nov 09, 2009 10:41:50 AM

in response to: tsekman's post

Thank you so much, I actually used the correcr JDBC and my connection was successful, I am about downloading the tcr according to the part given.
I will get back to u, thanks alot.

@__@@

Posts: 23
Registered: Feb 11, 2009 08:03:54 AM

Re: Connecting TCR to ITM for report
Posted: Nov 10, 2009 08:31:05 AM

in response to: @__@@'s post

tcrerror.doc (115.5 KB)

Hi Tomasz Sekman,

Thanks so much, please I really need your assistance here, I was able to install TCR V 2.2.1 but i am a novies configuring this report and hw to make it work to generate ITM report.

I have gone thru the pdf but I still cant figure my self out, please help with step by step of the implemenation.

attached is a copy of the new error i got pls, kindly help

Thanks so much.

Pages: 1

Back to Thread List

Threads: [ Previous | Next ]

Update your My developerWorks profile and start connecting with others.