dhis2-devs team mailing list archive

[Robin Martens <martens@xxxxxxx>]

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:abyota@xxxxxxxxx]
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 <martens@xxxxxxx<mailto:martens@xxxxxxx>> 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:abyota@xxxxxxxxx]
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 <martens@xxxxxxx<mailto:martens@xxxxxxx>> 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@xxxxxxxxxxxxxxxxxxx<mailto:dhis2-devs@xxxxxxxxxxxxxxxxxxx>
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
--