SUPPORT / SAMPLES & SAS NOTES
 

Support

Problem Note 68794: The message "...ExecuteStatement failed: out of sequence response: expected 11 but got 10, SQL state: HY00" occurs with concurrently running jobs

DetailsHotfixAboutRate It

You attempt to run similar jobs concurrently with code that contains a SELECT COLUMNS query, and the jobs also connect to an Apache Hive database. You then might encounter one of the following errors:

Error: ExecuteStatement failed: out of sequence response: expected 11 but got 10, SQL state: HY00

Error: ExecuteStatement failed: out of sequence response: expected 11 but got 10, SQL state: HY000, Query: USE 'ref'

This issue can occur when at least 50 jobs are running concurrently. 

Click the Hot Fix tab in this note for a link to instructions about accessing and applying the software update.



Operating System and Release Information

Product FamilyProductSystemProduct ReleaseSAS Release
ReportedFixed*ReportedFixed*
SAS SystemSAS ViyaMicrosoft® Windows® for x643.53.5ViyaViya
Linux for x643.53.5ViyaViya
* For software releases that are not yet generally available, the Fixed Release is the software release in which the problem is planned to be fixed.