Topic
1 reply Latest Post - ‏2012-10-16T19:53:09Z by SystemAdmin
SystemAdmin
SystemAdmin
373 Posts
ACCEPTED ANSWER

Pinned topic New with TCR

‏2012-10-16T15:24:21Z |
Hi,
we are trying to import reports from ITCAM, but when running:
./trcmd.sh -modify -dataSources -reports -username tipadmin -password XXX -dataSource name=WAREHOUS -setDatasource odaURL="jdbc:db2://10.16.93.25:50000/WAREHOUS:currentSchema=ITMUSER" odaDriverClass="com.ibm.db2.jcc.DB2Driver" odaUser=itmuser odaPassword=XXX

CTGTRQ099W No datasource matching the criteria was found for modification.

And when:
./trcmd.sh -user tipadm -password XXX -dataSource -test WAREHOUS -dbLogin itmuser -dbPassword XXX
CTGTRI164E Processing has failed. See the following error message for details:
QE-DEF-0285 The logon failed.

Should I configure something else in the DB2 client?
Updated on 2012-10-16T19:53:09Z at 2012-10-16T19:53:09Z by SystemAdmin
  • SystemAdmin
    SystemAdmin
    373 Posts
    ACCEPTED ANSWER

    Re: New with TCR

    ‏2012-10-16T19:53:09Z  in response to SystemAdmin
    Hi,
    That is a command to set a BIRT-based data source. Are you sure you have a BIRT package and not a Cognos package?

    First as a general comment, check out the field guide under the videos. That's a great overall resource.

    If this is indeed BIRT,: http://pic.dhe.ibm.com/infocenter/tivihelp/v3r1/topic/com.ibm.tivoli.tcr.doc_211/ttcr_jdbc_direct.html
    I don't know if WAREHOUS is the correct name the datasource is defined as in the reports. I think it's "ITM". You can instead pass a report name instead of a data source name (get the report name from a -list -reports.

    I suspect you instead have a Cognos package. In this case, I prefer to use the web UI to create the data source (but you first must have a local DB2 client or server cataloged with the database:
    http://pic.dhe.ibm.com/infocenter/tivihelp/v3r1/topic/com.ibm.tivoli.tcr.doc_211/ttcr_config_db2db.html
    You can also see this in Video #5, setting up a DB2 data source for a Cognos-based package:
    https://www.ibm.com/developerworks/mydeveloperworks/groups/service/html/communityview?communityUuid=9caf63c9-15a1-4a03-96b3-8fc700f3a364

    I hope that helps, Dan Krissell