Updating cube using writeback when processing the partition using proactivecaching

Question

question

venkat505 asked Feb 15, '13

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.

ssis ssas mdx cube

10 |1200

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

Answer 1 · 2013-02-16T18:55:46Z

Pavel Pawlowski answered Feb 16, '13

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

10 |1200

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

venkat505 commented · Feb 18, 2013 at 09:58 AM

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 ·

question