so I am new to the company and working on this package that builds cubes.
SQL Job constantly fails with Executed as user: (user name). The step failed.
opened actual package and was able to drill down to tasks where it fails Analysis Services processing tasks that processes dimensions.
so If i run the single task it fails with unhanded exception error (no details)
but, if I restart Analysis services first and then run tasks in completed fine.
After, I initiate second task, fails with same error, restart services, works fine. and so on.
One more thing, if i try to backup OLAP db before restart I am getting same error (unhanded exception), it disappears after restart and reappears after each failed task.
Please suggest something. I am not too familiar with redeployment option. Maybe?
Thank you in advance