Hi, all experts here,
How can we find the storage location of the first partition of a cube originally when the cube is created? I mean after the cube is created with the cube wizard, we can always add new partitions for a cube with the partition wizard which enables us to select the storage location of the partitions. But how about the first partition of a cube which is created automatically along with the creation of a cube? I need to locate the storage locations of all partitions of a cube to be able to put the OLAP database somewhere with enough space.
I am looking forward to hearing from you shortly and thanks a lot in advance for your kind advices and help.
With best regards,
Yours sincerely,
Open SSMS, connect to your instance, right-click it and select Properties. In the General tab, look for a property called DataDir. Your partitions will be created in a subfolder of that folder. If you open the value dialog on this property, you will be given instructions on how to make additional locations available.
Good luck,
Bryan
You can also view and set this from within BIDS for any partion.
Open up the cube, click on the partitions tab, click on a partition and in the properties window (right click on the partition and select "Properties" if this window is not already visible, in my environment the properties window is always visible in the lower right hand corner). There is a property called StoreageLocation, if you click on the button for this property a dialog pops up that lets you see the default storage location and override it, to set it to a given folder.
You can also change this property at the Cube and MeasureGroup objects, but I think at this level the property only works as a default setting for any new partitions that are created.
|||Why I am not able to start the Analysis Services Engine again as the error message from event viewer as:
Event Type: Error
Event Source: MSSQLServerOLAPService
Event Category: (289)
Event ID: 0
Date: 04/07/2007
Time: 10:45:48
User: N/A
Computer: computer_name
Description:
The service cannot be started: Message-handling subsystem: The message manager for the default locale cannot be found. The locale will be changed to US English. Message-handling subsystem: The message manager for the default locale cannot be found. The locale will be changed to US English. The following system error occurred: The filename, directory name, or volume label syntax is incorrect. . File system error: Error occurred during the creation of directory: '\\?\'.
For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
On SQL Server, when I start the Analysis services, the error message is : The SQL Server Analysis Services (MSSQLSERVER) service on local computer started and then stopped. Some services stop automatically if they have no work to do, for example, the performance logs and Alerts service.
Why is that? That is really frustrated and please any of you give me any advices or help on it. Thanks a lot in advance.
With best regards,
Yours sincerely,
|||Hi, Bryan,
Thank you for your kind advices. But another very weird problem occured now. I am not even able to restart the SQL Server 2005 Analysis Services Service now.
Event Type: Error
Event Source: MSSQLServerOLAPService
Event Category: (289)
Event ID: 0
Date: 04/07/2007
Time: 10:45:48
User: N/A
Computer: computer_name
Description:
The service cannot be started: Message-handling subsystem: The message manager for the default locale cannot be found. The locale will be changed to US English. Message-handling subsystem: The message manager for the default locale cannot be found. The locale will be changed to US English. The following system error occurred: The filename, directory name, or volume label syntax is incorrect. . File system error: Error occurred during the creation of directory: '\\?\'.
For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
On SQL Server, when I start the Analysis services, the error message is : The SQL Server Analysis Services (MSSQLSERVER) service on local computer started and then stopped. Some services stop automatically if they have no work to do, for example, the performance logs and Alerts service.
I have no idea what is going on and that is pretty frustrated.
I am looking forward to hearing from any of you here for your kind advices and help.
Thanks in advance.
With best regards,
Yours sincerely,
|||Did you change something?
The error message seems similar to the one you posted on June 13 in PostID 463688. Could this be the same issue?
B.
|||Hi, Bryan,
Thanks for your reply.
I have no idea what did I change. The only thing I did change was DataDir setting of the server property which I changed to other storage location instead of where the Analysis Services Instance was originally installed.
Does that have something to do with this problem?
Thanks a lot and I am looking forward to hearing from you shortly.
With best regards,
Yours sincerely,
|||Changing the default DataDir of a server that is in use is a bigger deal than either BOL or the user interface lets on.
Other people have posted about similar issues before: http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=500300&SiteID=1
The above posting might give you some ideas as to how to rectify the issue, it might be that the SSAS service account does not have access to the new location.
An alternative approach would be to set the DataDir back to its default setting and to just move specific cubes/partitions to an alternate location.
|||These two threads have been merged as the same question was posted twice
