Custom report service / OpenReport (GrapeCity.ActiveReports.Viewer.Html)

Custom report service / OpenReport (GrapeCity.ActiveReports.Viewer.Html)

Posted by: bram_neirinck on 19 January 2021, 12:05 pm EST

• 

  bram_neirinck

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 19 January 2021, 12:05 pm EST

  Hi,

  I’ve upgraded my project from AR8 to AR13 and everything works on my development pc. I fetch the report from my api and display it in the html viewer.

  But when I host it on our server my customreportservice.asmx gives an internal server error and doesn’t display the report.
  
  I doesn’t even get to the call to fetch the report. (api call, so no network traffic in developer tools)

  This is the error I’m getting:
  
  Failed to load resource: the server responded with a status of 500 (Internal Server Error)
  
  https://url/CustomReportService.asmx/OpenReport

  Instead of the report I get this in the viewer:
  
  An error(s) occurred
  
  The type initializer for ‘ac’ threw an exception.

  I’m using AR 13.3.18800.0.

  Can someone point me in the right direction?

• 

  mohitg

  

  • Post Options:
  • Link
    Copy

  Posted 20 January 2021, 12:10 am EST

  Hello,

  Could you please make sure that you have the following dll inlcluded in the production server:
  
  GrapeCity.ActiveReports.Core.Rendering.dll
  
  GrapeCity.ActiveReports.Core.Rdl.dll

  Thanks,
  
  Mohit

• 

  bram_neirinck

  • Post Options:
  • Link
    Copy

  Posted 20 January 2021, 4:28 am EST

  Mohit,

  The 2 files you mentioned are already on the server.

  The url it’s showing when the console is open is:
  
  https://url/bundles/jquery?v=2u0aRenDpYxArEyILB59ETSCA2cfQkSMlxb6jbMBqf81

  send @ jquery?v=2u0aRenDpYx…fQkSMlxb6jbMBqf81:1
  
  ajax @ jquery?v=2u0aRenDpYx…fQkSMlxb6jbMBqf81:1
  
  postJson @ GrapeCity.ActiveRepo…Viewer.Html.js:3299
  
  postService @ GrapeCity.ActiveRepo…Viewer.Html.js:3290
  
  open @ GrapeCity.ActiveRepo….Viewer.Html.js:224
  
  open @ GrapeCity.ActiveRepo…Viewer.Html.js:1894
  
  set report @ GrapeCity.ActiveRepo…Viewer.Html.js:3090
  
  createReportModel @ GrapeCity.ActiveRepo…Viewer.Html.js:2827
  
  report @ GrapeCity.ActiveRepo…Viewer.Html.js:2976
  
  optionImpl @ GrapeCity.ActiveRepo…Viewer.Html.js:2864
  
  generateReport @ app-home-index.js?v1.0:224
  
  printSticker @ app-home-index.js?v1.0:164
  
  onclick @ (index):1

• 

  mohitg

  

  • Post Options:
  • Link
    Copy

  Posted 21 January 2021, 12:52 am EST

  Hello,

  Could you please share the WebConfig file. Also, please make sure that you have correct AR handlers in the WebConfig file.
  
  https://help.grapecity.com/activereports/webhelp/AR13/webframe.html#ConfigureHTTPHandlersinIIS7x.html

  Thanks,
  
  Mohit

• 

  bram_neirinck

  • Post Options:
  • Link
    Copy

  Posted 21 January 2021, 3:55 am EST

  Hello,

  I’ve tried adding some of the handlers but it still doesn’t work on the server.

  Attached is my config file.

  Thanksweb.zip

• 

  mohitg

  

  • Post Options:
  • Link
    Copy

  Posted 22 January 2021, 12:31 am EST

  Hello,

  Could you please tried with the following handlers in the Webconfig file under “system.webServer” tag:

  Thanks,
  
  Mohit

• 

  bram_neirinck

  • Post Options:
  • Link
    Copy

  Posted 22 January 2021, 4:03 am EST

  Hello,

  I’ve changed the config in the system.webserver but it still gives the same error.

   <handlers>
        <add name="AsmxHandler" verb="*" path="*.asmx" preCondition="integratedMode" type="System.Web.Script.Services.ScriptHandlerFactory, System.Web.Extensions, Version=4.0.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35" resourceType="Unspecified" />
        <add verb="*" path="*.ar13" type="GrapeCity.ActiveReports.Web.Handlers.ReportBinariesStreamer, GrapeCity.ActiveReports.Web, Version=13.3.18800.0, Culture=neutral, PublicKeyToken=cc4967777c49a3ff" name="AR13_ReportBinariesStreamer" resourceType="Unspecified" preCondition="integratedMode" />
        <add verb="*" path="*.ar13Web,*.Web" type="GrapeCity.ActiveReports.Web.Handlers.WebCacheAccessHandler, GrapeCity.ActiveReports.Web, Version=13.3.18800.0, Culture=neutral, PublicKeyToken=cc4967777c49a3ff" name="AR13_WebCacheAccessHandler" resourceType="Unspecified" preCondition="integratedMode" />
  
        <add verb="*" path="*.ActiveReport" type="GrapeCity.ActiveReports.Web.Handlers.CompiledReportHandler, GrapeCity.ActiveReports.Web, Version=13.3.18800.0, Culture=neutral, PublicKeyToken=cc4967777c49a3ff" name="AR13_CompiledReportHandler" resourceType="Unspecified" preCondition="integratedMode" />
        <add verb="*" path="*.rpx" type="GrapeCity.ActiveReports.Web.Handlers.RpxHandler, GrapeCity.ActiveReports.Web, Version=13.3.18800.0, Culture=neutral, PublicKeyToken=cc4967777c49a3ff" name="AR13_RpxHandler" resourceType="Unspecified" preCondition="integratedMode" />
        <add verb="*" path="*.rdl,*.rdlx" type="GrapeCity.ActiveReports.Web.Handlers.RdlxHandler, GrapeCity.ActiveReports.Web, Version=13.3.18800.0, Culture=neutral, PublicKeyToken=cc4967777c49a3ff" name="AR13_RdlxHandler" resourceType="Unspecified" preCondition="integratedMode" />
  
      </handlers>
  

• 

  mohitg

  

  • Post Options:
  • Link
    Copy

  Posted 25 January 2021, 1:01 am EST

  Hello,

  Is it possible to share the stripped sample so that I can able to replicate the issue at my end. It is very helpful for us to narrow down the issue at our end.

  Thanks,
  
  Mohit

• 

  bram_neirinck

  • Post Options:
  • Link
    Copy

  Posted 3 February 2021, 12:02 pm EST

  Hi,
  
  I figured out the problem.
  
  When I published the changes to our production environment it appended the dll files instead of deleting everything first.
  
  Therefor there were 2 versions of active reports in the folder.

  I first deleted all dll files and then published it again and now everything works fine.

  Thanks