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" timestamjם~׫jب