none
Error while browing cube in SSMS but now while executing MDx

    Question

  • Hi all,

    I have a cube and When I browse(in SSMS) I get error while if I write MDX (in SSMS) and execute that, It executes without any error.

    This is strange and only happens for one measure group while it does not happen for other.

    In first case when I try to slice the count measure by a parent child attribute  (Relationship is Many to many on key column), it throiws me this error and server stops (I have to restart the server) :

    The query could not be processed:An error was encountered in the transport layer.The peer prematurely closed the connection.

    in second scenario when I slice by a description attribute (relationship is again many 2 many) I get this error :

    The query could not be processed:
    o File system error: The record ID is incorrect. Physical file: \\?\C:\ProgramFiles\Microsoft SQL Server\MSAS10_50.MSSQLSERVER\OLAP\Data

    The error doesnot happen if I execute an MDX in SSMS.

    Any suggestion(s) what is wrong here ?

    - Girija


    Please mark responses as answered if it helped you.. This helps others... - Girija Shankar Beuria

    Friday, August 22, 2014 7:08 PM

All replies