2016-07-01 01:34 AM - edited 2016-07-01 01:35 AM
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 :-
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 ..
2016-07-01 05:12 AM
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 ..
2016-07-01 11:41 AM
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: