[Dhis2-users] Error running the Analytics tables

helder yesid castrillon cobo Tue, 23 Sep 2014 23:24:56 -0700


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Ø¨

_______________________________________________
Mailing list: https://launchpad.net/~dhis2-users
Post to     : [email protected]
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

[Dhis2-users] Error running the Analytics tables

Reply via email to