dhis2-devs team mailing list archive

[Gomez Phiri <gomezphiri@xxxxxxxxxxx>]

HI all,
We are having trouble with customized data-set reports, the problem is when we download the data-set report as pdf or excel only the actual values are appearing without the data elements. Its just a sheet with figures, no corresponding data elements. Please find attached a copy of the excel document. Below is catalina log related to the problem:
 * INFO  2013-07-24 09:40:48,397 Split on de: 8 (DefaultQueryPlanner.java [ajp-bio-8009-exec-529])Time: 4261 micros: Planned query, got: 8 for optimal: 8Time: 33666 micros: Analytics SQL: select de,Monthly,uidlevel1,co, sum(value) as value from analytics_2013 where de in ('XjOt5EfpjZC', 'wjDQhwsZCe5', 'DWhQbsXTKqf') and Monthly in ('201301') and uidlevel1 in ('lZsCb6y0KDX') group by de,Monthly,uidlevel1,coTime: 41698 micros: Analytics SQL: select de,Monthly,uidlevel1,co, sum(value) as value from analytics_2013 where de in ('Q31McktaW8M', 'GzLcR3ixvtz', 'XLYQiQA35zH', 'HvWHBYXen9i', 'u798x1apYy4', 'ljy6cHYTGXC', 'e8X5cKMKZ3p') and Monthly in ('201301') and uidlevel1 in ('lZsCb6y0KDX') group by de,Monthly,uidlevel1,coTime: 41684 micros: Analytics SQL: select de,Monthly,uidlevel1,co, sum(value) as value from analytics_2013 where de in ('qPbrpLTXM6S', 'Gntlr7l7TIe', 'Gr4gBzCCi3J', 'j8fxNg5kzWk', 'u0WBPbyDNas', 'nqnRSXExdny', 'AFBkZPk15qp') and Monthly in ('201301') and uidlevel1 in ('lZsCb6y0KDX') group by de,Monthly,uidlevel1,coTime: 41906 micros: Analytics SQL: select de,Monthly,uidlevel1,co, sum(value) as value from analytics_2013 where de in ('tQb2rrNhe19', 'OD1VCBZeYIQ', 'B9AsUhem8OX', 'nxIfsvzEwuk', 'uO40lf7dYqf', 'jT8ZJIGYVZ7', 'mI5WLvyp52g') and Monthly in ('201301') and uidlevel1 in ('lZsCb6y0KDX') group by de,Monthly,uidlevel1,coTime: 44651 micros: Analytics SQL: select de,Monthly,uidlevel1,co, sum(value) as value from analytics_2013 where de in ('E1yxCspTcQU', 'ec2vmTwetld', 'bEEdLlwZk3R', 'CJvmthjspiC', 'sm31gFiYW9A', 'NKmZjg2Yt2Q', 'a4qTeKaB9xL') and Monthly in ('201301') and uidlevel1 in ('lZsCb6y0KDX') group by de,Monthly,uidlevel1,coTime: 45270 micros: Analytics SQL: select de,Monthly,uidlevel1,co, sum(value) as value from analytics_2013 where de in ('S1eyPvcAybx', 'JUwLXZcB628', 'dtRJWEYYUBC', 'pMSziwFJk95', 'wiuAGVuJ9PV', 'oxQURAVnA0N', 'w8irQ9jU2FG') and Monthly in ('201301') and uidlevel1 in ('lZsCb6y0KDX') group by de,Monthly,uidlevel1,coTime: 45304 micros: Analytics SQL: select de,Monthly,uidlevel1,co, sum(value) as value from analytics_2013 where de in ('xnJqG9UqXpZ', 'GFN0UYW6uUU', 'dqhar3wI35J', 'wBWW5XVqIxZ', 'wuMbrvSXuss', 'bntumFohe7J', 'xzqasXOwOr2') and Monthly in ('201301') and uidlevel1 in ('lZsCb6y0KDX') group by de,Monthly,uidlevel1,coTime: 45068 micros: Analytics SQL: select de,Monthly,uidlevel1,co, sum(value) as value from analytics_2013 where de in ('h9rQWvhIEFM', 'LUFJniad7ii', 'F2634y430TL', 'dMA26DAkasV', 'yMuz5acKnfU', 'igHqfYN0OPp', 'aD3Rz31vnJv') and Monthly in ('201301') and uidlevel1 in ('lZsCb6y0KDX') group by de,Monthly,uidlevel1,coTime: 51753 micros: Got aggregated values for query groupTime: 51816 micros: Got aggregated values* INFO  2013-07-24 09:40:48,450 Split on de: 8 (DefaultQueryPlanner.java [ajp-bio-8009-exec-529])Time: 1263 micros: Planned query, got: 8 for optimal: 8Time: 28355 micros: Analytics SQL: select de,Monthly,uidlevel1, sum(value) as value from analytics_2013 where de in ('XjOt5EfpjZC', 'wjDQhwsZCe5', 'DWhQbsXTKqf') and Monthly in ('201301') and uidlevel1 in ('lZsCb6y0KDX') group by de,Monthly,uidlevel1Time: 29783 micros: Analytics SQL: select de,Monthly,uidlevel1, sum(value) as value from analytics_2013 where de in ('xnJqG9UqXpZ', 'GFN0UYW6uUU', 'dqhar3wI35J', 'wBWW5XVqIxZ', 'wuMbrvSXuss', 'bntumFohe7J', 'xzqasXOwOr2') and Monthly in ('201301') and uidlevel1 in ('lZsCb6y0KDX') group by de,Monthly,uidlevel1Time: 30304 micros: Analytics SQL: select de,Monthly,uidlevel1, sum(value) as value from analytics_2013 where de in ('tQb2rrNhe19', 'OD1VCBZeYIQ', 'B9AsUhem8OX', 'nxIfsvzEwuk', 'uO40lf7dYqf', 'jT8ZJIGYVZ7', 'mI5WLvyp52g') and Monthly in ('201301') and uidlevel1 in ('lZsCb6y0KDX') group by de,Monthly,uidlevel1Time: 30777 micros: Analytics SQL: select de,Monthly,uidlevel1, sum(value) as value from analytics_2013 where de in ('Q31McktaW8M', 'GzLcR3ixvtz', 'XLYQiQA35zH', 'HvWHBYXen9i', 'u798x1apYy4', 'ljy6cHYTGXC', 'e8X5cKMKZ3p') and Monthly in ('201301') and uidlevel1 in ('lZsCb6y0KDX') group by de,Monthly,uidlevel1Time: 31977 micros: Analytics SQL: select de,Monthly,uidlevel1, sum(value) as value from analytics_2013 where de in ('qPbrpLTXM6S', 'Gntlr7l7TIe', 'Gr4gBzCCi3J', 'j8fxNg5kzWk', 'u0WBPbyDNas', 'nqnRSXExdny', 'AFBkZPk15qp') and Monthly in ('201301') and uidlevel1 in ('lZsCb6y0KDX') group by de,Monthly,uidlevel1Time: 31923 micros: Analytics SQL: select de,Monthly,uidlevel1, sum(value) as value from analytics_2013 where de in ('E1yxCspTcQU', 'ec2vmTwetld', 'bEEdLlwZk3R', 'CJvmthjspiC', 'sm31gFiYW9A', 'NKmZjg2Yt2Q', 'a4qTeKaB9xL') and Monthly in ('201301') and uidlevel1 in ('lZsCb6y0KDX') group by de,Monthly,uidlevel1Time: 38288 micros: Analytics SQL: select de,Monthly,uidlevel1, sum(value) as value from analytics_2013 where de in ('S1eyPvcAybx', 'JUwLXZcB628', 'dtRJWEYYUBC', 'pMSziwFJk95', 'wiuAGVuJ9PV', 'oxQURAVnA0N', 'w8irQ9jU2FG') and Monthly in ('201301') and uidlevel1 in ('lZsCb6y0KDX') group by de,Monthly,uidlevel1Time: 29622 micros: Analytics SQL: select de,Monthly,uidlevel1, sum(value) as value from analytics_2013 where de in ('h9rQWvhIEFM', 'LUFJniad7ii', 'F2634y430TL', 'dMA26DAkasV', 'yMuz5acKnfU', 'igHqfYN0OPp', 'aD3Rz31vnJv') and Monthly in ('201301') and uidlevel1 in ('lZsCb6y0KDX') group by de,Monthly,uidlevel1Time: 51472 micros: Got aggregated values for query groupTime: 51565 micros: Got aggregated values* WARN  2013-07-24 09:40:48,511 Ignoring row which has 6 columns since table has 8 columns (GridUtils.java [ajp-bio-8009-exec-529])* WARN  2013-07-24 09:40:48,512 Ignoring row which has 6 columns since table has 8 columns (GridUtils.java [ajp-bio-8009-exec-529])* WARN  2013-07-24 09:40:48,513 Ignoring row which has 7 columns since table has 8 columns (GridUtils.java [ajp-bio-8009-exec-529])* WARN  2013-07-24 09:40:48,513 Ignoring row which has 2 columns since table has 8 columns (GridUtils.java [ajp-bio-8009-exec-529])
We are running DHIS2.12 build revision 11216
Regards,
Gomez

Attachment: Gridxls (11).xls
Description: MS-Excel spreadsheet