Untitled
unknown
plain_text
3 years ago
1.9 kB
7
Indexable
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 6Editor is loading...