To homepage To homepage
Solved

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

  • 20 April 2023
  • 6 replies
  • 132 views
K
Rank
Userlevel 2

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.

 

 

icon

Best answer by Christian Hauggaard 24 April 2023, 10:23

View original
2 Attachments

6 replies

Thomas Lind
Rank
Userlevel 6
Badge +5

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
Rank
Userlevel 2

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
Rank
Userlevel 6
Badge +5

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

K
Rank
Userlevel 2

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
Rank
Userlevel 6
Badge +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
Rank
Userlevel 2

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


Terms and ConditionsCookie settings