Create a job to schedule updates for analysis services

Unforunately when I schedule and run the job I receive some errors:

Any ideas?


Date            11/19/2009 1:13:52 PM
Log            Job History (Cube Refresh)

Step ID            1
Server            MEM024
Job Name            Cube Refresh
Step Name            Rebuid Cubes
Duration            00:00:01
Sql Severity            0
Sql Message ID            0
Operator Emailed            
Operator Net sent            
Operator Paged            
Retries Attempted            0

Message
Executed as user: Corp\svc_sqlserver. Microsoft (R) SQL Server Execute Package Utility  Version 9.00.4035.00 for 32-bit  Copyright (C) Microsoft Corp 1984-2005. All rights reserved.    Started:  1:13:52 PM  Error: 2009-11-19 13:13:53.02     Code: 0xC0016016     Source:       Description: Failed to decrypt protected XML node "PackagePassword" with error 0x8009000B "Key not valid for use in specified state.". You may not be authorized to access this information. This error occurs when there is a cryptographic error. Verify that the correct key is available.  End Error  Error: 2009-11-19 13:13:53.10     Code: 0xC00220E4     Source: Run GL Budgets      Description: Error 0xC0014037 while preparing to load the package. The package is encrypted with a password. The password was not specified, or is not correct.  .  End Error  DTExec: The package execution returned DTSER_FAILURE (1).  Started:  1:13:52 PM  Finished: 1:13:53 PM  Elapsed:  0.141 seconds.  The package execution failed.  The step failed.

Hi,

It isn't clear to me what exactly the problem is or how to resolve it.  It seems that type of error can be caused by SQL permissions, or if you are not providing the password for an encrypted package.

Does this thread seem relevant?

http://social.msdn.microsoft.com/forums/en-US/sqlintegrationservices/thread/80aacf59-d339-4ae2-a9bc-8fb799027227/

Thanks,

Steve Endow
Dynamics GP Certified Trainer
Dynamics GP Certified Professional

Unfortunately the Analysis Cubes I'm using are for Dynamics and the password is integrated in the pre-built package not accessable by the user.

Simply running the task in SSIS without any parameters works fine, the problem is when the same thing is done but from within a job.

Hi,

Sorry, but I guess my only advice would be to open a support case with Microsoft.

I recently asked a friend, who is also a certified trainer, if she knows of anyone that is using Analysis Cubes for GP, and she has not seen or heard of a single implementation.  Given this, I'm assuming your best and most efficient route would be to contact them.

Thanks,

Steve Endow
Dynamics GP Certified Trainer
Dynamics GP Certified Professional

I did open a ticket with MS and they resolved the issue.

What I had to do is go into MS BI Studio and create a new project.  Within that project create a DTSX for each Analysis SSIS Task that had been created initially by default.

Save the project and then go into SSIS import and replace each of the default created SSIS tasks with the ones created in the BI Studio.

Once imported then the job pointing to the SSIS packages worked.

What MS said was that it was a known bug and the defaults only worked if it was run on the same server, with the same credentials that was originally used to insatll and configure Analaysis Cubes.