Skip to main content
Solved

Table does not load from ODX to DSA


Did this topic help you find an answer to your question?
Show first post

26 replies

wouter.goslinga
TimeXtender Xpert
Forum|alt.badge.img+2
  • Author
  • TimeXtender Xpert
  • 52 replies
  • Answer
  • June 12, 2024

All, thank you for all the responses. I have finally managed to solve the problem, but not in a very convenient/easy way. As it turns out, one of the varchar columns was too small. I have enlarged this column in the DSA table from a varchar(50) to a varchar(100) and after that, everything runs smooth.

This is however a bit strange because in the ODX (and the source system table) the column is a varchar(50). So in order to fix the problem I had to unsync the datatype with the ODX which should not be necessary IMHO. I didn't have the time to figure out what specific column value actually caused the problem, I will do that later. Probably some weird/special characters in a column value.

I think if you load a table from ODX to DSA with all the same datatypes (so everything in sync) this should always work, it should not be necessary to change datatypes just to make the load happen. Or at least, it should break off with an error and not hang :). 


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