Active IQ Unified Manager Discussions

Unable to create Cache Queries in WFA

SHYAMVOLVO
2,921 Views

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

4 REPLIES 4

marcusgross
2,907 Views

Hi,

 

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

 

SELECT snapshot.volumeId AS volumeid ...

 

 

Marcus

SHYAMVOLVO
2,896 Views

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

 
 

rkiran
2,859 Views

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

marcusgross
2,822 Views

Hi,

 

the error is not related to an empty tablespace.

 

In my DB, netapp_model_view.snapshot is emtpy too.

 

Marcus

Public