Hi Jan,

Thanks for your pointers. I installed jsReport without docker, used docx recipe from git as you mentioned and set the memory size as 8GB while starting the JsReport.

Below is what I tried on local JsReport server:

1. Increase memory size to 8GB and could render 100 and 200 page doc successfully.
2. I tried 300, and it gave error as “Error: Request body larger than maxBodyLength limit”. This was coming from follow-redirects module and I changed the code to set maxBodyLength as 3GB.
3. Tried 300 page request and it worked successfully.
4. Fired 400 page request this time and got below logs in jsReport

2019-11-29T13:18:48.668Z - debug: Executing recipe html
2019-11-29T13:18:48.765Z - debug: Skipping storing report.
2019-11-29T13:18:48.777Z - info: Rendering request 2 finished in 18955 ms
2019-11-29T13:21:52.063Z - error: unable to load planned schedules Error: Timeou
t during waiting for file system, try it again later.
at Object.rejectItemsWithTimeout (c:\jsreportapp\node_modules\jsreport-fs-st
ore\lib\queue.js:53:23)
at Timeout._onTimeout (c:\jsreportapp\node_modules\jsreport-fs-store\lib\pro
vider.js:346:73)
at listOnTimeout (internal/timers.js:531:17)
at processTimers (internal/timers.js:475:7)
2019-11-29T13:21:53.706Z - error: Error while trying to flush studio logs: Timeo
ut during waiting for file system, try it again later. - Error: Timeout during w
aiting for file system, try it again later.
at Object.rejectItemsWithTimeout (c:\jsreportapp\node_modules\jsreport-fs-st
ore\lib\queue.js:53:23)
at Timeout._onTimeout (c:\jsreportapp\node_modules\jsreport-fs-store\lib\pro
vider.js:346:73)
at listOnTimeout (internal/timers.js:531:17)
at processTimers (internal/timers.js:475:7)
2019-11-29T13:21:56.056Z - debug: Successfully zipped now.
2019-11-29T13:21:56.566Z - error: Error when processing render request Request f
ailed with status code 413 Error: Request failed with status code 413
at createError (c:\jsreportapp\node_modules\axios\lib\core\createError.js:16
:15)
at settle (c:\jsreportapp\node_modules\axios\lib\core\settle.js:17:12)
at IncomingMessage.handleStreamEnd (c:\jsreportapp\node_modules\axios\lib\ad
apters\http.js:237:11)
at IncomingMessage.emit (events.js:215:7)
at endReadableNT (_stream_readable.js:1183:12)
at processTicksAndRejections (internal/process/task_queues.js:80:21)
2019-11-29T13:21:56.607Z - error: Error during processing request at http://localhost:5488/api/report/HCFA

Looking at jsreport logs, it seems that it has generated document internally from green line marked above, but while sending this doc content to playground it fails and give HTTP error 413 which is related to large payload in response.

Appreciate your help in this.

Thanks,
Vishal

Hi Jan,

I am facing similar problem while rendering large data of around 500 pages. Basically I have a single page template and have added {{foreach}} helper in a page and I am passing json array of 500 objects to get document of 500 pages.

I am doing this on DocX recipe with handlebars engine.
My hosting server has 64GB RAM and I have installed dockerized JsReport on it.

Below is the configuration of jsReport.
{
"store": {
"provider": "fs"
},
"httpPort": 5488,
"allowLocalFilesAccess": true,
"blobStorage": {
"provider": "fs"
},
"logger": {
"console": {
"transport": "console",
"level": "debug"
},
"file": {
"transport": "file",
"level": "info",
"filename": "logs/reporter.log"
},
"error": {
"transport": "file",
"level": "error",
"filename": "logs/error.log"
}
},
"chrome": {
"timeout": 1800000
},
"templatingEngines": {
"numberOfWorkers": 50,
"timeout": 1800000,
"strategy": "http-server"
},
"extensions": {
"docx": {
"timeout": 1800000
},
"chrome-pdf": {
"timeout": 1800000
}
},
"express": {
"renderTimeout": 1800000
},
"scripts": {
"allowedModules": "*",
"timeout": 60000000
},
"office": {
"preview": {
"enabled": false,
"showWarning": false
}
}
}

Template and data for 500 pages are placed at below playground URL.
https://playground.jsreport.net/w/meetvishalt/aQGUr9g8

I am starting JsReport by setting Node.Js memory size around 15 GB by running below command
NODE_OPTIONS=--max-old-space-size=16000

