Oracle Commerce (ATG) Direct SQL Deployment With Database Links Is Not Working (Doc ID 1681014.1)

Last updated on DECEMBER 22, 2016

Applies to:

Oracle Commerce Merchandising - Version 10.1 and later
Oracle Commerce Platform - Version 10.1 and later
Information in this document applies to any platform.

Goal

You are trying a Direct SQL deployment with database links but it is not working.

You have successfully created shared database links and have followed the instructions from the documentation

ATG Content Administration Programming Guide -> Setting Up Deployment -> Configure Direct SQL Deployment

However, when you start the Direct SQL deployment it is not deploying anything and seems to be hanging.

The server logs shows that it is stuck on calling deleteAll() on all the repositories mentioned below

     

 
 

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms