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 success
Author: "Colin Mulkerrins" <Colin.Mulkerrins AT anpost DOT ie>
Date: Fri, 5 May 2006 16:01:22 +0100
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 DO
Author: "Hoang, Michael D CONT \(NETS\)" <Michael.Hoang AT nets.nemais.navy DOT mil>
Date: Fri, 5 May 2006 11:09:54 -0400
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
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 D
Author: "Hoang, Michael D CONT \(NETS\)" <Michael.Hoang AT nets.nemais.navy DOT mil>
Date: Fri, 5 May 2006 11:38:21 -0400
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.
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 T
Author: "Hoang, Michael D CONT \(NETS\)" <Michael.Hoang AT nets.nemais.navy DOT mil>
Date: Fri, 5 May 2006 12:10:16 -0400
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
Guys, the TWH_MD database is irrelevant in this case. The perl script referenced also seems to be wrong....it looks to be for the AMY WEP not the ANM WEP). In order to trouble shoot this type of prob
Also make sure the tdwdaemon has run at least once to refresh the smartset's it is monitoring. This is based on the entries in the /usr/OV/conf/tdwdameon.properties file. Here is an example. Note the
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, Micha