'So i am getting the ERROr related to SQL in jmeter
{"statusCode":500,"statusDescription":"Internal server error","status":"FAILED","userId":null,"role":null,"value":null,"errorMessage":"PreparedStatementCallback; bad SQL grammar [SELECT buc.class as class_id, count(distinct(buar.user_id)) as no_of_student_logged_in FROM bue_actor_role buar join bue_class buc ON buar.id = buc.id and buar.district_id = buc.district_id WHERE buar.district_id in (?) and buar.created between TO_DATE(?,'YYYYMMDD') AND dateadd(second,86399,TO_DATE(?,'YYYYMMDD')) AND actor_role in ('STUDENT') AND buc.created between TO_DATE(?,'YYYYMMDD') AND dateadd(second,86399,TO_DATE(?,'YYYYMMDD')) AND buc.district_id in (?) and buc.class in () and buar.id in (select distinct id from bue_school bus WHERE bus.created between TO_DATE(?,'YYYYMMDD') AND dateadd(second,86399,TO_DATE(?,'YYYYMMDD')) AND bus.district_id in (?) and bus.school_id in () ) group by buc.class;]; nested exception is java.sql.SQLException: Amazon Invalid operation: syntax error at or near ")" \nPosition: 505;"}
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
Solution | Source |
---|