RE: [nv-l] TDW Blank Reports!!!
2006-05-08 04:13:01
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 AT nets.nemais.navy DOT mil>
Sent by: owner-nv-l AT lists.us.ibm DOT com
05-05-06 09:10 PM
Please respond to
nv-l AT lists.us.ibm DOT com |
|
To
| <nv-l AT lists.us.ibm DOT 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 AT lists.us.ibm DOT com
[mailto:owner-nv-l AT lists.us.ibm DOT com] On Behalf Of usman.taokeer AT s-iii DOT com
Sent: Friday, May 05, 2006 12:06 PM
To: nv-l AT lists.us.ibm DOT com
Cc: nv-l AT lists.us.ibm DOT com; owner-nv-l AT lists.us.ibm DOT 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 AT nets.nemais.navy DOT mil>
Sent by: owner-nv-l AT lists.us.ibm DOT com
05-05-06 08:38 PM
Please respond to
nv-l AT lists.us.ibm DOT com |
|
To
| <nv-l AT lists.us.ibm DOT 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 AT lists.us.ibm DOT com
[mailto:owner-nv-l AT lists.us.ibm DOT com] On Behalf Of usman.taokeer AT s-iii DOT com
Sent: Friday, May 05, 2006 11:28 AM
To: nv-l AT lists.us.ibm DOT com
Cc: nv-l AT lists.us.ibm DOT com
Subject: RE: [nv-l] TDW Blank Reports!!!
well.. there isn't any data... what next!
-----owner-nv-l AT lists.us.ibm DOT com wrote: -----
To: <nv-l AT lists.us.ibm DOT com>
From: "Hoang, Michael D CONT \(NETS\)" <Michael.Hoang AT nets.nemais.navy DOT mil>
Sent by: owner-nv-l AT lists.us.ibm DOT 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 AT lists.us.ibm DOT com
[mailto:owner-nv-l AT lists.us.ibm DOT com] On Behalf Of Colin Mulkerrins
Sent: Friday, May 05, 2006 11:01 AM
To: nv-l AT lists.us.ibm DOT 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 AT lists.us.ibm DOT com [mailto:owner-nv-l AT lists.us.ibm DOT com]
On Behalf Of usman.taokeer AT s-iii DOT com
Sent: 05 May 2006 16:00
To: nv-l AT lists.us.ibm DOT 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.
*********************************************************************************
|
|
|