Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Memory and File system error in cube processing Expand / Collapse
Author
Message
Posted Sunday, October 13, 2013 12:18 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Tuesday, March 25, 2014 11:21 PM
Points: 12, Visits: 55
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
Post #1504242
Posted Sunday, October 13, 2013 5:47 PM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: Moderators
Last Login: Monday, July 28, 2014 8:56 AM
Points: 1,815, Visits: 3,455
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.
Post #1504296
Posted Tuesday, March 18, 2014 4:13 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, April 1, 2014 1:07 AM
Points: 4, Visits: 58
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
Post #1552086
Posted Friday, March 21, 2014 1:11 PM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Monday, July 28, 2014 7:12 PM
Points: 2,148, Visits: 487
Also, what is the size of the SOURCE DATA you are trying to process (uncompressed, in GB)?
Post #1553645
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse