设备数据上报报错:Table does not exist

Blade 未结 1 86
平淡
平淡 剑侠 2025-05-26 17:04

一、该问题的重现步骤是什么?

1. 项目在测试环境中部署,设备上报数据会自动建表,都没问题,部署到生产环境后,设备上报属性直接报错表不存在

2. 

device_property_urei113tjtqh_en17v6hvs935` USING `device_property_urei113tjtqh` TAGS ('uREI113TJtQH', 'en17v6hvs935') (`time`, `branch_code`, `current`, `date_time`, `tempture`, `resistor`, `leak_curr`, `voltage`, `capacitor`) VALUES (1748250183551, '["1","3","5","2","4","6","7","8","9","10","11","12"]', '["0","1","2","3","4","5","6","7","8","9","10","11"]', '20250526 17:03:03', '["20","21","22","23","24","25","26","27","28","29","30","31"]', '["1","1","1","1","1","1","1","1","1","1","1","1"]', '[{"leak_curr":"0","cable_code":"41-0000-0001"},{"leak_curr":"0","cable_code":"41-0000-0002"},{"leak_curr":"0","cable_code":"41-0000-0003"},{"leak_curr":"0","cable_code":"41-0000-0004"}]', '["220","220","220","220","220","220","220","220","220","220","220","220"]', '["0","0","1","1","2","2","3","3","4","4","5","5"]') `device_logger_urei113tjtqh_en17v6hvs935` USING `device_logger` TAGS ('uREI113TJtQH', 'en17v6hvs935') (`time`, `topic`, `message`) VALUES (1748250183551, '/blade/sys/uREI113TJtQH/en17v6hvs935/thing/event/property/post_reply', '{"id":"8918d363332d40e39ea7c116e3c16a99","version":"1.0","code":200,"message":"success","method":"thing.event.property.post"}');, desc: Table does not exist

at com.taosdata.jdbc.TSDBError.createSQLException(TSDBError.java:95)

at com.taosdata.jdbc.rs.RestfulStatement.execute(RestfulStatement.java:97)

at com.taosdata.jdbc.rs.RestfulStatement.execute(RestfulStatement.java:77)

at com.taosdata.jdbc.rs.RestfulStatement.executeUpdate(RestfulStatement.java:55)

at com.taosdata.jdbc.rs.RestfulPreparedStatement.executeUpdate(RestfulPreparedStatement.java:59)

at com.alibaba.druid.pool.DruidPooledPreparedStatement.executeUpdate(DruidPooledPreparedStatement.java:241)

at org.springframework.jdbc.core.JdbcTemplate.lambda$update$2(JdbcTemplate.java:975)

at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:658)

... 12 common frames omitted

3.


二、你期待的结果是什么?实际看到的又是什么?

期待设备上报数据成功,实际上直接报表不存在

三、你正在使用的是什么产品,什么版本?在什么操作系统上?


四、请提供详细的错误堆栈信息,这很重要。


五、若有更多详细信息,请在下面提供。

1条回答
  • 2025-05-26 19:36

    到产品的物模型做一次发布操作(发布后会创建物模型超级表),然后才可以自动建表写入数据。

    作者追问:2025-05-27 09:13

    解决了,那如果是将原来的td表导入生产的td库里面,可以吗

    0 讨论(1)
代码语言
提交回复