The community will be undergoing maintenance soon, requiring Read-Only mode. Click to learn more.

Active IQ Unified Manager Discussions

WFA - Create Custom Cache Query

sheelnidhig

Hello Guys,

 

I am trying to create a custom Cache query to have Annotation view from OCUM 7.0 imported in WFA 4.0, so i started with a very simple Cache Query but its coming up with an error.

I hace created a Dictionary Item under CM_Storage Schema and selected OCUM 6.3/6.4 as datasource type.

 

 

Cache Query Error.jpg

 

Any Help would be great,

 

Thanks,

Sheel

2 REPLIES 2

karale

id is mandatory to return.

 

Change your query to add following

 

SELECT
NULL AS id,

 

It should work.

 

shailaja

To add to it:

 

In general, it is good to see the contents of the tab "Create table SQL". That shows the structure of the cache table WFA will create, into which your SQL query should populate the data.

 

Thanks,

Shailaja

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