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
