question

Hijazi avatar image
Hijazi asked

Job to process a cube is failing but manual process succeeding

We have an sql server job with xmla code that processes the cube fully, the job is divided into many steps where first the dimensions get processed and then the cube. The dimensions' process succeeds but when reaching to processing the cube measure group it is failing with this memory error: "Error ErrorCode="3238002695" Description="Internal error: The operation terminated unsuccessfully." Source="Microsoft SQL Server 2012 Analysis Services" HelpFile="" / Error ErrorCode="3239837701" Description="Server: The operation has been cancelled because there is not enough memory available for the application. If using a 32-bit version of the product, consider upgrading to the 64-bit version or increasing the amount of memory available on the machine." (the product is already 64 bit) Then when going to the cube directly and manually processing the measure group, it succeeds. Does anyone have any input or feedback regarding this issue? Thanks in advance
ssassql server 2012
2 comments
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

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

ThomasRushton avatar image ThomasRushton ♦♦ commented ·
What else is going on at the time you try running that process? Or does it fail in the job no matter what time the job is scheduled?
0 Likes 0 ·
Hijazi avatar image Hijazi commented ·
It is failing no matter what time it is scheduled. We once restarted the analysis services then ran the job and it worked fine..is that a coincidence or what?
0 Likes 0 ·

1 Answer

·
erlokeshsharma08 avatar image
erlokeshsharma08 answered
By Looks of it, I get the feeling might be related to account details/security details or the owner running the job. Try creating a new job with single step of processing the cube, run the dimensions job followed by this new job.
4 comments
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

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

Hijazi avatar image Hijazi commented ·
The owner running the job is the "sa" so I don't think security details has to do with it, especially that sometimes (few) the job succeeds..
0 Likes 0 ·
erlokeshsharma08 avatar image erlokeshsharma08 Hijazi commented ·
Is the data source stable or somebody is pumpimp data into it? Very hard to find it out until there is a dedicated db to look after the cause.
0 Likes 0 ·
Hijazi avatar image Hijazi Hijazi commented ·
No when the cube is being processed there are no data being inserted into the warehouse (database where the cube is built on top of) SQL server has a dedicated memory, would this affect the SQL job processing the cube?
0 Likes 0 ·
Hijazi avatar image Hijazi commented ·
The job have been running successfully for 3 consecutive days now, although we did not change any settings or restart the analysis services, that is really weird..any analysis on this?
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.