Skip to main content
Solved

ODX SQL Transfer task failed SQL, but Preview & Sync successfull


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

After connecting successfully to my SQL server and adding the tables & rows I am able to preview the data by Select Tables. The Synchronize task also completed successfully. However, when I execute the Transfer task it fails with 2 errors (see attachments). I can’t figure out the reason why it fails though but the error message suggests something that (The specified path does not exist). 

I tried to remove the File Container in Azure and sync+transfer again, but it does’nt make a difference.

 

 

Best answer by Christian Hauggaard

Thanks for the info @KCMT, which version of the SQL provider are you using? Could you please try recreating the data source again but with a different name. Select just one table from the data source and then execute the synchronize task and then the transfer task?  

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

6 replies

Thomas Lind
Community Manager
Forum|alt.badge.img+5
  • Community Manager
  • 1070 replies
  • April 21, 2023

Hi Kevin

I am not sure, but it could be the datalake container that is missing. Can you test the connection of your ODX instance?

 


Forum|alt.badge.img
  • Author
  • Contributor
  • 33 replies
  • April 24, 2023
Thomas Lind wrote:

Hi Kevin

I am not sure, but it could be the datalake container that is missing. Can you test the connection of your ODX instance?

 

 

Hi @Thomas Lind,

I checked the connection and it connects successfully.

If I check the containers, it also added the container successfully. I tried to remove the container and sync+load again. It will successfully recreate the containers, but won’t run the Transfer task, resulting in the error messages.

 


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

Hi @KCMT, can you please confirm which version of TimeXtender are you using?


Forum|alt.badge.img
  • Author
  • Contributor
  • 33 replies
  • April 24, 2023
Christian Hauggaard wrote:

Hi @KCMT, can you please confirm which version of TimeXtender are you using?

Hi Christian,

I am using TimeXtender 20.10.35.64


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

Thanks for the info @KCMT, which version of the SQL provider are you using? Could you please try recreating the data source again but with a different name. Select just one table from the data source and then execute the synchronize task and then the transfer task?  


Forum|alt.badge.img
  • Author
  • Contributor
  • 33 replies
  • April 24, 2023
Christian Hauggaard wrote:

Thanks for the info @KCMT, which version of the SQL provider are you using? Could you please try recreating the data source again but with a different name. Select just one table from the data source and then execute the synchronize task and then the transfer task?  

Recreating the Data source and adding the tables 1 by 1 seemed to work, as it loads successsfully now, thanks! Not sure what the issue was though, as I literally copied all the settings...


Reply


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