This post is more than 5 years old
14 Posts
0
1212
November 14th, 2008 09:00
StorageScope 6.1 Sort and Subtotal functions failing in Query Builder
Hi everyone,
We have created a StorageScope Custom Query which assembles two columns: one being the LUN size and the other a Custom Field created in Control Centre providing the Storage Tier ( of which we have defined seven, but that's another story ).
The aim is eventually to cut and paste the SQL into a customised dashboard snapshot and display a pie chart with the seven storage tiers as slices.
The query returns 114 'pages' ( approx 5000 rows ) and works as expected.
If we run the query without sorts or subtotals, the rows are displayed as expected.
If we then sort on the Custom Field ( which contains the values 1 through 7 but I assume are treated as strings rather than integers ) the output is identical to that without the sort.
This suggests to us that the sort isn't working properly; maybe because 5000 rows is too great a task ( sounds unlikely ).
Furthermore, if we then try to subtotal on the Custom Field, we receive the "Error was encountered running the query" message.
This either means subtotalling is also not working or that, without a correctly sorted query, it simply can't subtotal properly.
We speculated that the sorting / subtotalling functions were falling foul of the Custom Field so we replaced it with a standard field - the Array Name - and the result was exactly the same; which we believe exonerates the Custom Field.
We'll raise a Service Request soon, but in the meantime has anyone experienced anything similar ?
Best wishes to everyone - have a nice weekend.
Nick Buckley
Group IT Storage Manager,
Atradius,
Cardiff,
UK
We have created a StorageScope Custom Query which assembles two columns: one being the LUN size and the other a Custom Field created in Control Centre providing the Storage Tier ( of which we have defined seven, but that's another story ).
The aim is eventually to cut and paste the SQL into a customised dashboard snapshot and display a pie chart with the seven storage tiers as slices.
The query returns 114 'pages' ( approx 5000 rows ) and works as expected.
If we run the query without sorts or subtotals, the rows are displayed as expected.
If we then sort on the Custom Field ( which contains the values 1 through 7 but I assume are treated as strings rather than integers ) the output is identical to that without the sort.
This suggests to us that the sort isn't working properly; maybe because 5000 rows is too great a task ( sounds unlikely ).
Furthermore, if we then try to subtotal on the Custom Field, we receive the "Error was encountered running the query" message.
This either means subtotalling is also not working or that, without a correctly sorted query, it simply can't subtotal properly.
We speculated that the sorting / subtotalling functions were falling foul of the Custom Field so we replaced it with a standard field - the Array Name - and the result was exactly the same; which we believe exonerates the Custom Field.
We'll raise a Service Request soon, but in the meantime has anyone experienced anything similar ?
Best wishes to everyone - have a nice weekend.
Nick Buckley
Group IT Storage Manager,
Atradius,
Cardiff,
UK
No Events found!
malisetty
21 Posts
0
November 17th, 2008 03:00
I have seen the same issue in ECC6.1,I tried to create a new query with required columns and run the Query with Subtotal By option and then it worked.
If that doesn't help it's a good time to open an SR.
Details from Storagescope help.
Subtotal By ¿ the depth at which you want the query results subtotaled. For example, if you select the column at Sort Order 1, only that column will be subtotaled. If you select the column at Sort Order 3, the query results will be subtotaled on the columns at Sort Orders 1, 2, and 3.
Note: Query results should only be subtotaled on string-based columns, such as ArrayName. Do not subtotal on numeric, counting or capacity-based columns, such as # Disks or Physical Capacity (KB).
Regards
Pawan
cincystorage
2 Intern
•
467 Posts
1
November 14th, 2008 10:00
If you can't find anything, i'd connect directly to the oracle database and run your query. See if it gives an error doing that.
seth_silverman
43 Posts
1
November 14th, 2008 10:00
Hopefully, you have some working knowledge of SQL if you are going to tweak the SQL.
AnuShivnath
41 Posts
0
November 18th, 2008 05:00
Engineering will work quickly towards releasing a fix for the subtotaling functionality.
Major Goat
14 Posts
0
November 18th, 2008 05:00
You emphasise new query.
Are you suggesting that deriving a query from an existing one using the copy button may be introducing a problem ?
Many thanks for your interest,
Nick