none
Data-driven Subscription stop running suddenly without any error message

    Question

  • I have a Data-driven subscription that create PDF files in a shared folder 3x a day (for e.g. 00:00 hour, 08:00 hour and 16:00 hour) . This report has been running for almost a year and working fine. There're no changes to the report. Account that is used to run the report never expires and have the rights to write into a folder. But one day, the report suddenly stop running. When I check the report at 17:00 hour, the last report generated was for the same day 08:00 hour. Nothing was generated at 16:00 hour. That's the Subscription status and no error message. No matter how I change the Hour, the report will just not run and it just show status that last report generated is 08:00. At the end, I have to restart the report server then report will run. My question: what is wrong and how can I detect something is wrong with scheduler that I need to restart services/server ? Please advise. Where can I find useful information regarding this error? which log files will help ?

    Thank you for your help

    library!ReportServer_0-145!1f90!09/20/2013-18:07:25:: Call to GetPropertiesAction(XXX, PathBased).
    library!ReportServer_0-145!1f90!09/20/2013-18:07:25:: Call to GetSystemPermissionsAction().
    extensionfactory!ReportServer_0-145!1f90!09/20/2013-18:07:25:: e ERROR: Exception caught instantiating TERADATA report server extension: System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> System.IO.FileNotFoundException: Could not load file or assembly 'Teradata.Client.Provider, Version=12.0.0.0, Culture=neutral, PublicKeyToken=7c' or one of its dependencies. The system cannot find the file specified.
    File name: 'Teradata.Client.Provider, Version=12.0.0.0, Culture=neutral, PublicKeyToken=7c'
       at System.Reflection.Assembly._nLoad(AssemblyName fileName, String codeBase, Evidence assemblySecurity, Assembly locationHint, StackCrawlMark& stackMark, Boolean throwOnFileNotFound, Boolean forIntrospection)
       at System.Reflection.Assembly.InternalLoad(AssemblyName assemblyRef, Evidence assemblySecurity, StackCrawlMark& stackMark, Boolean forIntrospection)
       at System.Reflection.Assembly.InternalLoad(String assemblyString, Evidence assemblySecurity, StackCrawlMark& stackMark, Boolean forIntrospection)
       at System.Reflection.Assembly.Load(String assemblyString)
       at Microsoft.ReportingServices.DataExtensions.TeradataConnectionWrapper.LoadTdAssembly()
       at Microsoft.ReportingServices.DataExtensions.TeradataConnectionWrapper.GetTdConnectionType()
       at Microsoft.ReportingServices.DataExtensions.TeradataConnectionWrapper..ctor()

    WRN: Assembly binding logging is turned OFF.
    To enable assembly bind failure logging, set the registry value [HKLM\Software\Microsoft\Fusion!EnableLog] (DWORD) to 1.
    Note: There is some performance penalty associated with assembly bind failure logging.
    To turn this feature off, remove the registry value [HKLM\Software\Microsoft\Fusion!EnableLog].

       --- End of inner exception stack trace ---
       at System.RuntimeTypeHandle.CreateInstance(RuntimeType type, Boolean publicOnly, Boolean noCheck, Boolean& canBeCached, RuntimeMethodHandle& ctor, Boolean& bNeedSecurityCheck)
       at System.RuntimeType.CreateInstanceSlow(Boolean publicOnly, Boolean fillCache)
       at System.RuntimeType.CreateInstanceImpl(Boolean publicOnly, Boolean skipVisibilityChecks, Boolean fillCache)
       at System.Activator.CreateInstance(Type type, Boolean nonPublic)
       at System.RuntimeType.CreateInstanceImpl(BindingFlags bindingAttr, Binder binder, Object[] args, CultureInfo culture, Object[] activationAttributes)
       at Microsoft.ReportingServices.Diagnostics.ExtensionClassFactory.<>c__DisplayClass2.<CreateExtensionObject>b__0()
       at Microsoft.ReportingServices.Diagnostics.RevertImpersonationContext.<>c__DisplayClass1.<Run>b__0(Object state)
       at System.Security.SecurityContext.runTryCode(Object userData)
       at System.Runtime.CompilerServices.RuntimeHelpers.ExecuteCodeWithGuaranteedCleanup(TryCode code, CleanupCode backoutCode, Object userData)
       at System.Security.SecurityContext.Run(SecurityContext securityContext, ContextCallback callback, Object state)
       at Microsoft.ReportingServices.Diagnostics.RevertImpersonationContext.Run(ContextBody callback)
       at Microsoft.ReportingServices.Diagnostics.ExtensionClassFactory.CreateExtensionObject(Extension extConfig, Boolean typeOnly).
    extensionfactory!ReportServer_0-145!1f90!09/20/2013-18:07:26:: e ERROR: Exception caught instantiating SQLPDW report server extension: System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> System.ArgumentException: Unable to find the requested .Net Framework Data Provider.  It may not be installed.
       at System.Data.Common.DbProviderFactories.GetFactory(String providerInvariantName)
       at Microsoft.ReportingServices.DataExtensions.SqlDwConnectionWrapper..ctor()
       --- End of inner exception stack trace ---
       at System.RuntimeTypeHandle.CreateInstance(RuntimeType type, Boolean publicOnly, Boolean noCheck, Boolean& canBeCached, RuntimeMethodHandle& ctor, Boolean& bNeedSecurityCheck)
       at System.RuntimeType.CreateInstanceSlow(Boolean publicOnly, Boolean fillCache)
       at System.RuntimeType.CreateInstanceImpl(Boolean publicOnly, Boolean skipVisibilityChecks, Boolean fillCache)
       at System.Activator.CreateInstance(Type type, Boolean nonPublic)
       at System.RuntimeType.CreateInstanceImpl(BindingFlags bindingAttr, Binder binder, Object[] args, CultureInfo culture, Object[] activationAttributes)
       at Microsoft.ReportingServices.Diagnostics.ExtensionClassFactory.<>c__DisplayClass2.<CreateExtensionObject>b__0()
       at Microsoft.ReportingServices.Diagnostics.RevertImpersonationContext.<>c__DisplayClass1.<Run>b__0(Object state)
       at System.Security.SecurityContext.runTryCode(Object userData)
       at System.Runtime.CompilerServices.RuntimeHelpers.ExecuteCodeWithGuaranteedCleanup(TryCode code, CleanupCode backoutCode, Object userData)
       at System.Security.SecurityContext.Run(SecurityContext securityContext, ContextCallback callback, Object state)
       at Microsoft.ReportingServices.Diagnostics.RevertImpersonationContext.Run(ContextBody callback)
       at Microsoft.ReportingServices.Diagnostics.ExtensionClassFactory.CreateExtensionObject(Extension extConfig, Boolean typeOnly).
    library!ReportServer_0-145!1f90!09/20/2013-18:07:26:: Call to GetSystemPropertiesAction().
    library!ReportServer_0-145!1f90!09/20/2013-18:07:26:: Call to GetItemTypeAction(/XXX).
    library!ReportServer_0-145!1f90!09/20/2013-18:07:26:: Call to GetReportParametersAction(/XXX).
    library!ReportServer_0-145!1f90!09/20/2013-18:07:29:: Call to GetSubscriptionPropertiessAction(f20a7e6c-dd80-4490-9d06-b2441bc9f054).
    library!ReportServer_0-145!1f90!09/20/2013-18:07:29:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.OperationNotSupportedNativeModeException: , Microsoft.ReportingServices.Diagnostics.Utilities.OperationNotSupportedNativeModeException: This operation is not supported on a report server that runs in native mode.;
    library!ReportServer_0-145!1f90!09/20/2013-18:07:29:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException: Email Provider has no server or pickup directory specified, Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException: The report server has encountered a configuration error. ;
    extensionfactory!ReportServer_0-145!1f90!09/20/2013-18:07:29:: e ERROR: Exception caught instantiating Report Server Email report server extension: Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException: The report server has encountered a configuration error.
       at Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider.SetConfiguration(String configInfo)
       at Microsoft.ReportingServices.Diagnostics.ExtensionClassFactory.CreateAndInitializeExtensionInstance(Extension extConfig).


    • Edited by MoritaYumi Monday, September 23, 2013 5:05 PM
    Monday, September 23, 2013 2:54 PM

Answers

  • Hi MoritaYumi,

    From the error message, the issue occurs because the Teradata extension is registered in the Reporting Services configuration file by default, but the Teradata assemblies are not shipped with SQL Server 2008 or as the part of the .NET Framework.

    In general, this error is logged under the following circumstances:

    1.After a new installation of SQL Server 2008 Reporting Services.

    2.Reporting Service restarts each time.

    To avoid the issue, please refer to the solutions below:

    1.Open the Reporting Services configuration file (C:\Program Files\Microsoft SQL Server\MSRS10.MSSQLSERVER\Reporting Services\ReportServer\rsreportserver.config), and remove or comment out the Teradata extension. Do this only if you do not require functionality that the Teradata extension provides.

    2.Install the .NET Data Provider for Teradata. Do this only if you require functionality that the Teradata extension provides. In this case, we can obtain the provider from the Teradata Web site. Reporting Services requires that the provider be version 12 or later, and we need to create the account or use existing account to download it.

    Regards,

    Heidi Duan

    Friday, September 27, 2013 10:02 AM