close Warning: Can't synchronize with repository "(default)" (/var/svn/mms does not appear to be a Subversion repository.). Look in the Trac log for more information.

Opened 11 years ago

Closed 11 years ago

#1154 closed defect (fixed)

Error al insertar en MmsDatabase

Reported by: josp Owned by: Chakib Faghloumi
Priority: critical Milestone: Maintenance
Component: MmsDatabase Keywords:
Cc:

Description

Estamos obteniendo este error al insertar resultados en la base de datos:

ERROR: [1] La consulta SQL ha fallado:
Insert Into mms_f_submodel_r_statistic (id_object,  co_submodel, co_statistic, vl_statistic)
Values ( 3.00000, 'sCluster1', 'Residuals.Mean', NULL::float8 )  ,
( 3.00000, 'sCluster1', 'Residuals.Sigma', NULL::float8 )  ,
( 3.00000, 'sCluster1', 'Residuals.Max', NULL::float8 )  ,
( 3.00000, 'sCluster1', 'Residuals.Min', NULL::float8 )  ,
( 3.00000, 'sCluster1', 'Residuals.Kurtosis', NULL::float8 )  ,
( 3.00000, 'sCluster1', 'Residuals.Asymmetry', NULL::float8 )  ,
( 3.00000, 'sCluster1', 'MAPE', NULL::float8 )  ,
( 3.00000, 'sCluster2', 'Residuals.Mean', -0.03368 )  ,
( 3.00000, 'sCluster2', 'Residuals.Sigma', 17.93343 )  ,
( 3.00000, 'sCluster2', 'Residuals.Max', 344.15383 )  ,
( 3.00000, 'sCluster2', 'Residuals.Min', -167.78493 )  ,
( 3.00000, 'sCluster2', 'Residuals.Kurtosis', 232.98467 )  ,
( 3.00000, 'sCluster2', 'Residuals.Asymmetry', 11.04373 )  ,
( 3.00000, 'sCluster2', 'MAPE', 8952918442761422085420338080681620440410440937594086790549391540224000.00000 )  ,
( 3.00000, 'sCluster3.1', 'Residuals.Mean', NULL::float8 )  ,
( 3.00000, 'sCluster3.1', 'Residuals.Sigma', NULL::float8 )  ,
( 3.00000, 'sCluster3.1', 'Residuals.Max', NULL::float8 )  ,
( 3.00000, 'sCluster3.1', 'Residuals.Min', NULL::float8 )  ,
( 3.00000, 'sCluster3.1', 'Residuals.Kurtosis', NULL::float8 )  ,
( 3.00000, 'sCluster3.1', 'Residuals.Asymmetry', NULL::float8 )  ,
( 3.00000, 'sCluster3.1', 'MAPE', NULL::float8 )  ,
( 3.00000, 'sCluster3.2', 'Residuals.Mean', NULL::float8 )  ,
( 3.00000, 'sCluster3.2', 'Residuals.Sigma', NULL::float8 )  ,
( 3.00000, 'sCluster3.2', 'Residuals.Max', NULL::float8 )  ,
( 3.00000, 'sCluster3.2', 'Residuals.Min', NULL::float8 )  ,
( 3.00000, 'sCluster3.2', 'Residuals.Kurtosis', NULL::float8 )  ,
( 3.00000, 'sCluster3.2', 'Residuals.Asymmetry', NULL::float8 )  ,
( 3.00000, 'sCluster3.2', 'MAPE', NULL::float8 )  ,
( 3.00000, 'sCluster3.2_city', 'Residuals.Mean', NULL::float8 )  ,
( 3.00000, 'sCluster3.2_city', 'Residuals.Sigma', NULL::float8 )  ,
( 3.00000, 'sCluster3.2_city', 'Residuals.Max', NULL::float8 )  ,
( 3.00000, 'sCluster3.2_city', 'Residuals.Min', NULL::float8 )  ,
( 3.00000, 'sCluster3.2_city', 'Residuals.Kurtosis', NULL::float8 )  ,
( 3.00000, 'sCluster3.2_city', 'Residuals.Asymmetry', NULL::float8 )  ,
( 3.00000, 'sCluster3.2_city', 'MAPE', NULL::float8 )

Change History (4)

comment:1 Changed 11 years ago by Chakib Faghloumi

El campo vl_statistic de la tabla mms_f_submodel_r_statistic no admite Null.

comment:2 Changed 11 years ago by Chakib Faghloumi

(In [4653]) Refs #1154
Poner id_object como Integer
y organizar las funciones Sql

comment:3 Changed 11 years ago by Chakib Faghloumi

(In [4654]) Refs #1154
genera version 9

comment:4 Changed 11 years ago by Chakib Faghloumi

Resolution: → fixed
Status: new → closed
Note: See TracTickets for help on using tickets.