1 Reply Latest reply on Sep 21, 2010 4:46 PM by jdoyle

    Error when CP contains only synonyms

    dvenus
    dvenus Sep 21, 2010 3:44 PM

      Hi!

       

      I am rather new to TEIID and am trying to use TEIID Designer 7.1 and TEIID database 7.1. I am trying to create a VDB that is connected to an Oracle 10g database. The user that I am connected to only has synonyms to other users tables. All of the synoyms are seen but show with an error. The error I am getting is:

       

      "The Base Table must reference 1 or more columns there are none"

       

      I did set the connection profile to only look at the user's synonyms.

       

      What am I doing wrong?

       

      Thanks!

       

      Dave Venus