Skip to main content


Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » BIRT » SQL Error: Cannot get the result set metadata(SQL Query returning an exception about not being able to get the result set metadata)
SQL Error: Cannot get the result set metadata [message #1750083] Thu, 15 December 2016 21:54
Sammy Ibrahim is currently offline Sammy IbrahimFriend
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
;
Previous Topic:Use of Birt Data Engine Api
Next Topic:Cross Tab Visibility
Goto Forum:
  


Current Time: Mon Dec 09 10:07:20 GMT 2019

Powered by FUDForum. Page generated in 0.01512 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software

Back to the top