Showing "Report is not available" message on ActiveReports 10

Showing "Report is not available" message on ActiveReports 10

Posted by: rambabu on 17 August 2018, 1:24 am EST

• 

  rambabu

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 17 August 2018, 1:24 am EST - Updated 30 September 2022, 8:50 am EST

  Hi,

  We are using grapecity Active Reports 10. while viewing the report, we are getting error like Report is not available.
  
  When the report is opened for first time, it shows the “Report Not Available” error message.
  
  And for the next time onwards it shows report data and Report Not Available error message on the same report.

  The Server we are using is Windows Server 2012 R2 and the IIS version is IIS8.5

  Please help me in resolving this issue.

  Below is the code used to view the report.

  $(function () {
  var viewer = GrapeCity.ActiveReports.Viewer({
  element: '#@timeString',
  reportService: {
  url: '/Lib/Active10/ActiveReports.ReportService.asmx'
  },
  uiType: 'desktop',
  reportLoaded: function (a) {
  console.log(a);
  },
  localeUri: '/Lib/Active10/Scripts/i18n/Localeuri.txt'
  });
  
  var reportOption = {
  id: '@Model.ReportName',
  parameters: parameters
  };
  viewer.option('report', reportOption);
  
  });
  

  https://www.grapecity.com/en/blogs/troubleshooting-activereports-errors-in-mvc/
  
  We tried checking the IIS handlers as well, they are as expected.

  Thankyou

  

  1213×580 20.7 KB

  

  1212×584 16.4 KB

• 

  abdias.michael

  

  • Post Options:
  • Link
    Copy

  Posted 19 August 2018, 5:12 pm EST

  Hi,

  The error you’re facing usually occurs when the handlers aren’t configured correctly. Kindly open the following documentation link and refer to the section ‘To add handlers without configuring IIS 7 or IIS 8 using the DefaultAppPool’ under Integrated Mode topic. The topic explains how to add the handlers under the <system.webserver> section in web.config.

  I would also suggest you to take a look at the following blog post which might be of help - https://www.grapecity.com/en/blogs/troubleshooting-errors-in-activereports-in-mvc-applications
  
  Please change the version from ar8 to ar10 in the route path.

  Let me know if you’re still facing the error.

• 

  rambabu

  • Post Options:
  • Link
    Copy

  Posted 20 August 2018, 1:00 am EST

  Hi,

  I have checked the handlers section in web.config with handlers section in the below Link
  
  http://help.grapecity.com/activereports/webhelp/PDF/ActiveReports10.pdf
  
  ‘To add handlers without configuring IIS 7 or IIS 8 using the DefaultAppPool’ (page No: 751)
  
  Both are same.

  But still i’m getting the error “Report is not available”.

  As i mentioned earlier, when i open the report for the first time, i’m getting “Report is not available” error message. when i closed the report and open the same report, data is coming.
  
  Why it is behaving differently??

  Note: This is a high priority issue. Please help me in resolving this issue.

  Thanks

• 

  mohitg

  

  • Post Options:
  • Link
    Copy

  Posted 20 August 2018, 3:38 pm EST

  Hello,

  Could you please share the images “Console” and “Network” of the browser in both cases?
  
  Also, could you please try after deleting the following line of code in your html page:

  reportLoaded: function (a) {
  console.log(a);
  },
  

  Please share the exact AR version that you are using.

  Also, if possible, could you please share the stripped down sample with us?

  Thanks

• 

  rambabu

  • Post Options:
  • Link
    Copy

  Posted 20 August 2018, 5:36 pm EST - Updated 30 September 2022, 8:51 am EST

  Hello,
  
  We tried removing the console.log in reportLoaded function, but issue not resolved.
  
  The Active Reports version is 10.0.5602.0.

  This is high priority issue. Could you please guide us to fix this ASAP

  The following are the screenshots of the Network window.

  

  1527×831 34 KB

  

  1690×732 37 KB

  

  1693×643 33.4 KB

  

  1635×614 24.4 KB

  Thank you

• 

  mohitg

  

  • Post Options:
  • Link
    Copy

  Posted 20 August 2018, 8:24 pm EST

  Hello,

  Could you please share the screenshot of “Request Headers” instead of “Response body” in “NetWork” tab.
  
  Also, please try with the latest build of AR10. You can download the latest installer at the following link:
  
  http://cdn.grapecity.com/ActiveReports/ar10/ActiveReports-v10.3.9175.0.msi

  I have created the sample application for you. If issue is not reproducible with attached application then could you please modified the application so that I can replicate the issue at my end.

  Thanks,
  
  AR_HTML5Viewer_MVC.zip

