I have been asked to investigate an issue of error 7321 while executing MDX to populate SQL tables using openquery.
The problem is most of the time this query runs fine but at times it fails with the error 7321 error. Since it runs most of the time, i guess syntax isn't a problem here. Yes, there are some With set statements; but we are using SQL 2008 and believe that
issue was fixed in 2005 itself.
Re-running the SP again however gives the desired results
Currently we are extracting the first 2000 characters from the error message
which starts as
and that gives a truncated version of the query, so first we are trying to increase that so that we get to see the entire query that is being parsed when it fails.
The last error message read as "An error occurred while preparing the query "MDX ....
Any other pointers on how to approach this problem would be appreciated.
View Complete Post