Skip to main content
Question

Data Migration Job keeps hanging when ran without CHECKOPTION


Forum|alt.badge.img+18

My data migration job keeps hanging when ran without CHECKOPTION.

It eventually errors with the following message:

Error occurred while calling 

../main/admin/plsqlgateway/AccessPlsql/Invoke?frmIntfaceStart. Please contact your system administrator.

Error 502 - Bad Gateway

 

Has anyone come across this before and if so, could you please point me in the right directions.

4 replies

Forum|alt.badge.img+18
  • Author
  • Superhero (Partner)
  • May 21, 2020

Thought I should add that the migration job SQL is using a database link.


JULIAN
Hero
Forum|alt.badge.img+9
  • Hero
  • May 21, 2020

We did encounter something similar. Not using a db link though. 
in our case it was due to some load balancer (really not an expert in that) but there was a setting for x seconds timeout/change over which caused us to run into errors until it was extended to a point where there really could be no time out/change over. As a work around i think it was set to like 1 hour for the duration of migrations which we needed to do in connection with upgrade. 


Forum|alt.badge.img+18
  • Author
  • Superhero (Partner)
  • May 22, 2020

@JULIAN Thank you for your reply, I will look into that.  Have a great weekend. 


Forum|alt.badge.img+2

Hello,

It’s seem that we have the same problem with the same error message, but with all screen in our case.  Coud you tell me if there is a solution and where I have to lookink for (what we have to change) ?

Thanks in advance

Regards

Olivier