Error saving msg.payload in Dash DB

#1

Hello, I'm currently trying to insert data into a Dash DB. Msg.payload has the following structure when getting sent to the Dash insert node:

{"timestamp":1536659274297,"sensor":"BUS#2","valueType":"barometer","value":98.35288,"lat":Decimal,"lon":Decimal,"timeDifference":8984}

The keys refer to columns in the DB table. I took out lat and lon for security reasons. Otherwise they're decimals.

I get the following error:

dashDB: Insert failed: Error: [IBM][CLI Driver][DB2/LINUXX8664] SQL0104N An unexpected token ")" was found following "6861.cleanedData " (". Expected tokens may include: "". SQLSTATE=42601

Not really sure what to do here since I followed the guide's instructions for formatting the data.

I've also previously gotten an error regarding the table name. When I enter [scheme.table] I don't seem to get the same message.

Would be grateful for any advice. Thanks!

0 Likes