Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
 Posted - 2010-05-12 : 07:58:47
|
| I've a package which is processing a cube. Its working fine when executed locally. But when I'm scheduling this to be executed from SQL agent job its failing with above error messageMessageExecuted as user: itlinfosys\Hariprasad_r03. Microsoft (R) SQL Server Execute Package Utility Version 10.0.2531.0 for 64-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: 12:03:22 PM Error: 2010-05-12 12:03:34.98 Code: 0xC1000007 Source: Analysis Services Processing Task Analysis Services Execute DDL Task Description: Internal error: The operation terminated unsuccessfully. End Error Error: 2010-05-12 12:03:34.98 Code: 0xC11F0006 Source: Analysis Services Processing Task Analysis Services Execute DDL Task Description: Errors in the OLAP storage engine: The process operation ended because the number of errors encountered during processing reached the defined limit of allowable errors for the operation. End Error Error: 2010-05-12 12:03:34.98 Code: 0xC11F000E Source: Analysis Services Processing Task Analysis Services Execute DDL Task Description: Errors in the OLAP storage engine: An error occurred while processing the 'Opportunities' partition of the 'Opportunities' measure group for the 'Reports' cube from the Sales Analysis database. End Error Error: 2010-05-12 12:03:34.98 Code: 0xC11F0006 Source: Analysis Services Processing Task Analysis Services Execute DDL Task Description: Errors in the OLAP storage engine: The process operation ended because the number of errors encountered during processing reached the defined limit of allowable errors for the operation. End Error Error: 2010-05-12 12:03:34.98 Code: 0xC11C0002 Source: Analysis Services Processing Task Analysis Services Execute DDL Task Description: Server: The operation has been cancelled. End Error DTExec: The package execution returned DTSER_FAILURE (1). Started: 12:03:22 PM Finished: 12:03:35 PM Elapsed: 12.636 seconds. The package execution failed. The step failed.the surprising fact is this is happening only when executed from sql job. I'm using the same login for executing SQL agent job ( i had also tried using a proxy account still no luck!) which i used locally for executing package and it has sysadmin priviledges also.Any help on resolving this will be appreciated------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
|
|
Error while processing cube from SQL job