Active IQ Unified Manager Discussions

Can't clone the Create Volume Workflow

TMADOCTHOMAS
2,228 Views

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...

---------------------------------------------------------------------------------------------

1 ACCEPTED SOLUTION

TMADOCTHOMAS
2,147 Views

Problem solved. I upgraded to the new cdot 1.5.0 pack and was able to clone "Create Volume" successfully.

View solution in original post

1 REPLY 1

TMADOCTHOMAS
2,148 Views

Problem solved. I upgraded to the new cdot 1.5.0 pack and was able to clone "Create Volume" successfully.

Public