Error in 4.9.0
-
In upgrading to 4.9.0 we use the JSReport .Net NuGet packages (v. 3.8.2) for doing
var report = await rs.RenderAsync(new RenderRequest() { Template = template, Data = reportContent, Options = new RenderOptions { Preview = false, Reports = new ReportsOptions { Save = true }, Timeout = 300000 } });
Up until this point everything has been fine, but this new version has now started throwing the error below. No other code has changed. This seems to be happening on our Excel files when downloading
Error when processing render request 53 (because) column "meta" of relation "jsreport_ReportType" does not exist error: column "meta" of relation "jsreport_ReportType" does not exist at Parser.parseErrorMessage (/app-rprt/node_modules/pg-protocol/dist/parser.js:285:98) at Parser.handlePacket (/app-rprt/node_modules/pg-protocol/dist/parser.js:122:29) at Parser.parse (/app-rprt/node_modules/pg-protocol/dist/parser.js:35:38) at TLSSocket.<anonymous> (/app-rprt/node_modules/pg-protocol/dist/index.js:11:42) at TLSSocket.emit (node:events:524:28) at addChunk (node:internal/streams/readable:561:12) at readableAddChunkPushByteMode (node:internal/streams/readable:512:3) at Readable.push (node:internal/streams/readable:392:5) at TLSWrap.onStreamRead (node:internal/stream_base_commons:191:23)
If we change the code to below it works
var report = await rs.RenderAsync(new RenderRequest() { Template = template, Data = reportContent, Options = new RenderOptions { Preview = false, Reports = new ReportsOptions { Save = false }, Timeout = 300000 } });
-
Alter your postgres schema and add the column jsreport_ReportType.meta as string, the same type as other columns there.
-
This corrected it. thank you