๐Ÿ“œ qp-gis-tmc-septage

โ† Back
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       =[NRM86633407037883701L1150526195638008.458459N076.936485E404x195084000006da7018.48147.1615011811M0001.8000Idea]
LAT_STR   =[008.458459]
LON_STR   =[076.936485]
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       =[NRM86056006909498701L1150526195637008.483123N076.911980E404x723635000005086000.00120.0045003101S7.77600IdeaXX]
LAT_STR   =[008.483123]
LON_STR   =[076.911980]
๐Ÿงท Stuck GPS rejected | IMEI=860560069094987 lat=8.483123 lon=76.91198 count=21
RAW       =[NRM86056006909498701L1150526195637008.483123N076.911980E404x723635000005086000.00120.0045003101S7.77600IdeaXX]
LAT_STR   =[008.483123]
LON_STR   =[076.911980]
๐Ÿงท Stuck GPS rejected | IMEI=860560069094987 lat=8.483123 lon=76.91198 count=22
RAW       =[NRM86256707246826201L1150526195717008.306461N077.223968E404x43A44D000016043031.00095.1134002311M]
LAT_STR   =[008.306461]
LON_STR   =[077.223968]
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       =[NRM86256707168297001L1150526195716008.480762N076.953979E4040720974000004F40000.00161.3628002301S]
LAT_STR   =[008.480762]
LON_STR   =[076.953979]
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       =[NRM86056006764166401L1150526195711008.893322N076.575686E404x95B798000032981000.00088.3801002301S]
LAT_STR   =[008.893322]
LON_STR   =[076.575686]
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:23.010Z  WARN 1 --- [quickpass-gis] [nio-8080-exec-1] .w.s.m.s.DefaultHandlerExceptionResolver : Resolved [org.springframework.web.bind.MissingServletRequestParameterException: Required request parameter 'vltdata' for method parameter type String is not present]
RAW       =[BTH86256707253913801001L1150526195723011.196053N076.234260E404x1958C3000062933036.00287.5432002111M02H1150526195056011.191205N076.256675E404x1958C1000018111022.00253.2836001911M02H1150526195037011.191198N076.257461E404x1958C1000018111022.00278.1332002411M02H1150526195028011.190884N076.257965E404x1958C1000018111024.00306.1935002411M02H1150526195008011.190491N076.258720E404x1958C1000018111007.00290.7535002211M02H1150526194948011.190291N076.259178E404x1958C1000062573014.00290.8334001811M02H1150526194928011.190142N076.259506E404x1958C1000062573003.00291.6736002111M02H1150526194908011.190089N076.259796E404x1958C1000062573005.00290.8535002011M02H1150526194848011.190043N076.260002E404x1958C1000062573002.00290.8534001911M02H1150526194828011.190004N076.260131E404x1958C1000062573002.00286.3637001911M]
LAT_STR   =[723011.196]
LON_STR   =[53N076.234]
RAW       =[NRM86256707479800501L1150526195641008.459558N076.935699E404x195084000039683016.00324.8646001511M]
LAT_STR   =[008.459558]
LON_STR   =[076.935699]
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       =[NRM86256707811844001L1150526195549010.384080N076.142396E4040951234000004E73000.00209.4136001701S0007.09AIRTEL]
LAT_STR   =[010.384080]
LON_STR   =[076.142396]
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       =[BTH86056006000944800201L1150526195640008.448856N076.952015E404x19508d000031121000.00333.2044101901S0005.96IDEAXX02H1150526195541008.448856N076.952015E404x19508d000031121000.00333.2043102201S0005.96IDEAXX]
LAT_STR   =[640008.448]
LON_STR   =[56N076.952]
RAW       =[NRM86256707804617901L1150526195638008.522637N076.960605E404095123400000E377000.00184.8935003011M0044.64AIRTEL]
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       =[NRM86633407359288901L1150526195725011.216675N078.148918E404x43B79B000043033000.00174.4143002801S]
LAT_STR   =[011.216675]
LON_STR   =[078.148918]
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:28.613Z  WARN 1 --- [quickpass-gis] [nio-8080-exec-5] .w.s.m.s.DefaultHandlerExceptionResolver : Resolved [org.springframework.web.bind.MissingServletRequestParameterException: Required request parameter 'vltdata' for method parameter type String is not present]
RAW       =[NRM86633407037883701L1150526195651008.457993N076.936813E404x195084000006da7009.54109.4215012311M0001.8600Idea]
LAT_STR   =[008.457993]
LON_STR   =[076.936813]
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       =[NRM86633407037883701L1150526195653008.457991N076.936859E404x195084000006da7009.91069.6915012311M0001.8400Idea]
LAT_STR   =[008.457991]
LON_STR   =[076.936859]
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       =[NRM86056006801358201L1150526195513008.460053N076.935356E404x197597000005084007.36181.0046001711M0000.20Vodafo]
LAT_STR   =[008.460053]
LON_STR   =[076.935356]
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       =[CRT86256707254050816L1150526195731010.075342N076.267326E404x194FBA000030022000.00006.4234001811M]
LAT_STR   =[010.075342]
LON_STR   =[076.267326]