000036417 - RSA Identity Governance & Lifecycle scheduled report generation with attachments in email fails when having a slash (/) in Report Name

Document created by RSA Customer Support Employee on Jun 27, 2018
Version 1Show Document
  • Comment • 0
  • View in full screen mode

Article Content

Article Number000036417
Applies ToRSA Product Set:  RSA Identity Governance &  Lifecycle
RSA Version/Condition:  7.0.0, 7.0.1, 7.0.2, 7.1.0
 
IssueIn Reports, when there is a forward slash (/, HTML /) in the report name, the scheduling with the option of sending attachment fails.

Below is the error we see in aveksaServer.log:
ERROR (ThreadPool-1) [com.aveksa.server.report.ReportRunnerTask] Failed to generate the report. Report Details: Report[id="148" name="Test/report"], ReportResult[id="306", report-id="148", save-date="Tue Jun 05 01:06:01 EDT 2018", fill-start-date="Tue Jun 05 01:04:35 EDT 2018", status="Completed", type="S", created-by-user="0", type-string="Scheduled Report", description="Scheduled Report", filter="null"], run-status="FAILED"]
java.io.FileNotFoundException: /home/oracle/wildfly/standalone/tmp/vfs/deployment/deploymenta01ddddae3cfb04c/aveksa.war-4cca8bb149afacf8/WEB-INF/../report_images/Test/report.CSV (No such file or directory)
at java.io.FileOutputStream.open(Native Method)
at java.io.FileOutputStream.<init>(FileOutputStream.java:221)
at java.io.FileOutputStream.<init>(FileOutputStream.java:110)
at com.aveksa.server.report.Report.saveForEmail(Report.java:1376)
at com.aveksa.server.report.ReportRunnerTask.process(ReportRunnerTask.java:115)
at com.aveksa.server.scheduler.ScheduledTask$Executor.execute(ScheduledTask.java:159)
at com.aveksa.common.ThreadPool$Executor.run(ThreadPool.java:141)
at java.lang.Thread.run(Thread.java:745)


Steps to reproduce



  1. On the General tab, create a custom report with the name Test/report.
  2. On the Query tab, put any simple query: for example, select 1 from dual.
  3. From the Schedule and E-Mail tab, schedule the report and select Attach the report result to the email (sent when scheduled).

User-added image
 


User-added image
CauseThe system translates the forward slash in the report name as a directory, so it looks for the attachment in a location that does not exist.   For example, /home/oracle/wildfly/standalone/tmp/vfs/deployment/deploymenta01ddddae3cfb04c/aveksa.war-4cca8bb149afacf8/WEB-INF/../report_images/Test/report.CSV

It throws the error No such file or directory.

ResolutionThis issue is fixed in 7.0.2 P07 and 7.1.0 P01. Deploy the respective patches to have this issue resolved.

Attachments

    Outcomes