Active IQ Unified Manager Discussions

WFA - Create Custom Cache Query

sheelnidhig
2,236 Views

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
2,223 Views

id is mandatory to return.

 

Change your query to add following

 

SELECT
NULL AS id,

 

It should work.

 

shailaja
2,173 Views

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

Public