Hi Devs,
I am encountering an error when creating an SQL View using the front-end (Data Administration Utility of DHIS2).
I tested this query in Postgre SQL and everything is okay.
Simple SQL View
SELECT de.name AS dataelementname,dv.value as Value,dv.comment, ou.uid As OrgUnitUID, ou.name,dv.periodid,pe.startdate,pe.enddate
FROM datavalue dv INNER JOIN dataelement de
ON(dv.dataelementid = de.dataelementid) AND ((de.uid=‘tATNxcPszv6’ OR de.uid=‘zdShnywRyRP’ OR de.uid=‘p33CeJ0tlE2’ OR de.uid=‘ZEhUXlEjQoY’ OR de.uid=‘Sgfn0Bw3OmZ’ OR de.uid=‘MeHrnx6ypja’ OR de.uid=‘EiHR3DtgJn9’ OR de.uid=‘Xix3M7SHKCf’ OR de.uid=‘Tlv3LImxRoW’ OR de.uid=‘p6GJqwbCXqf’))
INNER JOIN organisationunit ou
ON( dv.sourceid = ou.organisationunitid)
INNER JOIN period pe
ON(dv.periodid = pe.periodid)
ORDER BY OrgUnitUID;
Error in DHIS2
An exception occurred
Sorry! The system failed to execute the operation. Usually, no data is lost and you can continue working by going back to the previous page.
I have attached a snapshot of the tomcat logs.
What could be the problem???
Kind Regards,
Arthur Gwatidzo
Software Development and Information Systems
Health Information Systems Program
TomcatLog.txt (20.1 KB)
···
Email: arthur.g@hisp.org
Cell: +27(0)768983930
Skype: Arthur.Gwatidzo
Web**: ** http://www.hisp.org
66 Rigel Avenue North, Waterkloof Ridge
Pretoria, 0181
South Africa
E -25.7847787 S 28.2347984
This message may contain privileged and confidential information intended only for the person or entity to which it is addressed. Any review, retransmission, dissemination, copy or other use of, or taking of any action in reliance upon this information by persons or entities other than the intended recipient, is prohibited. If you received this message in error, please notify the sender immediately by e-mail, facsimile or telephone and thereafter delete the material from any computer. Any views expressed in this message are those of the individual sender, except where the sender specifically states them to be the view of the entity transmitting the message.