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.

All Forums  SQL Server 2005 Forums  Analysis Server and Reporting Services (2005)  SQL job failing to process SSAS database.

Author  Topic  BBowman Starting Member 1 Post Posted - 2010-01-20 : 21:23:04 I have a SQL job that processes data from 2 databases into another database, for step 1. It then goes and processes a SSAS database pointing to the destination database from the previous step which resides on the same machine. Step one runs successfully. Step 2 fails with the following error message. complete End Progress Progress: 2010-01-20 04:18:17.86 Source: Analysis Services Processing Task Started processing the 'DIMPatient' dimension.: 0% complete End Progress Progress: 2010-01-20 04:18:22.08 Source: Analysis Services Processing Task Processing of the '(All)' attribute has started.: 0% complete End Progress Progress: 2010-01-20 04:18:22.08 Source: Analysis Services Processing Task Started reading data for the '(All)' attribute.: 0% complete End Progress Progress: 2010-01-20 04:18:22.08 Source:... Process Exit Code 1. The step failed. I can copy the commandline syntax from step 2 out to a cmd window and it runs successfully. I can manually process the SSAS database via SSMS. Not really sure what to look at next???