dhis2-users team mailing list archive

Thread
Date

Error running the Analytics tables

To: "dhis2-users@xxxxxxxxxxxxxxxxxxx" <dhis2-users@xxxxxxxxxxxxxxxxxxx>
From: helder yesid castrillon cobo <helder_947@xxxxxxxxxxx>
Date: Tue, 23 Sep 2014 22:27:26 -0500
Importance: Normal



Hi team,
I have a problem with  the Analytics tables,  when is running   show a message that say "Process failed: Exception during execution ". for try to fix it, I've done the options then:
1) the Postgres log had a error in the period table and I resolved it  adjusting a range (see Log 000000).

2) Delete Analitics Tables in  the maintenance  option .

3) Create Resource tables.

After all the problem with the analytics tables persists.

Attached the logs and a image that show the message error.

information about the instalation:
Dhis ver 2.16.
Compilation 16452 ( 23/09/2014).
Postgres 9.3
Tomcat 7.
Server ubuntu 12.03 (and windows xp, MacOs for testing)


MG. Helder Yesid Castrillon.
Secretaría departamental de salud del Cauca (Colombia)
@heldersoft

2014-09-22 00:00:08 COT ERROR:  el valor null para la columna Â«periodidÂ» viola la restricciÃ³n not null
2014-09-22 00:00:08 COT DETALLE:  La fila que falla contiene (null, 1, 2014-09-01, 2014-09-01).
2014-09-22 00:00:08 COT SENTENCIA:  insert into period (periodtypeid,startdate,enddate)  VALUES (1,'2014-09-01','2014-09-01' )
2014-09-22 00:00:08 COT ERROR:  transacciÃ³n abortada, las Ã³rdenes serÃ¡n ignoradas hasta el fin de bloque de transacciÃ³n
2014-09-22 00:00:08 COT SENTENCIA:  SELECT NULL AS TABLE_CAT, n.nspname AS TABLE_SCHEM, c.relname AS TABLE_NAME,  CASE n.nspname ~ '^pg_' OR n.nspname = 'information_schema'  WHEN true THEN CASE  WHEN n.nspname = 'pg_catalog' OR n.nspname = 'information_schema' THEN CASE c.relkind   WHEN 'r' THEN 'SYSTEM TABLE'   WHEN 'v' THEN 'SYSTEM VIEW'   WHEN 'i' THEN 'SYSTEM INDEX'   ELSE NULL   END  WHEN n.nspname = 'pg_toast' THEN CASE c.relkind   WHEN 'r' THEN 'SYSTEM TOAST TABLE'   WHEN 'i' THEN 'SYSTEM TOAST INDEX'   ELSE NULL   END  ELSE CASE c.relkind   WHEN 'r' THEN 'TEMPORARY TABLE'   WHEN 'i' THEN 'TEMPORARY INDEX'   WHEN 'S' THEN 'TEMPORARY SEQUENCE'   WHEN 'v' THEN 'TEMPORARY VIEW'   ELSE NULL   END  END  WHEN false THEN CASE c.relkind  WHEN 'r' THEN 'TABLE'  WHEN 'i' THEN 'INDEX'  WHEN 'S' THEN 'SEQUENCE'  WHEN 'v' THEN 'VIEW'  WHEN 'c' THEN 'TYPE'  WHEN 'f' THEN 'FOREIGN TABLE'  WHEN 'm' THEN 'MATERIALIZED VIEW'  ELSE NULL  END  ELSE NULL  END  AS TABLE_TYPE, d.description AS REMARKS  FROM pg_catalog.pg_namespace n, pg_catalog.pg_class c  LEFT JOIN pg_catalog.pg_description d ON (c.oid = d.objoid AND d.objsubid = 0)  LEFT JOIN pg_catalog.pg_class dc ON (d.classoid=dc.oid AND dc.relname='pg_class')  LEFT JOIN pg_catalog.pg_namespace dn ON (dn.oid=dc.relnamespace AND dn.nspname='pg_catalog')  WHERE c.relnamespace = n.oid  AND c.relname LIKE 'PROBABLYNOT' AND (false  OR ( c.relkind = 'r' AND n.nspname !~ '^pg_' AND n.nspname <> 'information_schema' ) )  ORDER BY TABLE_TYPE,TABLE_SCHEM,TABLE_NAME 
2014-09-22 00:23:18 COT ERROR:  no existe la tabla Â«analytics_temp_2005Â»
2014-09-22 00:23:18 COT SENTENCIA:  drop table analytics_temp_2005
2014-09-22 00:23:18 COT ERROR:  no existe la tabla Â«analytics_temp_2006Â»
2014-09-22 00:23:18 COT SENTENCIA:  drop table analytics_temp_2006
2014-09-22 00:23:18 COT ERROR:  no existe la tabla Â«analytics_temp_2007Â»
2014-09-22 00:23:18 COT SENTENCIA:  drop table analytics_temp_2007
2014-09-22 00:23:18 COT ERROR:  no existe la tabla Â«analytics_temp_2008Â»
2014-09-22 00:23:18 COT SENTENCIA:  drop table analytics_temp_2008
2014-09-22 00:23:18 COT ERROR:  no existe la tabla Â«analytics_temp_2009Â»
2014-09-22 00:23:18 COT SENTENCIA:  drop table analytics_temp_2009
2014-09-22 00:23:18 COT ERROR:  no existe la tabla Â«analytics_temp_2010Â»
2014-09-22 00:23:18 COT SENTENCIA:  drop table analytics_temp_2010
2014-09-22 00:23:18 COT ERROR:  no existe la tabla Â«analytics_temp_2011Â»
2014-09-22 00:23:18 COT SENTENCIA:  drop table analytics_temp_2011
2014-09-22 00:23:19 COT ERROR:  no existe la tabla Â«analytics_temp_2012Â»
2014-09-22 00:23:19 COT SENTENCIA:  drop table analytics_temp_2012
2014-09-22 00:23:20 COT ERROR:  no existe la tabla Â«analytics_temp_2013Â»
2014-09-22 00:23:20 COT SENTENCIA:  drop table analytics_temp_2013
2014-09-22 00:23:20 COT ERROR:  no existe la tabla Â«analytics_temp_2014Â»
2014-09-22 00:23:20 COT SENTENCIA:  drop table analytics_temp_2014
2014-09-22 00:25:31 COT ERROR:  no existe la tabla Â«analytics_completeness_temp_2006Â»
2014-09-22 00:25:31 COT SENTENCIA:  drop table analytics_completeness_temp_2006
2014-09-22 00:25:31 COT ERROR:  no existe la tabla Â«analytics_completeness_temp_2007Â»
2014-09-22 00:25:31 COT SENTENCIA:  drop table analytics_completeness_temp_2007
2014-09-22 00:25:31 COT ERROR:  no existe la tabla Â«analytics_completeness_temp_2008Â»
2014-09-22 00:25:31 COT SENTENCIA:  drop table analytics_completeness_temp_2008
2014-09-22 00:25:31 COT ERROR:  no existe la tabla Â«analytics_completeness_temp_2009Â»
2014-09-22 00:25:31 COT SENTENCIA:  drop table analytics_completeness_temp_2009
2014-09-22 00:25:31 COT ERROR:  no existe la tabla Â«analytics_completeness_temp_2010Â»
2014-09-22 00:25:31 COT SENTENCIA:  drop table analytics_completeness_temp_2010
2014-09-22 00:25:31 COT ERROR:  no existe la tabla Â«analytics_completeness_temp_2011Â»
2014-09-22 00:25:31 COT SENTENCIA:  drop table analytics_completeness_temp_2011
2014-09-22 00:25:31 COT ERROR:  no existe la tabla Â«analytics_completeness_temp_2012Â»
2014-09-22 00:25:31 COT SENTENCIA:  drop table analytics_completeness_temp_2012
2014-09-22 00:25:31 COT ERROR:  no existe la tabla Â«analytics_completeness_temp_2013Â»
2014-09-22 00:25:31 COT SENTENCIA:  drop table analytics_completeness_temp_2013
2014-09-22 00:25:31 COT ERROR:  no existe la tabla Â«analytics_completeness_temp_2014Â»
2014-09-22 00:25:31 COT SENTENCIA:  drop table analytics_completeness_temp_2014
2014-09-22 00:25:56 COT ERROR:  no existe la tabla Â«analytics_completenesstarget_tempÂ»
2014-09-22 00:25:56 COT SENTENCIA:  drop table analytics_completenesstarget_temp
2014-09-22 00:26:16 COT ERROR:  no existe la tabla Â«analytics_orgunittarget_tempÂ»
2014-09-22 00:26:16 COT SENTENCIA:  drop table analytics_orgunittarget_temp
2014-09-22 00:27:33 COT ERROR:  no existe la tabla Â«analytics_event_temp_2011_r6xqjrte0myÂ»
2014-09-22 00:27:33 COT SENTENCIA:  drop table analytics_event_temp_2011_r6xqjRte0my
2014-09-22 00:27:33 COT ERROR:  la columna Â«aWOpamZLzAeÂ» fue especificada mÃ¡s de una vez
2014-09-22 00:27:33 COT SENTENCIA:  create table analytics_event_temp_2011_r6xqjRte0my ("F1kOhiFe3Jk" character(11),"ETFxArtbpXA" character(11),"ZSkK0ahwRdK" character(11),"YcluJwddRfS" character(11),"H0bTj0mgRgh" character(11),"q3PGFKhw8oZ" character(11),"uidlevel1" character(11),"uidlevel2" character(11),"uidlevel3" character(11),"uidlevel4" character(11),"uidlevel5" character(11),"daily" character varying(15),"weekly" character varying(15),"monthly" character varying(15),"bimonthly" character varying(15),"quarterly" character varying(15),"sixmonthly" character varying(15),"sixmonthlyapril" character varying(15),"yearly" character varying(15),"financialapril" character varying(15),"financialjuly" character varying(15),"financialoct" character varying(15),"N28WD5HGE3u" character varying(255),"vCsa81xauvA" character varying(255),"aWOpamZLzAe" character varying(255),"aWOpamZLzAe" character varying(255),"aWOpamZLzAe" character varying(255),"aWOpamZLzAe" character varying(255),"aWOpamZLzAe" character varying(255),"aWOpamZLzAe" character varying(255),"aWOpamZLzAe" character varying(255),"aWOpamZLzAe" character varying(255),"aWOpamZLzAe" character varying(255),"aWOpamZLzAe" character varying(255),"aWOpamZLzAe" character varying(255),"aWOpamZLzAe" character varying(255),"aWOpamZLzAe" character varying(255),"aWOpamZLzAe" character varying(255),"aWOpamZLzAe" character varying(255),"aWOpamZLzAe" character varying(255),"aWOpamZLzAe" character varying(255),"aWOpamZLzAe" character varying(255),"aWOpamZLzAe" character varying(255),"aWOpamZLzAe" character varying(255),"aWOpamZLzAe" character varying(255),"aWOpamZLzAe" character varying(255),"aWOpamZLzAe" character varying(255),"aWOpamZLzAe" character varying(255),"aWOpamZLzAe" character varying(255),"psi" character(11) not null,"ps" character(11) not null,"executiondate" timestam®éÜj×~Šæ¡×«jØ¨

2014-09-23 17:11:41 COT LOG:  duraciÃ³n: 0.000 ms  parse: <unnamed>: drop table analytics_event_temp_2011_J5FQb9XHJxK
2014-09-23 17:11:41 COT LOG:  duraciÃ³n: 0.000 ms  bind <unnamed>: drop table analytics_event_temp_2011_J5FQb9XHJxK
2014-09-23 17:11:41 COT LOG:  duraciÃ³n: 0.000 ms  ejecutar <unnamed>: drop table analytics_event_temp_2011_J5FQb9XHJxK
2014-09-23 17:11:41 COT LOG:  duraciÃ³n: 0.000 ms  parse: <unnamed>: create table analytics_event_temp_2011_J5FQb9XHJxK ("F1kOhiFe3Jk" character(11),"ETFxArtbpXA" character(11),"ZSkK0ahwRdK" character(11),"YcluJwddRfS" character(11),"H0bTj0mgRgh" character(11),"q3PGFKhw8oZ" character(11),"uidlevel1" character(11),"uidlevel2" character(11),"uidlevel3" character(11),"uidlevel4" character(11),"uidlevel5" character(11),"daily" character varying(15),"weekly" character varying(15),"monthly" character varying(15),"bimonthly" character varying(15),"quarterly" character varying(15),"sixmonthly" character varying(15),"sixmonthlyapril" character varying(15),"yearly" character varying(15),"financialapril" character varying(15),"financialjuly" character varying(15),"financialoct" character varying(15),"psi" character(11) not null,"ps" character(11) not null,"executiondate" timestamp,"longitude" double precision,"latitude" double precision,"ou" character(11) not null,"ouname" character varying(230) not null,"oucode" character varying(50),"tei" character(11)) with (autovacuum_enabled = false)
2014-09-23 17:11:41 COT LOG:  duraciÃ³n: 0.000 ms  bind <unnamed>: create table analytics_event_temp_2011_J5FQb9XHJxK ("F1kOhiFe3Jk" character(11),"ETFxArtbpXA" character(11),"ZSkK0ahwRdK" character(11),"YcluJwddRfS" character(11),"H0bTj0mgRgh" character(11),"q3PGFKhw8oZ" character(11),"uidlevel1" character(11),"uidlevel2" character(11),"uidlevel3" character(11),"uidlevel4" character(11),"uidlevel5" character(11),"daily" character varying(15),"weekly" character varying(15),"monthly" character varying(15),"bimonthly" character varying(15),"quarterly" character varying(15),"sixmonthly" character varying(15),"sixmonthlyapril" character varying(15),"yearly" character varying(15),"financialapril" character varying(15),"financialjuly" character varying(15),"financialoct" character varying(15),"psi" character(11) not null,"ps" character(11) not null,"executiondate" timestamp,"longitude" double precision,"latitude" double precision,"ou" character(11) not null,"ouname" character varying(230) not null,"oucode" character varying(50),"tei" character(11)) with (autovacuum_enabled = false)
2014-09-23 17:11:41 COT LOG:  duraciÃ³n: 0.000 ms  sentencia: SELECT 1;
2014-09-23 17:11:41 COT LOG:  duraciÃ³n: 172.000 ms  ejecutar <unnamed>: create table analytics_event_temp_2011_J5FQb9XHJxK ("F1kOhiFe3Jk" character(11),"ETFxArtbpXA" character(11),"ZSkK0ahwRdK" character(11),"YcluJwddRfS" character(11),"H0bTj0mgRgh" character(11),"q3PGFKhw8oZ" character(11),"uidlevel1" character(11),"uidlevel2" character(11),"uidlevel3" character(11),"uidlevel4" character(11),"uidlevel5" character(11),"daily" character varying(15),"weekly" character varying(15),"monthly" character varying(15),"bimonthly" character varying(15),"quarterly" character varying(15),"sixmonthly" character varying(15),"sixmonthlyapril" character varying(15),"yearly" character varying(15),"financialapril" character varying(15),"financialjuly" character varying(15),"financialoct" character varying(15),"psi" character(11) not null,"ps" character(11) not null,"executiondate" timestamp,"longitude" double precision,"latitude" double precision,"ou" character(11) not null,"ouname" character varying(230) not null,"oucode" character varying(50),"tei" character(11)) with (autovacuum_enabled = false)
2014-09-23 17:11:41 COT LOG:  duraciÃ³n: 0.000 ms  parse: <unnamed>: drop table analytics_event_temp_2011_OKTjWTBLu1x
2014-09-23 17:11:41 COT LOG:  duraciÃ³n: 0.000 ms  bind <unnamed>: drop table analytics_event_temp_2011_OKTjWTBLu1x
2014-09-23 17:11:41 COT LOG:  duraciÃ³n: 0.000 ms  ejecutar <unnamed>: drop table analytics_event_temp_2011_OKTjWTBLu1x
2014-09-23 17:11:41 COT LOG:  duraciÃ³n: 0.000 ms  parse: <unnamed>: create table analytics_event_temp_2011_OKTjWTBLu1x ("F1kOhiFe3Jk" character(11),"ETFxArtbpXA" character(11),"ZSkK0ahwRdK" character(11),"YcluJwddRfS" character(11),"H0bTj0mgRgh" character(11),"q3PGFKhw8oZ" character(11),"uidlevel1" character(11),"uidlevel2" character(11),"uidlevel3" character(11),"uidlevel4" character(11),"uidlevel5" character(11),"daily" character varying(15),"weekly" character varying(15),"monthly" character varying(15),"bimonthly" character varying(15),"quarterly" character varying(15),"sixmonthly" character varying(15),"sixmonthlyapril" character varying(15),"yearly" character varying(15),"financialapril" character varying(15),"financialjuly" character varying(15),"financialoct" character varying(15),"psi" character(11) not null,"ps" character(11) not null,"executiondate" timestamp,"longitude" double precision,"latitude" double precision,"ou" character(11) not null,"ouname" character varying(230) not null,"oucode" character varying(50),"tei" character(11)) with (autovacuum_enabled = false)
2014-09-23 17:11:41 COT LOG:  duraciÃ³n: 0.000 ms  bind <unnamed>: create table analytics_event_temp_2011_OKTjWTBLu1x ("F1kOhiFe3Jk" character(11),"ETFxArtbpXA" character(11),"ZSkK0ahwRdK" character(11),"YcluJwddRfS" character(11),"H0bTj0mgRgh" character(11),"q3PGFKhw8oZ" character(11),"uidlevel1" character(11),"uidlevel2" character(11),"uidlevel3" character(11),"uidlevel4" character(11),"uidlevel5" character(11),"daily" character varying(15),"weekly" character varying(15),"monthly" character varying(15),"bimonthly" character varying(15),"quarterly" character varying(15),"sixmonthly" character varying(15),"sixmonthlyapril" character varying(15),"yearly" character varying(15),"financialapril" character varying(15),"financialjuly" character varying(15),"financialoct" character varying(15),"psi" character(11) not null,"ps" character(11) not null,"executiondate" timestamp,"longitude" double precision,"latitude" double precision,"ou" character(11) not null,"ouname" character varying(230) not null,"oucode" character varying(50),"tei" character(11)) with (autovacuum_enabled = false)
2014-09-23 17:11:41 COT LOG:  duraciÃ³n: 47.000 ms  ejecutar <unnamed>: create table analytics_event_temp_2011_OKTjWTBLu1x ("F1kOhiFe3Jk" character(11),"ETFxArtbpXA" character(11),"ZSkK0ahwRdK" character(11),"YcluJwddRfS" character(11),"H0bTj0mgRgh" character(11),"q3PGFKhw8oZ" character(11),"uidlevel1" character(11),"uidlevel2" character(11),"uidlevel3" character(11),"uidlevel4" character(11),"uidlevel5" character(11),"daily" character varying(15),"weekly" character varying(15),"monthly" character varying(15),"bimonthly" character varying(15),"quarterly" character varying(15),"sixmonthly" character varying(15),"sixmonthlyapril" character varying(15),"yearly" character varying(15),"financialapril" character varying(15),"financialjuly" character varying(15),"financialoct" character varying(15),"psi" character(11) not null,"ps" character(11) not null,"executiondate" timestamp,"longitude" double precision,"latitude" double precision,"ou" character(11) not null,"ouname" character varying(230) not null,"oucode" character varying(50),"tei" character(11)) with (autovacuum_enabled = false)
2014-09-23 17:11:41 COT LOG:  duraciÃ®éÜj×~Šæ¡×«jØ¨

Follow ups

Re: Error running the Analytics tables
From: Moemedi Ntunyane, 2014-09-24