Skip to main content
Question

Migration field format

  • March 24, 2021
  • 3 replies
  • 119 views
C
Do Gooder (Partner)
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

    C
    Sidekick
    Forum|alt.badge.img+5
    • CedDinesY
    • Sidekick
    • 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

     

    C
    Do Gooder (Partner)
    Forum|alt.badge.img+5
    • CheHiroyK
    • Author
    • Do Gooder (Partner)
    • 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

    C
    Do Gooder (Partner)
    Forum|alt.badge.img+5
    • CheHiroyK
    • Author
    • Do Gooder (Partner)
    • 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

    C
    Terms & ConditionsCookie settingsAccessibility statement