Skip to main content
Question

Data Migration Error


Forum|alt.badge.img+1
  • Do Gooder (Customer)
  • 9 replies

I’m executing a loader job via OnServer route and once I select the file from the SFTP Server, getting an error “Invalid value for property “IntfaceFile””. Any suggestion on the reason of this error and how to fix it.

Thanks

5 replies

Jens
Hero (Employee)
Forum|alt.badge.img+10
  • Hero (Employee)
  • 123 replies
  • March 7, 2023

Hi @SPRRAJ ,

can you please add a screenshot of the migration job (Tab Formatting) and when does this error exactly occurs?

Normally when you choose “File Location:” OnServer then the file name must already be stored in the field “File Name:” before executing the job. 

 

I suppose you already have the “File Name:” and “File Path:” filled out with values.

The “File Path:” should be an ORACLE-DIRECTORY which refers to a folder on the database server.

So for example the name of the ORACLE-DIRECTORY is MIGRATION and MIGRATION refers to the folder D:\MyFiles on the database server.

File Path: → MIGRATION

File Name: testfile.txt (which is stored in the folder D:\MyFiles on the database server)

 

 


Forum|alt.badge.img+1
  • Author
  • Do Gooder (Customer)
  • 9 replies
  • March 7, 2023

Hi Jens,

The error appears when I choose the file in the File Name field under File Configuration Tab…

 


Forum|alt.badge.img+1
  • Author
  • Do Gooder (Customer)
  • 9 replies
  • March 7, 2023

The same file I can load successfully via the OnClient route…

Thanks


Forum|alt.badge.img+10
  • Hero (Employee)
  • 99 replies
  • March 30, 2023

Can you please test with “short” file name and make sure there are no special characters in the name. Do you still get the same error message?


Forum|alt.badge.img+10
  • Hero (Customer)
  • 48 replies
  • September 26, 2023

Unless I am not understanding correctly you say the File Path is “MIGRATION”. Yet in the file configuration screen, where you are picking the file, the path is “ASSET”. In order for the job to work, the file must be on “MIGRATION”.


Reply


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