๐Ÿ“œ qp-gis-tmc-water

โ† Back
LAT_STR   =[008.522637]
LON_STR   =[076.960605]
Hibernate: insert into gps_data (created_at,header,imei,latitude,longitude,timestamp,vltdata) values (?,?,?,?,?,?,?)
Hibernate: select ii1_0.imei,ii1_0.created_at,ii1_0.header,ii1_0.latitude,ii1_0.longitude,ii1_0.timestamp,ii1_0.updated_at,ii1_0.vltdata from imei_info ii1_0 where ii1_0.imei=?
Hibernate: select ii1_0.imei,ii1_0.created_at,ii1_0.header,ii1_0.latitude,ii1_0.longitude,ii1_0.timestamp,ii1_0.updated_at,ii1_0.vltdata from imei_info ii1_0 where ii1_0.imei=?
Hibernate: update imei_info set header=?,latitude=?,longitude=?,timestamp=?,updated_at=?,vltdata=? where imei=?
RAW       =[NRM86633407976876401L1150526195647009.538151N076.513648E404095123400000F2F0000.00293.2736001801S0006.90AIRTEL]
LAT_STR   =[009.538151]
LON_STR   =[076.513648]
Hibernate: insert into gps_data (created_at,header,imei,latitude,longitude,timestamp,vltdata) values (?,?,?,?,?,?,?)
Hibernate: select ii1_0.imei,ii1_0.created_at,ii1_0.header,ii1_0.latitude,ii1_0.longitude,ii1_0.timestamp,ii1_0.updated_at,ii1_0.vltdata from imei_info ii1_0 where ii1_0.imei=?
Hibernate: select ii1_0.imei,ii1_0.created_at,ii1_0.header,ii1_0.latitude,ii1_0.longitude,ii1_0.timestamp,ii1_0.updated_at,ii1_0.vltdata from imei_info ii1_0 where ii1_0.imei=?
Hibernate: update imei_info set header=?,latitude=?,longitude=?,timestamp=?,updated_at=?,vltdata=? where imei=?
RAW       =[NRM86832908270282401L1150526195649008.511955N076.985693E404x1975A1000005091000.00103.0040001901S0030.34Vodafo]
LAT_STR   =[008.511955]
LON_STR   =[076.985693]
Hibernate: insert into gps_data (created_at,header,imei,latitude,longitude,timestamp,vltdata) values (?,?,?,?,?,?,?)
Hibernate: select ii1_0.imei,ii1_0.created_at,ii1_0.header,ii1_0.latitude,ii1_0.longitude,ii1_0.timestamp,ii1_0.updated_at,ii1_0.vltdata from imei_info ii1_0 where ii1_0.imei=?
Hibernate: select ii1_0.imei,ii1_0.created_at,ii1_0.header,ii1_0.latitude,ii1_0.longitude,ii1_0.timestamp,ii1_0.updated_at,ii1_0.vltdata from imei_info ii1_0 where ii1_0.imei=?
Hibernate: update imei_info set header=?,latitude=?,longitude=?,timestamp=?,updated_at=?,vltdata=? where imei=?
RAW       =[NRM86418006885748616L1150526195752008.511654N076.988228E404019509100000799B000.00173.0430001401S]
LAT_STR   =[008.511654]
LON_STR   =[076.988228]
Hibernate: insert into gps_data (created_at,header,imei,latitude,longitude,timestamp,vltdata) values (?,?,?,?,?,?,?)
Hibernate: select ii1_0.imei,ii1_0.created_at,ii1_0.header,ii1_0.latitude,ii1_0.longitude,ii1_0.timestamp,ii1_0.updated_at,ii1_0.vltdata from imei_info ii1_0 where ii1_0.imei=?
Hibernate: select ii1_0.imei,ii1_0.created_at,ii1_0.header,ii1_0.latitude,ii1_0.longitude,ii1_0.timestamp,ii1_0.updated_at,ii1_0.vltdata from imei_info ii1_0 where ii1_0.imei=?
Hibernate: update imei_info set header=?,latitude=?,longitude=?,timestamp=?,updated_at=?,vltdata=? where imei=?
RAW       =[NRM86056006978852101L1150526195714008.573566N076.924698E404095123400000421B006.96196.0934002211M]
LAT_STR   =[008.573566]
LON_STR   =[076.924698]
Hibernate: insert into gps_data (created_at,header,imei,latitude,longitude,timestamp,vltdata) values (?,?,?,?,?,?,?)
Hibernate: select ii1_0.imei,ii1_0.created_at,ii1_0.header,ii1_0.latitude,ii1_0.longitude,ii1_0.timestamp,ii1_0.updated_at,ii1_0.vltdata from imei_info ii1_0 where ii1_0.imei=?
Hibernate: select ii1_0.imei,ii1_0.created_at,ii1_0.header,ii1_0.latitude,ii1_0.longitude,ii1_0.timestamp,ii1_0.updated_at,ii1_0.vltdata from imei_info ii1_0 where ii1_0.imei=?
Hibernate: update imei_info set header=?,latitude=?,longitude=?,timestamp=?,updated_at=?,vltdata=? where imei=?
RAW       =[NRM86249305934086302H1150526195507008.500581N076.967918E404072091000000C3E2034.85241.7739001811M]
LAT_STR   =[008.500581]
LON_STR   =[076.967918]
Hibernate: insert into gps_data (created_at,header,imei,latitude,longitude,timestamp,vltdata) values (?,?,?,?,?,?,?)
Hibernate: select ii1_0.imei,ii1_0.created_at,ii1_0.header,ii1_0.latitude,ii1_0.longitude,ii1_0.timestamp,ii1_0.updated_at,ii1_0.vltdata from imei_info ii1_0 where ii1_0.imei=?
Hibernate: select ii1_0.imei,ii1_0.created_at,ii1_0.header,ii1_0.latitude,ii1_0.longitude,ii1_0.timestamp,ii1_0.updated_at,ii1_0.vltdata from imei_info ii1_0 where ii1_0.imei=?
Hibernate: update imei_info set header=?,latitude=?,longitude=?,timestamp=?,updated_at=?,vltdata=? where imei=?
RAW       =[NRM86256707168269901L1150526195802008.375303N076.996086E40409512340000007B3006.76146.0641003111M]
LAT_STR   =[008.375303]
LON_STR   =[076.996086]
Hibernate: insert into gps_data (created_at,header,imei,latitude,longitude,timestamp,vltdata) values (?,?,?,?,?,?,?)
Hibernate: select ii1_0.imei,ii1_0.created_at,ii1_0.header,ii1_0.latitude,ii1_0.longitude,ii1_0.timestamp,ii1_0.updated_at,ii1_0.vltdata from imei_info ii1_0 where ii1_0.imei=?
Hibernate: select ii1_0.imei,ii1_0.created_at,ii1_0.header,ii1_0.latitude,ii1_0.longitude,ii1_0.timestamp,ii1_0.updated_at,ii1_0.vltdata from imei_info ii1_0 where ii1_0.imei=?
Hibernate: update imei_info set header=?,latitude=?,longitude=?,timestamp=?,updated_at=?,vltdata=? where imei=?
2026-05-15T14:27:29.652Z  WARN 1 --- [quickpass-gis] [nio-8080-exec-3] .w.s.m.s.DefaultHandlerExceptionResolver : Resolved [org.springframework.web.bind.MissingServletRequestParameterException: Required request parameter 'vltdata' for method parameter type String is not present]
RAW       =[NRM86647706489832601L1150526195727008.575273N077.018249E404095f424000048733000.00327.2523002601M]
LAT_STR   =[008.575273]
LON_STR   =[077.018249]
Hibernate: insert into gps_data (created_at,header,imei,latitude,longitude,timestamp,vltdata) values (?,?,?,?,?,?,?)
Hibernate: select ii1_0.imei,ii1_0.created_at,ii1_0.header,ii1_0.latitude,ii1_0.longitude,ii1_0.timestamp,ii1_0.updated_at,ii1_0.vltdata from imei_info ii1_0 where ii1_0.imei=?
Hibernate: select ii1_0.imei,ii1_0.created_at,ii1_0.header,ii1_0.latitude,ii1_0.longitude,ii1_0.timestamp,ii1_0.updated_at,ii1_0.vltdata from imei_info ii1_0 where ii1_0.imei=?
Hibernate: update imei_info set header=?,latitude=?,longitude=?,timestamp=?,updated_at=?,vltdata=? where imei=?
Hibernate: select mii1_0.mobile_imei,mii1_0.accuracy,mii1_0.created_at,mii1_0.device_id,mii1_0.latitude,mii1_0.longitude,mii1_0.raw_data,mii1_0.received_on,mii1_0.timestamp,mii1_0.token,mii1_0.updated_at from mobile_imei_info mii1_0 where mii1_0.token=? and mii1_0.mobile_imei in (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)
Hibernate: select ii1_0.imei,ii1_0.created_at,ii1_0.header,ii1_0.latitude,ii1_0.longitude,ii1_0.timestamp,ii1_0.updated_at,ii1_0.vltdata from imei_info ii1_0 where ii1_0.imei in (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)
RAW       =[NRM86500604177476201L1150526195632008.534563N076.882562E404095123400000B98E004.00332.0444002711M0008.59AIRTEL]
LAT_STR   =[008.534563]
LON_STR   =[076.882562]
Hibernate: insert into gps_data (created_at,header,imei,latitude,longitude,timestamp,vltdata) values (?,?,?,?,?,?,?)
Hibernate: select ii1_0.imei,ii1_0.created_at,ii1_0.header,ii1_0.latitude,ii1_0.longitude,ii1_0.timestamp,ii1_0.updated_at,ii1_0.vltdata from imei_info ii1_0 where ii1_0.imei=?
Hibernate: select ii1_0.imei,ii1_0.created_at,ii1_0.header,ii1_0.latitude,ii1_0.longitude,ii1_0.timestamp,ii1_0.updated_at,ii1_0.vltdata from imei_info ii1_0 where ii1_0.imei=?
Hibernate: update imei_info set header=?,latitude=?,longitude=?,timestamp=?,updated_at=?,vltdata=? where imei=?
RAW       =[NRM86249305934086301L1150526195720008.495731N076.964485E404072091000000C3E2000.00181.7144002111M]
LAT_STR   =[008.495731]
LON_STR   =[076.964485]
Hibernate: insert into gps_data (created_at,header,imei,latitude,longitude,timestamp,vltdata) values (?,?,?,?,?,?,?)
Hibernate: select ii1_0.imei,ii1_0.created_at,ii1_0.header,ii1_0.latitude,ii1_0.longitude,ii1_0.timestamp,ii1_0.updated_at,ii1_0.vltdata from imei_info ii1_0 where ii1_0.imei=?
Hibernate: select ii1_0.imei,ii1_0.created_at,ii1_0.header,ii1_0.latitude,ii1_0.longitude,ii1_0.timestamp,ii1_0.updated_at,ii1_0.vltdata from imei_info ii1_0 where ii1_0.imei=?
Hibernate: update imei_info set header=?,latitude=?,longitude=?,timestamp=?,updated_at=?,vltdata=? where imei=?
RAW       =[NRM86056006582201901L1150526195613008.563466N076.949463E404x195086000034432000.00265.5002001501S]
LAT_STR   =[008.563466]
LON_STR   =[076.949463]
Hibernate: insert into gps_data (created_at,header,imei,latitude,longitude,timestamp,vltdata) values (?,?,?,?,?,?,?)
Hibernate: select ii1_0.imei,ii1_0.created_at,ii1_0.header,ii1_0.latitude,ii1_0.longitude,ii1_0.timestamp,ii1_0.updated_at,ii1_0.vltdata from imei_info ii1_0 where ii1_0.imei=?
Hibernate: select ii1_0.imei,ii1_0.created_at,ii1_0.header,ii1_0.latitude,ii1_0.longitude,ii1_0.timestamp,ii1_0.updated_at,ii1_0.vltdata from imei_info ii1_0 where ii1_0.imei=?
Hibernate: update imei_info set header=?,latitude=?,longitude=?,timestamp=?,updated_at=?,vltdata=? where imei=?
RAW       =[NRM86281804385603001L1150526195730008.512503N076.987915E4040720910000050148000.10000.0012002501S]
LAT_STR   =[008.512503]
LON_STR   =[076.987915]
Hibernate: insert into gps_data (created_at,header,imei,latitude,longitude,timestamp,vltdata) values (?,?,?,?,?,?,?)
Hibernate: select ii1_0.imei,ii1_0.created_at,ii1_0.header,ii1_0.latitude,ii1_0.longitude,ii1_0.timestamp,ii1_0.updated_at,ii1_0.vltdata from imei_info ii1_0 where ii1_0.imei=?
Hibernate: select ii1_0.imei,ii1_0.created_at,ii1_0.header,ii1_0.latitude,ii1_0.longitude,ii1_0.timestamp,ii1_0.updated_at,ii1_0.vltdata from imei_info ii1_0 where ii1_0.imei=?
Hibernate: update imei_info set header=?,latitude=?,longitude=?,timestamp=?,updated_at=?,vltdata=? where imei=?
RAW       =[NRM86065705640500010L1150526195708008.481805N076.955780E4040720974000004F3F000.00275.6143002101S]
LAT_STR   =[008.481805]
LON_STR   =[076.955780]
๐Ÿงท Stuck GPS rejected | IMEI=860657056405000 lat=8.481805 lon=76.95578 count=21
RAW       =[NRM86633407205301601L1150526195655008.511500N076.988304E404072091000000C3E4000.00319.6633001911S]
LAT_STR   =[008.511500]
LON_STR   =[076.988304]
Hibernate: insert into gps_data (created_at,header,imei,latitude,longitude,timestamp,vltdata) values (?,?,?,?,?,?,?)
Hibernate: select ii1_0.imei,ii1_0.created_at,ii1_0.header,ii1_0.latitude,ii1_0.longitude,ii1_0.timestamp,ii1_0.updated_at,ii1_0.vltdata from imei_info ii1_0 where ii1_0.imei=?
Hibernate: select ii1_0.imei,ii1_0.created_at,ii1_0.header,ii1_0.latitude,ii1_0.longitude,ii1_0.timestamp,ii1_0.updated_at,ii1_0.vltdata from imei_info ii1_0 where ii1_0.imei=?
Hibernate: update imei_info set header=?,latitude=?,longitude=?,timestamp=?,updated_at=?,vltdata=? where imei=?
RAW       =[ALT86065705864918304L1150526195706008.511616N076.988236E404x720910000050146000.00168.0907001511S]
LAT_STR   =[008.511616]
LON_STR   =[076.988236]