topic Re: Import failed in ThingWorx Developers

Import failed

AP_9587236 — Wed, 21 Jul 2021 18:38:43 GMT

I am repeatedly getting this error in application log while importing project. And the import is getting failed. It is pointing " [1,018] " for media, users, modeltags as well. How to rectify this?

1. Unable to process import: Unable to update user: [1,018] Data store unknown error: [Error occurred while accessing the model provider.]
2. [message: Unable to Invoke Service ImportSourceControlledEntities on SourceControlFunctions : Import Failed: Unable to update user: [1,018] Data store unknown error: [Error occurred while accessing the model provider.]]

Re: Import failed

vi1 — Fri, 09 Jul 2021 15:49:32 GMT

Hi,

when you observe message "Unable to update user: [1,018] Data store unknown error", you have to restart tomcat. After that, you can try to import files.

Regards,

Latha

Re: Import failed

AP_9587236 — Sat, 10 Jul 2021 11:59:00 GMT

It is working now @vi1. But Importing project doesn't import DataTables right. But In my case it replaced all the DataTables(with data) to empty DataTables.

Now I have to export each and every DataTable through source control and import individually(from file, type-data) to get all the datas in DataTable.

1. How to stop replacing with empty dataTables?

2. Any other ways to export and import all datatables with all the datas?

Re: Import failed

vi1 — Mon, 12 Jul 2021 09:09:32 GMT

Hi,

You have to import Datatables data separately. In Import, select file->File type as "Data"->browse Datatable file ".twx". After selecting ".twx" file, click on import . You can see datatable entries after successful. You have to do one by one for all the datatables.

Regards,

Latha

Re: Import failed

AP_9587236 — Wed, 14 Jul 2021 09:51:53 GMT

Okay Thanks. But while importing the project, the datatables(with datas) are getting replaced with empty datatables(zero datas). why? what is the solution for this ?

Re: Import failed

vi1 — Wed, 14 Jul 2021 13:00:03 GMT

Hi,

Datatable entries will not import when import the project. We have to do separately data after import all the entities. This is process.

Regards,

Latha

Re: Import failed

AP_9587236 — Wed, 14 Jul 2021 17:01:18 GMT

We can import datatables first, then we can import project also right??

Re: Import failed

slangley — Wed, 21 Jul 2021 18:47:25 GMT

Hi @AP_9587236.

Can you provide more details of your import procedure? You shouldn't have to import each datatable individually.

One question we have is whether anything is changing in the datatable entity, such as the data shape, between the one you're overwriting vs. the one you're overwriting it with?

What version of ThingWorx are you running?

Regards.

--Sharon

Re: Import failed

AP_9587236 — Wed, 21 Jul 2021 19:01:43 GMT

I am using thingworx 8.5.4.

There is no changes between the datatable entities of both server.

Right now iam exporting datatables separately using (to file, single data, datatables option) and import (from file, data, file repository, browse) to get the values in it. I am doing this export/import one by one for all datatables.

Re: Import failed

slangley — Wed, 21 Jul 2021 19:10:42 GMT

Hi @AP_9587236.

I recommend we open a case for this issue assuming you have a support contract. If so, please let me know if you would like me to open the case on your behalf. You'll need to provide your customer number and corporate email address (under private message).

Regards.

--Sharon

Re: Import failed

AP_9587236 — Tue, 27 Jul 2021 14:58:49 GMT

Thanks ill let you know.