replicat hangs on delete because of foreign key constraint?
we have Golden Gate 11.1, as a target from a remote site. The source database is oracle. The target is sql server 2008R2. Yesterday, the replicat hung - it was processing a delete on order_detail. No errors. no abend. cpu usage was thru the roof. Lag was more than 25 hours. If I entered a stop replicat command in ggsci, it gave the message Stop pending end of transaction, # records so far. a full minute later another stop command yielded only 1000 more records. Crawling.
We had a similar problem about a year and a half ago with a different target database (target still sql, source still oracle) and via a support ticket were advised to remove or disable the foreign key constraints that referenced this table. So I followed the same procedure on this table, kill the replicat, remove the constraints, restart the sql server service, start replicat - it worked. The support ticket suspected cascading deletes, which we are not doing. And it mentioned that the tables in the source and target databases could be out of sync - not sure what that means, might