InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comMon, 20 May 2013 15:19:11 GMT20http://www.sqlservercentral.com/Forums/Topic1174360-147-1.aspxHello,I am new to this. can u send me any documents with steps to follow on this?ThanksTue, 18 Dec 2012 04:17:01 GMTdhaval.joshi.djhttp://www.sqlservercentral.com/Forums/Topic1174360-147-1.aspxHave you set the correct permissions to the files it is complaining about not being able to access? Do the files even exist?Tue, 18 Dec 2012 04:01:49 GMTanthony.greenhttp://www.sqlservercentral.com/Forums/Topic1174360-147-1.aspxHello,Thanks for prompt reply.I have done the same thing.But still facing issue.Please advice.Tue, 18 Dec 2012 04:00:52 GMTdhaval.joshi.djhttp://www.sqlservercentral.com/Forums/Topic1174360-147-1.aspxCreate a job in SQL Agent.Job Step Type of SQL Server Analysis Services CommandCommand below[code="other"]<Batch xmlns="http://schemas.microsoft.com/analysisservices/2003/engine"> <Parallel> <Process xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:ddl2="http://schemas.microsoft.com/analysisservices/2003/engine/2" xmlns:ddl2_2="http://schemas.microsoft.com/analysisservices/2003/engine/2/2" xmlns:ddl100_100="http://schemas.microsoft.com/analysisservices/2008/engine/100/100" xmlns:ddl200="http://schemas.microsoft.com/analysisservices/2010/engine/200" xmlns:ddl200_200="http://schemas.microsoft.com/analysisservices/2010/engine/200/200"> <Object> <DatabaseID>******************BUT YOUR CUBE DATABASE NAME HERE******************</DatabaseID> </Object> <Type>ProcessFull</Type> <WriteBackTableCreation>UseExisting</WriteBackTableCreation> </Process> </Parallel></Batch>[/code]Also ensure that you have given the SQL Agent account the access it needs on the right directories etc.Tue, 18 Dec 2012 03:54:36 GMTanthony.greenhttp://www.sqlservercentral.com/Forums/Topic1174360-147-1.aspxI have done scheduling by copying the code and made the job in SQL server agent.However, while running job, it gives error message like below.Executed as user: VGROUP\BI-SERVER$. System.Configuration.ConfigurationErrorsException: Configuration system failed to initialize ---> System.Configuration.ConfigurationErrorsException: An error occurred loading a configuration file: Access to the path 'C:\Windows\Microsoft.NET\Framework64\v2.0.50727\Config\machine.config' is denied. (C:\Windows\Microsoft.NET\Framework64\v2.0.50727\Config\machine.config) ---> System.UnauthorizedAccessException: Access to the path 'C:\Windows\Microsoft.NET\Framework64\v2.0.50727\Config\machine.config' is denied. at System.IO.__Error.WinIOError(Int32 errorCode<c/> String maybeFullPath) at System.IO.FileStream.Init(String path<c/> FileMode mode<c/> FileAccess access<c/> Int32 rights<c/> Boolean useRights<c/> FileShare share<c/> Int32 bufferSize<c/> FileOptions options<c/> SECURITY_ATTRIBUTES secAttrs<c/> String msgPath<c/> Boolean bFromProxy) at System.IO.FileStream..ctor(String path<c/> FileMode mode<c/> FileAccess access<c/> FileShare share<c/> Int32 bufferSize<c/> FileOptions options<c/> String msgPath<c/> Boolean bFromProxy) at System.IO.FileStream..ctor(String path<c/> FileMode mode<c/> FileAccess access<c/> FileShare share) at System.Configuration.Internal.InternalConfigHost.StaticOpenStreamForRead(String streamName) at System.Configuration.Internal.InternalConfigHost.System.Configuration.Internal.IInternalConfigHost.OpenStreamForRead(String streamName<c/> Boolean assertPermissions) at System.Configuration.Internal.InternalConfigHost.System.Configuration.Internal.IInternalConfigHost.OpenStreamForRead(String streamName) at System.Configuration.ClientConfigurationHost.OpenStreamForRead(String streamName) at System.Configuration.BaseConfigurationRecord.InitConfigFromFile() --- End of inner exception stack trace --- at System.Configuration.ConfigurationSchemaErrors.ThrowIfErrors(Boolean ignoreLocal) at System.Configuration.BaseConfigurationRecord.ThrowIfInitErrors() at System.Configuration.ClientConfigurationSystem.EnsureInit(String configKey) --- End of inner exception stack trace --- at System.Configuration.ClientConfigurationSystem.EnsureInit(String configKey) at System.Configuration.ClientConfigurationSystem.PrepareClientConfigSystem(String sectionName) at System.Configuration.ClientConfigurationSystem.System.Configuration.Internal.IInternalConfigSystem.GetSection(String sectionName) at System.Configuration.ConfigurationManager.GetSection(String sectionName) at System.Configuration.PrivilegedConfigurationManager.GetSection(String sectionName) at System.Net.Configuration.SettingsSectionInternal.get_Section() at System.Net.Sockets.Socket.InitializeSockets() at System.Net.IPAddress.InternalParse(String ipString<c/> Boolean tryParse) at System.Net.NetworkInformation.IpAddrString.ToIPAddressCollection() at System.Net.NetworkInformation.FixedInfo..ctor(FIXED_INFO info) at System.Net.NetworkInformation.SystemIPGlobalProperties.GetFixedInfo() at System.Net.NetworkInformation.SystemIPGlobalProperties.get_FixedInfo() at System.Net.NetworkInformation.SystemIPGlobalProperties.get_DomainName() at System.Net.CookieContainer..ctor() at Microsoft.AnalysisServices.Xmla.XmlaClient..ctor(StringCollection log) at Microsoft.SqlServer.Management.Smo.Olap.SoapClient..ctor(String serverName<c/> String connectionString) at OlapEvent(SCH_STEP* pStep<c/> SUBSYSTEM* pSubSystem<c/> SUBSYSTEMPARAMS* pSubSystemParams<c/> Boolean fQueryFlag). The step failed.Please suggest.Thanks in advance.Tue, 18 Dec 2012 03:42:51 GMTdhaval.joshi.djhttp://www.sqlservercentral.com/Forums/Topic1174360-147-1.aspxYou can create Either an XMLA script To process the cube OR SSAS Cube Process Task in SSIS Designer, For XMLA Script you need to connect to the Analysis Services , select the cube that you want to create Script, Right click and select process tab, a new window opens on the top corner select script, then select create XMLA script..Copy the script in Job schedule Task in SSMS for processing the Cube.Wed, 14 Sep 2011 03:54:08 GMTaks27http://www.sqlservercentral.com/Forums/Topic1174360-147-1.aspxi would like to create an automatic job or script or command to run PROCESS on my cube.dougTue, 13 Sep 2011 10:39:04 GMTdoug moore