October 13, 2013 at 12:18 am
Hi All,
I am facing file system and memory error(most of the time) problem in cube processing
I tried to execute it through a process as well as running it with normal xml script
But every time they are getting failed
It is giving me the following error
Execution failed: File system error: A FileStore error from WriteFile occurred. Physical file: \\?\E:\Program Files (x86)\Microsoft SQL Server\MSSQL.2\OLAP\Data\PV_OLAP.0.db\Ev Data Source 19.0.cub\PVC Tab Resource Hours Fact.0.det\PVC Tab Resource Hours Fact 2.0.prt\13.fact.data. Logical file: . : Not enough storage is available to process this command. .
File system error: The following error occurred while writing to the file 'LazyWriter Stream': Not enough storage is available to process this command. .
File system error: The background thread running lazy writer encountered an I/O error. Physical file: \\?\E:\Program Files (x86)\Microsoft SQL Server\MSSQL.2\OLAP\Data\PV_OLAP.0.db\Ev Data Source 19.0.cub\PVC Tab Resource Hours Fact.0.det\PVC Tab Resource Hours Fact 2.0.prt\13.fact.data. Logical file: .
File system error: A FileStore error from WriteFile occurred. Physical file: \\?\E:\Program Files (x86)\Microsoft SQL Server\MSSQL.2\OLAP\Data\PV_OLAP.0.db\Ev Data Source 19.0.cub\PVC Tab Resource Hours Fact.0.det\PVC Tab Resource Hours Fact 2.0.prt\13.fact.data. Logical file: . : Not enough storage is available to process this command. .
File system error: The following error occurred while writing to the file 'LazyWriter Stream': Not enough storage is available to process this command. .
File system error: The background thread running lazy writer encountered an I/O error. Physical file: \\?\E:\Program Files (x86)\Microsoft SQL Server\MSSQL.2\OLAP\Data\PV_OLAP.0.db\Ev Data Source 19.0.cub\PVC Tab Resource Hours Fact.0.det\PVC Tab Resource Hours Fact 2.0.prt\13.fact.data. Logical file: .
The following system error occurred from a call to GetOverlappedResult for Physical file: '\\?\E:\Program Files (x86)\Microsoft SQL Server\MSSQL.2\OLAP\Data\PV_OLAP.0.db\Ev Data Source 19.0.cub\PVC Tab Resource Hours Fact.0.det\PVC Tab Resource Hours Fact 2.0.prt\13.fact.data', Logical file: '' : Not enough storage is available to process this command. .
File system error: The following error occurred during a file operation: .
Errors in the OLAP storage engine: An error occurred while processing the 'Pvc Resourcemixbycompetence 2' partition of the 'Demand' measure group for the 'Capacity Planning NCCM' cube from the PV_OLAP database.
Internal error: The operation terminated unsuccessfully.
Internal error: The operation terminated unsuccessfully.
Internal error: The operation terminated unsuccessfully.
Internal error: The operation terminated unsuccessfully.
Internal error: The operation terminated unsuccessfully.
at Microsoft.AnalysisServices.AnalysisServicesClient.SendExecuteAndReadResponse(ImpactDetailCollection impacts, Boolean expectEmptyResults, Boolean throwIfError)
at Microsoft.AnalysisServices.AnalysisServicesClient.Process(IMajorObject obj, ProcessType type, Binding source, ErrorConfiguration errorConfig, WriteBackTableCreation writebackOption, ImpactDetailCollection impact)
at Microsoft.AnalysisServices.Server.Process(IMajorObject obj, ProcessType processType, Binding source, ErrorConfiguration errorConfig, WriteBackTableCreation writebackOption, XmlaWarningCollection warnings, ImpactDetailCollection impactResult, Boolean analyzeImpactOnly)
at Microsoft.AnalysisServices.Server.SendProcess(IMajorObject obj, ProcessType processType, Binding source, ErrorConfiguration errorConfig, WriteBackTableCreation writebackOption, XmlaWarningCollection warnings, ImpactDetailCollection impactResult, Boolean analyzeImpactOnly)
at Microsoft.AnalysisServices.ProcessableMajorObject.Process(ProcessType processType, ErrorConfiguration errorConfiguration, XmlaWarningCollection warnings)
at Primavera.Datamart.Olap.AnalysisServer.OlapDriver.CmdMain.ProcessCubes(Server server, Database db)
at Primavera.Datamart.Olap.AnalysisServer.OlapDriver.CmdMain.ProcessOLAPDatabase(Server server)
at Primavera.Datamart.Olap.AnalysisServer.OlapDriver.CmdMain.Main(String[] args)
or mostly this error
Execution failed: Memory error: Allocation failure : Not enough storage is available to process this command. .
Errors in the OLAP storage engine: An error occurred while processing the 'Resource Mix' partition of the 'Resource Mix' measure group for the 'Resource Mix NCCM' cube from the PV_OLAP database.
Memory error: Allocation failure : Not enough storage is available to process this command. .
Errors in the OLAP storage engine: An error occurred while processing the 'PVC Tab Resource Hours Fact 2' partition of the 'Supply' measure group for the 'Capacity Planning' cube from the PV_OLAP database.
Internal error: The operation terminated unsuccessfully.
Internal error: The operation terminated unsuccessfully.
Internal error: The operation terminated unsuccessfully.
Memory error: Allocation failure : Not enough storage is available to process this command. .
Errors in the OLAP storage engine: An error occurred while processing the 'Resource Hours' partition of the 'Resource Hours' measure group for the 'Resource Hours' cube from the PV_OLAP database.
Memory error: Allocation failure .
Errors in the OLAP storage engine: An error occurred while processing the indexes for the PVC Tab Resource Functional Areas partition of the Resource Functional Areas measure group of the Capacity Planning NCCM cube from the PV_OLAP database.
Internal error: The operation terminated unsuccessfully.
Internal error: The operation terminated unsuccessfully.
at Microsoft.AnalysisServices.AnalysisServicesClient.SendExecuteAndReadResponse(ImpactDetailCollection impacts, Boolean expectEmptyResults, Boolean throwIfError)
at Microsoft.AnalysisServices.AnalysisServicesClient.Process(IMajorObject obj, ProcessType type, Binding source, ErrorConfiguration errorConfig, WriteBackTableCreation writebackOption, ImpactDetailCollection impact)
at Microsoft.AnalysisServices.Server.Process(IMajorObject obj, ProcessType processType, Binding source, ErrorConfiguration errorConfig, WriteBackTableCreation writebackOption, XmlaWarningCollection warnings, ImpactDetailCollection impactResult, Boolean analyzeImpactOnly)
at Microsoft.AnalysisServices.Server.SendProcess(IMajorObject obj, ProcessType processType, Binding source, ErrorConfiguration errorConfig, WriteBackTableCreation writebackOption, XmlaWarningCollection warnings, ImpactDetailCollection impactResult, Boolean analyzeImpactOnly)
at Microsoft.AnalysisServices.ProcessableMajorObject.Process(ProcessType processType, ErrorConfiguration errorConfiguration, XmlaWarningCollection warnings)
at Primavera.Datamart.Olap.AnalysisServer.OlapDriver.CmdMain.ProcessCubes(Server server, Database db)
at Primavera.Datamart.Olap.AnalysisServer.OlapDriver.CmdMain.ProcessOLAPDatabase(Server server)
at Primavera.Datamart.Olap.AnalysisServer.OlapDriver.CmdMain.Main(String[] args)
or in a simple way it gives the below error when running through xml script
<return xmlns="urn:schemas-microsoft-com:xml-analysis">
<results xmlns="http://schemas.microsoft.com/analysisservices/2003/xmla-multipleresults">
<root xmlns="urn:schemas-microsoft-com:xml-analysis:empty">
<Exception xmlns="urn:schemas-microsoft-com:xml-analysis:exception" />
<Messages xmlns="urn:schemas-microsoft-com:xml-analysis:exception">
<Error ErrorCode="3238002695" Description="Internal error: The operation terminated unsuccessfully." Source="Microsoft SQL Server 2005 Analysis Services" HelpFile="" />
<Error ErrorCode="3238199297" Description="Memory error: Allocation failure : Not enough storage is available to process this command. ." Source="Microsoft SQL Server 2005 Analysis Services" HelpFile="" />
<Error ErrorCode="3240034318" Description="Errors in the OLAP storage engine: An error occurred while processing the 'Resource Mix' partition of the 'Resource Mix' measure group for the 'Resource Mix NCCM' cube from the PV_OLAP database." Source="Microsoft SQL Server 2005 Analysis Services" HelpFile="" />
<Error ErrorCode="3238002695" Description="Internal error: The operation terminated unsuccessfully." Source="Microsoft SQL Server 2005 Analysis Services" HelpFile="" />
<Error ErrorCode="3238002695" Description="Internal error: The operation terminated unsuccessfully." Source="Microsoft SQL Server 2005 Analysis Services" HelpFile="" />
<Error ErrorCode="3238002695" Description="Internal error: The operation terminated unsuccessfully." Source="Microsoft SQL Server 2005 Analysis Services" HelpFile="" />
<Error ErrorCode="3238199297" Description="Memory error: Allocation failure : Not enough storage is available to process this command. ." Source="Microsoft SQL Server 2005 Analysis Services" HelpFile="" />
<Error ErrorCode="3240034318" Description="Errors in the OLAP storage engine: An error occurred while processing the 'Resource Hours' partition of the 'Resource Hours' measure group for the 'Resource Hours' cube from the PV_OLAP database." Source="Microsoft SQL Server 2005 Analysis Services" HelpFile="" />
<Error ErrorCode="3238199297" Description="Memory error: Allocation failure : Not enough storage is available to process this command. ." Source="Microsoft SQL Server 2005 Analysis Services" HelpFile="" />
<Error ErrorCode="3240034318" Description="Errors in the OLAP storage engine: An error occurred while processing the 'Resource Mix' partition of the 'Resource Mix' measure group for the 'Resource Mix NCCM' cube from the PV_OLAP database." Source="Microsoft SQL Server 2005 Analysis Services" HelpFile="" />
</Messages>
</root>
</results>
</return>
The action I have taken to resolve this
One most important thing I forgot to say is the m/c is having 4 gb ram
I have tried to change the low level memory properties of SQL server analysis services instance in msmsdrv.ini file
but not fruitful also tried to change the SQL server database instance max server memory used to be changed as 1536 from 2048 to resolve the issue but no use
Please help me in this case to resolve this issue
October 13, 2013 at 5:47 pm
General, sweeping statement but 4GB is not enough memory for a server - especially a server with SQL AND SSAS. Please tell me you haven't got SSRS on there too...
So, you've posted three errors - the third does look like a memory issue but the other two are file system errors - so when it says there isn't enough storage, it's referring to HDD space not RAM.
Steve.
March 18, 2014 at 4:13 am
try to move temp file,log and data folder to drive which has enough disk space.
You can validate the current temp file path in Config file named "msmdsrv.ini" located at
Drive:\Program Files\Microsoft SQL Server\MSAS10_50.MSSQLSERVER\OLAP\Config
hope this help!
Regards,
Alpesh Dhori | Software Professional
March 21, 2014 at 1:11 pm
Also, what is the size of the SOURCE DATA you are trying to process (uncompressed, in GB)?
February 2, 2015 at 12:45 am
Hi,
I am getting same issue. Data folder size of failed dimension is 6GB and in dim table we have records around 16963258 records. Our cube processes incrementally and we have enough size on disk.We tried dimension full processing as well but it was failed.
Could you please help on it
Error is
File system error: A FileStore error from WriteFile occurred. Physical file: \\?\D:\MSSQL2008R2\MSAS10_50.PMGBSSAS01\TEMP\MSMDCacheRowset_3488_434c_aueaks.tmp.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply