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
comment:2 Changed 11 years ago by
Component: | Persistence → MmsDatabase |
---|---|
Resolution: | → fixed |
Status: | new → closed |
Note: See
TracTickets for help on using
tickets.
(In [4661]) Refs #1163
se añade la condición de que si el estadistico es infinito no lo inserta