3 Replies Latest reply on Dec 2, 2013 9:07 AM by Steven Hawkins

    Teiid 'Error Executing Statements' on join query

    Sarvesh Mali Newbie

      I am writing the following join query in Teiid designer view to combine two different JDBC data sources (Composite Single Source and SQL Server)

       

      QUERY

      SELECT * FROM

        Composite_SS.dm_DailyProd_vin AS SS LEFT OUTER JOIN DSPMSrc.DS_WELL_VW AS W ON SS.Well_Name = W.UWI

       

      ERROR:

      Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.4.1.v20121003-ad44345): org.eclipse.persistence.exceptions.DatabaseException

      Internal Exception: org.teiid.jdbc.TeiidSQLException: TEIID30504 Composite_SS_source: 1906510 TEIID11008:TEIID11004 Error executing statement(s): [Prepared Values: [] SQL: SELECT g_0.Well Name AS c_0 FROM "SandBox"."Wi_Dat"."dm_DailyProd_vin" AS g_0 ORDER BY c_0]

      Error Code: 1906510

       

      Please advise on how to resolve this issue. I have even tried a similar query with two SQL Server sources but still get the error.