I am getting error in console logs as below:
Error
2019-11-28T15:38:04.984Z - warn: Error when processing render request socket hang up Error: socket hang up
at connResetException (internal/errors.js:561:14)
at Socket.socketOnEnd (_http_client.js:440:23)
at Socket.emit (events.js:214:15)
at endReadableNT (_stream_readable.js:1178:12)
at processTicksAndRejections (internal/process/task_queues.js:80:21)
2019-11-28T15:38:04.996Z - warn: Error when processing render request socket hang up Error: socket hang up
at connResetException (internal/errors.js:561:14)
at Socket.socketOnEnd (_http_client.js:440:23)
at Socket.emit (events.js:214:15)
at endReadableNT (_stream_readable.js:1178:12)
at processTicksAndRejections (internal/process/task_queues.js:80:21)

Kindly help in this.

Thanks,
Vishal

Hi Jan,

I have mailed you samples at JAN.BLAHA@JSREPORT.NET from my email id (vtahilramani@equian.com).

Regards,
Vishal

Hi Jan,

Hope you are doing great !

One of my client has specific requirement related to table in template. Template is one page document and it has fixed 6 rows table. apart from table, template has some other data at top and bottom of page.
I have array in input json which represents data to be rendered on table and below is the scenario with expected report.

Scenario1: If json data array length is less than 6 items, generated report would generate 1 page document.

Scenario2: If json data array length is more than 6 items, generated report would generate 2 page document.

PFA template, only issue is how to work with table which has fixed row size of 6, and need to continue on new pages based on data size.

So the requirement is, if data which represents table exceeds than number of rows defined in template, rendered report should generate new page and put the remaining data on new page. Also rest other common data would be replicated into new page. like name, signature and date in attached example.

Kindly share your thoughts on how to achieve this in JsReport using Docx recipe.
Please let me know how can I share samples with you, may be through email.
Appreciate your help as always :)

Regards,
Vishal

Thanks for your quick response. I tried to call the RenderAsync with Anonymous object but I am getting error related to recipe. Below is excerpts from my code.

private static void GenerateWord(ReportingService rs)
{
var html = System.IO.File.ReadAllText(@"C:\temp\CV.htm");

        var prop = new JProperty( "name", "Test Name");

        var customReport = rs.RenderAsync(new {
                Data = new JObject { prop } ,
                Template = new {Content = html, Engine = Engine.Handlebars } } );

        using (var fs = File.Create(@"C:\temp\CV_converted.docx"))
        {
            customReport.Result.Content.CopyTo(fs);
        }
    }

Above code gives Engine exception:
Unable to render template. Engine '0' not found. If this is a custom engine make sure it's properly installed from npm

Kindly share your thoughts. What should be the structure of anonymous object?

I am trying to call the Docx engine through .net nuget package jsreport.Local --> jsreport.Client --> jsreport.Types. Since Docx recipe is not thr in enum I am not able to create Docx through code.
Can you let me know when can we expect Docx recipe type in jsreport.client?

My use case is to work on Check Box in word document. Check box is added from Legacy Forms inside Controls group of Developer tab. Does DocX Recipes have out of box support for Check box added as above? So that when I pass relevant option value in JSON corresponding checkbox would be checked.

Please suggest.

I am converting HTML to PDF using PhantomPDF recipe and encountering problem related to Tabs.
HTML has span tag with style as mso-tab-count:1 like below
<span style='mso-tab-count:1'> </span>.
The problem is my resulting PDF displays junk characters instead of blank spaces/tabs at all places where mso-tab-count is present in HTML.

Please help.

Thanks Jan for your pointers, I used PdfOperation in utils and it solved my problem.

Hi,
I have similar kind of requirement. Use case is like below:

1. I have word document having multiple pages with different orientation, some are landscape and some are portrait.
2. I am saving this word doc as html and as a result I am getting multiple div in html, each represents page having its own style.
3. In header of this html, I have separate style for every page mentioning its orientation as below
   <head>
   .......
   <style>
   .....
   @page WordSection1
   {size:8.5in 11.0in;
   margin:1.0in 1.0in 1.0in 1.0in;
   mso-header-margin:.5in;
   mso-footer-margin:.5in;
   mso-paper-source:0;}
   div.WordSection1
   {page:WordSection1;}
   @page WordSection2
   {size:11.0in 8.5in;
   mso-page-orientation:landscape;
   margin:1.0in 1.0in 1.0in 1.0in;
   mso-header-margin:.5in;
   mso-footer-margin:.5in;
   mso-paper-source:0;}
   div.WordSection2
   {page:WordSection2;}
   @page WordSection3
   {size:8.5in 11.0in;
   margin:1.0in 1.0in 1.0in 1.0in;
   mso-header-margin:.5in;
   mso-footer-margin:.5in;
   mso-paper-source:0;}
   div.WordSection3
   {page:WordSection3;}
   </style>
   </head>
   <body>
   <div page1>
   <div page2>
   <div page3>
   </body>
4. I am feeding this HTML to JsReport as Template and my requirement is to generate corresponding pdf and every page should have orientation as per its respective style mentioned in head/style of html, I mean every page should have orientation as it was in original word document.

Can you please give me some pointers on that?
Thank you in advance for your help