My Oracle Support Banner

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:

Enterprise Manager Base Platform - Version and later
Information in this document applies to any platform.


On : version, Provisioning Framework

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

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

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 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/' -H 'Accept: application/' -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 }'

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


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

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