• 

  rambabu

  • Post Options:
  • Link
    Copy

  Posted 23 August 2018, 11:01 pm EST

  Hello,

  Few dll files are missed in the attached file(AR_HTML5Viewer_MVC.zip)
  
  Can you please provide the latest dll files(version 10.3.9175.0) for the below:

  GrapeCity.ActiveReports.Export.Word.v10.dll
  
  GrapeCity.ActiveReports.Export.xml.v10.dll
  
  GrapeCity.ActiveReports.Viewer.Win.v10.dll
  
  GrapeCity.ActiveReports.Export.Image.Unsafe.v10.dll

  Thankyou

• 

  mohitg

  

  • Post Options:
  • Link
    Copy

  Posted 26 August 2018, 5:46 pm EST

  Hello,

  You can delete the references of above dll’s in the project as these dll’s never used in the project.

  Thanks,

• 

  rambabu

  • Post Options:
  • Link
    Copy

  Posted 27 August 2018, 12:17 am EST

  Hello,

  In my project, i’m using the above requested dll files.
  
  can you please provide the latest version 10.3.9175.0 for the below:
  
  GrapeCity.ActiveReports.Export.Word.v10.dll
  
  GrapeCity.ActiveReports.Export.xml.v10.dll
  
  GrapeCity.ActiveReports.Viewer.Win.v10.dll
  
  GrapeCity.ActiveReports.Export.Image.Unsafe.v10.dll

  Thankyou

• 

  mohitg

  

  • Post Options:
  • Link
    Copy

  Posted 27 August 2018, 7:32 pm EST

  Hello,

  You can find the above dll in the following folder:
  
  C:\Program Files (x86)\Common Files\GrapeCity\ActiveReports 10

  If you haven’t installed the latest version of AR10 then you may face the license issue on rebuilding the project. Hence, please install the latest version on your machine.

  Also, please refer the attached zip file for the desired dll’s.

  Thanks,
  
  dlls.zip

• 

  rambabu

  • Post Options:
  • Link
    Copy

  Posted 30 August 2018, 6:14 pm EST - Updated 30 September 2022, 8:50 am EST

  Hello,
  
  We updated the dll’s to the latest version of Activer Reports 10.
  
  But the issue still persists.

  The issue happens only when showing the report on Web. Exporting of the Active Report to a file location using c# works fine.

  Following are the screenshots for the Request Headers for the Active reports.

  

  1541×825 35.6 KB

  

  1434×878 40.1 KB

  

  1414×882 42.5 KB

  
  
  

  

  1638×825 38.5 KB

  Thanks & Regards
  
  Teja Gudivada

• 

  mohitg

  

  • Post Options:
  • Link
    Copy

  Posted 2 September 2018, 3:51 pm EST

  Hello Teja,

  Could you please confirm that issue is also reproducible with the sample that I have provided you earlier.

  Thanks,

• 

  rambabu

  • Post Options:
  • Link
    Copy

  Posted 2 September 2018, 4:52 pm EST

  Hello Mohit,
  
  The Active Reports is working fine on the Development Server.
  
  But the issue happens only on the production server .This issue happens not only for my project, it happens in all the projects hosted on the production server.

  Active Reports on the production server worked fine till August 13th.

  Could you please guide us what could be the issue.

  Thanks & Regards
  
  Teja Gudivada

• 

  mohitg

  

  • Post Options:
  • Link
    Copy

  Posted 2 September 2018, 5:22 pm EST

  Hello Teja,

  Could you please tell is there any action performed by you after 13 August like server update, AR build update etc? Also, could you please try after restarting the application pool.

  Thanks,

• 

  rambabu

  • Post Options:
  • Link
    Copy

  Posted 31 January 2019, 5:03 pm EST

  Hello,

  There are no AR build updates installed on Windows 2012 R2 machine, we tried restarting the application pool as well, but there is no luck.

  We have two production boxes Windows 2008 R2 and Windows 2012 R2.
  
  When we host the project in Windows 2008 R2, Active reports are working fine without any issues.

  The issue happens with only Windows 2012 R2, we tried hosting our project in other windows 2012 R2 machines, the same Active Report issue happens there.

  Note: Only the Active Reports Web Viewer is throwing an error as mentioned in this thread, Generating an active Report through c# code works fine without any issues.

  Please let us know if we could have a call to solve this issue. As this has been one of the critical issues in our project.

  Let me know if you need any other information.

  Thanks & Regards
  
  Teja

• 

  mohitg

  

  • Post Options:
  • Link
    Copy

  Posted 1 February 2019, 12:27 am EST

  Hello Teja,

  Could you please provide us the sample so that we can replicate the issue our end. This will be very helpful for us to resolve the problem asap.

  Thanks.

