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
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.