Symptoms

Periodic task "Collect changed billing data for Report Manager" fails with following error:

/var/log/taskman.log
--->8---
[2013/08/13 06:59:41] [INFO] [22608] [HSPC::Taskman::call_task] ===> Executing task #30 [HSPC::MT::Billing::Reports->collect_report_data] [undef]
[2013/08/13 09:55:39] [ERROR] [22608] [HSPC::Taskman::call_task] <=== Task #30 failed locally: 500 Server closed connection without sending any data back at /usr/lib/perl5/site_perl/5.8.8/HSPC/Taskman.pm line 288
---8<---

PBA-S database is located on external server:

/etc/hspc/hspc.conf
---8<---
# Databases settings
MAIN_DB_HOST    = SOME_SERVER
MAIN_DB_NAME    = aspc
MAIN_DB_USER    = DB_USER
MAIN_DB_PASS    = DB_PASS
--->8---

Cause

External server closes the connection during task execution.

Resolution

Run the task manually and check mysql logs on remote server to get reason of the failure. The task may be executed through

PCC > Top > Configuration Director > Logging and Errors > Action Log > Tasks Queue > "Collect changed billing data for Report Manager" > Run now