Developer forum

Forum » Dynamicweb 9.0 Upgrade issues » Data Integration 9.1.0

Data Integration 9.1.0

Adrian Ursu Dynamicweb Employee
Adrian Ursu
Reply

Hi Guys,

Anybody managed to use the Dta Integration in the new version?

I tried on 2 separate solutions on 2 different servers and I get the same error (see link)

http://screencast.com/t/Xp9JLHxLND

It looks like something wrong wth mapping, although the mapping seems fine.

In both cases I tried exporting or importin ItemTypes.

Thanks,

Adrian


Replies

 
Adrian Ursu Dynamicweb Employee
Adrian Ursu
Reply

I have more information.
After trying to run a regular CSV import, I have noticed this in the log file:

2016-11-25 16:48:41.943: Starting job - Import Articole.
2016-11-25 16:48:42.021: 11/25/2016 4:48:42 PM: Job creation failed. Error message: could not create destination provider of type: Dynamicweb.DataIntegration.Providers.ItemProvider.ItemProvider 

Any ideeas? Is there something missing from my Application?

 Thanks,

Adrian

 
Adrian Ursu Dynamicweb Employee
Adrian Ursu
Reply

I have a few more updates. I have managed to get past the error above by Updating all Core packages and recycling the application pool a few times.

I also noticed that the control for saving the destination node for the new pages is not working properly. No matter what you choose, it will save a 0 value as PageID.

I have managed to edit the xml Job manually and it displays correctly in the Job definition.

But now I get a different error for both export and import of items.

2016-11-25 18:30:40.518: Starting job - ImportArticole.
2016-11-25 18:30:40.627: Job Failed with the following message: Object reference not set to an instance of an object.
   at Dynamicweb.Environment.ExecutingContext.GetCulture(Boolean frontEnd)    at Dynamicweb.Content.Items.ItemManager.CreateValueConverter(Boolean frontend)    at Dynamicweb.Content.Items.Queries.Repository..ctor(ItemType metadata)    at Dynamicweb.Content.Items.Queries.StorageFactory.CreateRepository(ItemType metadata)    at Dynamicweb.DataIntegration.Providers.ItemDestinationWriter.GetExistingItemIdsDictionary()    at Dynamicweb.DataIntegration.Providers.ItemDestinationWriter..ctor(Job job, Int32 rootPageId, Boolean importItemsAsParagraph, ItemList itemList, ILogger logger)    at Dynamicweb.DataIntegration.Providers.ItemProvider.ItemProvider.RunJob(Job job)
2016-11-25 18:30:40.627: Finished job - ImportArticole.
2016-11-25 18:30:40.627: Batch failed.

Someone, please help me get past this one too.

Thanks,

Adrian

 

 
Adrian Ursu Dynamicweb Employee
Adrian Ursu
Reply

Really? Nobody used this DataIntegration functionality in DW9 yet?

 
Jonas Krarup Dam
Reply

Hi Adrian,

Imports run as they should on my machine, with the latest version of DW9.

Can you provide some source files for your import that cause it to fail, or maybe a link to a website where I can see/recreate the problem?

Regards, Jonas

 
Adrian Ursu Dynamicweb Employee
Adrian Ursu
Reply

Hi Jonas,

Sure.

You can try http://ttonline.dotfusion.ro version is 9.1.2

The job name is "ImportArticole"

But I have a similar issue on another solution that runs 9.1.3 (just been upgraded last night).

http://bioverativ.dw.kom-design.de/

The Job is called "ImportNews" is has a simple XML with just one node and an XSLT file

 
Jonas Krarup Dam
Reply

Hi Adrian,

 

Right, I've reproduced the problem. It is specific to the ItemProvider (as you probably guessed).

I've created bug 28156 to fix this problem.

Regards, Jonas

 
Gaëtan
Reply

I have the same problem with my integration with 9.1.3 (didn't work in 9.0.0 either). I use an ecom provider as destination and I can see in the XML that the destination type is "Dynamicweb.Data.Providers.EcomProvider", so I'm guessing my jobs weren't converted to the new api.

2016-12-12_12_57_28-Dynamicweb_Admin.png
 
Dmitriy Benyuk Dynamicweb Employee
Dmitriy Benyuk
Reply

Hi Gaƫtan,
Dynamicweb 9 should support the jobs from Dynamicweb 8. So the type "Dynamicweb.Data.Providers.EcomProvider" should be resolved to the new
"Dynamicweb.DataIntegration.Providers.EcomProvider" after save and close the job. From the stack trace you shown it is not clear where it fails.
I wasn't able to reproduce this with mine ecom provider in the job file from DW8 opened in DW9.
What is your source provider? Could you send your xml job file?
Regards, Dmitrij

 
Gaetan Caro
Reply

The source is of type Dynamicweb.Data.Providers.SqlViewProvider (with views). I can't even open the job (I get the error on the screenshot), much less save it. I sent you my job by email.

 
Dmitriy Benyuk Dynamicweb Employee
Dmitriy Benyuk
Reply

Hi Gaetan,
this is another bug related to the SqlViewProvider being a Source, I've created the tfs# 28829 to fix this problem
Regards, Dmitrij

 
Kristian Kirkholt Dynamicweb Employee
Kristian Kirkholt
Reply

Hi Gaetan and Adrian

The problem TFS#28829 "SqlViewProvider is absent in DW9" has now been fixed in version 9.1.4

You are able to find this build in the download section:

http://doc.dynamicweb.com/releases-and-downloads/releases

Please contact Dynamicweb Support if you need any additional help regarding this.

Kind Regards
Dynamicweb Support
Kristian Kirkholt

 
Gaëtan Di Caro
Reply

Works fine now, thanks :)

 

You must be logged in to post in the forum