Skip to main content
Panther Knowledge Base

Why am I getting the Data Explorer error "Actual statement count 2 did not match the desired statement count 1" in the Panther Console?

Issue

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.

Resolution

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;

Cause

This error occurs because Panther explicitly denies multiple statements in the Data Explorer. Each query should only contain 1 statement. 

 

  • Was this article helpful?