Skip to main content
Question

Data Migration Job keeps hanging when ran without CHECKOPTION

  • May 21, 2020
  • 4 replies
  • 530 views

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)
  • 368 replies
  • 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
  • 75 replies
  • 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)
  • 368 replies
  • May 22, 2020

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


Forum|alt.badge.img+2
  • Do Gooder (Customer)
  • 3 replies
  • November 30, 2020

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