cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
addyb77 Regular Visitor
Regular Visitor

An error has occurred. Please try again (Only happens on 1 report)

Hi.

 

I've recently setup all my mobile reports again and i'm having issues opening one report from the mobile app (android) It tries to render and then i get a brief message along the bottom An error has occurred. Please try again which then disappears and the report continues to try and load.

 

Its a simple text based report which at present should only return 2 rows of text. The only difference with this report is that the data source is from a different server and isnt local like my other reports. Could this be the issue? It was working last year when i originally set it up. I have tried resaving the report under a different name but still no joy. It previews fine in the mobile report publisher.

 

To add the reports all run fine in report manager.

3 REPLIES 3
addyb77 Regular Visitor
Regular Visitor

Re: An error has occurred. Please try again (Only happens on 1 report)

Looking at the error log after i've tried to run the report via the mobile app and this is the text from the log.

 

Microsoft.ReportingServices.Portal.WebHost!reportserverwebapp!3f4!06/20/2017-11:55:13:: e ERROR: [12hribjh]: There was a problem getting data from the Report Server Web Service: System.Web.Services.Protocols.SoapException: An error has occurred during report processing. ---> Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException: An error has occurred during report processing. ---> Microsoft.ReportingServices.ReportProcessing.DataSetExecutionException: The execution failed for the shared data set 'DataSet1'. ---> Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Cannot create a connection to data source ' Data source for shared dataset'. ---> System.Exception: For more information about this error navigate to the report server on the local server machine, or enable remote errors
   at Microsoft.ReportingServices.Library.ReportExecution2005Impl.InternalRender(String Format, String DeviceInfo, PageCountMode pageCountMode, Stream& Result, String& Extension, String& MimeType

 

Now im not sure what its referring to when  it says Dataset1 as i have no dataset named that on the server and im equally confused by the cannot create connection to Data Source for shared dataset.

Community Support Team
Community Support Team

Re: An error has occurred. Please try again (Only happens on 1 report)

Hi @addyb77,

 

>>Cannot create a connection to data source ' Data source for shared dataset'.

Based on error message, it seems like gateway can't connect to datasource. Can you ensure you have correct setting the datasource?

 

In addition, you can also try to ping datasource from the device which install the gateway to confirm the connect state.

 

Regards,

Xiaoxin Sheng

 

 

Community Support Team _ Xiaoxin Sheng
If this post helps, please consider Accept it as the solution to help the other members find it more quickly
Learning resources: Power BI
addyb77 Regular Visitor
Regular Visitor

Re: An error has occurred. Please try again (Only happens on 1 report)

Not sure whats happened but the mobile report now runs on an ipad and android device but doesnt show any data. Today there should be 1 row of data but all im getting is the column headers and its just blank beneath it.

Helpful resources

Announcements
Exclusive LIVE Community Event #3 – Ask Arun Anything

Exclusive LIVE Community Event #3 – Ask Arun Anything

Join us in the third Triple A event!

Meet the 2020 Season 1 Power BI Super Users!

Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

January 2020 Community Highlights

January 2020 Community Highlights

Make sure you didn't miss any of the things that happened in the community in January!

Top Solution Authors