dean j garrett

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!

dean j garrett

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'

robert bogue [mvp]

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

Rob