Data integration export issues with EcomProvider and Excel

Adrian Ursu

Posted on 07/04/2021 14:55:11

Hi guys,

I have a project running on DW 9.9.8.

I have set up an export for the products in the database using EcomProivider as Source and Exvcel provider as destination.

For some reason, I get an exception when running the export and the log does not help very much.

I get this in the EventViewer:

2021-04-07 15:47:44.917: Request headers: [ "Connection", "Host" ]
2021-04-07 15:47:44.917: Request item keys: [ "Dynamicweb.DataIntegration.Providers.ExcelProvider.ExcelProvider", "Dynamicweb.Environment.Web", "Dynamicweb.DataIntegration.Providers.EcomProvider.EcomProvider", "Dynamicweb.DataIntegration.Integration.Column", "ExecutionTableMapper" ]
2021-04-07 15:47:44.917: Request form: []

And this in the Log:

Job failed Object reference not set to an instance of an object. The failed input row is: [productid:"GF-2040"], [productlanguageid:"LANG1"], [productvariantid:""], [productdefaultshopid:""], [productnumber:"GF-2040"], [productlink1:""], [productlink2:""], [productprice:"0"], [productstock:"24],......

How can I identify what is wrong?

The Health check for ecommerce is green for all checks.

Thank you,
Adrian

Replies

Oleg Rodionov

Posted on 12/04/2021 07:42:56

Hi Adrian

I've checked the issue on Rapido 3.4 solution based on last DW9.10.5 and was not able to catch any issue - proof.

BR, Oleg QA

Dmitriy Benyuk

Posted on 12/04/2021 07:57:14

Hi Adrian, does it work when exporting same data to Xml provider? Regards, Dmitrij

Adrian Ursu

Posted on 12/04/2021 08:56:35

Hi Oleg, Dmitrij,

I am sure it is not supposed to fail on the Rapido Dataset. I am sure there is something wrong with my data and probably some exception is not captured when joining the objects.

And I am trying to find out what is wrong.

The error message though is not helpful and the Health Check seems fine. It is probably some other check that is not included in the Health Check.

@Dimitrij I have tried exporting with XML and it worked. It took a lot of time (~10 minutes) but it eventually worked. This supports my theory that the Excel provider somehow misses an exception.

If you want to have a look, the solution is http://gf.dotfusion.ro/

Thank you,

Adrian

Dmitriy Benyuk

Posted on 12/04/2021 09:01:54

Hi Adrian,
you are using a bit old ExcelProvider: 3.2.0 while 3.2.3 is already available on nuget. Try to update the ExcelProvider package and check with that.
Kind regards, Dmitrij

Adrian Ursu

Posted on 12/04/2021 09:43:16

Hi Dmitrij,

I have not used NuGet for defining the project. I have manually installed it.

Is there any way I can download only the DLL for the excel provider?

Is it enough if I take it from the most recent DW 9.10?

Adrian

Dmitriy Benyuk

Posted on 12/04/2021 09:46:41

Yes, you can download it from here and then unzip it and look in the lib/net472 subfolder, there will be the dll that you can copy.
Regards, Dmitrij

Adrian Ursu

Posted on 12/04/2021 10:27:40

Hi Dmitrij,

Thank you.

I will give it a try.

Adrian

You must be logged in to post in the forum

Developer forum

Data integration export issues with EcomProvider and Excel

Replies