awips2 icon indicating copy to clipboard operation
awips2 copied to clipboard

Ingest.bufrssmi BatchingBatch: HHH000315: Exception executing batch [could not execute batch]

Open mjames-upc opened this issue 9 years ago • 1 comments

ERROR 2015-10-05 19:36:28,264 [Ingest.bufrssmi-1] BatchingBatch: HHH000315: Exception executing batch [could not execute batch] ERROR 2015-10-05 19:36:28,278 [Ingest.bufrssmi-1] SqlExceptionHelper: Batch entry 0 insert into bufrssmi (forecastTime, refTime, utilityFlags, rangeEnd, rangeStart, insertTime, elevation, latitude, location, locationDefined, longitude, stationId, idx, satId, timeObs, wmoHeader, id) values (0, '2015-10-05 00:00:28.000000 +00:00:00', '[]', '2015-10-05 00:00:28.000000 +00:00:00', '2015-10-05 00:00:28.000000 +00:00:00', '2015-10-05 19:36:19.261000 +00:00:00', NULL, 47.85, 'POINT(-149.25999450683594 47.849998474121094)', '0', -149.26, '-149.26:47.85', 65121, 248, '2015-10-05 00:00:28.000000 +00:00:00', 'ISXA29 KWNO 051900', 2958066) was aborted. Call getNextException to see the cause. ERROR 2015-10-05 19:36:28,278 [Ingest.bufrssmi-1] SqlExceptionHelper: ERROR: duplicate key value violates unique constraint "uk_jd9b0c5ne0a96nvudofq0m6at" Detail: Key (stationid, reftime, satid, latitude, longitude)=(-149.26:47.85, 2015-10-05 00:00:28, 248, 47.8499985, -149.259995) already exists.

mjames-upc avatar Oct 05 '15 19:10 mjames-upc

INFO 2015-10-05 19:33:00,680 [Ingest.bufrssmi-1] SSMIDecoder: null - Document size = 3 INFO 2015-10-05 19:33:00,680 [Ingest.bufrssmi-1] SSMIDecoder: null - Entering createDataList INFO 2015-10-05 19:33:00,681 [Ingest.bufrssmi-1] SSMIDataAdapter: getHeaderData(248,81730,1345)2015-10-05 01:20:55.0 INFO 2015-10-05 19:33:00,681 [Ingest.bufrssmi-1] SSMIDataAdapter: Decoding 64 observations INFO 2015-10-05 19:33:00,687 [Ingest.bufrssmi-1] SSMIDecoder: null - Entering createDataList INFO 2015-10-05 19:33:00,687 [Ingest.bufrssmi-1] SSMIDataAdapter: getHeaderData(248,81730,1346)2015-10-05 01:20:59.0 INFO 2015-10-05 19:33:00,687 [Ingest.bufrssmi-1] SSMIDataAdapter: Decoding 64 observations INFO 2015-10-05 19:33:00,691 [Ingest.bufrssmi-1] SSMIDecoder: null - Entering createDataList INFO 2015-10-05 19:33:00,691 [Ingest.bufrssmi-1] SSMIDataAdapter: getHeaderData(248,81730,1347)2015-10-05 01:21:02.0 INFO 2015-10-05 19:33:00,691 [Ingest.bufrssmi-1] SSMIDataAdapter: Decoding 64 observations INFO 2015-10-05 19:33:00,694 [Ingest.bufrssmi-1] SSMIDecoder: null - Decoded 192 obs INFO 2015-10-05 19:33:00,695 [Ingest.bufrssmi-1] Ingest: EDEX: Ingest - bufrssmi:: /awips2/data_store/bufrssmi/ISXA26_KWNO_051900_656494919.bufr.2015100519 processed in: 0.0210 (sec) Latency: 126.1380 (sec)

mjames-upc avatar Oct 05 '15 19:10 mjames-upc