Scheduling does not work!

Hi Guys
On one of my RS Servers the scheduling does not work. That is the "schedule"
is created. It even exists as a job in SQL Server that runs however the
actual report is not run. In the log file I have the following entries:
ReportingServicesService!library!10ac!11/08/2004-18:04:22:: e ERROR:
Throwing
Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerDisabledExcept
ion: The report server cannot decrypt the symmetric key used to access
sensitive or encrypted data in a report server database. You must either
restore a backup key or delete all encrypted content and then restart the
service. Check the documentation for more information., ;
Info:
Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerDisabledExcept
ion: The report server cannot decrypt the symmetric key used to access
sensitive or encrypted data in a report server database. You must either
restore a backup key or delete all encrypted content and then restart the
service. Check the documentation for more information. -->
System.Runtime.InteropServices.COMException (0x80090005): Bad Data.
at System.Runtime.InteropServices.Marshal.ThrowExceptionForHR(Int32
errorCode, IntPtr errorInfo)
at RSManagedCrypto.RSCrypto.ImportSymmetricKey(Byte[] pSymKeyBlob)
at
Microsoft.ReportingServices.Library.ConnectionManager.GetEncryptionKey()
Does anyone have any ideas as how to fix this problem?
(I have deleted all schedules and having the server rebooted tonight but
dont know if that will fix the problem).
Thanks.
Regards
JonasDid you recently change the user that the reportserver service runs under?
Did you back up your symmetric key?
If you changed the user but did not back up the symmetric key, then change
the user back to the original and use rskeymgmt to back up the symmetric
key. Change the user again to what you want and user rskeymgmt to insert
the symmetric key.
If you have already saved your symmetric key then just insert it using
rskeymgmt.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Jonas Larsen" <Jonas.Larsen@.Alcan.com> wrote in message
news:ezvNqMBgEHA.2536@.TK2MSFTNGP09.phx.gbl...
> Hi Guys
> On one of my RS Servers the scheduling does not work. That is the
"schedule"
> is created. It even exists as a job in SQL Server that runs however the
> actual report is not run. In the log file I have the following entries:
> ReportingServicesService!library!10ac!11/08/2004-18:04:22:: e ERROR:
> Throwing
>
Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerDisabledExcept
> ion: The report server cannot decrypt the symmetric key used to access
> sensitive or encrypted data in a report server database. You must either
> restore a backup key or delete all encrypted content and then restart the
> service. Check the documentation for more information., ;
> Info:
>
Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerDisabledExcept
> ion: The report server cannot decrypt the symmetric key used to access
> sensitive or encrypted data in a report server database. You must either
> restore a backup key or delete all encrypted content and then restart the
> service. Check the documentation for more information. -->
> System.Runtime.InteropServices.COMException (0x80090005): Bad Data.
> at System.Runtime.InteropServices.Marshal.ThrowExceptionForHR(Int32
> errorCode, IntPtr errorInfo)
> at RSManagedCrypto.RSCrypto.ImportSymmetricKey(Byte[] pSymKeyBlob)
> at
> Microsoft.ReportingServices.Library.ConnectionManager.GetEncryptionKey()
> Does anyone have any ideas as how to fix this problem?
> (I have deleted all schedules and having the server rebooted tonight but
> dont know if that will fix the problem).
> Thanks.
> Regards
> Jonas
>|||Thanks. Problem solved.
Next problem. Due to this issue I now have 2 jobs on my SQLServer created by
Reporting Services that does not show in RS. Can I just delete these jobs
or?
Regards
Jonas
"Daniel Reib [MSFT]" <danreib@.online.microsoft.com> wrote in message
news:%23fN5hFJgEHA.536@.TK2MSFTNGP11.phx.gbl...
> Did you recently change the user that the reportserver service runs under?
> Did you back up your symmetric key?
> If you changed the user but did not back up the symmetric key, then change
> the user back to the original and use rskeymgmt to back up the symmetric
> key. Change the user again to what you want and user rskeymgmt to insert
> the symmetric key.
> If you have already saved your symmetric key then just insert it using
> rskeymgmt.
> --
> -Daniel
> This posting is provided "AS IS" with no warranties, and confers no
rights.
>
> "Jonas Larsen" <Jonas.Larsen@.Alcan.com> wrote in message
> news:ezvNqMBgEHA.2536@.TK2MSFTNGP09.phx.gbl...
> > Hi Guys
> >
> > On one of my RS Servers the scheduling does not work. That is the
> "schedule"
> > is created. It even exists as a job in SQL Server that runs however the
> > actual report is not run. In the log file I have the following entries:
> >
> > ReportingServicesService!library!10ac!11/08/2004-18:04:22:: e ERROR:
> > Throwing
> >
>
Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerDisabledExcept
> > ion: The report server cannot decrypt the symmetric key used to access
> > sensitive or encrypted data in a report server database. You must either
> > restore a backup key or delete all encrypted content and then restart
the
> > service. Check the documentation for more information., ;
> > Info:
> >
>
Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerDisabledExcept
> > ion: The report server cannot decrypt the symmetric key used to access
> > sensitive or encrypted data in a report server database. You must either
> > restore a backup key or delete all encrypted content and then restart
the
> > service. Check the documentation for more information. -->
> > System.Runtime.InteropServices.COMException (0x80090005): Bad Data.
> > at System.Runtime.InteropServices.Marshal.ThrowExceptionForHR(Int32
> > errorCode, IntPtr errorInfo)
> > at RSManagedCrypto.RSCrypto.ImportSymmetricKey(Byte[] pSymKeyBlob)
> > at
> > Microsoft.ReportingServices.Library.ConnectionManager.GetEncryptionKey()
> >
> > Does anyone have any ideas as how to fix this problem?
> > (I have deleted all schedules and having the server rebooted tonight but
> > dont know if that will fix the problem).
> >
> > Thanks.
> >
> > Regards
> > Jonas
> >
> >
>|||Yes, RS will recreate jobs if they are deleted from SQL Agent and RS still
needs them. By default it will check this every 12 hours. You can force
this to happen by recycling the ReportServer service.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Jonas Larsen" <Jonas.Larsen@.Alcan.com> wrote in message
news:OG$#KRMgEHA.4024@.TK2MSFTNGP10.phx.gbl...
> Thanks. Problem solved.
> Next problem. Due to this issue I now have 2 jobs on my SQLServer created
by
> Reporting Services that does not show in RS. Can I just delete these jobs
> or?
> Regards
> Jonas
> "Daniel Reib [MSFT]" <danreib@.online.microsoft.com> wrote in message
> news:%23fN5hFJgEHA.536@.TK2MSFTNGP11.phx.gbl...
> > Did you recently change the user that the reportserver service runs
under?
> > Did you back up your symmetric key?
> >
> > If you changed the user but did not back up the symmetric key, then
change
> > the user back to the original and use rskeymgmt to back up the symmetric
> > key. Change the user again to what you want and user rskeymgmt to
insert
> > the symmetric key.
> >
> > If you have already saved your symmetric key then just insert it using
> > rskeymgmt.
> >
> > --
> > -Daniel
> > This posting is provided "AS IS" with no warranties, and confers no
> rights.
> >
> >
> > "Jonas Larsen" <Jonas.Larsen@.Alcan.com> wrote in message
> > news:ezvNqMBgEHA.2536@.TK2MSFTNGP09.phx.gbl...
> > > Hi Guys
> > >
> > > On one of my RS Servers the scheduling does not work. That is the
> > "schedule"
> > > is created. It even exists as a job in SQL Server that runs however
the
> > > actual report is not run. In the log file I have the following
entries:
> > >
> > > ReportingServicesService!library!10ac!11/08/2004-18:04:22:: e ERROR:
> > > Throwing
> > >
> >
>
Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerDisabledExcept
> > > ion: The report server cannot decrypt the symmetric key used to access
> > > sensitive or encrypted data in a report server database. You must
either
> > > restore a backup key or delete all encrypted content and then restart
> the
> > > service. Check the documentation for more information., ;
> > > Info:
> > >
> >
>
Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerDisabledExcept
> > > ion: The report server cannot decrypt the symmetric key used to access
> > > sensitive or encrypted data in a report server database. You must
either
> > > restore a backup key or delete all encrypted content and then restart
> the
> > > service. Check the documentation for more information. -->
> > > System.Runtime.InteropServices.COMException (0x80090005): Bad Data.
> > > at System.Runtime.InteropServices.Marshal.ThrowExceptionForHR(Int32
> > > errorCode, IntPtr errorInfo)
> > > at RSManagedCrypto.RSCrypto.ImportSymmetricKey(Byte[] pSymKeyBlob)
> > > at
> > >
Microsoft.ReportingServices.Library.ConnectionManager.GetEncryptionKey()
> > >
> > > Does anyone have any ideas as how to fix this problem?
> > > (I have deleted all schedules and having the server rebooted tonight
but
> > > dont know if that will fix the problem).
> > >
> > > Thanks.
> > >
> > > Regards
> > > Jonas
> > >
> > >
> >
> >
>