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

    Error when CP contains only synonyms

    David Venus Newbie



      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?




      Dave Venus