Problem with Report Pack for sharepoint's, rpdataextraction parser

hi,

when i try to execute the rpdataextraction parser, i am getting the following message - Unable to access site collection: User cannot be found.

it will be of immense help for me if any one helps me on this or directs me to right resource.

thanks

hello,

I have the same problem, so yesterday I found a possible solution for this problem, I'm trying to follow it:

There are a french blog for this issue: http://fmdain.blogspot.com/2006/06/reporting-pack-sps.pour-sql2k5.html.

The solution consist in:

1 - Verify that the tables DimDate and DimTime was complete filled. In my case the DimTime wasn't.

2 - an edition on procedures on database dbSPSReporting, to comment's lines : WHERE dd.DateFull and DATEADD, for all procedures on database.

I localized only those below:

PROCEDURE dbo.uspStorage_AreaGrowthTrend
PROCEDURE dbo.uspStorage_ListGrowthTrend
PROCEDURE dbo.uspStorage_SiteCollectionTrend
PROCEDURE dbo.uspStorage_SizeTrend
PROCEDURE dbo.usp_StartDateEndDate_Retrieve

If you use this solution and works, please send me a confirmation and any other comments about, or other solution.

Regards,

Ernani