Subscribe

Unable to create Cache Queries in WFA

[ Edited ]

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

 

Capture.JPG

Re: Unable to create Cache Queries in WFA

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

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 ..

 

 

BR

Shyam

 
 

Re: Unable to create Cache Queries in WFA

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/...

Re: Unable to create Cache Queries in WFA

Hi,

 

the error is not related to an empty tablespace.

 

In my DB, netapp_model_view.snapshot is emtpy too.

 

Marcus