Teiid 'Error Executing Statements' on join query

[sarvesh723]

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.

[biaobiaoqi]

I've succeed in processing a join SQL cross a JDBC data source  and csv data source in Teiid Designer.

Could you please show more details?

[rareddy]

This error external to Teiid. You need to figure out what error means by

Error Code: 1906510

in Composite Source, or eclipse.

Ramesh..

[shawkins]

You can also simply things by just issuing the query shown above directly against the source.  It may simply turn out to be an unsupported syntax issue.