When iterating through a cellset using the following code, I get an error when accessing the value of a particular cell. Any tips of what caused this error? It seems to only happen on a particular mdx query. If I run that mdx query in Management Studio, I get a value for that particular cell.
Error:
"File system error: The record ID is incorrect. Physical file: \\?\E:\Program Files\Microsoft SQL Server\MSSQL.2\OLAP\Data\[name].db\b356fd10-9f2e-42e3-9756-774f5d15f4bd.0.dim\35.b356fd10-9f2e-42e3-9756-774f5d15f4bd.b356fd10-9f2e-42e3-9756-774f5d15f4bd2.ostore. Logical file: ."
Code:
For c As Integer = 0 To cs.Axes(0).Set.Tuples.Count - 1
For r As Integer = 0 To cs.Axes(1).Set.Tuples.Count - 1
hash.add(cs.Cells(c,r).Value)
Next
Next
This could either be a bug in AS or data corruption.
No comments:
Post a Comment