I am just starting to work on WFA scripting. My first task is to script volume creation so it conforms to our standards.
Part of our standards include snapmirror job creation for most volumes. I was able to successfully clone the "Create SnapMirror" command so I can customize it. However, I cannot clone the "Create Volume" command. Every time I try I get the following error. Any ideas? We are on WFA version 4.2, cdot WFA pack 1.4.2.
---------------------------------------------------------------------------------------------
Validation of the reservation failed for the command : org.hibernate.exception.SQLGrammarException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'INTO
cm_storage.volume
SELECT
NULL AS id,
vs.id AS vserv' at line 4
Query is:
sql : 'CREATE PROCEDURE wfa.reservation_dummy_6a265dfc_f9fc_427d_910d_afc75605e06c(AQOSPolicyGroupName varchar(255),AggregateList varchar(255),AggregateListMultiplier int,AggregateName varchar(255),AntivirusOnAccessPolicy varchar(255),AutoDeleteOptions varchar(255),AutosizeIncrementSize bigint,AutosizeMaxSize bigint,AutosizeMode varchar(255),Cluster varchar(255),Compression varchar(255),Deduplication BOOL,EfficiencyPolicy varchar(255),EncryptVolume BOOL,ExportPolicy varchar(255),ExtendedVolum...
COMMENT 'cm_storage.Create volume (EBSCO)'
BEGIN
# Create a new volume INSERT...
---------------------------------------------------------------------------------------------
