The transition to NetApp MS Azure AD B2C is complete. If you missed the pre-registration, you will be invited to reigister at next log in.
Please note that access to your NetApp data may take up to 1 hour.
To learn more, read the FAQ and watch the video.
Need assistance? Complete this form and select “Registration Issue” as the Feedback Category.

Active IQ Unified Manager Discussions

Unable to create Cache Queries in WFA

SHYAMVOLVO

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

Hi,

 

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

 

SELECT snapshot.volumeId AS volumeid ...

 

 

Marcus

SHYAMVOLVO

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

 
 

marcusgross

Hi,

 

the error is not related to an empty tablespace.

 

In my DB, netapp_model_view.snapshot is emtpy too.

 

Marcus

rkiran

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

Announcements
NetApp on Discord Image

We're on Discord, are you?

Live Chat, Watch Parties, and More!

Explore Banner

Meet Explore, NetApp’s digital sales platform

Engage digitally throughout the sales process, from product discovery to configuration, and handle all your post-purchase needs.

NetApp Insights to Action
I2A Banner
Public