Skip to main content
Solved

Invalid data type long raw

  • January 2, 2024
  • 3 replies
  • 102 views

Forum|alt.badge.img

The column LVALUE from the table "PROD"."MICROSOFTDTPROPERTIES" failed synchronization with the error:
System.Exception: Invalid data type long raw.

how to solve this error.
 

Best answer by daniel

Dear @Karankadam ,

I'm not sure what goed wrong here. Can you provide more info on which connector you are using and the settings? Maybe you need to change the row scan because it is giving an error on the length of a column. You can also try to:
1. Do a Data type override. 
2. Create a Query Table and cast / covert the column into something else
3. If you dont need that column, exclude it from the query so it doenst throughs an error

 

Hope this helps

= Daniel

3 replies

Forum|alt.badge.img
  • Author
  • Contributor
  • 14 replies
  • January 2, 2024

@daniel would you please help me with this.


daniel
TimeXtender Xpert
Forum|alt.badge.img+8
  • TimeXtender Xpert
  • 192 replies
  • Answer
  • January 2, 2024

Dear @Karankadam ,

I'm not sure what goed wrong here. Can you provide more info on which connector you are using and the settings? Maybe you need to change the row scan because it is giving an error on the length of a column. You can also try to:
1. Do a Data type override. 
2. Create a Query Table and cast / covert the column into something else
3. If you dont need that column, exclude it from the query so it doenst throughs an error

 

Hope this helps

= Daniel


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

@Karankadam do you have an update for the above questions? Please let us know so we can assist further