Home > Uncategorized > CRM Report Error: Guid should contain 32 digits with 4 dashes

CRM Report Error: Guid should contain 32 digits with 4 dashes


Post from

Rafael’s Blog

http://rafsystems.blogspot.com/2012/04/crm-report-error-guid-should-contain-32.html

 

You receive the following errors when you run a Microsoft Dynamics CRM report in the SRS Report Manager or SRS Report Server:

An error has occurred during report processing (rsProcessingAborted)  Cannot create a connection to data source ‘CRM.’ (rsErrorOpeningConnection)  Guid should contain 32 digits with 4 dashes (xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx).

This error occurs in Microsoft Dynamics CRM 2011 because the Microsoft Dynamics CRM Reporting Extensions requires the user’s SystemUserId value as the Log in name and the user’s OrganizationId value as the password.

When a report runs inside Microsoft Dynamics CRM, these values are passed automatically. These values must be entered manually when the report is run directly from SQL Server Reporting Services.

Obtain the SystemUserId and OrganizationId from the database and manually enter the values using the following steps:

  • Connect to the SQL server machine that contains the Microsoft Dynamics CRM databases as a user that has admin rights to SQL Server.
  • Click Start, click All Programs, click Microsoft SQL Server, and then click SQL Server Management Studio.
  • Click New Query.
  • Click File, click New, and then click Database Engine Query.
  • Select your <organization>_MSCRM from the dropdown list.
  • Execute the following query:
    • Select FullName, SystemUserId, OrganizationId
    • From FilteredSystemUser
    • Order by FullName
  •  Locate the user that will run the report.
  • Enter the SystemUserId value into the Login Name box on the report.
  • Enter the OrganizationId value into the password field on the report.
  • Run the report.
Advertisements
Categories: Uncategorized
  1. No comments yet.
  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: