Trouble with subscription in reporting services 2008
Hi all
I've got some troubles when I create a subscription in report manager. Fileshare or email, I have always the same errors in log files :
library!WindowsService_0!ba8!09/05/2011-15:32:03:: i INFO: Schedule 5c5bd323-cd36-4939-b739-ff7e5992f638 executed at 09/05/2011 15:32:03.
schedule!WindowsService_0!ba8!09/05/2011-15:32:03:: Creating Time based subscription notification for subscription: d3002c89-5fde-4e10-acb7-0d8ad7f94d81
library!WindowsService_0!ba8!09/05/2011-15:32:03:: i INFO: Schedule 5c5bd323-cd36-4939-b739-ff7e5992f638 execution completed at 09/05/2011 15:32:03.
library!WindowsService_0!ba8!09/05/2011-15:32:03:: e ERROR: Queue item has unhandled exception. System.IO.FileLoadException: Impossible de charger le fichier ou l'assembly 'Microsoft.ReportingServices.ProcessingCore, Version=10.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91'
ou une de ses dépendances. Impossible d'accorder l'autorisation d'exécuter. (Exception de HRESULT : 0x80131418)
Nom du fichier : 'Microsoft.ReportingServices.ProcessingCore, Version=10.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' ---> System.Security.Policy.PolicyException: Impossible d'acquérir l'autorisation d'exécution.
à System.Security.SecurityManager.ResolvePolicy(Evidence evidence, PermissionSet reqdPset, PermissionSet optPset, PermissionSet denyPset, PermissionSet& denied, Boolean checkExecutionPermission)
à System.Security.SecurityManager.ResolvePolicy(Evidence evidence, PermissionSet reqdPset, PermissionSet optPset, PermissionSet denyPset, PermissionSet& denied, Int32& securitySpecialFlags, Boolean checkExecutionPermission)
à Microsoft.ReportingServices.Library.NotificationQueueWorker.HandleNotification(QueueItem item)
à Microsoft.ReportingServices.Library.NotificationQueueWorker.QueueWorker(QueueItem item)
à Microsoft.ReportingServices.Library.QueuePollWorker.WorkItemStart(Object state)
All is working perfectly (viewing, printing report via report server or report manager) excepted in the subscription ... any ideas ?
September 5th, 2011 9:51am
You may want to try the suggestions here
http://social.msdn.microsoft.com/Forums/en/sqlreportingservices/thread/db19c566-f876-4fb1-8bd2-f73449ae3531
Free Windows Admin Tool Kit Click here and download it now
September 6th, 2011 2:04am
I tried this. I found the problem, I've just changed the order of a unioncodegroup (for a private assembly) in the config file. Moved it in the end and all is ok. A bit strange but it works :o)
Thank you all
September 7th, 2011 6:32am