Opened 12 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 12 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.
![(please configure the [header_logo] section in trac.ini)](/mms/chrome/site/logomms.png)
(In [4661]) Refs #1163
se añade la condición de que si el estadistico es infinito no lo inserta