Question

Data Migration Job keeps hanging when ran without CHECKOPTION

  • 21 May 2020
  • 4 replies
  • 427 views

Userlevel 7
Badge +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

Userlevel 7
Badge +18

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

Userlevel 4
Badge +9

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. 

Userlevel 7
Badge +18

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

Badge +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

 

Reply