Migrate data from Postgres to Influx

[MM_9023322]

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]

 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