Hi Abyot,
Analytics has no effect, let me try to give you some more details:
· Event reports on individual cases work, but when swapping to
aggregated cases gives the 409 conflict. The aggregated case table doesn't show.
· When downloading, only the first entry is in the export file, all
others are not.
· This issue is for each and every program I with single event without
registration.
Actually, my program instances were not deleted, I was merely thinking about
it. I deleted one duplicate program instance however, and that solved my
previous problem. You're probably right that the problems are linked.
This is the query reported by catalina (only INFO, no WARN or ERROR):
* INFO 2014-09-18 12:50:28,945 Time: 6047 micros: Analytics event aggregate
SQL: select count(psi) as value,"uidlevel3","yearly","CNsby5YXfwg" from
analytics_event_2014_zxpbxmexqlw where Yearly in ('2014') and (uidlevel3 =
'I0VKkMOZxpX' or uidlevel3 = 'glgeSKFNXPa' or uidlevel3 = 'KXilAievUdU' or
uidlevel3 = 'z2zryIhRXae' or uidlevel3 = 'D8BN7nadgnq' or uidlevel3 =
'vnSd7A99aQq' or uidlevel3 = 'BOFb4akeNH3' or uidlevel3 = 'ULF8Ho2cfD7' or
uidlevel3 = 'B2RgtXQ2qes' or uidlevel3 = 'wzLzzvCxYKi' or uidlevel3 =
'a8E8JE43lO9' or uidlevel3 = 'qXuzuo4CNka' or uidlevel3 = 'Jk5fEbW2MRy' or
uidlevel3 = 'rHOAciJo2rS' or uidlevel3 = 'N3WWpd56AF7' or uidlevel3 =
'lp9neuproli' or uidlevel3 = 'kDMzUcY2ZVF' or uidlevel3 = 'k16oIshfkwk' or
uidlevel3 = 'UNA6CawrQhK' or uidlevel3 = 'l250JocutpA' or uidlevel3 =
'PByvDxpbibx' or uidlevel3 = 'DgPyE1KSE4N' or uidlevel3 = 'wnSidr8A3Pw' or
uidlevel3 = 'XmH5uCIONk4' or uidlevel3 = 'yJbg2GIMdnc' or uidlevel3 =
'bcU1Jq7BOKq' or uidlevel3 = 'CeEl2ug1n6w' or uidlevel3 = 'iq4s71gcYF4' or
uidlevel3 = 'SO5Czg58s82' or uidlevel3 = 'L6qT9m4jIOF' ) and ps = 'ZHScYfgW1HR'
group by "uidlevel3","yearly","CNsby5YXfwg" limit 1 (Timer.java
[http-bio-8080-exec-1])
I also put my program tables in annex.
Regards,
Robin
From: Abyot Gizaw [mailto:aby...@gmail.com]
Sent: 18 September 2014 12:33
To: Robin Martens
Cc: DHIS 2 Developers list
Subject: Re: [Dhis2-devs] DHIS2 - Event capture error
Hi Robin,
More details would be nice.
Often, the 409 conflict happens when there is a mismatch in identifiers. And I
guess this is related to the earlier problem you reported, that all your
program instances are deleted. Try to re-run the analytic and see what happens.
---
Thank you,
Abyot.
On Thu, Sep 18, 2014 at 11:50 AM, Robin Martens
<mart...@sher.be<mailto:mart...@sher.be>> wrote:
Hi devs,
Sorry to bother you but it's pretty urgent. Do you have any idea about the
error below?
Thanks a lot!
Robin
From: Robin Martens
Sent: 17 September 2014 17:06
To: 'Abyot Gizaw'
Cc: DHIS 2 Developers list
Subject: RE: [Dhis2-devs] DHIS2 - Event capture error
I'm again on the events, reporting here. When generating any random event
report previously generated without problems (i.e. before upgrading), it gives
the following error in Chrome Console (none in catalina):
GET
http://xx.xx.xx.xx:xx/api/analytics/events/aggregate/Rz3Kk3wc7Hr.json?stage=O6kuhQjsj9b&dimension=pe:THIS_YEAR&dimension=AWDGkLx05Wu&filter=ou:l01au4APkBP
409 Conflict
Most tables don't work, and those that do work can only export a single row
when downloading (similar error).
The demo apparently doesn't show this issue. Any idea if this is linked to the
upgrade? I'm in 16431 now.
Robin
From: Abyot Gizaw [mailto:aby...@gmail.com]
Sent: 17 September 2014 14:24
To: Robin Martens
Cc: DHIS 2 Developers list
Subject: Re: [Dhis2-devs] DHIS2 - Event capture error
You mean you custom form is not shown? If you are using chrome, do you see any
log by pressing F12?
---
Thank you,
Abyot.
On Wed, Sep 17, 2014 at 1:13 PM, Robin Martens
<mart...@sher.be<mailto:mart...@sher.be>> wrote:
To add a point (after checking my other programs for event capture): there is
one for which my custom data form is invisible in event capture but still there
for editing. It's a different one from the one with the error message below.
There's no error log on this one when loading the template.
How can this happen?
Kind regards,
Robin
From: Robin Martens
Sent: 17 September 2014 13:08
To: DHIS 2 Developers list
Subject: DHIS2 - Event capture error
Hi all,
I upgraded this morning to the last version and had the following error message
when trying to save a single event without registration:
"No active event exists for single event no registration program xxx, please
check and correct your database".
I read in the mailing list this might be linked to program instances. Does it
mean I delete all my program instances?
Regards,
Robin
_______________________________________________
Mailing list: https://launchpad.net/~dhis2-devs
Post to :
dhis2-devs@lists.launchpad.net<mailto:dhis2-devs@lists.launchpad.net>
Unsubscribe : https://launchpad.net/~dhis2-devs
More help : https://help.launchpad.net/ListHelp
--
-- PostgreSQL database dump
--
-- Dumped from database version 9.2.8
-- Dumped by pg_dump version 9.2.8
-- Started on 2014-09-18 13:01:46 CAT
SET statement_timeout = 0;
SET client_encoding = 'UTF8';
SET standard_conforming_strings = on;
SET check_function_bodies = false;
SET client_min_messages = warning;
SET search_path = public, pg_catalog;
SET default_tablespace = '';
SET default_with_oids = false;
--
-- TOC entry 335 (class 1259 OID 17346)
-- Name: programstageinstance; Type: TABLE; Schema: public; Owner: dhis;
Tablespace:
--
CREATE TABLE programstageinstance (
programstageinstanceid integer NOT NULL,
uid character varying(11),
created timestamp without time zone,
lastupdated timestamp without time zone,
programinstanceid integer NOT NULL,
programstageid integer NOT NULL,
duedate timestamp without time zone,
executiondate timestamp without time zone,
organisationunitid integer,
status character varying(25),
longitude double precision,
latitude double precision,
completeduser character varying(255),
completeddate timestamp without time zone,
trackedentitycommentid integer
);
ALTER TABLE public.programstageinstance OWNER TO dhis;
--
-- TOC entry 2989 (class 0 OID 17346)
-- Dependencies: 335
-- Data for Name: programstageinstance; Type: TABLE DATA; Schema: public;
Owner: dhis
--
COPY programstageinstance (programstageinstanceid, uid, created, lastupdated,
programinstanceid, programstageid, duedate, executiondate, organisationunitid,
status, longitude, latitude, completeduser, completeddate,
trackedentitycommentid) FROM stdin;
1443 Uj0z3okVDIJ 2014-08-01 10:48:29.092 2014-08-01 10:50:58.267 1442
1441 2014-08-01 10:50:58.267 2014-08-01 00:00:00 80 ACTIVE \N
\N \N \N \N
1446 QvO1pOHxGdx 2014-08-01 10:51:21.252 2014-08-01 10:51:21.253 1442
1441 \N 2014-05-01 00:00:00 80 ACTIVE \N \N \N
\N \N
1435 POVfcdpm3FO 2014-07-28 13:53:33.267 2014-07-28 14:03:47.361 562
561 2014-06-01 00:00:00 2014-06-01 00:00:00 80 COMPLETED
\N \N admin 2014-07-28 00:00:00 \N
1457 cR9Pu5Xe1wN 2014-08-01 14:45:48.98 2014-08-01 14:48:33.288 1456
345 2014-08-01 14:45:48.973 2014-08-01 00:00:00 51 COMPLETED
\N \N admin 2014-08-01 00:00:00 \N
1437 P64o2IZVUNo 2014-07-28 14:03:47.442 2014-07-28 14:04:11.254 562
561 2014-06-01 00:00:00 2014-06-01 00:00:00 80 COMPLETED
\N \N admin 2014-07-28 00:00:00 \N
1438 bJKME5ZUvQJ 2014-08-01 10:23:07.959 2014-08-05 16:57:46.96 329
328 2014-08-05 16:57:46.96 2014-05-01 00:00:00 80 ACTIVE \N
\N \N \N \N
1459 CZE1mj9MDdo 2014-08-01 14:55:32.377 2014-08-05 17:03:05.218 329
328 2014-08-05 17:03:05.218 2014-05-01 00:00:00 80 ACTIVE \N
\N \N \N \N
1483 Tv9rpQuNDKP 2014-08-05 17:24:42.674 2014-08-05 17:34:33.747 562
561 2014-08-05 17:34:33.747 2014-05-01 00:00:00 80 ACTIVE \N
\N \N \N \N
1482 qb9fntoXvHf 2014-08-05 17:24:22.252 2014-08-05 17:34:43.737 562
561 2014-08-05 17:34:43.736 2014-05-01 00:00:00 80 ACTIVE \N
\N \N \N \N
1481 mMlV8iuHx7a 2014-08-05 17:23:58.529 2014-08-05 17:34:50.767 562
561 2014-08-05 17:34:50.767 2014-05-01 00:00:00 80 ACTIVE \N
\N \N \N \N
1484 sIChexe3nKs 2014-08-05 17:25:03.255 2014-08-05 17:37:22.126 562
561 2014-08-05 17:37:22.126 2014-05-01 00:00:00 80 ACTIVE \N
\N \N \N \N
1487 muStVTaghjN 2014-08-05 18:08:47.022 2014-08-05 18:18:28.542 562
561 2014-08-05 18:18:28.542 2014-05-01 00:00:00 77 ACTIVE \N
\N \N \N \N
1488 mzFcfUjrnZC 2014-08-05 18:09:44.11 2014-08-05 18:19:25.654 562
561 2014-08-05 18:19:25.653 2014-05-01 00:00:00 77 ACTIVE \N
\N \N \N \N
1489 PzNJTrGM5NU 2014-08-05 18:21:02.806 2014-08-05 18:22:24.085 562
561 2014-08-05 18:22:24.085 2014-05-01 00:00:00 76 ACTIVE \N
\N \N \N \N
1495 NGSkrYJZ31r 2014-08-07 12:12:26.366 2014-08-07 12:12:26.366 562
561 \N 2014-05-01 00:00:00 80 ACTIVE \N \N \N
\N \N
1651 IJXYhUkkpMb 2014-09-02 09:48:21.087 2014-09-02 12:09:41.317 329
328 2014-09-02 12:09:41.317 2014-09-02 00:00:00 80 ACTIVE \N
\N \N \N \N
2461 EuPLYpAS9bG 2014-09-16 10:43:27.515 2014-09-16 10:43:27.516 329
328 \N 2014-05-01 00:00:00 77 ACTIVE \N \N \N
\N \N
2462 MnnWWpahIGT 2014-09-16 10:44:07.148 2014-09-16 10:44:07.149 329
328 \N 2014-05-01 00:00:00 77 ACTIVE \N \N \N
\N \N
1460 mCh6FlB4Lnm 2014-08-01 14:56:23.141 2014-09-17 10:44:56.105 329
328 2014-09-17 10:44:56.105 2014-05-01 00:00:00 80 ACTIVE \N
\N \N \N \N
2065 VyRuAXWO0Me 2014-09-02 12:21:15.31 2014-09-17 11:06:28.522 329
328 2014-09-17 11:06:28.522 2014-05-01 00:00:00 80 ACTIVE \N
\N \N \N \N
2488 BvwcX1j5Iwx 2014-09-17 11:10:31.159 2014-09-17 11:10:31.159 329
328 \N 2014-05-01 00:00:00 80 ACTIVE \N \N \N
\N \N
1461 KBwL8qHEDkQ 2014-08-01 14:57:04.116 2014-09-17 11:10:48.201 329
328 2014-09-17 11:10:48.201 2014-05-01 00:00:00 80 ACTIVE \N
\N \N \N \N
2586 CC275KpuolE 2014-09-17 13:00:27.315 2014-09-17 13:00:27.315 329
328 \N 2014-08-01 00:00:00 80 ACTIVE \N \N \N
\N \N
2587 DxAQNTGY3Wf 2014-09-17 13:01:24.069 2014-09-17 13:01:24.069 1442
1441 \N 2014-08-01 00:00:00 80 ACTIVE \N \N \N
\N \N
2590 ZTNNcwYMdPo 2014-09-17 13:03:14.276 2014-09-17 13:03:37.201 2589
345 2014-08-01 00:00:00 2014-08-01 00:00:00 \N COMPLETED
\N \N admin 2014-09-17 00:00:00 \N
2602 gO5QHpXWzqx 2014-09-17 15:04:25.362 2014-09-17 15:04:25.362 2595
2594 \N 2014-08-01 00:00:00 80 ACTIVE \N \N \N
\N \N
2596 EnEU8ckU2zC 2014-09-17 14:57:29.886 2014-09-17 15:05:27.93 2595
2594 2014-09-17 15:05:27.93 2014-08-01 00:00:00 80 ACTIVE \N
\N \N \N \N
2752 anigaakzKA9 2014-09-17 15:26:28.784 2014-09-17 15:26:28.784 2595
2594 \N 2014-08-01 00:00:00 80 ACTIVE \N \N \N
\N \N
2756 mwo0cnyZv2U 2014-09-17 15:46:59.856 2014-09-17 15:46:59.856 562
561 \N 2014-06-10 00:00:00 80 ACTIVE \N \N \N
\N \N
\.
--
-- TOC entry 2876 (class 2606 OID 17350)
-- Name: programstageinstance_pkey; Type: CONSTRAINT; Schema: public; Owner:
dhis; Tablespace:
--
ALTER TABLE ONLY programstageinstance
ADD CONSTRAINT programstageinstance_pkey PRIMARY KEY
(programstageinstanceid);
--
-- TOC entry 2878 (class 2606 OID 19983)
-- Name: programstageinstance_uid_key; Type: CONSTRAINT; Schema: public; Owner:
dhis; Tablespace:
--
ALTER TABLE ONLY programstageinstance
ADD CONSTRAINT programstageinstance_uid_key UNIQUE (uid);
--
-- TOC entry 2874 (class 1259 OID 57941)
-- Name: programstageinstance_executiondate; Type: INDEX; Schema: public;
Owner: dhis; Tablespace:
--
CREATE INDEX programstageinstance_executiondate ON programstageinstance USING
btree (executiondate);
--
-- TOC entry 2882 (class 2606 OID 19329)
-- Name: fk_programinstance_commentid; Type: FK CONSTRAINT; Schema: public;
Owner: dhis
--
ALTER TABLE ONLY programstageinstance
ADD CONSTRAINT fk_programinstance_commentid FOREIGN KEY
(trackedentitycommentid) REFERENCES
trackedentitycomment(trackedentitycommentid);
--
-- TOC entry 2881 (class 2606 OID 19324)
-- Name: fk_programstageinstance_organisationunitid; Type: FK CONSTRAINT;
Schema: public; Owner: dhis
--
ALTER TABLE ONLY programstageinstance
ADD CONSTRAINT fk_programstageinstance_organisationunitid FOREIGN KEY
(organisationunitid) REFERENCES organisationunit(organisationunitid);
--
-- TOC entry 2879 (class 2606 OID 19314)
-- Name: fk_programstageinstance_programinstanceid; Type: FK CONSTRAINT;
Schema: public; Owner: dhis
--
ALTER TABLE ONLY programstageinstance
ADD CONSTRAINT fk_programstageinstance_programinstanceid FOREIGN KEY
(programinstanceid) REFERENCES programinstance(programinstanceid);
--
-- TOC entry 2880 (class 2606 OID 19319)
-- Name: fk_programstageinstance_programstageid; Type: FK CONSTRAINT; Schema:
public; Owner: dhis
--
ALTER TABLE ONLY programstageinstance
ADD CONSTRAINT fk_programstageinstance_programstageid FOREIGN KEY
(programstageid) REFERENCES programstage(programstageid);
-- Completed on 2014-09-18 13:01:46 CAT
--
-- PostgreSQL database dump complete
--
--
-- PostgreSQL database dump
--
-- Dumped from database version 9.2.8
-- Dumped by pg_dump version 9.2.8
-- Started on 2014-09-18 13:00:52 CAT
SET statement_timeout = 0;
SET client_encoding = 'UTF8';
SET standard_conforming_strings = on;
SET check_function_bodies = false;
SET client_min_messages = warning;
SET search_path = public, pg_catalog;
SET default_tablespace = '';
SET default_with_oids = false;
--
-- TOC entry 323 (class 1259 OID 17274)
-- Name: program; Type: TABLE; Schema: public; Owner: dhis; Tablespace:
--
CREATE TABLE program (
programid integer NOT NULL,
uid character varying(11),
code character varying(50),
created timestamp without time zone,
lastupdated timestamp without time zone,
name character varying(230) NOT NULL,
description text,
version integer,
dateofenrollmentdescription text,
dateofincidentdescription text,
type integer,
displayincidentdate boolean,
onlyenrollonce boolean,
ignoreoverdueevents boolean,
displayonallorgunit boolean,
selectenrollmentdatesinfuture boolean,
selectincidentdatesinfuture boolean,
relationshiptext character varying(255),
relationshiptypeid integer,
relationshipfroma boolean,
relatedprogramid integer,
dataentrymethod boolean,
trackedentityid integer,
userid integer,
publicaccess character varying(8)
);
ALTER TABLE public.program OWNER TO dhis;
--
-- TOC entry 2988 (class 0 OID 17274)
-- Dependencies: 323
-- Data for Name: program; Type: TABLE DATA; Schema: public; Owner: dhis
--
COPY program (programid, uid, code, created, lastupdated, name, description,
version, dateofenrollmentdescription, dateofincidentdescription, type,
displayincidentdate, onlyenrollonce, ignoreoverdueevents, displayonallorgunit,
selectenrollmentdatesinfuture, selectincidentdatesinfuture, relationshiptext,
relationshiptypeid, relationshipfroma, relatedprogramid, dataentrymethod,
trackedentityid, userid, publicaccess) FROM stdin;
342 CpiDHghr3VQ \N 2014-07-16 14:30:09.604 2014-09-08 14:15:33.409
Forest Restoration Follow-up of restoration activities 1 Event
Creation Date Restoration Start Date 2 t f f t
t f \N f \N f 479 47
rw------
1440 Rz3Kk3wc7Hr \N 2014-08-01 10:42:10.686 2014-09-09 11:52:10.282
Reforestation Permit Reforestation via Exploitation/Cut Permit 1
Enrollment Date Incident Date 3 f f f f f
f \N f \N f \N 47 rw------
327 a0CGF6Asy1r \N 2014-07-16 10:13:54.013 2014-07-24 15:42:35.913
On-site Forest Activity Forest activity data collected on site 1
Enrollment Date Incident Date 3 f f f f f
f \N f \N f \N 47 rw------
560 ZxpBxMexQLW \N 2014-07-24 14:50:22.677 2014-07-24 15:42:46.89
Transport Permit Transport Permit 1 Enrollment Date
Incident Date 3 f f f f f f
\N f \N f \N 47 rw------
2162 vXLf22l8BYp \N 2014-09-08 18:26:11.785 2014-09-08 18:34:31.669
Test2 Test 1 Enrollment Date Incident Date 3 f f
f f f f \N f \N f \N
47 rw------
2593 Y2OQ6y3JDay \N 2014-09-17 14:54:59.663 2014-09-17 14:56:50.018
Forestry Sector Company Register of forestry sector companies 1
Enrollment Date Incident Date 3 f f f f f
f \N f \N f \N 47 rw------
\.
--
-- TOC entry 2875 (class 2606 OID 17281)
-- Name: program_pkey; Type: CONSTRAINT; Schema: public; Owner: dhis;
Tablespace:
--
ALTER TABLE ONLY program
ADD CONSTRAINT program_pkey PRIMARY KEY (programid);
--
-- TOC entry 2877 (class 2606 OID 19977)
-- Name: program_uid_key; Type: CONSTRAINT; Schema: public; Owner: dhis;
Tablespace:
--
ALTER TABLE ONLY program
ADD CONSTRAINT program_uid_key UNIQUE (uid);
--
-- TOC entry 2879 (class 2606 OID 19194)
-- Name: fk_program_relatedprogram; Type: FK CONSTRAINT; Schema: public; Owner:
dhis
--
ALTER TABLE ONLY program
ADD CONSTRAINT fk_program_relatedprogram FOREIGN KEY (relatedprogramid)
REFERENCES program(programid);
--
-- TOC entry 2878 (class 2606 OID 19189)
-- Name: fk_program_relationshipid; Type: FK CONSTRAINT; Schema: public; Owner:
dhis
--
ALTER TABLE ONLY program
ADD CONSTRAINT fk_program_relationshipid FOREIGN KEY (relationshiptypeid)
REFERENCES relationshiptype(relationshiptypeid);
--
-- TOC entry 2880 (class 2606 OID 19199)
-- Name: fk_program_trackedentityid; Type: FK CONSTRAINT; Schema: public;
Owner: dhis
--
ALTER TABLE ONLY program
ADD CONSTRAINT fk_program_trackedentityid FOREIGN KEY (trackedentityid)
REFERENCES trackedentity(trackedentityid);
--
-- TOC entry 2881 (class 2606 OID 19204)
-- Name: fk_program_userid; Type: FK CONSTRAINT; Schema: public; Owner: dhis
--
ALTER TABLE ONLY program
ADD CONSTRAINT fk_program_userid FOREIGN KEY (userid) REFERENCES
userinfo(userinfoid);
-- Completed on 2014-09-18 13:00:53 CAT
--
-- PostgreSQL database dump complete
--
--
-- PostgreSQL database dump
--
-- Dumped from database version 9.2.8
-- Dumped by pg_dump version 9.2.8
-- Started on 2014-09-18 13:01:12 CAT
SET statement_timeout = 0;
SET client_encoding = 'UTF8';
SET standard_conforming_strings = on;
SET check_function_bodies = false;
SET client_min_messages = warning;
SET search_path = public, pg_catalog;
SET default_tablespace = '';
SET default_with_oids = false;
--
-- TOC entry 330 (class 1259 OID 17318)
-- Name: programinstance; Type: TABLE; Schema: public; Owner: dhis; Tablespace:
--
CREATE TABLE programinstance (
programinstanceid integer NOT NULL,
uid character varying(11),
created timestamp without time zone,
lastupdated timestamp without time zone,
dateofincident timestamp without time zone NOT NULL,
enrollmentdate timestamp without time zone NOT NULL,
enddate timestamp without time zone,
followup boolean,
status integer,
trackedentityinstanceid integer,
programid integer NOT NULL,
trackedentitycommentid integer
);
ALTER TABLE public.programinstance OWNER TO dhis;
--
-- TOC entry 2988 (class 0 OID 17318)
-- Dependencies: 330
-- Data for Name: programinstance; Type: TABLE DATA; Schema: public; Owner: dhis
--
COPY programinstance (programinstanceid, uid, created, lastupdated,
dateofincident, enrollmentdate, enddate, followup, status,
trackedentityinstanceid, programid, trackedentitycommentid) FROM stdin;
1456 OrD7U4HnTdb 2014-08-01 14:45:48.973 2014-08-01 14:48:33.294
2014-08-01 14:45:48.973 2014-08-01 14:45:48.973 2014-08-01 14:48:33.294 f
1 1455 342 \N
2164 dcf9SqCdDlg 2014-09-08 18:26:11.834 2014-09-08 18:26:11.834
2014-09-08 18:26:11.834 2014-09-08 18:26:11.834 \N f 0 \N
2162 \N
329 wZ9PiD2OMv7 2014-07-16 10:13:54.028 2014-07-16 10:13:54.028
2014-07-16 10:13:54.028 2014-07-16 10:13:54.028 \N f 0 \N
327 \N
2589 IpFQT5LuBCj 2014-09-17 13:03:14.274 2014-09-17 13:03:37.207
2014-08-01 00:00:00 2014-08-01 00:00:00 2014-09-17 13:03:37.207 f
1 2588 342 \N
2595 J0ELyFh2DDl 2014-09-17 14:54:59.772 2014-09-17 14:54:59.772
2014-09-17 14:54:59.771 2014-09-17 14:54:59.771 \N f 0 \N
2593 \N
562 AwxgcjR4Y7Z 2014-07-24 14:50:22.691 2014-07-24 14:50:22.691
2014-07-24 14:50:22.691 2014-07-24 14:50:22.691 \N f 0 \N
560 \N
1442 mz5bz73RYGM 2014-08-01 10:42:10.795 2014-08-01 10:42:10.795
2014-08-01 10:42:10.794 2014-08-01 10:42:10.794 \N f 0 \N
1440 \N
\.
--
-- TOC entry 2876 (class 2606 OID 17322)
-- Name: programinstance_pkey; Type: CONSTRAINT; Schema: public; Owner: dhis;
Tablespace:
--
ALTER TABLE ONLY programinstance
ADD CONSTRAINT programinstance_pkey PRIMARY KEY (programinstanceid);
--
-- TOC entry 2878 (class 2606 OID 19981)
-- Name: programinstance_uid_key; Type: CONSTRAINT; Schema: public; Owner:
dhis; Tablespace:
--
ALTER TABLE ONLY programinstance
ADD CONSTRAINT programinstance_uid_key UNIQUE (uid);
--
-- TOC entry 2874 (class 1259 OID 20100)
-- Name: index_programinstance; Type: INDEX; Schema: public; Owner: dhis;
Tablespace:
--
CREATE INDEX index_programinstance ON programinstance USING btree
(programinstanceid);
--
-- TOC entry 2881 (class 2606 OID 19264)
-- Name: fk_programinstance_commentid; Type: FK CONSTRAINT; Schema: public;
Owner: dhis
--
ALTER TABLE ONLY programinstance
ADD CONSTRAINT fk_programinstance_commentid FOREIGN KEY
(trackedentitycommentid) REFERENCES
trackedentitycomment(trackedentitycommentid);
--
-- TOC entry 2880 (class 2606 OID 19259)
-- Name: fk_programinstance_programid; Type: FK CONSTRAINT; Schema: public;
Owner: dhis
--
ALTER TABLE ONLY programinstance
ADD CONSTRAINT fk_programinstance_programid FOREIGN KEY (programid)
REFERENCES program(programid);
--
-- TOC entry 2879 (class 2606 OID 19254)
-- Name: fk_programinstance_trackedentityinstanceid; Type: FK CONSTRAINT;
Schema: public; Owner: dhis
--
ALTER TABLE ONLY programinstance
ADD CONSTRAINT fk_programinstance_trackedentityinstanceid FOREIGN KEY
(trackedentityinstanceid) REFERENCES
trackedentityinstance(trackedentityinstanceid);
-- Completed on 2014-09-18 13:01:12 CAT
--
-- PostgreSQL database dump complete
--
--
-- PostgreSQL database dump
--
-- Dumped from database version 9.2.8
-- Dumped by pg_dump version 9.2.8
-- Started on 2014-09-18 13:01:31 CAT
SET statement_timeout = 0;
SET client_encoding = 'UTF8';
SET standard_conforming_strings = on;
SET check_function_bodies = false;
SET client_min_messages = warning;
SET search_path = public, pg_catalog;
SET default_tablespace = '';
SET default_with_oids = false;
--
-- TOC entry 333 (class 1259 OID 17333)
-- Name: programstage; Type: TABLE; Schema: public; Owner: dhis; Tablespace:
--
CREATE TABLE programstage (
programstageid integer NOT NULL,
uid character varying(11),
code character varying(50),
created timestamp without time zone,
lastupdated timestamp without time zone,
name character varying(230),
description character varying(255),
mindaysfromstart integer NOT NULL,
programid integer,
irregular boolean,
dataentryformid integer,
standardinterval integer,
reportdatedescription character varying(255),
autogenerateevent boolean,
validcompleteonly boolean,
displaygenerateeventbox boolean,
capturecoordinates boolean,
generatedbyenrollmentdate boolean,
blockentryform boolean,
remindcompleted boolean,
allowgeneratenextvisit boolean,
openafterenrollment boolean,
reportdatetouse character varying(255),
pregenerateuid boolean
);
ALTER TABLE public.programstage OWNER TO dhis;
--
-- TOC entry 2986 (class 0 OID 17333)
-- Dependencies: 333
-- Data for Name: programstage; Type: TABLE DATA; Schema: public; Owner: dhis
--
COPY programstage (programstageid, uid, code, created, lastupdated, name,
description, mindaysfromstart, programid, irregular, dataentryformid,
standardinterval, reportdatedescription, autogenerateevent, validcompleteonly,
displaygenerateeventbox, capturecoordinates, generatedbyenrollmentdate,
blockentryform, remindcompleted, allowgeneratenextvisit, openafterenrollment,
reportdatetouse, pregenerateuid) FROM stdin;
561 ZHScYfgW1HR \N 2014-07-24 14:50:22.687 2014-09-17 15:47:17.622
Transport Permit Data Input Transport Permit Data Input 0 560
f 567 \N Report date t t f f f
f f f f \N f
345 yMWsGlnS5el \N 2014-07-16 14:32:04.534 2014-09-01 17:31:42.872
Restoration Activity Data Restoration Activity Data 0 342
f 1454 \N Report date t f f t f
f f f f \N \N
2163 jU4APnFZSyG \N 2014-09-08 18:26:11.807 2014-09-17 11:31:16.897
Single-Event Test Test 0 2162 f 2165 \N Report
date t f f f f f f f f
\N f
1441 O6kuhQjsj9b \N 2014-08-01 10:42:10.775 2014-09-11 12:30:19.163
Reforestation Permit Data Entry Reforestation activity via Exploitation/Cut
Permit for DFOs 0 1440 f \N \N Report date t
f f t f f f f f \N \N
328 fXIhuB7grSL \N 2014-07-16 10:13:54.023 2014-09-17 14:52:22.844
Forest Activity Data Input Forest activity data collected on-site 0
327 f 331 \N Report Date t t f t
f f f f f \N f
2594 cT3s07Q8iQt \N 2014-09-17 14:54:59.734 2014-09-17 14:59:25.409
Single-Event Forestry Sector Company Register of forestry sector companies
0 2593 f \N \N Registration date t f
f f f f f f f \N f
\.
--
-- TOC entry 2875 (class 2606 OID 17340)
-- Name: programstage_pkey; Type: CONSTRAINT; Schema: public; Owner: dhis;
Tablespace:
--
ALTER TABLE ONLY programstage
ADD CONSTRAINT programstage_pkey PRIMARY KEY (programstageid);
--
-- TOC entry 2877 (class 2606 OID 19979)
-- Name: programstage_uid_key; Type: CONSTRAINT; Schema: public; Owner: dhis;
Tablespace:
--
ALTER TABLE ONLY programstage
ADD CONSTRAINT programstage_uid_key UNIQUE (uid);
--
-- TOC entry 2879 (class 2606 OID 19294)
-- Name: fk_programstage_dataentryform; Type: FK CONSTRAINT; Schema: public;
Owner: dhis
--
ALTER TABLE ONLY programstage
ADD CONSTRAINT fk_programstage_dataentryform FOREIGN KEY (dataentryformid)
REFERENCES dataentryform(dataentryformid);
--
-- TOC entry 2878 (class 2606 OID 19289)
-- Name: fk_programstage_program; Type: FK CONSTRAINT; Schema: public; Owner:
dhis
--
ALTER TABLE ONLY programstage
ADD CONSTRAINT fk_programstage_program FOREIGN KEY (programid) REFERENCES
program(programid);
-- Completed on 2014-09-18 13:01:31 CAT
--
-- PostgreSQL database dump complete
--
_______________________________________________
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
