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

Error 7320 while executing a MDX through Linked Server on SQl server 2005 Expand / Collapse
Author
Message
Posted Thursday, January 15, 2009 9:51 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Friday, August 17, 2012 5:53 PM
Points: 15, Visits: 49
while executing a MDX through the Linked Server on a 64 bit SQL server 2005 it's throwing Error 7320: Cannot execute the Query "With Set....".

This error doesn't occur frequently.. Once or twice in a week it does happen... The Profiler states the Operation has been cancelled... with error -1055129598.... Not much expalnation is available in microsoft KB ...

I don't think this Error would be because of system out of memory exception... since the server is having huge amount of free memory...;)

Hardware Description:
SQl server 2005 64 bit enterprise edition, with 32 GB Ram ...

Any Soultion \ ideas?

Thanks,
Harsha
Post #637736
Posted Wednesday, August 29, 2012 5:09 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Saturday, August 31, 2013 10:19 PM
Points: 5, Visits: 60
Hi,

have you checked your MDX query result set... take your MDX query and execute it on cube directlly. than check it is there any measures return any infinite value. If yes this is the problem. If your measues return any infinite or #error value and you want the same to retrive it from linke server using select statment it will through you an error.


Probable Solution is : handle exception like value/0 using if condition on calculate measures

Regards
Binayak
Post #1351521
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse