topic Re: WFA - Create Custom Cache Query in Active IQ Unified Manager Discussions

WFA - Create Custom Cache Query

sheelnidhig — Wed, 04 Jun 2025 18:05:27 GMT

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.

Any Help would be great,

Thanks,

Sheel

Re: WFA - Create Custom Cache Query

karale — Wed, 14 Dec 2016 15:33:43 GMT

id is mandatory to return.

Change your query to add following

SELECT
NULL AS id,

It should work.

Re: WFA - Create Custom Cache Query

shailaja — Mon, 19 Dec 2016 05:16:50 GMT

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