SQL Server job agent failed processing a cube

Question

SQL Server job agent failed processing a cube

VA123

SSCarpal Tunnel

Points: 4272
More actions
May 22, 2009 at 5:40 am

#205035

New to SSIS 2205 and Analysis Services 2005.
I created a SSIS package to process two cubes, then deployed the package to the server. I then created a SQL Server agent job to schedule the processing of the package.
The job occasionally fails (perhaps 1 in 5 times). The message in the log file viewer of the job history only states, "The package execution failed. The step failed."
I've checked the error log, but don't find any error message related to the failed step.
Is there some other way to determine why the step failed?
After processing the cubes manually in Management Studio or the BI Development Studio, the scheduled job then succeeds. My SSIS package has only two tasks in the Control Flow tab; an Analysis Services Processing task for each cube.
Help please.

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Sriram-288748 SSCrazy Points: 2874 More actions · Answer 1

Hello brother,

think you have some data issue around or there can be issues with the system as such, in the analysis service processing task, put setting for capturing the log of the cube process, it will be helpful to debug further.

Sriram

VA123 SSCarpal Tunnel Points: 4272 More actions · Answer 2

Thanks, Sriram.

Will you get me started with instructions on how capture the log file in SSIS?

Thanks.

colin.shepherd Old Hand Points: 312 More actions · Answer 3

I'm not sure if this is relevant in SQL Server 2k5, but I find the following to be a useful place for information when my SSIS packages fail to execute:

1. Open Management Studio and connect to your database

2. Under SQL Server Agent (expand it), double click on the Jobs activity monitor

3. right click on the job and select view history

I've found the descriptions of errors much better there.

Jason-1080732 Mr or Mrs. 500 Points: 546 More actions · Answer 4

Patrick,

have you tried processing the cube through analysis services independent of the ssis package? This will display specific details of the processing error. i.e. which primary keys are conflicting etc.

VA123 SSCarpal Tunnel Points: 4272 More actions · Answer 5

Jason,

Yes I have. I don't get errors when processing the cube from AS. The SQL Server agent job step that processes the cubes errors approximately 20% of the time. The error messages I get from History are not useful. I did some googling and learned how to capture logging information using SSIS; using the SSIS menu...Logging...menu item. I'll try to get that to work.

Thanks.