Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

some air_util_tx out of range for database schema #37

Open
fifieldt opened this issue May 27, 2024 · 0 comments
Open

some air_util_tx out of range for database schema #37

fifieldt opened this issue May 27, 2024 · 0 comments

Comments

@fifieldt
Copy link
Contributor

fifieldt commented May 27, 2024

Received the error below:

PrismaClientKnownRequestError: 
Invalid `prisma.deviceMetric.create()` invocation in
src/mqtt.js:544:51

  541 
  542 // create metric if no duplicates found
  543 if(!existingDuplicateDeviceMetric){
→ 544     await prisma.deviceMetric.create(
Value out of range for the type. Out of range value for column 'air_util_tx' at row 1
    at In.handleRequestError (node_modules/@prisma/client/runtime/library.js:122:6854)
    at In.handleAndLogRequestError (node_modules/@prisma/client/runtime/library.js:122:6188)
    at In.request (node_modules/@prisma/client/runtime/library.js:122:5896)
    at async l (node_modules/@prisma/client/runtime/library.js:127:10871)
    at async MqttClient.<anonymous> (src/mqtt.js:544:25) {
  code: 'P2020',
  clientVersion: '5.11.0',
  meta: {
    modelName: 'DeviceMetric',
    details: "Out of range value for column 'air_util_tx' at row 1"
  }
}
PrismaClientKnownRequestError: 
Invalid `prisma.node.updateMany()` invocation in
src/mqtt.js:564:39

  561 // update node telemetry in db
  562 if(Object.keys(data).length > 0){
  563     try {
→ 564         await prisma.node.updateMany(
Value out of range for the type. Out of range value for column 'air_util_tx' at row 1
    at In.handleRequestError (node_modules/@prisma/client/runtime/library.js:122:6854)
    at In.handleAndLogRequestError (node_modules/@prisma/client/runtime/library.js:122:6188)
    at In.request (node_modules/@prisma/client/runtime/library.js:122:5896)
    at async l (node_modules/@prisma/client/runtime/library.js:127:10871)
    at async MqttClient.<anonymous> (src/mqtt.js:564:21) {
  code: 'P2020',
  clientVersion: '5.11.0',
  meta: {
    modelName: 'Node',
    details: "Out of range value for column 'air_util_tx' at row 1"
  }
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant