Skip to main content
Question

Migration field format


Forum|alt.badge.img+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 replies.

3 replies

Forum|alt.badge.img+5
  • Sidekick
  • 15 replies
  • March 24, 2021

Hi 

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

 

Regards

/D

 


Forum|alt.badge.img+5
  • Author
  • Do Gooder (Partner)
  • 12 replies
  • March 25, 2021

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


Forum|alt.badge.img+5
  • Author
  • Do Gooder (Partner)
  • 12 replies
  • March 25, 2021

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


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