<?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 volHistory tables are not filled anymore, while fine for aggrHistory in Active IQ Unified Manager Discussions</title>
    <link>https://community.netapp.com/t5/Active-IQ-Unified-Manager-Discussions/volHistory-tables-are-not-filled-anymore-while-fine-for-aggrHistory/m-p/40479#M8282</link>
    <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;Dear all, &lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;this is my first issue I'm highlighting in this forum, so please apologize that I'm a newbie and not - yet! - a Netapp expert.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;I'm managing capacity trends and calculate the amount of used space on volume level using &lt;SPAN style="font-family: 'Courier New'; color: red; font-size: 9pt;"&gt;&lt;SPAN style="color: #000000;"&gt;volHistoryYearView&lt;/SPAN&gt;.&lt;/SPAN&gt;&lt;SPAN style="font-family: 'Courier New'; font-size: 9pt;"&gt;volEffectiveDataSpaceUsedSum&lt;/SPAN&gt; to avoid the influence of deduplication. &lt;/P&gt;&lt;P&gt;This data is missing for the recent months for some controllers, while the aggregate histories are still filled.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;To get the committed space I stay on aggregate level and get fine figures:&lt;SPAN style="font-size: 10pt;"&gt; &lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;A&gt;&lt;/A&gt;&lt;A&gt;&lt;/A&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;DIV&gt;&lt;SPAN style="font-size: 10pt;"&gt;&lt;P&gt;Query:&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;/SPAN&gt;&lt;/DIV&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&lt;SPAN style="font-size: 10pt;"&gt;&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;select objFullName,SUBSTR(timestamp,1,7) as month,max(ah.dfKBytesTotalCommittedSum/sampleCount) from aggrHistoryYearView ah join dfmgroup.objectView on ah.aggrId=objectView.objId inner join aggregateView a on a.aggrId = ah.aggrId where objFullName like 'MYFILER:MYAggregate' group by objFullName,month,aggrTotalCommittedSpaceKB order by month&lt;/P&gt;&lt;P style="padding-left: 30px;"&gt;&lt;SPAN style="font-family: courier new,courier;"&gt;objFullName month max(aggrHistoryYear.dfKBytesTotalCommittedSum/aggrHistoryYear.sampleCount)&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;SPAN style="font-family: courier new,courier;"&gt;MYFILER:MYAggregate 2013-12 2956984320&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;SPAN style="font-family: courier new,courier;"&gt;MYFILER:MYAggregate 2014-01 3009413120&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;SPAN style="font-family: courier new,courier;"&gt;MYFILER:MYAggregate 2014-02 3009413120&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;SPAN style="font-family: courier new,courier;"&gt;MYFILER:MYAggregate 2014-03 3009413120&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;SPAN style="font-family: courier new,courier;"&gt;MYFILER:MYAggregate 2014-04 3009413804&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;SPAN style="font-family: courier new,courier;"&gt;MYFILER:MYAggregate 2014-05 3009413120&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P style="padding-left: 30px;"&gt;&lt;SPAN style="font-family: courier new,courier;"&gt;MYFILER:MYAggregate 2014-06 75591606797&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&lt;SPAN style="font-size: 10pt; font-family: courier new,courier;"&gt;&lt;SPAN id="mce_marker"&gt;&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;SPAN style="font-size: 10pt; font-family: courier new,courier;"&gt;﻿&lt;/SPAN&gt;&lt;SPAN style="font-family: Courier New;"&gt;Now I join the &lt;SPAN id="mce_marker"&gt;&lt;/SPAN&gt;volHistoryYearView via aggregateView.aggrId&lt;SPAN id="mce_marker"&gt;&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;A&gt;&lt;/A&gt; =&amp;gt; volumeView.volAggrId, volumeView.volId =&amp;gt; volHistoryYearView.volId&lt;/P&gt;&lt;P&gt;&lt;SPAN style="font-size: 10pt;"&gt;&lt;SPAN id="mce_marker"&gt;&lt;/SPAN&gt;And I get only ﻿results back until January 2014.&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;SPAN style="font-size: 10pt;"&gt;﻿&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;SPAN style="font-size: 10pt;"&gt;﻿&lt;/SPAN&gt;I'm not aware of any issues in January concerning the given controller, other controllers are managed fine, volHistory tables are managed, but for this controller it stopped and I have no idea why.&lt;/P&gt;&lt;P&gt;&lt;SPAN style="font-size: 10pt;"&gt;﻿&lt;/SPAN&gt;On DFM page (old style) it also looks strange: there I see the volume history only for the last month.&lt;/P&gt;&lt;P&gt;&lt;SPAN style="font-size: 10pt;"&gt;&lt;TABLE border="0" cellpadding="2" cellspacing="0" width="100%"&gt;&lt;TBODY&gt;&lt;TR class="fc1"&gt;&lt;TD align="left" class="subhead" colspan="2"&gt;About DataFabric® Manager server&lt;/TD&gt;&lt;/TR&gt;&lt;TR class="fc1"&gt;&lt;TD align="left" class="fc1"&gt;Version &lt;/TD&gt;&lt;TD align="left" class="fc1"&gt;5.0.2.10002 (5.0.2P1)&lt;/TD&gt;&lt;/TR&gt;&lt;/TBODY&gt;&lt;/TABLE&gt;﻿&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;SPAN style="font-size: 10pt;"&gt;﻿&lt;/SPAN&gt;Can anyone please give me a hint where to start searching for the issue? &lt;/P&gt;&lt;P&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; Are there any logs I can analyze? &lt;/P&gt;&lt;P&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; Any tests I can run? &lt;/P&gt;&lt;P&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; Any ideas how the DFM volume history issue might be linked to the database issue?&lt;/P&gt;&lt;P&gt;&lt;SPAN style="font-size: 10pt;"&gt;﻿&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;SPAN style="font-size: 10pt;"&gt;﻿&lt;/SPAN&gt;Thanks a lot for any hint!&lt;/P&gt;&lt;P&gt;&lt;SPAN style="font-size: 10pt;"&gt;﻿&lt;/SPAN&gt;Andi&lt;/P&gt;&lt;P&gt;&lt;SPAN style="font-size: 10pt;"&gt;﻿&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;SPAN style="font-size: 10pt;"&gt;﻿&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;SPAN style="font-size: 10pt;"&gt;﻿&lt;SPAN id="mce_marker"&gt;&lt;/SPAN&gt;&lt;SPAN id="mce_marker"&gt;&lt;/SPAN&gt;&lt;SPAN id="mce_marker"&gt;&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;SPAN style="font-family: Courier New;"&gt;&lt;SPAN id="mce_marker"&gt;&lt;/SPAN&gt;&lt;SPAN id="mce_marker"&gt;&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
    <pubDate>Thu, 05 Jun 2025 05:32:18 GMT</pubDate>
    <dc:creator>ANDREASWANSKE</dc:creator>
    <dc:date>2025-06-05T05:32:18Z</dc:date>
    <item>
      <title>volHistory tables are not filled anymore, while fine for aggrHistory</title>
      <link>https://community.netapp.com/t5/Active-IQ-Unified-Manager-Discussions/volHistory-tables-are-not-filled-anymore-while-fine-for-aggrHistory/m-p/40479#M8282</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;Dear all, &lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;this is my first issue I'm highlighting in this forum, so please apologize that I'm a newbie and not - yet! - a Netapp expert.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;I'm managing capacity trends and calculate the amount of used space on volume level using &lt;SPAN style="font-family: 'Courier New'; color: red; font-size: 9pt;"&gt;&lt;SPAN style="color: #000000;"&gt;volHistoryYearView&lt;/SPAN&gt;.&lt;/SPAN&gt;&lt;SPAN style="font-family: 'Courier New'; font-size: 9pt;"&gt;volEffectiveDataSpaceUsedSum&lt;/SPAN&gt; to avoid the influence of deduplication. &lt;/P&gt;&lt;P&gt;This data is missing for the recent months for some controllers, while the aggregate histories are still filled.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;To get the committed space I stay on aggregate level and get fine figures:&lt;SPAN style="font-size: 10pt;"&gt; &lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;A&gt;&lt;/A&gt;&lt;A&gt;&lt;/A&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;DIV&gt;&lt;SPAN style="font-size: 10pt;"&gt;&lt;P&gt;Query:&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;/SPAN&gt;&lt;/DIV&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&lt;SPAN style="font-size: 10pt;"&gt;&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;select objFullName,SUBSTR(timestamp,1,7) as month,max(ah.dfKBytesTotalCommittedSum/sampleCount) from aggrHistoryYearView ah join dfmgroup.objectView on ah.aggrId=objectView.objId inner join aggregateView a on a.aggrId = ah.aggrId where objFullName like 'MYFILER:MYAggregate' group by objFullName,month,aggrTotalCommittedSpaceKB order by month&lt;/P&gt;&lt;P style="padding-left: 30px;"&gt;&lt;SPAN style="font-family: courier new,courier;"&gt;objFullName month max(aggrHistoryYear.dfKBytesTotalCommittedSum/aggrHistoryYear.sampleCount)&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;SPAN style="font-family: courier new,courier;"&gt;MYFILER:MYAggregate 2013-12 2956984320&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;SPAN style="font-family: courier new,courier;"&gt;MYFILER:MYAggregate 2014-01 3009413120&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;SPAN style="font-family: courier new,courier;"&gt;MYFILER:MYAggregate 2014-02 3009413120&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;SPAN style="font-family: courier new,courier;"&gt;MYFILER:MYAggregate 2014-03 3009413120&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;SPAN style="font-family: courier new,courier;"&gt;MYFILER:MYAggregate 2014-04 3009413804&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;SPAN style="font-family: courier new,courier;"&gt;MYFILER:MYAggregate 2014-05 3009413120&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P style="padding-left: 30px;"&gt;&lt;SPAN style="font-family: courier new,courier;"&gt;MYFILER:MYAggregate 2014-06 75591606797&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&lt;SPAN style="font-size: 10pt; font-family: courier new,courier;"&gt;&lt;SPAN id="mce_marker"&gt;&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;SPAN style="font-size: 10pt; font-family: courier new,courier;"&gt;﻿&lt;/SPAN&gt;&lt;SPAN style="font-family: Courier New;"&gt;Now I join the &lt;SPAN id="mce_marker"&gt;&lt;/SPAN&gt;volHistoryYearView via aggregateView.aggrId&lt;SPAN id="mce_marker"&gt;&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;A&gt;&lt;/A&gt; =&amp;gt; volumeView.volAggrId, volumeView.volId =&amp;gt; volHistoryYearView.volId&lt;/P&gt;&lt;P&gt;&lt;SPAN style="font-size: 10pt;"&gt;&lt;SPAN id="mce_marker"&gt;&lt;/SPAN&gt;And I get only ﻿results back until January 2014.&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;SPAN style="font-size: 10pt;"&gt;﻿&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;SPAN style="font-size: 10pt;"&gt;﻿&lt;/SPAN&gt;I'm not aware of any issues in January concerning the given controller, other controllers are managed fine, volHistory tables are managed, but for this controller it stopped and I have no idea why.&lt;/P&gt;&lt;P&gt;&lt;SPAN style="font-size: 10pt;"&gt;﻿&lt;/SPAN&gt;On DFM page (old style) it also looks strange: there I see the volume history only for the last month.&lt;/P&gt;&lt;P&gt;&lt;SPAN style="font-size: 10pt;"&gt;&lt;TABLE border="0" cellpadding="2" cellspacing="0" width="100%"&gt;&lt;TBODY&gt;&lt;TR class="fc1"&gt;&lt;TD align="left" class="subhead" colspan="2"&gt;About DataFabric® Manager server&lt;/TD&gt;&lt;/TR&gt;&lt;TR class="fc1"&gt;&lt;TD align="left" class="fc1"&gt;Version &lt;/TD&gt;&lt;TD align="left" class="fc1"&gt;5.0.2.10002 (5.0.2P1)&lt;/TD&gt;&lt;/TR&gt;&lt;/TBODY&gt;&lt;/TABLE&gt;﻿&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;SPAN style="font-size: 10pt;"&gt;﻿&lt;/SPAN&gt;Can anyone please give me a hint where to start searching for the issue? &lt;/P&gt;&lt;P&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; Are there any logs I can analyze? &lt;/P&gt;&lt;P&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; Any tests I can run? &lt;/P&gt;&lt;P&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; Any ideas how the DFM volume history issue might be linked to the database issue?&lt;/P&gt;&lt;P&gt;&lt;SPAN style="font-size: 10pt;"&gt;﻿&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;SPAN style="font-size: 10pt;"&gt;﻿&lt;/SPAN&gt;Thanks a lot for any hint!&lt;/P&gt;&lt;P&gt;&lt;SPAN style="font-size: 10pt;"&gt;﻿&lt;/SPAN&gt;Andi&lt;/P&gt;&lt;P&gt;&lt;SPAN style="font-size: 10pt;"&gt;﻿&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;SPAN style="font-size: 10pt;"&gt;﻿&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;SPAN style="font-size: 10pt;"&gt;﻿&lt;SPAN id="mce_marker"&gt;&lt;/SPAN&gt;&lt;SPAN id="mce_marker"&gt;&lt;/SPAN&gt;&lt;SPAN id="mce_marker"&gt;&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;SPAN style="font-family: Courier New;"&gt;&lt;SPAN id="mce_marker"&gt;&lt;/SPAN&gt;&lt;SPAN id="mce_marker"&gt;&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Thu, 05 Jun 2025 05:32:18 GMT</pubDate>
      <guid>https://community.netapp.com/t5/Active-IQ-Unified-Manager-Discussions/volHistory-tables-are-not-filled-anymore-while-fine-for-aggrHistory/m-p/40479#M8282</guid>
      <dc:creator>ANDREASWANSKE</dc:creator>
      <dc:date>2025-06-05T05:32:18Z</dc:date>
    </item>
  </channel>
</rss>

