Import Entities from MSSQL Data provider to an instance with PostgreSQL

[bot1q]

Hello,

I've try to export ententies (without Data) from an Thingworx Instance (8.4.5-b102) with MSSQL as Maindataprovider to an Thingworx Instance (8.4.5-b102) with Postgre.

I reseive [message: [1,018] Data store unknown error: [Error occurred while accessing the property provider.]] as Error Message.

Do you have any idea how to do this entety migration?

[raluca_edu]

Hi,

You need to check at import "Use default Persistence Provider".

Hope it helps,

Raluca Edu

[bot1q]

Hello,

thank you.

Same issue.

[raluca_edu]

Please attach ThingworxStorage/logs/Error.log to see more info about the error.

Thanks,

Raluca Edu

[Constantine · Accepted solution]

Hello @bot1q,

We sometimes see this error while importing multiple entities at once. I don't know why it happens, but in our case it helps when we import them in small batches or even one by one.

/ Constantine

[slangley]

Hi @bot1q.

If one of the previous responses allowed you to find a solution, please mark the appropriate one as the Accepted Solution for the benefit of others with the same issue.

Regards.

--Sharon