2 Replies Latest reply on Jul 21, 2014 9:51 AM by Steven Hawkins

    Have physical table with Native query errors with TEIID11020

    virtualdatabase Apprentice

      I've created a number of physical tables utilizing native query (Oracle).

      However, in my most recent I am getting the following error.

      What should I look for?

       

      Error: TEIID11020 no alias found on RRD_GEOSPATIAL_COMPLETE. When native query is being used, then alias name must be defined for table in the query.

      SQLState:  38000

      ErrorCode: 0

       

      Thanks!