MS SQL Server OLAP - "The Handle Is Invalid" error during incremental processing

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

"The Handle Is Invalid" error during incremental processing

Boris Zakharin

2005-12-23, 1:23 pm

Using SQL Server 2000 and Analysis Services 2000, during incremental
processing of a dimension using DSO we are getting an "Unknown or Unexpected
Error." When logging to a file is enabled, the following error is logged:

20157 Analysis Server Error: File error [Seek operation] ' The handle is
invalid. The handle is invalid. '

The actual functions called is:

DSO.MDStore.Dimensions("Custom Dimension Name").process processDefault

Looking at the data of the cube in Analysis Manager shows all cells with
#Err and double-clicking one results in an "Invalid Handle" as well.

Does anyone know why this could be happening?

Thanks in advance,
Boris Zakharin, MCAD
Prime Associates, Inc

Sponsored Links