Options

Report error rendering output

CenterDCenterD Member Posts: 37
edited 2013-09-11 in NAV Three Tier
Have a problem with a not customized 116 statement report,
when I print a customer and the output contains more than approx. 1000 postings I get these errors:

Print to Pdf gives this error:
Rendering output for the report failed and the following error occurred : An error has occurred during report processing.

Using preview:
Will show all the data but with an empty header and without totals
The "Help - About This Report" :
Shows all lines including the last total line.

It seems to be some kind of sql timeout?

From starting the report until I get a reply takes approx. 1,5 min.

Navision server configuration:
"SQL Command Timeout" is the standard 00:30:00
Operation Timeout is set to MaxValue

Comments

  • Options
    nsaleronnsaleron Member Posts: 3
    Hi,

    Have you made any customization in the report? If so, have you tried with the standard report?
    Regards,
    Nicolas Saleron
  • Options
    CenterDCenterD Member Posts: 37
    Hi,

    Nothing has been changed in the 116 statement report, it is totally standard.
    No customization what so ever.
  • Options
    mohana_cse06mohana_cse06 Member Posts: 5,503
    Did you check what is the value in "OperationTimeout" in your Service CustomSettings.config file?

    Did you try by changing it to "MaxValue"?
  • Options
    CenterDCenterD Member Posts: 37
    These are the values in the configuration:

    "SQL Command Timeout" is the standard 00:30:00
    Operation Timeout is set to MaxValue
Sign In or Register to comment.