When running a query in the Data Explorer, I get an error saying:
268002: 02c58eb6-0502-a2a2-0034-12830691fa2c: server ErrorCode=000008, ErrorMessage=Actual statement count 2 did not match the desired statement count 1.
To resolve this issue:
Make sure your SQL query only contains 1 statement. For example the following is 2 statements and would not work:
set a = 1; select * from xyz where field = $a;
Whereas the below is only one statement and does work:
select * from xyz where field = 1;
This error occurs because Panther explicitly denies multiple statements in the Data Explorer. Each query should only contain 1 statement.