web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics CRM (Archived) / CRM Custom Report (use...
Microsoft Dynamics CRM (Archived)

CRM Custom Report (used SQL filtered views) are extremely slow when run on the Web UI

(0) ShareShare
ReportReport
Posted on by Hasibur Rahman

I have used Visual studio 2008 BID to make custom report. It works fine in the Preview pane of visual studio (although a bit slow for my liking). However when I upload the report and run it on CRM web UI  - sometimes the wheel keeps spinning for 10 minutes and then stops  - but there is absolutely nothing for the report.

This how the log file looks at that time -

webserver!ReportServer_0-3!778!09/23/2014-13:56:22:: i INFO: Processed report. Report='/DevCRM_MSCRM/CustomReports/{E2ED39D2-1B43-E411-93F3-00155D2D75C6}', Stream=''
library!ReportServer_0-3!10dc!09/23/2014-13:56:38:: i INFO: RenderForNewSession('/DevCRM_MSCRM/CustomReports/{E2ED39D2-1B43-E411-93F3-00155D2D75C6}')
library!WindowsService_8!105c!09/23/2014-13:57:22:: i INFO: Call to CleanBatch()

And sometimes the log file shows this

library!ReportServer_0-3!1428!09/23/2014-13:25:05:: i INFO: Using folder C:\Program Files\Microsoft SQL Server\MSRS11.CRM2013DEV\Reporting Services\RSTempFiles for temporary files.
webserver!ReportServer_0-3!1428!09/23/2014-13:25:14:: i INFO: Processed report. Report='/DevCRM_MSCRM/CustomReports/{E2ED39D2-1B43-E411-93F3-00155D2D75C6}', Stream=''
library!WindowsService_8!1314!09/23/2014-13:27:22:: i INFO: Call to CleanBatch()
library!WindowsService_8!1314!09/23/2014-13:27:22:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams, 0 segments, 0 segment mappings, 0 edit sessions.
library!WindowsService_8!1314!09/23/2014-13:27:22:: i INFO: Call to CleanBatch() ends
extensionfactory!ReportServer_0-3!1428!09/23/2014-13:27:30:: 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=76b417ee2e04956c' 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=76b417ee2e04956c'
   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-3!1428!09/23/2014-13:27:31:: 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-3!1428!09/23/2014-13:27:32:: i INFO: Call to GetDataSourceContentsAction(/SharedReports/6.0.xxxx/MSCRM_FetchDataSource).
library!ReportServer_0-3!10dc!09/23/2014-13:27:32:: i INFO: Call to GetDataSourceContentsAction(/DevCRM_MSCRM/CustomReports/MSCRM_FetchDataSource).
extensionfactory!ReportServer_0-3!1428!09/23/2014-13:27:32:: 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=76b417ee2e04956c' 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=76b417ee2e04956c'
   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()

Could someone tell me if I have to anything clever in my query. My queries are nothing more than select stament

SELECT
 [Subject]
,[ActivityId]
,[RegardingObjectId]
FROM [ActivityPointer]

Please kindly help

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    ScottDurow Profile Picture
    ScottDurow 21 on at

    Those errors in your log file are expected. It might be that your SSRS or SQL server is running low on resources. I suggest you use SQL profiler and activity monitor to find out why the query takes so long.

  • Verified answer
    Aileen Gusni Profile Picture
    Aileen Gusni 44,524 on at

    Hi Hasibur,

    The error seems either your query takes so long (agree to Scott) or your CRM cannot connect to the DataSource as SSRS running problem.

    To check, please check the other uploaded or existing reports, can you run?

    I have encountered this error before because I can access through BIDS same as you do, and did searching anywhere, everywhere with no result, and then I try to check my data source (in this case your data source is DevCRM_MSCRM), so I try to Manage the data source, and got error, when I clicked the Manage.

    Check the Custom Report Data Source first.

    I documented in this blog you can access:

    missdynamicscrm.blogspot.com/.../crm-2011-crm-2013-reporting-error-errorErrorOccurredwhilesettingthedatasourceforthereport.html

    You can try another solution:

    muhammetatalay.blogspot.com/.../exception-caught-instantiating-teradata.html

    social.msdn.microsoft.com/.../teradata-error-in-the-report-server-logs

    In our issue experience before, we fixed the error like what I documented before.

    And hope this helps!

    Thanks.

  • Verified answer
    Hasibur Rahman Profile Picture
    Hasibur Rahman on at

    Thanks for your help guys. The problem was indeed in my query. In my datasource query I was just doing the select (without the "where"). I was letting the filter do that. So, what I did was to pass my input parameter in the initial query - and that made it blazing fast.

    Thanks again - Aileen Gusni and ScottDurow

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics CRM (Archived)

#1
SA-08121319-0 Profile Picture

SA-08121319-0 4

#1
Calum MacFarlane Profile Picture

Calum MacFarlane 4

#3
Alex Fun Wei Jie Profile Picture

Alex Fun Wei Jie 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans