My Oracle Support Banner

E-CLOUD: Cloning Custom Imported Environment Stuck at the Deployment Task- Performing DB tier OCI Clone Activity with Error: Got exception while executing SQL script.', 'activity_name': 'PscDBTierOciClone' (Doc ID 3056128.1)

Last updated on OCTOBER 28, 2024

Applies to:

PeopleSoft Cloud Manager - Version 17 and later
Linux x86-64 on Oracle Public Cloud

Symptoms

When cloning an imported environment into Peoplesoft Cloud Manager (CM), the clone process gets stuck at the Deployment Task --> Performing DB tier OCI Clone Activity.

The following error can be found in the environment's out.log file:

INFO psc_activity_executor.py 233 Activity response object: {'status': 'failure', 'exit_code': '1', 'status_message': 'Got exception while executing SQL script.', 'activity_name': 'PscDBTierOciClone', 'id': '1', 'activity_description': 'Performing DB tier OCI Clone Activity', 'data': {}, 
DEBUG psc_activity_executor.py 254 Status after running PscDBTierOciClone[1] : {'status': 'unknown', 'exit_code': '-1', 'status_message': 'NIL', 'data': {}, 'psft_activity_response': [{'status': 'success', 'exit_code': '0', 'status_message': 'Successfully completed', 'activity_name': 'PsftActivityCloudFolderSync', 'id': '0', 'activity_description': 'Cloud Folder Sync Activity', 'data': {}, 'action_status': {}}, {'status': 'failure', 'exit_code': '1', 'status_message': 'Got exception while executing SQL script.', 'activity_name': 'PscDBTierOciClone', 'id': '1', 'activity_description': 'Performing DB tier OCI Clone Activity', 'data': {}, 'action_status': {}}]}




The issue can be reproduced at will with the following steps:

1. Import an environment in Cloud Manager.

Navigation: Environments tile > Click on 'Import' button.

2. Once the import is successful, perform the clone. 

Navigation: Environments tile > Open the Environment detail > Click on Related Actions menu and choose: Clone.

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.