Solved

Execution log warning column already exists

  • 3 August 2023
  • 9 replies
  • 108 views

Userlevel 1
Badge

Hi all,

For one of my current client's we are rectrieving a warning while syncing the odx. The task is completed and we can transfer the data. but the warning is a bit odd.

We already tried to remove the folder from the data lake and try a full load. but this didn't fix the warning. Anyone any ideas?

icon

Best answer by Christian Hauggaard 28 October 2023, 06:45

View original

9 replies

Userlevel 6
Badge +5

Hi @Bernarddb 

Which data source are you using? Does the data source table/view have an Id column? Was this Id column at some point deleted and re-added?

Userlevel 1
Badge

We are using a ADO data Source. with an SqLClient data provider. The table indeed has a the id field. As far as we are aware the supplier didn't change anything in the view. 

Userlevel 6
Badge +5

@Bernarddb  Which version of TimeXtender are you using?

Can you please share a screenshot of your data source settings similar to below?

Have you set up any primary keys or incremental load rules on the data source?

Userlevel 6
Badge +5

Also could you please try to create a new data source and see if you get the same issue? If so can you please also test with the TimeXtender SQL data source?

Userlevel 1
Badge

hereby the screenshot. Sorry for the slow reply 

We also tried it with the different connectors but still got the same result

Userlevel 6
Badge +5

@Bernarddb Thanks for the screenshot, can you please share the create statement for the view and create statement for the table which the view is based on in the source database? 

Userlevel 1
Badge

We don't have those script's since we are only supplied the table and view. But not the create statements. So i'm guessing we just have to live with the completed with warnings. Since it doesn't impact the transfer.

Userlevel 4
Badge +5

@Christian Hauggaard , I'm interesed in the reason why TX throughs an 'Warning'. What is the definition or ‘business rule’ for TX to get this warning?

Userlevel 6
Badge +5

Hi @Bernarddb @daniel this issue has been fixed now, please see

  • 19429: Removed unnecessary warnings in the ODX when synchronizing OLE DB based data sources

in the product update:

 

Reply