Question

Migration field format

  • 24 March 2021
  • 3 replies
  • 89 views
C
Rank
Badge +5

Hi,

I am using Migration Job, but encountered an error mssage, that a filed format is wrong.
I used "'" single quotation.

Could you tell me how the "format" to be modified?
The value is VARCHAR2.

 

Kind regards,

Kokubo

This topic has been closed for comments

3 replies

C
Rank
Userlevel 2
Badge +5

Hi 

Not sure how your file configuration looks like but it’s worth try and changing the String Delimiter field.

 

Regards

/D

 

C
Rank
Badge +5

Hi,

Before I used comma as column separator and single quotation, which did not work.  This time I used double quotation, but still this does not work and the message is the same.  Do you have any idea please?

 

Thank you!

 

Kind regards,

 

Kokubo

C
Rank
Badge +5

Hi,

I checked the DB data and found the reason.

I typed e.g., Conforming but in DB this was CONFORMING, and could import the data now.

 

Thanks for your help!

 

Kind regards,

 

Kokubo

Terms & ConditionsCookie settings