error 1203,severity 20, state 1

hi
im getting the below erro
error 1203,severity 20, state
i was running my interest calculation procedures..its a abanking site..and it updates around 1-2 million records.
profiler is showing this error as exception..but when i saw sysprocess ..that spid is runnable and i can see cpu and io values updated.
wot can be the source of error.
thanks
sanjayHi.
On BOOKS ONLINE:
Error 1203
Severity Level 20
Message Text
Process ID %d attempting to unlock unowned resource %.*ls.
Explanation
This error occurs when Microsoft=AE SQL ServerT is engaged in some activity other than normal post-processing cleanup and it finds that a particular page it is attempting to unlock is already unlocked. The underlying cause for this error may be related to structural problems within the affected database. SQL Server manages the acquisition and release of pages to maintain concurrency control in the multi-user environment. This mechanism is maintained through the use of various internal lock structures that identify the page and the type of lock present. Locks are acquired for processing of affected pages and released when the processing is completed.
Action
Execute DBCC CHECKDB against the database in which the object belongs. If DBCC CHECKDB reports no errors, attempt to reestablish the connection and execute the command
>--Original Message--
>hi,
> im getting the below error
> error 1203,severity 20, state 1
>i was running my interest calculation procedures..its a abanking site..and it updates around 1-2 million records..
>profiler is showing this error as exception..but when i saw sysprocess ..that spid is runnable and i can see cpu and io values updated..
>wot can be the source of error..
>thanks >sanjay
>.
>|||thnks for reply..
i tried but same error..

error 0xE0040200 when browse a cube

I am using AS 2005 + SP2.

I got error 0xE0040200 when browse a cube with a calculation member for a dimension, the calculation is defined like the following.

iif([Time].[Calendar].currentmember.prevmember is null or
([TimeSeries].[Period].&[1], [Time].[Calendar].currentmember.prevmember) = 0, null, ROUND(((([TimeSeries].[Period].&[1],
[Time].[Calendar].currentmember) -
([TimeSeries].[Period].&[1], [Time].[Calendar].currentmember.prevmember))/([TimeSeries].[Period].&[1], [Time].[Calendar].currentmember.prevmember)),4))'

I think the problem is around "([TimeSeries].[Period].&[1], [Time].[Calendar].currentmember.prevmember) = 0", because when I change the "=0" to "is null", the error disappears.

Can anyone know why the "=0" won't work? BTW, the same calculation works well in AS 2000.

Thanks

It seems that it is a bug of cube browser in AS 2005.

When I browse the cube in Excel with AS 9.0 OLE DB provider, everything is fine.

has anyone experienced the same?

Thanks
Michael