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.»
[bash]
oracle@em12cr5.localdomain [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.
oracle@em12cr5.localdomain [emrep] /home/oracle
oracle $
[/bash]
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
[bash]
oracle@em12cr5.localdomain [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.

[/bash]
Once I corrected this, I was able to create the service template without any issue
[bash]
oracle@em12cr5.localdomain [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.
[/bash]
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.