question

venkat505 avatar image
venkat505 asked

Updating cube using writeback when processing the partition using proactivecaching

Hi, We have a cube which contains only one partition(Writeback enabled). This partition is having proactive caching enabled. **Issue** We have a client application which writes data to this partition using UPATE CUBE(behind the scenes). We have an SSIS package which processes the main partition using Client enabled proactive caching. The problem is that Users are unable to UPDATECUBE through web application while this job is running. They are getting an error message "**Writeback has failed. An error occured when writing data to the database.....**" and in profiler i got the below error message "**Current session is no longer valid due to structural changes in the database. Query Text: SELECT {AddCalculatedMembers ( [Labor_Employees].MEMBERS )} DIMENSION PROPERTIES MEMBER_NAME, PARENT_UNIQUE_NAME, IS_DATAMEMBER ON COLUMNS** " Is it possible to UPDATECUBE while processing the partition(Using proactive caching) or is there any option in SSAS which will make this UPDATECUBE statement to wait till partition processing completes.
ssisssasmdxcube
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

· Write an Answer
Pavel Pawlowski avatar image
Pavel Pawlowski answered
Didn't tested, but for determining whether the processing of the cube/measure groups/partition is in progress you can use the SSAS DMVs [DISCOVER_COMMANDS Rowset][1] or [DISCOVER_LOCKS Rowset][2]. select * from $system.discover_commands select * from $system.discover_locks The client application can check whether the objects are being processed and wait until the locks are freed or the processing command is completed. Then sent the UPDATE CUBE. Additional useful resource: [SSAS DMV (Dynamic Management View)][3] Of course all above will work on SSAS 2008 and above.. as the lower version of SSAS do not have DMVs. [1]: http://msdn.microsoft.com/en-us/library/bb934103.aspx [2]: http://msdn.microsoft.com/en-us/library/bb934104(v=sql.110).aspx [3]: http://dwbi1.wordpress.com/2010/01/01/ssas-dmv-dynamic-management-view/
1 comment
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Hi Pavel, Thanks for the reply but my basic question is Is it possible to UPDATECUBE while processing the partition(Using proactive caching) or is there any option in SSAS(Not in Client applicaion but some server property) which will make this UPDATECUBE statement to wait till partition processing completes.
0 Likes 0 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.