SQL Error: Cannot get the result set metadata [message #1750083] |
Thu, 15 December 2016 21:54 |
Sammy Ibrahim Messages: 3 Registered: December 2016 |
Junior Member |
|
|
Hello everyone,
I have the following query..but it's not returning a result set.
SELECT CLIENT.CLIENT_001 AS CLIENT_CODE, CLIENT.CLIENT_002 AS CLIENT_NAME,PROD.M_PROD_002 AS PRODUCT_CODE, PROD.M_PROD_003 AS PRODUCT_DESCRIPTION, PROD.M_PROD_004 AS SKU, QTY.PRODQTY05 AS ON_HAND, QTY.PRODQTY30 AS AVAILABLE, QTY.PRODQTY06 AS GROSS_WEIGHT, QTY.PRODQTY07 AS NET_WEIGHT, QTY.PRODQTY25 AS CUBE
FROM
M.PW_CLIENT_L1 AS CLIENT JOIN M.PW_M_PROD_L1 AS PROD ON CLIENT.CLIENT_001 = PROD.M_PROD_001 JOIN M.PW_PROD_QTY_L1 AS QTY ON PROD.M_PROD_001 = QTY.PRODQTY01 AND PROD.M_PROD_002 = QTY.PRODQTY02
WHERE
QTY.PRODQTY03 <> ' ' AND QTY.PRODQTY04 = ' '
GROUP BY
CLIENT.CLIENT_001, PROD.M_PROD_002
ORDER BY
CLIENT_CODE, PRODUCT_CODE
I get the following error after I run this query...
org.eclipse.birt.data.engine.odaconsumer.OdaDataException: Cannot get the result set metadata.
org.eclipse.birt.report.data.oda.jdbc.JDBCException: SQL statement does not return a ResultSet object.
SQL error #1:An expression starting with "PRODQTY25" specified in a SELECT clause, HAVING clause, or ORDER BY clause is not specified in the GROUP BY clause or it is in a SELECT clause, HAVING clause, or ORDER BY clause with a column function and no GROUP BY clause is specified.. SQLCODE=-119, SQLSTATE=42803, DRIVER=3.68.61
SQL error #2:An error occurred during implicit system action type "2". Information returned for the error includes SQLCODE "-119", SQLSTATE "42803" and message tokens "PRODQTY25".. SQLCODE=-727, SQLSTATE=56098, DRIVER=3.68.61
;
|
|
|
Powered by
FUDForum. Page generated in 0.02574 seconds