Skip to main content
B
bot1q1-Visitor
1-Visitor
March 25, 2020
Solved

Import Entities from MSSQL Data provider to an instance with PostgreSQL

  • March 25, 2020
  • 5 replies
  • 1680 views

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?

Best answer by Constantine

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

5 replies

raluca_edu
raluca_edu17-Peridot
17-Peridot
March 26, 2020

Hi,

 

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

 

Hope it helps,

Raluca Edu

B
bot1q1-VisitorAuthor
1-Visitor
March 26, 2020

Hello,

 

thank you.

Same issue.

raluca_edu
raluca_edu17-Peridot
17-Peridot
March 26, 2020

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

 

Thanks,

Raluca Edu

C
Constantine18-OpalAnswer
18-Opal
March 29, 2020

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

S
slangleyCommunity Manager
Support
April 6, 2020

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

Terms & ConditionsAccessibility statement