nv-l
[Top] [All Lists]

RE: [nv-l] TDW Blank Reports!!!

To: nv-l@lists.us.ibm.com
Subject: RE: [nv-l] TDW Blank Reports!!!
From: usman.taokeer@s-iii.com
Date: Mon, 8 May 2006 13:16:16 +0500
Cc: nv-l@lists.us.ibm.com, owner-nv-l@lists.us.ibm.com
Delivery-date: Mon, 08 May 2006 09:13:02 +0100
Envelope-to: nv-l-archive@lists.skills-1st.co.uk
In-reply-to: <EE7CD35953DA44468086D44664EB59BC011BF070@v53-es02.nets.nemais.navy.mil>
Reply-to: nv-l@lists.us.ibm.com
Sender: owner-nv-l@lists.us.ibm.com

Micheal,

Everything is on one server with following versions: -
  • Crystal Enterprise 10 SP4
  • Latest Monthly Hot Fixes for Crystal
  • TDW 1.3
  • WEP 1.2 - ANM 1.2.1
  • WIndows 2003 SP1
  • DB2 8.1 FP10a




"Hoang, Michael D CONT \(NETS\)" <Michael.Hoang@nets.nemais.navy.mil>
Sent by: owner-nv-l@lists.us.ibm.com

05-05-06 09:10 PM
Please respond to
nv-l@lists.us.ibm.com

To
<nv-l@lists.us.ibm.com>
cc
Subject
RE: [nv-l] TDW Blank Reports!!!





Usman,
 
1) What version of TDW and Crystal are you using ?  What fixpacks have you applied ?
2) Are all the components on one machine, or are they distributed ?  Please describe the architecture of your environment.

3) If the Crystal Enterprise Server and the Data Mart are on different servers, did you perform this step from the TDW Installation Manual:

 
To create an ODBC connection from the Crystal Enterprise server to a data mart on DB2 Universal Database, choose from one of the following options: If the Crystal Enterprise server is on a stand-alone system and no other Tivoli Data Warehouse components are installed on the system, use twh_create_datasource to create an ODBC data source on the Crystal Enterprise server...
 
 



From: owner-nv-l@lists.us.ibm.com [mailto:owner-nv-l@lists.us.ibm.com] On Behalf Of usman.taokeer@s-iii.com
Sent:
Friday, May 05, 2006 12:06 PM
To:
nv-l@lists.us.ibm.com
Cc:
nv-l@lists.us.ibm.com; owner-nv-l@lists.us.ibm.com
Subject:
RE: [nv-l] TDW Blank Reports!!!



Thanks a lot, if i am not mistaken this script is written to extract data from ITM DWH! will it work for Netview's DWH as well?? Coz i dont see any of relevant tables in the queries!


Regards,


Usman Taokeer

Si3


"Hoang, Michael D CONT \(NETS\)" <Michael.Hoang@nets.nemais.navy.mil>
Sent by: owner-nv-l@lists.us.ibm.com

05-05-06 08:38 PM
Please respond to
nv-l@lists.us.ibm.com


To
<nv-l@lists.us.ibm.com>
cc
Subject
RE: [nv-l] TDW Blank Reports!!!







Usman,

Modify the user name and password....run this perl script to see if there is data in your TWD_MD database.

 

%TWH_TOPDIR\tools\perl\bin\perl.exe amy_check_host_data.pl

 

Let me know how this goes.



From: owner-nv-l@lists.us.ibm.com [mailto:owner-nv-l@lists.us.ibm.com] On Behalf Of usman.taokeer@s-iii.com
Sent:
Friday, May 05, 2006 11:28 AM
To:
nv-l@lists.us.ibm.com
Cc:
nv-l@lists.us.ibm.com
Subject:
RE: [nv-l] TDW Blank Reports!!!


well.. there isn't any data... what next!

-----owner-nv-l@lists.us.ibm.com wrote: -----


To: <nv-l@lists.us.ibm.com>
From: "Hoang, Michael D CONT \(NETS\)" <Michael.Hoang@nets.nemais.navy.mil>
Sent by: owner-nv-l@lists.us.ibm.com
Date: 05/05/2006 08:09PM
Subject: RE: [nv-l] TDW Blank Reports!!!

Usman,
Make sure there is data in the TWH_MD database.



From: owner-nv-l@lists.us.ibm.com [mailto:owner-nv-l@lists.us.ibm.com] On Behalf Of Colin Mulkerrins
Sent:
Friday, May 05, 2006 11:01 AM
To:
nv-l@lists.us.ibm.com
Subject:
RE: [nv-l] TDW Blank Reports!!!


Hey Usman,
Welcome to my world.  Never had any satisfaction from TDW - gave up on it...
Regs

Colin M

-----Original Message-----
From:
owner-nv-l@lists.us.ibm.com [mailto:owner-nv-l@lists.us.ibm.com] On Behalf Of usman.taokeer@s-iii.com
Sent:
05 May 2006 16:00
To:
nv-l@lists.us.ibm.com
Subject:
[nv-l] TDW Blank Reports!!!
Importance:
High


Hi,

TDW 1.3
WEP ANM 1.2.1
NV FP04
Win2003 std SP1

Installed Tivoli Data warehouse 1.3 and WEP 1.2, Executed ETL but when check reports on crystal server there is no data, the ETL processs was successfull, but yet i dont see any data when i execute any of the reports. Any reason ... what can i check to trouble shoot this ... the installation went smooth followed all the steps.

Regards,

Usman Taokeer
Si3.

*********************************************************************************

This e-mail and its attachments, is confidential and is intended for the addressee(s) only. If you are not the intended recipient, disclosure, distribution or any action taken in reliance on it is prohibited and may be unlawful. Please note that any information expressed in this message or its attachments is not given or endorsed by An Post unless otherwise indicated by an authorised representative independently of this message. An Post does not accept responsibility for the contents of this message and although it has been scanned for viruses An Post will not accept responsibility for any damage caused as a result of a virus being passed on.

*********************************************************************************

<Prev in Thread] Current Thread [Next in Thread>

Archive operated by Skills 1st Ltd

See also: The NetView Web