• 

  rambabu

  • Post Options:
  • Link
    Copy

  Posted 7 February 2019, 2:59 am EST

  Hello Mohith, Please find the sample project in the attached link.
  
  https://www.dropbox.com/s/h4j8qrg3lvlutc9/ActiveReportsSample.zip?dl=0

  please let me know if you have any questions.

  Thanks & Regards
  
  Teja Gudivada

• 

  mohitg

  

  • Post Options:
  • Link
    Copy

  Posted 7 February 2019, 5:40 pm EST - Updated 30 September 2022, 8:50 am EST

  Hello Teja,

  I have deployed your application on Windows 2012 R2. and the report is previewed successfully at my end. Please refer to the attached image.

  Steps:
  
  1: Browse the application
  
  2: Clicked on the “Click to Generate Report”
  
  Observe: the report is previewed successfully

  Request to please confirm if I am missing something.

  Could you please check that Pipeline mode of "Application Pool’ of deployed application is “Integrated” or “Classic”. If it is classic, then please try after changing to “Integrated” Mode. Please refer to the attached image.

  Thanks.

  

  884×973 44 KB

  

  480×553 15.2 KB

• 

  rambabu

  • Post Options:
  • Link
    Copy

  Posted 8 February 2019, 12:25 am EST - Updated 30 September 2022, 8:50 am EST

  Hello Mohit,
  
  I checked the application pool settings for the project, the pipeline mode is already set as Integrated mode.
  
  please refer to the screenshot.

  

  822×330 18.8 KB

  .

  Thanks & Regards
  
  Teja Gudivada

• 

  rambabu

  • Post Options:
  • Link
    Copy

  Posted 11 February 2019, 1:40 am EST - Updated 30 September 2022, 8:50 am EST

  Hello Mohit,
  
  We deployed the same application in the Windows 2012 R2 version, but the following issue still happens.

  

  1836×853 54.4 KB

• 

  abdias.michael

  

  • Post Options:
  • Link
    Copy

  Posted 11 February 2019, 6:52 am EST

  Hi Teja,

  There are two possible reasons for this error -

  1. Either the report doesn’t exist at the specified path
     
     Or
  2. The AR handlers haven’t been set up correctly

  I could see that the handlers have been set up correctly in web.config. On the other hand, you’ve placed the ActiveReports.ReportService.asmx file under the Lib/Active10 folder whereas the Reports folder is under the root folder. Hence, the service is unable to find the report at the specified relative location. Please move the ReportService.asmx file under the root folder of the application so the Reports folder path is relative to the report service.

  If you’re still facing the issue, kindly open the browser’s Developer Tools (F12) and go the Network tab. Now when you click on the ‘Click to Generate Report’ button, you’ll be able to see the exact request that is causing the problem. Please send a screen shot of the Network tab.

  Hope it helps

• 

  rambabu

  • Post Options:
  • Link
    Copy

  Posted 13 February 2019, 9:46 pm EST - Updated 30 September 2022, 8:51 am EST

  Hello Michael,
  
  We moved the ReportService.asmx page as per your suggestion. but it doesn’t solve the issue.
  
  Can you please take a look at the screenshots.

  let me know if you need any other information.

  

  1108×513 26.8 KB

  

  1847×813 68.2 KB

  

  1914×722 13.1 KB

  Thanks & Regards
  
  Teja Gudivada

• 

  abdias.michael

  

  • Post Options:
  • Link
    Copy

  Posted 14 February 2019, 3:14 pm EST - Updated 30 September 2022, 8:51 am EST

  Hi Teja,

  Perhaps I wasn’t clear enough. The report service needs to be in the root directory of the application i.e in the same folder as the Reports folder. Please see attached screen shot.

  

• 

  rambabu

  • Post Options:
  • Link
    Copy

  Posted 15 February 2019, 1:02 am EST - Updated 30 September 2022, 8:51 am EST

  Hello Michael,
  
  We tried to move the Activereports.ReportService.asmx file to the root folder as mentioned above.
  
  But, it still didn’t solve the issue. It shows the same error message ‘Report Not Available’.

  

  731×408 15 KB

  Thanks & Regards
  
  Teja Gudivada

• 

  abdias.michael

  

  • Post Options:
  • Link
    Copy

  Posted 17 February 2019, 7:51 pm EST

  Hi Teja,

  I have moved this issue to our support system (http://supportone.componentone.com/home/casedetail/367453). Kindly login with your existing credentials (used to login to the forums) or create a new account with the same email address on our support portal. We’ll proceed with this issue through the support portal here on.

  Thanks