Skip to main content
Solved

Transfer task doesnt work - sql database - doesnt show any table in ODX select table

  • March 25, 2024
  • 5 replies
  • 58 views

Hello Guys. I tried to select table from ODX but it deosnt show none (except once query table).

the transfer task work fine (it show succefull) but once I triy to select table in order to send them to the datawerhouse I show nothing.- even if it work fine when I use query tool.

 

Any suggestion please? thanks

@Thomas Lind 

 

 

Best answer by pontus.berglund

Hi @majeddig,

A possible reason could be that you have made table selections in either the synchronize or transfer task.

Have you made any selections in the Synchronize task? You can check this by right clicking the data source and click “Select tables...”. If you want to synchronize all tables in the source, you set that here:


You can also make table selections on the transfer task:

Have you made any selections there?

//Pontus

5 replies

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

Hi @majeddig 

can you please share a screenshots of:

  1. the tables that are selected on the data source level

     

  2. the tables that are selected on the transfer task

Also please try to close TimeXtender and restart the application to see if the problem persists

 

 


Forum|alt.badge.img+2
  • Contributor
  • 64 replies
  • Answer
  • March 25, 2024

Hi @majeddig,

A possible reason could be that you have made table selections in either the synchronize or transfer task.

Have you made any selections in the Synchronize task? You can check this by right clicking the data source and click “Select tables...”. If you want to synchronize all tables in the source, you set that here:


You can also make table selections on the transfer task:

Have you made any selections there?

//Pontus


  • Author
  • Starter
  • 1 reply
  • March 25, 2024

Hello @Christian Hauggaard ,

Honestly I cant see the select table at data source table

 

Also in seelct table at task level it show only this:

 

 when *I use query tool it work fine


Forum|alt.badge.img+2

@majeddig 

Which settings can you see if you click on “Select Tables...” highlighted in yellow? 

 


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

Hi @majeddig please let us know if you are able to select tables now