I have a customer running a Balance POC that has hit a problem with Balance collecting data. Below is his explanation.
My first guess is that the "@" sign in the lun and qtree names is causing a problem, but I'm looking for anyone who may have encountered this before. Any ideas?
Phil
We finally managed to get the OnCommand Balance appliance installed.
We don’t seem to be able to get very far with the product however.
We have been using Syncsorts backup product since the beginning of this year and it likes to create some … verbose(?) LUN and QTREE names.
These names seem to be giving the OnCommand Balance SQL a bit of a hard time and Balance does not seem to be able to ignore or get around the issue, so it cannot collect any data from the NetApp Storage arrays.
OnCommand Balance Collection Error:
Storage System Summary: sef-netapp01
Open console Refresh Edit
Storage System Nickname:
sef-netapp01
FQDN/IP Address: 10.126.10.20
Storage System Type: NetApp FAS Partners IP Address: 10.126.10.22
You appear to have whitespace in your mountpoint names which would confuse mysql into interpreting a mountpoint as several tokens instead of a single token. Can you confirm that this is indeed the case?
In any event if you can open a support case then we can look at the logs and raw data and go from there.
Re: Balance throws SQL error when collecting array data
I see the problem then. The '[' and ']' characters are being treated as part of a regular expression pattern match, instead of literal characters. I'll go ahead and put in code to escape these special characters if they appear in the path, that should take care of this problem.
Code freeze for the 4.1.1.1 patch release is COB tomorrow (Sept 4th), and we plan to release around Sept 19th at which point you can download from the NOW site.
Re: Balance throws SQL error when collecting array data
Yes it is, although in the example above it isn't treated as a session variable in the context given. Still it can't hurt to be safe so I've gone ahead and escape the '@' symbol as well. I ran a test SQL query escaping all five of these characters against the example you provided and it works, so we'll go with that.
Re: Balance throws SQL error when collecting array data