Migrate data from Postgres to Influx

Question

Hi everyone,

I want to migrate data from postgres to influx db. I followed This Link and was able to migrate the data. The data available in postgres is around 16.34 MB. When I tried to migrate the whole data, it gave me an error "Import failed com.thingworx.common.exceptions.DataAccessException: [2,000] Error occurred while accessing the data provider. {}". So I tried to import approx. 1MB of data, and it worked successfully. Now I am trying to migrate the data using SQL queries, is there any article which gives what steps has to be followed.

@VladimirN @AnnaAn @paic @slangley @CarlesColl @c_lowy

Thank you!!

VladimirN · Answer

Hi, Read the following articles:"Migration of ValueStream from Postgresql to InfluxDB failed for certain Value Stream, import fails with error "com.thingworx.common.exceptions.DataAccessException: [2,000] Error occurred while accessing the data provider" in ThingWorx Platform": https://www.ptc.com/en/support/article/CS333946 "Error occurred while accessing the data provider while using InFluxDB as persistence provider in ThingWorx Platform": https://www.ptc.com/en/support/article/CS339783 "QueryPropertyHistory service for InfluxDB ValueStream returns "[2,000] Error occurred while accessing the data provider." in ThingWorx 8.4": https://www.ptc.com/en/support/article/CS311164 ""[message: [2,000] Error occurred while accessing the data provider.] java.net.SocketException: Socket closed" "timeout" is seen when interacting with a backing InfluxDB Persistence Provider from ThingWorx Platform": https://www.ptc.com/en/support/article/CS334229

Sign up

Please use your PTC eSupport account.

Welcome to the PTC Community

Please use your PTC eSupport account.

Scanning file for viruses.

This file cannot be downloaded