No ResultSet set was produced

, ,
1

I am facing this error in a IC

‘Adapter’: ‘JDBC’

‘Error Category’: ‘Adapter’

‘Error Text’: ‘(316) Could not execute SQL statement “SELECT t1.SP_No, t1.stores_Date, t1.measured_TI, t1.measured_SDR, t1.measured_weight, t1.error_code, t1.error_description, t1.business_stream, t1.wm_rowid FROM WMB_WSC_JDBC01_WSCNotification t1 ORDER BY wm_rowid”.
(HY000/0) [Microsoft][SQLServer 2000 Driver for JDBC]No ResultSet set was produced.
java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]No ResultSet set was produced.’

2

Try to use Custom SQL for the same.
if u still face the problem, pls try to explain it little more.
Custom SQL should work.