Active IQ Unified Manager Discussions

WFA - Maximum of 255 characters for Exports Rule Clientmatch

Livewire18
2,502 Views

We have a few sites where we have recently learned that the NAS admins at the site have been placing multiple server names in the clientmatch for the export rule. This is considered normal and allowed by NetApp, but we usually place one server per rule for easy edits/modifications. The problem with using a comma separate list in clientmatch is that WFA only allows up to 255 characters (varchar255 per the database for that field). Is there any way to modify this to allow for larger clientmatch lists to be used in WFA, or should we just suggest they move their comma separated lists to individual rules?

 

The database field in question is cm_storage.export_rule.clientmatch

1 ACCEPTED SOLUTION

mbeattie
2,436 Views

Hi,

 

The "cm_storage" schema for the "export_rule" dictionary limits the "clientmatch" to a string of 255 characters. As it is a "certified" dictionary object you can not edit it, you'd have to clone it and create your own datasource. I would advise you raise a support case to ensure a bug (BURT) is raised so WFA engineering may consider increasing the maximum string length in a future release (to match the string length in ONTAP).

 

In the meantime you might consider generating a report from OCUM to see how widespread the issue is in your environment. EG:

 

SELECT
   cluster.name AS 'cluster_name',
   vserver.name AS 'vserver_name',
   export_policy.name AS 'export_policy',
   export_rule.clientMatch AS 'client_match',
   CHAR_LENGTH(export_rule.clientMatch) AS 'rule_length'
FROM
   netapp_model_view.export_rule,
   netapp_model_view.export_policy,
   netapp_model_view.vserver,
   netapp_model_view.cluster
WHERE
   export_rule.exportPolicyId = export_policy.objid
AND
   export_policy.vserverId = vserver.objid
AND
   vserver.clusterId = cluster.objid
AND
   CHAR_LENGTH(export_rule.clientMatch) >= 255
ORDER BY
   rule_length DESC

Once you know the extent of the issue you can determine if automation is required to update the export rules with individual client match values rather than a comma delimited string.

 

/Matt

If this post resolved your issue, help others by selecting ACCEPT AS SOLUTION or adding a KUDO.

View solution in original post

2 REPLIES 2

mbeattie
2,437 Views

Hi,

 

The "cm_storage" schema for the "export_rule" dictionary limits the "clientmatch" to a string of 255 characters. As it is a "certified" dictionary object you can not edit it, you'd have to clone it and create your own datasource. I would advise you raise a support case to ensure a bug (BURT) is raised so WFA engineering may consider increasing the maximum string length in a future release (to match the string length in ONTAP).

 

In the meantime you might consider generating a report from OCUM to see how widespread the issue is in your environment. EG:

 

SELECT
   cluster.name AS 'cluster_name',
   vserver.name AS 'vserver_name',
   export_policy.name AS 'export_policy',
   export_rule.clientMatch AS 'client_match',
   CHAR_LENGTH(export_rule.clientMatch) AS 'rule_length'
FROM
   netapp_model_view.export_rule,
   netapp_model_view.export_policy,
   netapp_model_view.vserver,
   netapp_model_view.cluster
WHERE
   export_rule.exportPolicyId = export_policy.objid
AND
   export_policy.vserverId = vserver.objid
AND
   vserver.clusterId = cluster.objid
AND
   CHAR_LENGTH(export_rule.clientMatch) >= 255
ORDER BY
   rule_length DESC

Once you know the extent of the issue you can determine if automation is required to update the export rules with individual client match values rather than a comma delimited string.

 

/Matt

If this post resolved your issue, help others by selecting ACCEPT AS SOLUTION or adding a KUDO.

Livewire18
2,396 Views

Thanks Matt, that is what I figured. Just wanted to make sure there wasn't something on my end. I will open a case to log it and hopefully in the next release we can this resolved. 

Public