Skip to main content
To homepage To homepage
Solved

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

  • April 20, 2023
  • 6 replies
  • 158 views
K
Contributor
Forum|alt.badge.img
  • KCMT
  • 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?  

6 replies

Thomas Lind
Community Manager
Forum|alt.badge.img+5
  • Thomas Lind
  • Community Manager
  • 1161 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?

 

K
Contributor
Forum|alt.badge.img
  • KCMT
  • Author
  • Contributor
  • 33 replies
  • April 24, 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?

 

 

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?

K
Contributor
Forum|alt.badge.img
  • KCMT
  • Author
  • Contributor
  • 33 replies
  • April 24, 2023

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?  

K
Contributor
Forum|alt.badge.img
  • KCMT
  • Author
  • Contributor
  • 33 replies
  • April 24, 2023

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...


Terms and ConditionsCookie settingsAccessibility statement