Microsoft Dynamics 365 | Integration, Dataverse...

The report cannot be displayed. (rsProcessingAborted)

(0) Share

Report

Posted on by EmployeeOcta

Hello All Experts,

I am facing the challenge while trying to open the (The report cannot be displayed. (rsProcessingAborted) )

By following one of the thread am trying to see the log but the directory is not available where the logs gets generated.

<SQL INSTALLDIR>\MSRS11.MSSQLSERVER\Reporting Services\LogFiles.

from the above path the highlighted folder is misssing .

Any help will be appreciable.

I have the same question (0)

All responses (5)

Answers (0)

EmployeeOcta 6 on at

Like (0)

Report

After running the report using report server url i am getting the below error.

An error has occurred during report processing. (rsProcessingAborted)

Cannot create a connection to data source 'CRM'. (rsErrorOpeningConnection)

Microsoft.Crm.CrmException: An unexpected error occurred. System.FormatException: Guid should contain 32 digits with 4 dashes (xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx).

An unexpected error occurred.

Guid should contain 32 digits with 4 dashes (xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx).

Was this reply helpful? Yes No
EmployeeOcta 6 on at

Like (0)

Report

After digging little more i am getting below error.

The EXECUTE permission was denied on the object 'p_GetCrmUserId', database 'MSCRM_CONFIG', schema 'dbo'.

How to resolve this issue now.

Was this reply helpful? Yes No
Suggested answer

Wahaj Rashid 11,321 on at

Like (0)

Report
Hi,

I assume you have an on-premise environment and your reports works in the Visual Studio.

You can check the Error on the Event Viewer (Application) log as well (on your reporting/DB server).

Furthermore, please verify:

You have used the Filtered Views (if it is a sql query).

Depending on your CRM version, your report project TargetServerVersion should be changed, for example:

Once you build the report, copy it from the Bin/Debug or Bin/Release folder (this will have the correct Target Version).

Was this reply helpful? Yes No
EmployeeOcta 6 on at

Like (0)

Report

Hi Wahaj Rashid,

Yes you are correct , this is our on premise version.

I am using fetch based reports and not sql query.

in visual studio report is working fine, even deployed on dev environment from bin->release folder it's working fine.

From DEV environment to Test it is moved in managed solution and there it is giving an issue.

When connecting the Test crm environment through visual studio report is working fine, but from within crm it's not working.

Was this reply helpful? Yes No
EmployeeOcta 6 on at

Like (0)

Report

Hi Guys,

I followed below link

www.inogic.com/.../

and as per the link there is one spn command which i have run on the Active directory server and report is working fine now.

May be this would be helpful for others as well.

Was this reply helpful? Yes No