dhis2-users team mailing list archive

["Wilson,Randy" <rwilson@xxxxxxx>]

We have several forms for neonatal, child and maternal death audits that are using the Single Event without registration module.

When I try to Export the data from the Import-Export menu I get an error regardless of which data set.

It appears to be a problem with the date parameter in the SQL query.  Below is the relevant section of the log:

type Exception report
message
description The server encountered an internal error () that prevented it from fulfilling this request.
exception
org.springframework.web.util.NestedServletException: Request processing failed; nested exception is org.springframework.dao.DataIntegrityViolationException: StatementCallback; SQL [select p.uid as p_uid, ps.uid as ps_uid, psi.uid as psi_uid, psi.status as psi_status, ou.uid as ou_uid, psi.executiondate as psi_executiondate, psi.completeduser as psi_completeduser, pdv.value as pdv_value, pdv.storedby as pdv_storedby, pdv.providedelsewhere as pdv_providedelsewhere, de.uid as de_uid from program p left join programstage ps on ps.programid=p.programid left join programstageinstance psi on ps.programstageid=psi.programstageid left join organisationunit ou on (psi.organisationunitid=ou.organisationunitid) left join patientdatavalue pdv on psi.programstageinstanceid=pdv.programstageinstanceid left join dataelement de on pdv.dataelementid=de.dataelementid  where p.programid in (6130)  and ps.programstageid in (6131)  and ou.organisationunitid in (756)  and (psi.executiondate >= 'Tue Jan 01 00:00:00 CAT 2013' and psi.executiondate <= 'Thu Nov 21 00:00:00 CAT 2013')  order by psi_uid;]; ERROR: invalid input syntax for type date: "Tue Jan 01 00:00:00 CAT 2013"
  Position: 805; nested exception is org.postgresql.util.PSQLException: ERROR: invalid input syntax for type date: "Tue Jan 01 00:00:00 CAT 2013"


Has this been reported yet?  I can't get the query to run through PgAdmin either unless I remove the date parameters.

Randy Wilson