zimbra daily reports problem - mta table is empty

[sine]

Hello.

I am receiving empty admin reports for some time.
I have tried solutions mentioned in this thread:
http://www.zimbra.com/forums/adminis...in-report.html

I checked tables raw_log and service_status. Both are ok.
I uncommented the print statements in /opt/zimbra/libexec/zmdailyreport, all of the SELECTions are from mta table.
But mta table is empty.

This is output from /tmp/logproccess.out

Pruning service/server entries older then 2008-02-26 17:20:02
xxxxxxx maps to mail.xxxxxx.com
Processing mta entries from 149124001
Found 1 messages
Inserted 1 rows
Saving ID 149124001
Deleting processed postfix logs from raw_logs...Done
Processing clamd entries from 149125690
Found 0 entries
Deleting processed clamd logs from raw_logs...Done
Processing amavis entries from 150464000
Found 35 entries
Saving ID 150464214
Deleting processed amavis logs from raw_logs...Done
Processing sendmail entries from 0
Found 0 entries
Deleting processed sendmail logs from raw_logs...Done
Processing zimbramon entries from 150463557
Found 2 entries
Saving ID 150464002
Deleting processed zimbramon logs from raw_logs...Done
Aggregating hour mta from 2008-01-17 20:00:00 to 2008-01-17 21:00:00
Aggregating hour mta from 2008-01-17 21:00:00 to 2008-01-17 22:00:00
Aggregating hour mta from 2008-01-17 22:00:00 to 2008-01-17 23:00:00
Aggregating hour mta from 2008-01-17 23:00:00 to 2008-01-18 00:00:00
Aggregating hour mta from 2008-01-18 00:00:00 to 2008-01-18 01:00:00
Aggregating hour mta from 2008-01-18 01:00:00 to 2008-01-18 02:00:00
Aggregating hour mta from 2008-01-18 02:00:00 to 2008-01-18 03:00:00
.
.
.
.
Aggregating day mta from 2008-02-25 00:00:00 to 2008-02-26 00:00:00
Aggregating hour amavis from 2008-02-26 16:00:00 to 2008-02-26 17:00:00
Aggregating day amavis from 2008-02-25 00:00:00 to 2008-02-26 00:00:00
Aggregating hour disk from 2008-02-26 16:00:00 to 2008-02-26 17:00:00
Aggregating day disk from 2008-02-25 00:00:00 to 2008-02-26 00:00:00
Retaining 5 days worth of raw logs based on zimbraLogRawLifetime config.
Retaining 366 days worth of summary logs based on zimbraLogSummaryLifetime config.
Pruning raw mta logs from 2008-02-21 00:00:00
Pruning raw amavis logs from 2008-02-21 00:00:00
Pruning raw disk logs from 2008-02-21 00:00:00
Pruning summary mta logs from 2007-02-25 00:00:00
Pruning summary amavis logs from 2007-02-25 00:00:00
Pruning summary disk logs from 2007-02-25 00:00:00
Pruning other raw logs from 2008-02-21 00:00:00
Optimizing mta tables
Optimizing raw amavis tables
Optimizing raw disk logs table
Optimizing summary mta logs table
Optimizing summary amavis logs table
Optimizing summary disk logs table
Optimizing other raw logs table

~$ /opt/zimbra/libexec/zmdailyreport

Generating report
From 2008-02-25 00:00:00 to 2008-02-26 00:00:00

No messages found

[flare04]

I also have this issue.

[multicast]

Yep same exact problem.... Though I've been asking for help for over a year now and still nothing. Yay.

[ericortego]

My report is nearly empty only reports mail for/from the admin "user".

[staufj22]

Originally Posted by sine

Hello.

I am receiving empty admin reports for some time.
I have tried solutions mentioned in this thread:
http://www.zimbra.com/forums/adminis...in-report.html

I checked tables raw_log and service_status. Both are ok.
I uncommented the print statements in /opt/zimbra/libexec/zmdailyreport, all of the SELECTions are from mta table.
But mta table is empty.

Have you tried checking the mta table? That solved my problem.