Search Engine: Elastic

Article ID: 125218, created on Apr 14, 2015, last review on Apr 20, 2015

  • Applies to:
  • Odin Business Automation Standard 4.5


Top > Billing Director > Report Manager > Aged A/R Report > Total shows all values equal to zero while on Details tab there are real data.


The empty Aged A/R Report and other reports are caused by NULL value returned by the mysql function CONVERT_TZ().


To resolve the issue, please populate again the timezone values from system to mysql tables with the following commands:

# mysql_tzinfo_to_sql /usr/share/zoneinfo | mysql -u root mysql
# service mysqld restart

To verify the solution, please run

# hspc-sql
> select CONVERT_TZ(now(), 'GMT', 'Europe/London');

It should return a not-NULL value.

400e18f6ede9f8be5575a475d2d6b0a6 caea8340e2d186a540518d08602aa065 624ca542e40215e6f1d39170d8e7ec75 70a5401e8b9354cd1d64d0346f2c4a3e

Email subscription for changes to this article
Save as PDF