<?xml version="1.0" encoding="UTF-8"?>
<rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:taxo="http://purl.org/rss/1.0/modules/taxonomy/" version="2.0">
  <channel>
    <title>topic Can't clone the Create Volume Workflow in Active IQ Unified Manager Discussions</title>
    <link>https://community.netapp.com/t5/Active-IQ-Unified-Manager-Discussions/Can-t-clone-the-Create-Volume-Workflow/m-p/140144#M25589</link>
    <description>&lt;P&gt;I am just starting to work on WFA scripting. My first task is to script volume creation so it conforms to our standards.&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;Part of&amp;nbsp;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.&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;&lt;SPAN&gt;---------------------------------------------------------------------------------------------&lt;/SPAN&gt;&lt;/P&gt;
&lt;P&gt;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&lt;BR /&gt;cm_storage.volume&lt;BR /&gt;SELECT&lt;BR /&gt;NULL AS id,&lt;BR /&gt;vs.id AS vserv' at line 4&lt;BR /&gt;Query is:&lt;BR /&gt;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...&lt;BR /&gt;COMMENT 'cm_storage.Create volume (EBSCO)'&lt;BR /&gt;BEGIN&lt;BR /&gt;# Create a new volume INSERT...&lt;/P&gt;
&lt;P&gt;---------------------------------------------------------------------------------------------&lt;/P&gt;</description>
    <pubDate>Wed, 04 Jun 2025 13:43:38 GMT</pubDate>
    <dc:creator>TMADOCTHOMAS</dc:creator>
    <dc:date>2025-06-04T13:43:38Z</dc:date>
    <item>
      <title>Can't clone the Create Volume Workflow</title>
      <link>https://community.netapp.com/t5/Active-IQ-Unified-Manager-Discussions/Can-t-clone-the-Create-Volume-Workflow/m-p/140144#M25589</link>
      <description>&lt;P&gt;I am just starting to work on WFA scripting. My first task is to script volume creation so it conforms to our standards.&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;Part of&amp;nbsp;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.&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;&lt;SPAN&gt;---------------------------------------------------------------------------------------------&lt;/SPAN&gt;&lt;/P&gt;
&lt;P&gt;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&lt;BR /&gt;cm_storage.volume&lt;BR /&gt;SELECT&lt;BR /&gt;NULL AS id,&lt;BR /&gt;vs.id AS vserv' at line 4&lt;BR /&gt;Query is:&lt;BR /&gt;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...&lt;BR /&gt;COMMENT 'cm_storage.Create volume (EBSCO)'&lt;BR /&gt;BEGIN&lt;BR /&gt;# Create a new volume INSERT...&lt;/P&gt;
&lt;P&gt;---------------------------------------------------------------------------------------------&lt;/P&gt;</description>
      <pubDate>Wed, 04 Jun 2025 13:43:38 GMT</pubDate>
      <guid>https://community.netapp.com/t5/Active-IQ-Unified-Manager-Discussions/Can-t-clone-the-Create-Volume-Workflow/m-p/140144#M25589</guid>
      <dc:creator>TMADOCTHOMAS</dc:creator>
      <dc:date>2025-06-04T13:43:38Z</dc:date>
    </item>
    <item>
      <title>Re: Can't clone the Create Volume Workflow</title>
      <link>https://community.netapp.com/t5/Active-IQ-Unified-Manager-Discussions/Can-t-clone-the-Create-Volume-Workflow/m-p/140439#M25652</link>
      <description>&lt;P&gt;&lt;SPAN&gt;Problem solved. I upgraded to the new cdot 1.5.0 pack and was able to clone "Create Volume" successfully.&lt;/SPAN&gt;&lt;/P&gt;</description>
      <pubDate>Tue, 22 May 2018 18:52:53 GMT</pubDate>
      <guid>https://community.netapp.com/t5/Active-IQ-Unified-Manager-Discussions/Can-t-clone-the-Create-Volume-Workflow/m-p/140439#M25652</guid>
      <dc:creator>TMADOCTHOMAS</dc:creator>
      <dc:date>2018-05-22T18:52:53Z</dc:date>
    </item>
  </channel>
</rss>

