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

[usman.taokeer@s-iii.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.

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