Mombu the Microsoft Forum sponsored links

Go Back   Mombu the Microsoft Forum > Microsoft > Report prep DTS step?
User Name
Password
REGISTER NOW! Mark Forums Read

sponsored links


Reply
 
1 21st January 09:51
dean j garrett
External User
 
Posts: 1
Default Report prep DTS step?


When running the dw population DTS task, it gets all the way through except
for the last step: "Report Preparation". The error just says "Report
preparation failed." but nothing more descriptive. There were no logs
generated for additional info. How can I find out why this step failed?
Where do I look?

Also, how can I find out what this step is actually doing. I don't see a
property page??

Thanks!
  Reply With Quote


  sponsored links


2 21st January 09:51
dean j garrett
External User
 
Posts: 1
Default Report prep DTS step?


Hello,

I have some more info about the Report Prep DTS step. I looked in the
Windows application log and found the following errors, all having to do
with "no rows" found? The system I'm working on is in test mode, so there's
not much data, but would that stop the cubes from being processed?

Thanks!

-----------------

Prepare Reports DTS task : Error Processing error [Source data contains no
rows] 'Buyer Visits^BuyerType'S'

Prepare Reports DTS task : Error Processing error [Source data contains no
rows] 'Buyer Visits^UserType'S'

Prepare Reports DTS task : Error Processing error [Source data contains no
rows] '***mulative User Activity^Event'S'

Prepare Reports DTS task : Error Processing error [Source data contains no
rows] '***mulative User Activity^Site Page'S'

Prepare Reports DTS task : Error Processing error [Source data contains no
rows] '***mulative User Activity^User Name'S'

Prepare Reports DTS task : Error Processing error [Source data contains no
rows] 'Do***entActivitySummary^Product Name'S'

Prepare Reports DTS task : Error Processing error [Source data contains no
rows] 'Do***entActivitySummary^User Name'S'

Prepare Reports DTS task : Error Processing error [Source data contains no
rows] 'Full Name'S'

Prepare Reports DTS task : Error Processing error [Source data contains no
rows] 'Named User Activity^Company Name'S'

Prepare Reports DTS task : Error Processing error [Source data contains no
rows] 'Named User Activity^Doc Name'S'

Prepare Reports DTS task : Error Processing error [Source data contains no
rows] 'Named User Activity^Full Name'S'

Prepare Reports DTS task : Error Processing error [Source data contains no
rows] 'Named User Activity^Logon Name'S'

Prepare Reports DTS task : Error Cube Process Full : ***mulative User
Activity : Processing error [Source data contains no rows] '***mulative User
Activity^User Name'S'

Prepare Reports DTS task : Error Cube Process Full : Do***entActivitySummary
: Processing error [Source data contains no rows]
'Do***entActivitySummary^User Name'S'

Prepare Reports DTS task : Error Cube Process Full : Named User Activity :
Processing error [Source data contains no rows] 'Named User Activity^Logon
Name'S'
  Reply With Quote


  sponsored links


3 21st January 09:51
robert bogue [mvp]
External User
 
Posts: 1
Default Report prep DTS step?


Yes, it can. Try importing everything (profiles, transactions, etc.)
once -- even if there is no data. That should clear it up.

Rob
  Reply With Quote
Reply


Thread Tools
Display Modes




Copyright 2006 SmartyDevil.com - Dies Mies Jeschet Boenedoesef Douvema Enitemaus -
666