DPA: Scheduled Reports Use US Date Format While Ad-hoc Reports Use Local Format

A DPA server located in a non-US country or region (for example, AU) keeps sending scheduled reports in US date format (MM/DD/YY). Ad-hoc reports are sent in the local date format (DD/MM/YY).

In one instance, a DPA server was installed on Red Hat OS in AU. The scheduled report date format was constantly presented as MM/DD/YY.
When running the same report from the DPA UI -> Run Reports, the report is rendered in the date format DD/MM/YY.
Sending the report output by email from the DPA UI also results in DD/MM/YY.
However, once this report is configured as a scheduled report, the date format changes to the US format (MM/DD/YY). This occurs whether the report is published as a file or an email.
Changing the time zone settings from the DPA UI does not change the date format in scheduled reports.

After DPA installation, locale parameter "wrapper.lang parameter" in the configuration file "..\EMC\DPA\services\executive\application-service.conf" is defined as "en_US" by default.
The OS locale setting is overridden by the wrapper configuration. As a result, the date format changes to the US format in scheduled reports.

There are two workarounds available:

1. To change the date format on a specific scheduled report:
   Run the report. In Report Format > Table Styles > Date Fields, set the date format to "DD/MM/YY hh:mm:ss" and save the report.
   This workaround must be done per report.
2. To change the date format on all scheduled reports (for example, to DD/MM/YY with locale AU):
   1. Stop the application service and agent
   2. Back up the application-service.config file to a location outside the DPA directory.
   3. Add the following lines to the application-service.config file:

      wrapper.java.additional.40 = -Duser.language=en
      wrapper.java.additional.41 = -Duser.country=AU

   4. Start the Application service and agent.

Contact support for further details or information.