Skip to main content
Solved

transfer task error


Forum|alt.badge.img
  • Contributor
  • 26 replies

Hi everyone

 

After successful synchronization of a csv file, I get an error in the transfer job. The error is: ‘The schema XXXData_CSV is invalid. Execution is canceled’ 

 

But with Query Tool I can see all of data. In addition If I click to preview this source in ODX , I take this error  'the sql server contains no data for the table'. 

 

What changes should I make to the schema of this csv data?

 

Best Regards

Best answer by Christian Hauggaard

OK 0 is infinite so increasing that property will not help in this case. I recommend keeping it at zero, so that it scans all records before determining the data types.

Thanks for providing the data source settings. Do you have a dummy csv file (perhaps a subset of non-sensitive records) I can test with?

View original
Did this topic help you find an answer to your question?

5 replies

Christian Hauggaard
Community Manager
Forum|alt.badge.img+5

Hi @ebay in order to troubleshoot, do you have a dummy csv file similar to the one you are connecting to? Can you also please share the data source settings?


Christian Hauggaard
Community Manager
Forum|alt.badge.img+5

Also, what is the Row Scan Depth set to? Please try increasing this value and then running the sync and transfer tasks again


Forum|alt.badge.img
  • Author
  • Contributor
  • 26 replies
  • March 24, 2023

I send you the changes I made. I increased Row Scan from 0 to 105. But doesnt work.


Christian Hauggaard
Community Manager
Forum|alt.badge.img+5

OK 0 is infinite so increasing that property will not help in this case. I recommend keeping it at zero, so that it scans all records before determining the data types.

Thanks for providing the data source settings. Do you have a dummy csv file (perhaps a subset of non-sensitive records) I can test with?


Forum|alt.badge.img
  • Author
  • Contributor
  • 26 replies
  • March 24, 2023

Thanks @Christian Hauggaard . I will send you the csv file that I work on.  


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings