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]<mailto:[EMAIL PROTECTED]> | C: [EMAIL PROTECTED]<sip:[EMAIL PROTECTED]> | W: www.readify.net<http://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
