0 Replies Latest reply on Jul 2, 2014 7:55 PM by kako.hiroshi

    How can I set up a group(virtual group?) in to materialized view definition?

    kako.hiroshi

      Hi there, I am new to use Data Virtualization

      using

      JBoss Developer Studio 7.1.1GA

      Teiid Designer 8.3.2

      JBoss EAP 6.1

       

      I have the error below when I try to preview relational view data that materialized property set to true.

       

      19:20:58,821 WARN  [org.teiid.PROCESSOR] (Worker34_QueryProcessorQueue79) TEIID30020 Processing exception for request C5msvIgY0rJ8.0 'Group does not exist: DB2Tables.ACT'. Originally QueryPlannerException ResolverUtil.java:814. Enable more detailed logging to see the entire stacktrace.

       

      Actually, I changed materialized property to true from false by Action Set daialog  -> preview Data -> select view -> properties

      Before I changed it, I could see a result of preview.

      Relateional view table is sourced by just one table from DB2 datasource which is sample DB.

       

      I have a problem with defining materialized view, and I do no understand what group in error mean.

      How can I define materialized view and preview it?

       

      Please help me.

      Any information would be appriciated.

       

      Bye the way, Thank you Ramesh for telling me right place to post this question.