4 Replies Latest reply on Sep 16, 2019 8:11 AM by Maria Riccelli

    ERROR - [red-sys-1020400] BCO_DH_ERR011: red-sys-launcher error detected

    Enrique Guerrero
      Share This:

      2019-09-13 00:07:08,533 ERROR - [red-sys-1020400] BCO_DH_ERR011: red-sys-launcher error detected

      StackTrace: com.neptuny.cpit.querymanager.QueryException: DYNAMIC POSTGRES-23505 - ERROR: llave duplicada viola restricción de unicidad «sys_data_d_3_p_20190901_pkey»

        Detail: Ya existe la llave (sysobjid, ts, dclassid, pclassid)=(1020400, 2019-08-11 00:00:00, 3, 0).

        Where: sentencia SQL: «insert into partitions.sys_data_d_3_p_20190901 values (new.*)»

      función PL/pgSQL sys_data_d_3_trg_ins() en la línea 8 en sentencia SQL

      sql-code  : insert into SYS_DATA_D_3 (sysobjid, ts, tzoffset, dclassid, pclassid, hclassid, duration, avgvalue, minvalue, maxvalue, sumvalue, sumquadvalue, cumsumvalue,

      countgood, countwarn, countpoor, counterror, countvalue, weight, wavgvalue) select objid, ts, tzoffset, dclassid, pclassid, hclassid, duration, avgvalue, minvalue, max

      value, sumvalue, sumquadvalue, cumsumvalue, countgood, countwarn, countpoor, counterror, countvalue, weight, wavgvalue from ENT_DATA_GTT s where not exists (select null

      from SYS_DATA_D_3 d where s.objid=d.sysobjid and s.ts=d.ts  and s.dclassid=d.dclassid and d.pclassid=s.pclassid and d.ts>=to_date('2019-08-11 01:00:00','yyyy-mm-dd hh2

      4:mi:ss') and d.ts<to_date('2019-09-13 00:00:00','yyyy-mm-dd hh24:mi:ss'))

      POSTGRES sql-code  : insert into SYS_DATA_D_3 (sysobjid, ts, tzoffset, dclassid, pclassid, hclassid, duration, avgvalue, minvalue, maxvalue, sumvalue, sumquadvalue, cum

      sumvalue, countgood, countwarn, countpoor, counterror, countvalue, weight, wavgvalue) select objid, ts, tzoffset, dclassid, pclassid, hclassid, duration, avgvalue, minv

      alue, maxvalue, sumvalue, sumquadvalue, cumsumvalue, countgood, countwarn, countpoor, counterror, countvalue, weight, wavgvalue from ENT_DATA_GTT s where not exists (se

      lect null from SYS_DATA_D_3 d where s.objid=d.sysobjid and s.ts=d.ts  and s.dclassid=d.dclassid and d.pclassid=s.pclassid and d.ts>='2019-08-11 01:00:00'::timestamp(0)

      and d.ts<'2019-09-13 00:00:00'::timestamp(0))

              at com.neptuny.cpit.querymanager.QueryManager.executeDynamicQuery(QueryManager.java:197)

              at com.neptuny.cpit.querymanager.QueryManager.executeDynamicQuery(QueryManager.java:128)

              at com.neptuny.cpit.querymanager.QueryManager.executeDynamicQuery(QueryManager.java:120)

              at com.neptuny.cpit.warehouse.AbstractThread.mergeFromEntDataGTT(AbstractThread.java:1019)

              at com.neptuny.cpit.warehouse.ReduceThread.doReduce(ReduceThread.java:547)

              at com.neptuny.cpit.warehouse.ReduceThread.doReduceD(ReduceThread.java:575)

              at com.neptuny.cpit.warehouse.ReduceThread.doReduce(ReduceThread.java:563)

              at com.neptuny.cpit.warehouse.ReduceThread.reduce(ReduceThread.java:114)

              at com.neptuny.cpit.warehouse.ReduceThread.doExecution(ReduceThread.java:84)

              at com.neptuny.cpit.warehouse.AbstractThread.runImpl(AbstractThread.java:225)

              at com.neptuny.cpit.warehouse.AbstractThread.run(AbstractThread.java:178)

              at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)

              at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)

              at java.lang.Thread.run(Thread.java:748)

      Caused by: org.postgresql.util.PSQLException: ERROR: llave duplicada viola restricción de unicidad «sys_data_d_3_p_20190901_pkey»

        Detail: Ya existe la llave (sysobjid, ts, dclassid, pclassid)=(1020400, 2019-08-11 00:00:00, 3, 0).

        Where: sentencia SQL: «insert into partitions.sys_data_d_3_p_20190901 values (new.*)»

      función PL/pgSQL sys_data_d_3_trg_ins() en la línea 8 en sentencia SQL

              at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2182)

              at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1911)

              at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:173)

              at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:645)

              at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:481)

              at org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:409)

              at org.apache.tomcat.dbcp.dbcp2.DelegatingStatement.executeUpdate(DelegatingStatement.java:237)

              at org.apache.tomcat.dbcp.dbcp2.DelegatingStatement.executeUpdate(DelegatingStatement.java:237)

              at org.apache.tomcat.dbcp.dbcp2.DelegatingStatement.executeUpdate(DelegatingStatement.java:237)

              at com.neptuny.cpit.querymanager.MyPreparedStatement.execute(MyPreparedStatement.java:109)

              at com.neptuny.cpit.querymanager.MyPreparedStatement.doExecuteDynamicQuery(MyPreparedStatement.java:42)

              at com.neptuny.cpit.querymanager.MyAbstractStatement.executeDynamicQuery(MyAbstractStatement.java:873)

              at com.neptuny.cpit.querymanager.QueryManager.executeDynamicQuery(QueryManager.java:172)

              ... 13 more