Hi Richard, i now it's a bit delayed but I had a post on my Blog about the steps to recover your corrupted Warehouse, it might be of help for later issues (God forbids) :)
The post URL is http://abadawi.blogspot.com/2007/01/tfswarehouse-cube-corruption.html Regards, Ayman On 10/30/07, Richard Banks <[EMAIL PROTECTED]> wrote: > > I've now slapped myself in the forehead and feel much better for doing > so. > > > > When running setupwarehouse.exe I was using the command line. When I > tried running it with the –rebuild option I was using command line history > to save typing and forgot to remove the –o option to force a rebuild of both > the OLTP and OLAP databases. > > > > I just did a full rebuild again and now it all works properly. > > > > I'll still be checking the process templates though to see if I can find > why it broke in the first place. > > > > - Richard > > > > *From:* [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] *On Behalf Of > *Richard Banks > *Sent:* Tuesday, 30 October 2007 2:39 PM > *To:* [email protected] > *Subject:* [OzTFS] RE: TFSWarehouse problem > > > > It's very, very possible as it's an existing TFS server that has been used > for many other projects by many other people. Unfortunately none of the > people here now have any real history with what's happened on this server. > > > > I'm going to have to put my investigators hat J > > > > - Richard > > > > *From:* [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] *On Behalf Of > *Chris Burrows > *Sent:* Tuesday, 30 October 2007 2:26 PM > *To:* [email protected] > *Subject:* [OzTFS] RE: TFSWarehouse problem > > > > The question I have then has somebody been playing with the process > templates? You might also want to look here > http://msdn2.microsoft.com/en-us/library/ms252458(VS.80).aspx for some > ideas. > > > > Cheers > > > > Chris > > > > Chris Burrows > Readify | Principal Consultant (Canberra Region) > M: +61 (0)404 254 654 > ------------------------------ > > The content of this e-mail, including any attachments is a confidential > communication between Readify Pty Ltd and the intended addressee and is for > the sole use of that intended addressee. If you are not the intended > addressee, any use, interference with, disclosure or copying of this > material is unauthorized and prohibited. If you have received this e-mail in > error please contact the sender immediately and then delete the message and > any attachment(s). > > > > *From:* [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] *On Behalf Of > *Richard Banks > *Sent:* Tuesday, 30 October 2007 2:19 PM > *To:* [email protected] > *Subject:* [OzTFS] RE: TFSWarehouse problem > > > > Hi Chris, > > > > I've already tried that. > > > > I've also completely removed the OLAP data directory before doing > setupwarehouse (as per > http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=317697&SiteID=1) > but that didn't work either. > > > > I've also tried the "bare earth" policy and used the -rebuild option for > setupwarehouse. Also no luck. > > > > I'd think the next step would be to drop the TFSWarehouse database > completely, but I haven't looked into what steps I'd need to get that back > up and running. > > > > - Richard > > > ------------------------------ > > *From:* [EMAIL PROTECTED] [EMAIL PROTECTED] On Behalf Of Chris > Burrows [EMAIL PROTECTED] > *Sent:* Tuesday, 30 October 2007 2:08 PM > *To:* [email protected] > *Subject:* [OzTFS] RE: TFSWarehouse problem > > Richard, > > > > Whilst I haven't seen this specific error, I have had errors with the > Warehouse before. When I had them I just rebuilt the cube and the problem > went away. Some of the problems can happen if people have been playing > with the Process templates. You can rebuild the Warehouse cube, by using > the following command. > > > > setupwarehouse -o -s ServerName -d TFSWarehouse -c > warehouseschema.xml -a TFSServiceAccount -ra TFSReportAccount. > > > > More information about the command can be found here. > http://msdn2.microsoft.com/en-us/library/ms400783(VS.80).aspx > > > > Cheers > > > > Chris > > > > Chris Burrows > Readify | Principal Consultant (Canberra Region) > M: +61 (0)404 254 654 > ------------------------------ > > The content of this e-mail, including any attachments is a confidential > communication between Readify Pty Ltd and the intended addressee and is for > the sole use of that intended addressee. If you are not the intended > addressee, any use, interference with, disclosure or copying of this > material is unauthorized and prohibited. If you have received this e-mail in > error please contact the sender immediately and then delete the message and > any attachment(s). > > > > *From:* [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] *On Behalf Of > *Richard Banks > *Sent:* Tuesday, 30 October 2007 1:51 PM > *To:* [email protected] > *Subject:* [OzTFS] TFSWarehouse problem > > > > Hi, > > > > Out of curiosity has anyone seen these sort of analysis services errors > before during cube processing? > > > > Detailed Message: Processing OLAP failed > Exception Message: The member '[10/30/2007]' was not found in the cube > when the string, [Date].[Date].[Date].[10/30/2007], was parsed. > The END SCOPE statement does not match the opening SCOPE statement. > MdxScript(Team System) (66, 1) The END SCOPE statement does not match the > opening SCOPE statement. > The member '[Week of October 28]' was not found in the cube when the > string, [Date].[Week].[Week].[Week of October 28], was parsed. > The END SCOPE statement does not match the opening SCOPE statement. > MdxScript(Team System) (70, 1) The END SCOPE statement does not match the > opening SCOPE statement. > The member '[October, 2007]' was not found in the cube when the string, > [Date].[Month].[Month].[October, 2007], was parsed. > The END SCOPE statement does not match the opening SCOPE statement. > MdxScript(Team System) (74, 1) The END SCOPE statement does not match the > opening SCOPE statement. > > > > I've been trying to figure out what is causing it, but so far I've come up > with nothing. > > > > Regards, > > *Richard Banks > *Readify | Senior Consultant > > Suite 206 Nolan Tower | 29 Rakaia Way | Docklands | VIC 3008 | Australia > > M: +61 424 184 979 | E: [EMAIL PROTECTED] | C: > [EMAIL PROTECTED] | W: www.readify.net > ------------------------------ > > The content of this e-mail, including any attachments is a confidential > communication between Readify Pty Ltd and the intended addressee and is for > the sole use of that intended addressee. If you are not the intended > addressee, any use, interference with, disclosure or copying of this > material is unauthorized and prohibited. If you have received this e-mail in > error please contact the sender immediately and then delete the message and > any attachment(s). > > OzTFS.com - to unsubscribe from this list, send a message back to the list > with 'unsubscribe' as the subject. View the web archives at > http://www.mail-archive.com/[email protected]/ > Powered by mailenable.com, supported by www.readify.net > > OzTFS.com - to unsubscribe from this list, send a message back to the list > with 'unsubscribe' as the subject. View the web archives at > http://www.mail-archive.com/[email protected]/ > Powered by mailenable.com, supported by www.readify.net > > OzTFS.com - to unsubscribe from this list, send a message back to the list > with 'unsubscribe' as the subject. View the web archives at > http://www.mail-archive.com/[email protected]/ > Powered by mailenable.com, supported by www.readify.net > > OzTFS.com - to unsubscribe from this list, send a message back to the list > with 'unsubscribe' as the subject. View the web archives at > http://www.mail-archive.com/[email protected]/ > Powered by mailenable.com, supported by www.readify.net > > OzTFS.com - to unsubscribe from this list, send a message back to the list > with 'unsubscribe' as the subject. View the web archives at > http://www.mail-archive.com/[email protected]/ > Powered by mailenable.com, supported by www.readify.net > OzTFS.com - to unsubscribe from this list, send a message back to the list > with 'unsubscribe' as the subject. View the web archives at > http://www.mail-archive.com/[email protected]/ > Powered by mailenable.com, supported by www.readify.net > -- Regards, Ayman Badawi OzTFS.com - to unsubscribe from this list, send a message back to the list with 'unsubscribe' as the subject. View the web archives at http://www.mail-archive.com/[email protected]/ Powered by mailenable.com, supported by www.readify.net
