Solved

Data Migration

  • 31 May 2023
  • 7 replies
  • 121 views

Badge +1

My Migration Job based on procedure “CREATE_TABLE_FROM_FILE” is not able to load data into the IC/TEMP table from a file holding more than 1 million records. Is there a limitation in IFS Cloud to handle the number of records during Data Migration?

icon

Best answer by Makede 31 May 2023, 18:57

View original

7 replies

Userlevel 4
Badge +10

Hi @SPRRAJ ,

Which kind of error message do you receive? Are you loading the data online or as a background job?

Best regards

Martina

Badge +1

I’m loading it online, not getting any error message but the job terminates after sometime and the last info does not refresh…

 

Userlevel 4
Badge +10

@SPRRAJ 
Sounds like a session timeout within the client
First step is to load the data from file into the migration job via Load File Button. Does this step already abort or the following step to execute the job?
 

 

Userlevel 4
Badge +10

 

Badge +1

Hi, 

Load file step works ok but online step fails…

 

Regards

Userlevel 4
Badge +10

Ok then try to run the job in background instead of online like shown in the hardcopy
A background will be generated and you can check in background jobs the progress

Badge +1

Thank you @Makede, it worked under a background job!

Cheers

Reply