Blank Elements

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: 8

Time: 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,co

Time: 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,co

Time: 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,co

Time: 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,co

Time: 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,co

Time: 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,co

Time: 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,co

Time: 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,co

Time: 51753 micros: Got aggregated values for query group

Time: 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: 8

Time: 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,uidlevel1

Time: 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,uidlevel1

Time: 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,uidlevel1

Time: 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,uidlevel1

Time: 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,uidlevel1

Time: 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,uidlevel1

Time: 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,uidlevel1

Time: 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,uidlevel1

Time: 51472 micros: Got aggregated values for query group

Time: 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

Gridxls (11).xls (18 KB)

Hi Gomez,

the custom form pdf/excel download is a bit vulnerable since it is parsing the HTML of the form/report and relies on there being well-formed HTML tables inside it. So if you forms have any anomalies in the HTML table markup then you get weird output. The log indicates this, e.g. " Ignoring row which has 6 columns since table has 8 columns". Can you please double-check your custom form HTML and make sure the tables are well-formed, ie. has the same number of cells for each row?

Lars

···

On Wed, Jul 24, 2013 at 10:07 AM, Gomez Phiri gomezphiri@hotmail.com wrote:

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: 8

Time: 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,co

Time: 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,co

Time: 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,co

Time: 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,co

Time: 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,co

Time: 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,co

Time: 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,co

Time: 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,co

Time: 51753 micros: Got aggregated values for query group

Time: 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: 8

Time: 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,uidlevel1

Time: 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,uidlevel1

Time: 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,uidlevel1

Time: 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,uidlevel1

Time: 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,uidlevel1

Time: 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,uidlevel1

Time: 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,uidlevel1

Time: 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,uidlevel1

Time: 51472 micros: Got aggregated values for query group

Time: 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


Mailing list: https://launchpad.net/~dhis2-devs

Post to : dhis2-devs@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-devs

More help : https://help.launchpad.net/ListHelp

ok thanks will do that.