crm 4.0 reports error using SQL server 2008 r2 reporting services

All replies

• 

  

  0

  Sign in to vote

  1. Check the organization properties in the deployment manager and make sure that it is pointing to the correct Report Server.

  2. Try publishing reports.  The publish reports tool can be found in the tools directory of CRM on the server.  Execute it from the command prompt using publishreports <orgname>

  The reason I'm suggesting to publish again is the following from the above error

  "Exception information: 
      Exception type: ReportServerException 
      Exception message: Execution 'jexv5r45nmonrt45xfjbse45' cannot be found (rsExecutionNotFound)"

  Publishing reports should update this reference.

  Try running your reports again.

  ---

  Jason Peterson

  Wednesday, January 8, 2014 9:59 AM
• 

  

  0

  Sign in to vote

  Thanks for the suggestion but no luck. Same error as before.

  ---

  regards Alan Ward

  Wednesday, January 8, 2014 9:48 PM
• 

  

  0

  Sign in to vote

  Is the report server in the privReporting group in AD?

  Try running one of the out of the box reports like the user summary report directly from the report server.  This will show if the issue is only with CRM or if there is a problem with the report server.  If the reports don't run on the report server, they will not run in CRM either.

  When the Report asks: "Type or enter a user name and password to access the data source: ", you are going to need to input the user's SystemUserID GUID and their Organization GUID. To help us determine this, please run the following statement against the Org_MSCRM database:

   

  SELECT SystemUserId,OrganizationId, FullName FROM SystemUserBase

  WHERE DomainName = 'domain\user'

   

  Note:  Domain is a place holder for the NetBIOS name of the domain and user is a place holder for the user's domain name. For example; Microsoft is the Domain name and Jane Doe's domain name is jdoe so the DomainName = 'Microsoft\jdoe'

   

  For "Log In Name:", please copy the SystemUserId GUID from the query and paste it in the text box.

  For "Password:", please copy the OrganizationId GUID from the query and paste it in the text box.

   

  If the report fails to run properly, then the root cause is with the report server.

   

  You could also try creating a vanilla org from the deployment manager to see if you can run reports in CRM from there to help isolate where the root cause is located.

  
  

  ---

  Jason Peterson

  
  

  • Edited by Jason J Peterson Thursday, January 9, 2014 9:38 AM bad formating

  Thursday, January 9, 2014 9:37 AM
• 

  

  0

  Sign in to vote

  Thanks for the assistance on this Jason.  The reports definitely run when CRM credentials are passed as described above using the Report Manager Web browser so I don't think the problem is on the report server.  I mentioned that the new imported organisation is using the same sql 2008 database server as the other existing organisations but is using its own SSRS instance distinct from the other orgs for its 2008r2 reports.  I don't know if this is significant.  It should be a supported config and there were no validation issues/ errors  when importing the organisation or installing the data connector on the 2008R2 SSRS SQL server. 

  ---

  regards Alan Ward

  Friday, January 10, 2014 4:28 AM
• 

  

  0

  Sign in to vote

  The reporting services log files may provide more information to help diagnose the problem

  ---

  Microsoft CRM MVP - http://mscrmuk.blogspot.com/ http://www.excitation.co.uk

  Friday, January 10, 2014 9:24 AM

  Moderator
• 

  

  0

  Sign in to vote

  Something else I did not mention. Perhaps its significant. If new users are added to CRM directly from the API, Reports work ok.   This is what is written to the Reporting server log : 

  extensionfactory!ReportServer_0-1!a48!01/13/2014-08:32:11:: 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-1!a48!01/13/2014-08:32:12:: 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-1!a48!01/13/2014-08:32:14:: Call to GetDataSourceContentsAction(/ApprenticeManagement_MSCRM/4.0/MSCRM_DataSource).
  library!ReportServer_0-1!a48!01/13/2014-08:32:14:: i INFO: Catalog SQL Server Edition = Enterprise
  crypto!ReportServer_0-1!a48!01/13/2014-08:32:14:: i INFO: Initializing crypto as user: NT AUTHORITY\SYSTEM
  crypto!ReportServer_0-1!a48!01/13/2014-08:32:14:: i INFO: Exporting public key
  crypto!ReportServer_0-1!a48!01/13/2014-08:32:14:: i INFO: Performing sku validation
  crypto!ReportServer_0-1!a48!01/13/2014-08:32:14:: i INFO: Importing existing encryption key
  library!WindowsService_2!f10!01/13/2014-08:33:34:: i INFO: Call to CleanBatch()
  library!WindowsService_2!f10!01/13/2014-08:33:35:: 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_2!f10!01/13/2014-08:33:35:: i INFO: Call to CleanBatch() ends
  

  ---

  regards Alan Ward

  Sunday, January 12, 2014 9:42 PM