May 31, 2007 at 3:00 am
Hello All!
I get the below error message for only few fiels of the openquery select, I have about 10 fields. If I comment this two fields from the select it will show the result set, but I need to have all fields for the statistic to be correct.
OLE DB error trace [OLE/DB Provider 'MSOLAP' IRowset::GetData returned 0x80040e21: Data status returned from the provider: [COLUMN_NAME=[Measures].[Field Name] STATUS=DBSTATUS_E_UNAVAILABLE], [COLUMN_NAME=[Measures].[Second Field Name] STATUS=DBSTATUS_E_UNAVAILABLE]].
Thanks in advance!
May 31, 2007 at 8:19 am
What Service Pack do you have installed.
May 31, 2007 at 2:51 pm
Thank you for your reply
SQL : 8.00.2148 SP4
Analysis: 8.0.2039 SP4
June 14, 2007 at 8:40 am
Try limiting the data further. It may be the column datatype is being mistranslated do to a variance in the data. What I am meaning is that if say you open an Excel file in a DTS package with a date coulmn but the first 10 records are blank the import may translate instead to text and cause formatting issues. In researching this message seems to be a similar type of deal. Might even try changing your field to another datatype to see if you can get around it if is that case.
June 18, 2007 at 2:32 am
Hi there....
did you find a resolution to your problems? I am getting a very similar error and can't seem to find a fix anywhere for it..
thanks.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply