Showing "Report is not available" message on ActiveReports 10

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

  • Posted 17 August 2018, 10:24 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
  • Replied 20 August 2018, 2:12 am 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.
  • Replied 20 August 2018, 10: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
  • Replied 21 August 2018, 12:38 am 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
  • Replied 21 August 2018, 2:36 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.



    Thank you
  • Replied 21 August 2018, 5:24 am 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
  • Replied 24 August 2018, 8:01 am 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
  • Replied 27 August 2018, 2:46 am EST

    Hello,

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

    Thanks,
  • Replied 27 August 2018, 9: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
  • Replied 28 August 2018, 4:32 am 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
  • Replied 31 August 2018, 3:14 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.


    Thanks & Regards
    Teja Gudivada
  • Replied 3 September 2018, 12:51 am EST

    Hello Teja,

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

    Thanks,
  • Replied 3 September 2018, 1:52 am 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


  • Marked as Answer

    Replied 3 September 2018, 2:22 am 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,
  • Replied 1 February 2019, 2:03 am 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
  • Replied 1 February 2019, 9: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.
  • Replied 7 February 2019, 11: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
  • Replied 8 February 2019, 2:40 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.
  • Replied 8 February 2019, 9:25 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.


    .

    Thanks & Regards
    Teja Gudivada
  • Replied 11 February 2019, 10:40 am EST

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

  • Replied 11 February 2019, 3:52 pm 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
  • Replied 14 February 2019, 6:46 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.






    Thanks & Regards
    Teja Gudivada
  • Replied 15 February 2019, 12:14 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.

  • Replied 15 February 2019, 10:02 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'.





    Thanks & Regards
    Teja Gudivada
  • Replied 18 February 2019, 4:51 am 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
Need extra support?

Upgrade your support plan and get personal unlimited phone support with our customer engagement team

Learn More

Forum Channels