none
crm 4.0 reports error using SQL server 2008 r2 reporting services

    Question

  • I am attempting to migrate a crm 4.0 organisation on rollup 14  which uses sql 2005 for its database server and SQL 2008r2 for reports to a new deployment . I successfully imported my organisation  from the deployment manager but  none of my reports work. I checked the log for the organisation import but no errors there. In the event viewer of the web server hosting the deployment manaqer, I have an error : 

          

    Log Name:      Application
    Source:        ASP.NET 2.0.50727.0
    Date:          8/01/2014 4:30:25 PM
    Event ID:      1309
    Task Category: Web Event
    Level:         Warning
    Keywords:      Classic
    User:          N/A
    Computer:      xxxxxxxxxxxxxxxxxxxxxxxx
    Description:
    Event code: 3005 
    Event message: An unhandled exception has occurred. 
    Event time: 8/01/2014 4:30:25 PM 
    Event time (UTC): 8/01/2014 5:30:25 AM 
    Event ID: 6e8ff2e6d6db49a3a130d1337ef0c895 
    Event sequence: 156718 
    Event occurrence: 71 
    Event detail code: 0 

    Application information: 
        Application domain: /LM/W3SVC/6/ROOT-1-130335439943500243 
        Trust level: Full 
        Application Virtual Path: / 
        Application Path: E:\Websites\MicrosoftCRM\ 
        Machine name:xxxxxxxxxxxxxxx 

    Process information: 
        Process ID: 5212 
        Process name: w3wp.exe 
        Account name: NT AUTHORITY\NETWORK SERVICE 

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

    Request information: 
        Request URL: https://xxxxxxxxxxxxx:443/Reserved.ReportViewerWebControl.axd?ReportSession=jexv5r45nmonrt45xfjbse45&ControlID=3ceb773806bc46269b8752e1b62d295d&Culture=3081&UICulture=1033&ReportStack=1&OpType=SessionKeepAlive&TimerMethod=KeepAliveMethodreportViewerTouchSession0&CacheSeed=Wedhttps://crm.education.tas.gov.au:443/Reserved.ReportViewerWebControl.axd?ReportSession=jexv5r45nmonrt45xfjbse45&ControlID=3ceb773806bc46269b8752e1b62d295d&Culture=3081&UICulture=1033&ReportStack=1&OpType=SessionKeepAlive&TimerMethod=KeepAliveMethodreportViewerTouchSession0&CacheSeed=Wedhttps://crm.education.tas.gov.au:443/Reserved.ReportViewerWebControl.axd?ReportSession=jexv5r45nmonrt45xfjbse45&ControlID=3ceb773806bc46269b8752e1b62d295d&Culture=3081&UICulture=1033&ReportStack=1&OpType=SessionKeepAlive&TimerMethod=KeepAliveMethodreportViewerTouchSession0&CacheSeed=Wedhttps://crm.education.tas.gov.au:443/Reserved.ReportViewerWebControl.axd?ReportSession=jexv5r45nmonrt45xfjbse45&ControlID=3ceb773806bc46269b8752e1b62d295d&Culture=3081&UICulture=1033&ReportStack=1&OpType=SessionKeepAlive&TimerMethod=KeepAliveMethodreportViewerTouchSession0&CacheSeed=Wed%20Jan%2008%2016%3A30%3A24%202014Jan%2008%2016%3A30%3A24%202014Jan%2008%2016%3A30%3A24%202014Jan%2008%2016%3A30%3A24%202014 
        Request path: /Reserved.ReportViewerWebControl.axd 
        User host address: 10.33.32.10 
        User:xxxxxxxxxxxxxxxxx 
        Is authenticated: True 
        Authentication Type: Negotiate 
        Thread account name: NT AUTHORITY\NETWORK SERVICE 

    Thread information: 
        Thread ID: 13 
        Thread account name: NT AUTHORITY\NETWORK SERVICE 
        Is impersonating: True 
        Stack trace:    at Microsoft.Reporting.WebForms.ServerReport.GetExecutionInfo()
       at Microsoft.Reporting.WebForms.ServerReport.SetExecutionId(String executionId, Boolean fullReportLoad)
       at Microsoft.Reporting.WebForms.ServerReport.LoadFromUrlQuery(NameValueCollection requestParameters, Boolean fullReportLoad)
       at Microsoft.Reporting.WebForms.ReportDataOperation..ctor()
       at Microsoft.Reporting.WebForms.HttpHandler.GetHandler(String operationType)
       at Microsoft.Reporting.WebForms.HttpHandler.ProcessRequest(HttpContext context)
       at System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
       at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)

    Custom event details: 
    Event Xml:
    <Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">
      <System>
        <Provider Name="ASP.NET 2.0.50727.0" />
        <EventID Qualifiers="32768">1309</EventID>
        <Level>3</Level>
        <Task>3</Task>
        <Keywords>0x80000000000000</Keywords>
        <TimeCreated SystemTime="2014-01-08T05:30:25.000Z" />
        <EventRecordID>362050</EventRecordID>
        <Channel>Application</Channel>
        <Computer>xxxxxxxxxxxxxxxxxx</Computer>
        <Security />
      </System>
      <EventData>
        <Data>3005</Data>
        <Data>An unhandled exception has occurred.</Data>
        <Data>8/01/2014 4:30:25 PM</Data>
        <Data>8/01/2014 5:30:25 AM</Data>
        <Data>6e8ff2e6d6db49a3a130d1337ef0c895</Data>
        <Data>156718</Data>
        <Data>71</Data>
        <Data>0</Data>
        <Data>/LM/W3SVC/6/ROOT-1-130335439943500243</Data>
        <Data>Full</Data>
        <Data>/</Data>
        <Data>E:\Websites\MicrosoftCRM\</Data>
        <Data>xxxxxxxxxxxx</Data>
        <Data>
        </Data>
        <Data>5212</Data>
        <Data>w3wp.exe</Data>
        <Data>NT AUTHORITY\NETWORK SERVICE</Data>
        <Data>ReportServerException</Data>
        <Data>Execution 'jexv5r45nmonrt45xfjbse45' cannot be found (rsExecutionNotFound)</Data>
        <Data>https://xxxxxxxxx:443/Reserved.ReportViewerWebControl.axd?ReportSession=jexv5r45nmonrt45xfjbse45&amp;ControlID=3ceb773806bc46269b8752e1b62d295d&amp;Culture=3081&amp;UICulture=1033&amp;ReportStack=1&amp;OpType=SessionKeepAlive&amp;TimerMethod=KeepAliveMethodreportViewerTouchSession0&amp;CacheSeed=Wed%20Jan%2008%2016%3A30%3A24%202014</Data>
        <Data>/Reserved.ReportViewerWebControl.axd</Data>
        <Data>10.33.32.10</Data>
        <Data>xxxxxxxxxxxxxxx</Data>
        <Data>True</Data>
        <Data>Negotiate</Data>
        <Data>NT AUTHORITY\NETWORK SERVICE</Data>
        <Data>13</Data>
        <Data>NT AUTHORITY\NETWORK SERVICE</Data>
        <Data>True</Data>
        <Data>   at Microsoft.Reporting.WebForms.ServerReport.GetExecutionInfo()
       at Microsoft.Reporting.WebForms.ServerReport.SetExecutionId(String executionId, Boolean fullReportLoad)
       at Microsoft.Reporting.WebForms.ServerReport.LoadFromUrlQuery(NameValueCollection requestParameters, Boolean fullReportLoad)
       at Microsoft.Reporting.WebForms.ReportDataOperation..ctor()
       at Microsoft.Reporting.WebForms.HttpHandler.GetHandler(String operationType)
       at Microsoft.Reporting.WebForms.HttpHandler.ProcessRequest(HttpContext context)
       at System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
       at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean&amp; completedSynchronously)
    </Data>
      </EventData>
    </Event>

    The data connector is installed on the sql server where SSRS installed and patched to the latest rollup. I have tried executing the reports using the deployment administrator account and as other users. Same problem.

    Anybody know how to resolve this error ? 



    regards Alan Ward


    • Edited by Alan Ward Wednesday, January 08, 2014 6:25 AM
    Wednesday, January 08, 2014 6:23 AM

All replies

  • 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 08, 2014 9:59 AM
  • Thanks for the suggestion but no luck. Same error as before.

    regards Alan Ward

    Wednesday, January 08, 2014 9:48 PM
  • 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


    Thursday, January 09, 2014 9:37 AM
  • 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
  • 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
  • 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