File system error while querying using a parent child dimension.

Question

I am getting file system error when I run the query on the synchornized(destination) server.

WITH

 

 

MEMBER [Date].[Date YMD].[ Grand Total] AS 'SUM( INTERSECT( { { EXTRACT( { [Date].[Date YMD].[Month Name Ext].&[200710], [Date].[Date YMD].[Month Name Ext].&[200711], [Date].[Date YMD].[Month Name Ext].&[200712], [Date].[Date YMD].[Month Name Ext].&[200801], [Date].[Date YMD].[Month Name Ext].&[200802], [Date].[Date YMD].[Month Name Ext].&[200803], [Date].[Date YMD].[Month Name Ext].&[200804] }, [Date].[Date YMD] ) } }, { [Date].[Date YMD].[Month Name Ext].&[200710], [Date].[Date YMD].[Month Name Ext].&[200711], [Date].[Date YMD].[Month Name Ext].&[200712], [Date].[Date YMD].[Month Name Ext].&[200801], [Date].[Date YMD].[Month Name Ext].&[200802], [Date].[Date YMD].[Month Name Ext].&[200803], [Date].[Date YMD].[Month Name Ext].&[200804] } ) )', SOLVE_ORDER = 1000 SELECT { [Measures].[Net Calls], [Measures].[Lead Count], [Measures].[Credit Pulled], [Measures].[Denied], [Measures].[FICO Count], [Measures].[FICO Score], [Measures].[Setup], [Measures].[Folder Recvd], [Measures].[Closed Loan Count], [Measures].[Closed Loan Amount], [Measures].[Revenue Count], [Measures].[Revenue Amount] } ON COLUMNS ,{ { [Date].[Date YMD].[Month Name Ext].&[200710], [Date].[Date YMD].[Month Name Ext].&[200711], [Date].[Date YMD].[Month Name Ext].&[200712], [Date].[Date YMD].[Month Name Ext].&[200801], [Date].[Date YMD].[Month Name Ext].&[200802], [Date].[Date YMD].[Month Name Ext].&[200803], [Date].[Date YMD].[Month Name Ext].&[200804] }, ( [Date].[Date YMD].[ Grand Total] ) } ON ROWS
FROM [LeadConversion]
WHERE ( [Marketing Category].[Category Parent ID].&[796749] )

 

 

"File system error: The following error occurred while opening the file '\\?\S:\OLAP\Data\Conversion.43.db\Capstone Mktg Category Dim.0.dim\54.Capstone Mktg Category Dim.Category Parent ID2.fact.map'."

 

 

The above query runs fine on the source server.

If I run the same query without including the parent child dimension it works fine:

WITH

 

 

MEMBER [Date].[Date YMD].[ Grand Total] AS 'SUM( INTERSECT( { { EXTRACT( { [Date].[Date YMD].[Month Name Ext].&[200710], [Date].[Date YMD].[Month Name Ext].&[200711], [Date].[Date YMD].[Month Name Ext].&[200712], [Date].[Date YMD].[Month Name Ext].&[200801], [Date].[Date YMD].[Month Name Ext].&[200802], [Date].[Date YMD].[Month Name Ext].&[200803], [Date].[Date YMD].[Month Name Ext].&[200804] }, [Date].[Date YMD] ) } }, { [Date].[Date YMD].[Month Name Ext].&[200710], [Date].[Date YMD].[Month Name Ext].&[200711], [Date].[Date YMD].[Month Name Ext].&[200712], [Date].[Date YMD].[Month Name Ext].&[200801], [Date].[Date YMD].[Month Name Ext].&[200802], [Date].[Date YMD].[Month Name Ext].&[200803], [Date].[Date YMD].[Month Name Ext].&[200804] } ) )', SOLVE_ORDER = 1000 SELECT { [Measures].[Net Calls], [Measures].[Lead Count], [Measures].[Credit Pulled], [Measures].[Denied], [Measures].[FICO Count], [Measures].[FICO Score], [Measures].[Setup], [Measures].[Folder Recvd], [Measures].[Closed Loan Count], [Measures].[Closed Loan Amount], [Measures].[Revenue Count], [Measures].[Revenue Amount] } ON COLUMNS ,{ { [Date].[Date YMD].[Month Name Ext].&[200710], [Date].[Date YMD].[Month Name Ext].&[200711], [Date].[Date YMD].[Month Name Ext].&[200712], [Date].[Date YMD].[Month Name Ext].&[200801], [Date].[Date YMD].[Month Name Ext].&[200802], [Date].[Date YMD].[Month Name Ext].&[200803], [Date].[Date YMD].[Month Name Ext].&[200804] }, ( [Date].[Date YMD].[ Grand Total] ) } ON ROWS
FROM [LeadConversion]

Help is appreaciated!

Thanks in advance.
Nagy

Answer 1

After little bit of research I found that below file is missing from the destination server:

"File system error: The following error occurred while opening the file '\\?\S:\OLAP\Data\Conversion.43.db\Capstone Mktg Category Dim.0.dim\54.Capstone Mktg Category Dim.Category Parent ID2.fact.map'."

I am not sure why this file would be missing on sync. Does this mean that sync is working properly or is there somthing that I am missing?

Thanks in advance.

Regards,
Nagy

Answer 2

Could check out the following link, and let us konw if helpful
http://support.microsoft.com/kb/970184

Answer 3

This post is for processing. Once I process the cube on the destination server it creates the missing file. But this file does not exists when I sync the databases. I am not sure why this happening.

Thanks,
Nagy