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

    Teiid 'Error Executing Statements' on join query


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




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



      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.