Developer forum

Forum » Integration » Error logging

Error logging

E-mail notifications
Morten Bengtson
Reply
Posted on 11/05/2012 15:00:15
Hi,

I have run into some problems with Data Integration and the messages that are logged are not very helpful.

In the example below I am trying to import data from an xml file previously exported through another activity (ecom provider to xml provider).
The import uses xml provider as source and ecom provider as destination.

Example:
11-05-2012 14:42:30: Starting batch
11-05-2012 14:42:31: Starting job - Import2.
11-05-2012 14:42:31: reading configuration
11-05-2012 14:42:31: Importing data to table: EcomGroups
11-05-2012 14:42:31: Importing data to table: EcomProducts
11-05-2012 14:42:31: Finished job - Import2.
11-05-2012 14:42:31: batch failed.
"batch failed" - no shit? what exactly does that mean? I need some more info about WHAT caused the batch to fail.
Is it possible to get a more detailed report about what went wrong?

DW version 8.0.2.2 (clean install)

/Morten

Replies

 
Morten Bengtson
Posted on 11/05/2012 15:20:17
Reply
Another example:
11-05-2012 15:18:06: Job Failed with the following message: Input string was not in a correct format.
What input string? Where?!

Somehow i managed to make it "work"...
11-05-2012 15:39:13: Starting batch
11-05-2012 15:39:14: Starting job - Import3.
11-05-2012 15:39:14: reading configuration
11-05-2012 15:39:15: Importing data to table: EcomProducts
11-05-2012 15:39:15: Finished job - Import3.
11-05-2012 15:39:15: batch succeeded.
But only 1 out of 3 products was actually imported?!

 
Jonas Dam
Posted on 16/05/2012 13:41:12
Reply
 Hey,

Hmm - that sounds strange. 

Any chance I can get you to attach the Job xml file, and the input data (assuming it is either XML input or CSV input)?

The job xml file can be found in the files folder at the path: Files/Integration/jobs/YourJobNameHere.xml

Thanks, Jonas 
 
Morten Bengtson
Posted on 24/05/2012 20:55:39
Reply
I have attached the two files.

Export2.xml contains the data exported previously with Data Integration.
Import2.xml is the import job definition file.

In this case the problem is caused by the EcomManufacturers mapping.
Attempting to add a column mapping will result in a server error - "sequence contains no elements" - a linq expression error? 
If I remove the EcomManufacturers mapping completely, it seems to work.

There are no manufacturers in database or data file (the table element is there, but no items), but other "empty sequences" than the EcomManufacturers does not cause this problem.
 
Morten Snedker
Posted on 25/05/2012 13:17:05
Reply
Hi Morten,

Problem is being solved as we speak. I'll get back to you first thing next week with updated assemblies. Pop a mail if I'm too slow.

Regards /Snedker
 
Morten Snedker
Posted on 25/05/2012 13:51:17
Reply
 Hi Morten,

Please try and use the attached assemblies (the two for Data Integration).

Also, delete the job you already have and create it again. Now it ought to work.


/Snedker
 
Morten Snedker
Posted on 29/05/2012 09:02:40
Reply

...and let me know the grade of success!  :-)

/Snedker

 

You must be logged in to post in the forum