Error in EM12c using emcli create_service_template

29 Sep Error in EM12c using emcli create_service_template

This will be a small post regarding creating an error I had today regarding Schema as a Service template with EM12c emcli . While creating today a service template , I had an error that showed me nothing more or where I could look for it “Validation error(s) occurred. Resolve these and try again.“

[email protected] [emrep] /home/oracle
oracle $ emcli create_service_template -name="EMPTY_SCHEMA_SERVICE_TEMPLATE" -service_family="DBAAS" -service_type="SCHEMA" -pool_target_type="schaas_pool" -software_pools="SCHEMA_POOL" -roles="SSA_USER_ROLE" -description="Schema small instance service template" -input_file="data:schema_service.json"
Validation error(s) occurred. Resolve these and try again.

So looking at the ../gc_inst/em/EMGC_OMS1/sysman/log/emoms.log , I saw that in my JSON file, I was missing the workload information in it

[email protected] [emrep] /home/oracle
oracle $ vi /u02/app/oracle/gc_inst/em/EMGC_OMS1/sysman/log/emoms.log
...
2015-09-29 19:41:51,428 [EMUI_19_41_49_/console/cli] ERROR handler.SchaasServiceTemplateHandler logp.251 - State flow message : Create at least one workload size in order to complete this service template.
...

Once I corrected this, I was able to create the service template without any issue

[email protected] [emrep] /home/oracle
oracle $ emcli create_service_template -name="EMPTY_SCHEMA_SERVICE_TEMPLATE" -service_family="DBAAS" -service_type="SCHEMA" -pool_target_type="schaas_pool" -software_pools="SCHEMA_POOL" -roles="SSA_USER_ROLE" -description="Schema small instance service template." -input_file="data:schema_service.json"
Service Template "EMPTY_SCHEMA_SERVICE_TEMPLATE" created successfully.

Here you will find an example of the JSON file I used for creating the Schema Service Template

Conclusion
Just be aware that you need to create a workload for your service template while creating it.