Untitled
unknown
plain_text
2 years ago
1.9 kB
1
Indexable
Never
An error occurred while communicating with the Incorta Connector by Incorta data source 'sales_business_Schema (SALES_BUSINESS_SCHEMA.sales_business_Schema) (bi_test)' Bad Connection: Tableau could not connect to the data source. Error Code: FAB9A2C5 ERROR: Unsupported feature:[" New_ View"" AMOUNT_ SOLD"," New_ View"" COST_ OF_ GOODS"] must appear in GROUP BY[ Unsupported Operation Exception: Unsupported feature:[" New_ View"" AMOUNT_ SOLD"," New_ View"" COST_ OF_ GOODS"] must appear in GROUP BY]. Unsupported feature:[" New_ View"" AMOUNT_ SOLD"," New_ View"" COST_ OF_ GOODS"] must appear in GROUP BY Detail: java.sql.SQLException: Unsupported feature: ["New_View"."AMOUNT_SOLD", "New_View"."COST_OF_GOODS"] must appear in GROUP BY [java.lang.UnsupportedOperationException: Unsupported feature: ["New_View"."AMOUNT_SOLD", "New_View"."COST_OF_GOODS"] must appear in GROUP BY] at com.incorta.sqlinterface.exception.ErrorCode.toSQLException(ErrorCode.java:63) at com.incorta.sqlinterface.exception.BridgeException.get(BridgeException.java:58) at com.incorta.sqlinterface.exception.BridgeException.convert(BridgeException.java:135) at com.incorta.sqlinterface.exception.BridgeException.toSQLException(BridgeException.java:108) at com.incorta.sqlinterface.net.tra Connector Class: incorta_jdbc, Version: 1.0.0 SELECT SUM("New_View"."AMOUNT_SOLD") AS "sum:AMOUNT_SOLD:ok", SUM("New_View"."COST_OF_GOODS") AS "sum:COST_OF_GOODS:ok", CORR("New_View"."AMOUNT_SOLD", "New_View"."COST_OF_GOODS") AS "usr:Calculation_140456073647910928:ok", COVAR_SAMP("New_View"."COST_OF_GOODS", "New_View"."AMOUNT_SOLD") AS "usr:Calculation_140456073654411282:ok", COVAR_POP("New_View"."AMOUNT_SOLD", "New_View"."COST_OF_GOODS") AS "usr:Calculation_140456073655603219:ok", CAST(TRUNC(EXTRACT(YEAR FROM "New_View"."TIME_ID")) AS INTEGER) AS "yr:TIME_ID:ok" FROM "Sales_BSCH"."New_View" "New_View" GROUP BY 6