getting error with MS-SQL

Prince Rajput2 years ago

hello Developers,

i am getting following error while saving data in database..
how can i fix or for which column datatype error is it ?

2022-12-01 06:09:53  INFO: [2d7a78a9: gt06 > 223.180.224.200] HEX: 78780501058657d30d0a
2022-12-01 06:09:53  WARN: Event save error - Arithmetic overflow error converting IDENTITY to data type int. - SQLServerException (... < QueryBuilder:446 < DataManager:425 < NotificationManager:68 < ...)
2022-12-01 06:09:53  INFO: [3d8dd3a9] id: 862874040036514, time: 2022-12-01 06:05:31, lat: 20.32805, lon: 74.23924, course: 278.0
2022-12-01 06:09:53  INFO: [3d8dd3a9: gt06 > 223.180.224.159] HEX: 787805220917972c0d0a
2022-12-01 06:09:54  WARN: Event save error - Arithmetic overflow error converting IDENTITY to data type int. - SQLServerException (... < QueryBuilder:446 < DataManager:425 < NotificationManager:68 < ...)
2022-12-01 06:09:54  WARN: Failed to store position - The statement must be executed before any results can be obtained. - SQLServerException (... < QueryBuilder:448 < DataManager:425 < DefaultDataHandler:40 < ...)
2022-12-01 06:09:54  INFO: [6edbfa6c: gt06 < 223.180.224.165] HEX: 78781f12160c0106022bce01fae28d07ee60cd00151701945a13fe005cec02c229750d0a78782516160c0106022bce01fae28d07ee60cd0015170901945a13fe005cec450604ff0202c3efd10d0a78780d01086001602282390502c4cc960d0a78781f12160c01060132d201fae01707ee6c960b156601945a13fe005cec02c563330d0a78781f12160c01060138d201fae0e507ee6c4d05154201945a13fe005cec02c6731a0d0a
2022-12-01 06:09:54  INFO: [6edbfa6c: gt06 > 223.180.224.165] HEX: 7878050102c47bcd0d0a
2022-12-01 06:09:54  INFO: [baa53345] id: 860016021750471, time: 2022-12-01 06:07:00, lat: 24.49420, lon: 86.66289, speed: 8.1, course: 132.0
2022-12-01 06:09:54  INFO: [baa53345: gt06 > 223.180.224.160] HEX: 787805129af6d4300d0a
2022-12-01 06:09:54  WARN: Event save error - Arithmetic overflow error converting IDENTITY to data type int. - SQLServerException (... < QueryBuilder:446 < DataManager:425 < NotificationManager:68 < ...)
2022-12-01 06:09:54  WARN: Failed to store position - The statement must be executed before any results can be obtained. - SQLServerException (... < QueryBuilder:448 < DataManager:425 < DefaultDataHandler:40 < ...)
Anton Tananaev2 years ago

Looks like event id overflow.

mahmoud Yehia6 months ago

how did you solve this issue?