Question

No result set in XML with larger size PDF reports

  • 8 March 2022
  • 1 reply
  • 107 views

Badge +2

Hi,

We are running on IFS 9 and using report rules to send emails in order to have control of the the PDF file name. 

However, much of the time the rule fails with an error similar to:


Rule ID=30 ORA-6502:ERROR Evaluating Expression=''[@CUSTOMER_ORDER_CONF_REP/BILL_ADDR_1]'' result_key=1499formatter_properties=LocaleCountryUS

 

Upon further investigation, the rules are failing on larger sized documents (order lines can number into the hundreds of lines).  I downloaded the report XML and see that the file contains no information other than the report translation information, which would explain the errors reported in the reporting rule log.

The reporting rules work fine with smaller printouts where the report data is present in the XML.

Are there any settings that control this behavior?

Thank you.

Best regards,

Pakorn


This topic has been closed for comments

1 reply

Userlevel 7
Badge +15

Hi, 

If you are on UPD 7 or above then the XML is compressed and saved rather than having is in plain XML text. This was done with patch 134728 which went with UPD 7.

 

This patch has some supplementary patches which matches the issues you face. See below for details and apply them and see if it resolves your issue.

 

Bug Fix 139408 (UPD 10) -  Report Rule Engine evaluate Xpath values does not work with Large zipped report data.

Bug Fix 137254 (UPD 8) - 'Get XML Data...' from Report Archive sometimes returns only header xml. Missing data. Apply supplementary fix 138314 as well.

There are few more supplementary bug fixes for 134728 which you can have a look and apply if needed.

Regards,

Chanaka