DBAAS Snapclone Job Failed At The Step "Obtain The Target Node List Using The Placement Algorithm" (Doc ID 2043974.1)

Last updated on JANUARY 19, 2023

Applies to:

Symptoms

On : 12.1.0.2.0 version, Provisioning Framework

When attempting to utilize snapclone via EMCLI created profile and EMCLI commands,
the following error occurs.

ERROR
-----------------------
2015-06-10 10:15:59,504 [RJob Step 2784742] ERROR diagnosability.DiagnosabilityService logp.251 - [EM-03657] Unexpected exception being throwing in ComputeStep code.
ExpressionEvaluationException: An unexpected error encountered while executing this Computational step. An incident was created for this event. Below is the error message
----------------------------------------------------------
1
----------------------------------------------------------


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

1)Profile creation using the emcli :
 emcli create_dbprofile '-input_file=data:/tools/oracle/DBAAS/input_for_profile__2015-06-09_1149.txt' '-purge_policy=DAYS:15'
2) Service template creation :
emcli create_service_template '-name=Auto template at 2015-06-09_1149 for SID02' '-service_family=DBAAS' '-service_type=DB' '-pool_target_type=oracle_cloud_zone' '-software_pools=Pool DBA test' '-roles=DBA_SSA_USER' '-description=Auto created template 2015-06-09_1149 for SID.world in Pool DBA test' '-input_file=data:svc_template_SID02_2015-06-09_1149.txt'
3) Running the snapclone creation job :
curl -k -X POST -H 'Content-Type: application/oracle.com.cloud.common.DbPlatformInstance+json' -H 'Accept: application/oracle.com.cloud.common.DbPlatformInstance+json' -H 'Authorization: basic someauthorizationcharactershere123==' -d $'{\n "zone": "/em/cloud/dbaas/zone/51A32D564E37B2C2BCFA861A449F4EF1",\n "name": "Autocreation 2015-06-09T23:59:02 SID12",\n "description": "from Auto template at 2015-06-09_1149 for SID02",\n "end_date": "2015-06-09T23:59:02ZEurope/Paris",\n "params":\n { \n "username": "<name>",\n "password": "<password>",\n "database_sid": "SID12",\n "service_name": "DBAAS_NAME_SID12"\n }\n }' https://host.company.com:7799/em/cloud/dbaas/dbplatformtemplate/1813AE68F7EA0E96E05344350BB89851

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot use EMCLI for snapclone profile creation.

Cause

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