topic Unable to create Cache Queries in WFA in Active IQ Unified Manager Discussions

Unable to create Cache Queries in WFA

SHYAMVOLVO — Wed, 04 Jun 2025 20:08:32 GMT

Hi team,

I am trying to create a Dictionary object and tis related Cache query to pull snapshot details from Cluster mode. but while creating cache queries its throwing error " Property order does not match the order of select columns in the related cache query. " .

could please help what is the problem .

my create table command for dictionary is :-

CREATE TABLE `cm_storage`.`snapshot` (
`id` INT NOT NULL AUTO_INCREMENT ,
`volumeid` INT NOT NULL ,
`createtime` DATETIME NOT NULL ,
`snapshotname` VARCHAR(255) NOT NULL ,
`cumulativepercentageoftotalblocks` DOUBLE DEFAULT NULL ,
`vserverid` INT DEFAULT NULL ,
PRIMARY KEY (`id`)
);

SQL select query is :-

Select
snapshot.objid,
snapshot.volumeId,
snapshot.createTime,
snapshot.name,
snapshot.cumulativePercentageOfTotalBlocks,
snapshot.vserverId
From
netapp_model_view.snapshot snapshot

Getting error :-

DictionaryEntry 'cm_storage.Snapshot': Property order does not match the order of select columns in the related cache query.
Mismatch at property name: id
DictionaryEntry properties :
id[Type: Integer], VolumeID[Type: Integer], createTime[Type: DateTime], SnapshotName[Type: String], cumulativepercentageoftotalblocks[Type: Double], VserverID[Type: Integer],
Cache query columns:
[objid, volumeId, createTime, name, cumulativePercentageOfTotalBlocks, vserverId]

Please find the screenshot for more details ..

Thanks

Shyam

Re: Unable to create Cache Queries in WFA

marcusgross — Fri, 01 Jul 2016 10:06:50 GMT

Hi,

the values from the select statement have to match the names of the created table.

SELECT snapshot.volumeId AS volumeid ...

Marcus

Re: Unable to create Cache Queries in WFA

SHYAMVOLVO — Fri, 01 Jul 2016 12:12:35 GMT

Hello Marcus,

thanks for help, I don't see that error but look like its not aquiring data from OnCommand Unified Manager 6.3 ..

when troubleshoot I found that, I can see all the snapshot details on OCUM GUI but its not visible on " netapp_model_view.snapshot " view ..

can you help me how to sort this out ..

Shyam

Re: Unable to create Cache Queries in WFA

rkiran — Fri, 01 Jul 2016 18:41:53 GMT

Hi,

Seems like OCUM does not database, and instead directly uses APIs to get the snapshot information. There is a similar link about obtaining snapshot information from WFA:

http://community.netapp.com/t5/OnCommand-Storage-Management-Software-Articles-and-Resources/WFA-2-1-CM-Snapshot-support-with-Unified-Manager-6-0/ta-p/86568

Re: Unable to create Cache Queries in WFA

marcusgross — Mon, 04 Jul 2016 15:24:03 GMT

Hi,

the error is not related to an empty tablespace.

In my DB, netapp_model_view.snapshot is emtpy too.

Marcus