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

#1163 closed defect (fixed)

Error insertando resultados con MmsDatabase

Reported by: josp Owned by: Chakib Faghloumi
Priority: critical Milestone: Maintenance
Component: MmsDatabase Keywords:
Cc: aberzosa, Pedro Gea

Description

Nos falla la inserción de una estimación, el siguiente es el mensaje de error:

ERROR: [3] La consulta SQL ha fallado:
Insert Into mms_f_submodelc_r_series ( id_object, co_submodel, dt_series, vl_observations, vl_output,  vl_interruptions, vl_additive_filter, vl_filter, vl_noise,  vl_dif_noise, vl_residuals, vl_std_residuals, vl_prediction, vl_obs_prediction)
Values ( 179, 'Sucursal', to_timestamp('2011/01/03', 'YYYY/MM/DD'), 1016.00000, 6.92461, NULL::float8, 0.00000, 0.03361, 6.89100, NULL::float8, -0.09828, -1.27550, 7.02289, 1121.02250 ) , 
( 179, 'Sucursal', to_timestamp('2011/01/04', 'YYYY/MM/DD'), 926.00000, 6.83195, NULL::float8, 0.00000, -0.02404, 6.85600, NULL::float8, -0.04712, -0.61151, 6.87907, 970.72214 ) , 
( 179, 'Sucursal', to_timestamp('2011/01/05', 'YYYY/MM/DD'), 801.00000, 6.68711, NULL::float8, 0.00000, -0.00525, 6.69236, NULL::float8, -0.15060, -1.95461, 6.83771, 931.35004 ) , 
( 179, 'Sucursal', to_timestamp('2011/01/06', 'YYYY/MM/DD'), 897.00000, 6.80017, NULL::float8, 0.00000, -0.00280, 6.80297, NULL::float8, -0.01271, -0.16494, 6.81288, 908.48466 ) , 
( 179, 'Sucursal', to_timestamp('2011/01/07', 'YYYY/MM/DD'), 1005.00000, 6.91374, NULL::float8, 0.00000, -0.00021, 6.91394, NULL::float8, -0.04884, -0.63387, 6.96258, 1055.35133 ) , 
( 179, 'Sucursal', to_timestamp('2011/01/10', 'YYYY/MM/DD'), 1121.00000, 7.02287, NULL::float8, 0.00000, 0.00247, 7.02040, 0.12940, 0.07855, 1.01952, 6.94432, 1036.23713 ) , 

Change History (2)

comment:1 Changed 11 years ago by Chakib Faghloumi

(In [4661]) Refs #1163
se añade la condición de que si el estadistico es infinito no lo inserta

comment:2 Changed 11 years ago by Pedro Gea

Component: PersistenceMmsDatabase
Resolution: fixed
Status: newclosed
Note: See TracTickets for help on using tickets.