Post reply

Error 7320 while executing a MDX through Linked Server on SQl server 2005

  • January 15, 2009 at 9:51 pm

    #198848

    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

  • August 29, 2012 at 5:09 am

    #1531308

    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

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply