Problem Note 68794: The message "...ExecuteStatement failed: out of sequence response: expected 11 but got 10, SQL state: HY00" occurs with concurrently running jobs
 |  |  |  |  |
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 Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS Viya | Microsoft® Windows® for x64 | 3.5 | 3.5 | Viya | Viya |
| Linux for x64 | 3.5 | 3.5 | Viya | Viya | ||
Viya on Linux: An update for this issue is available for SAS Viya 3.5. For instructions on how to access and apply software updates, see the Updating Your SAS Viya software section in the SAS Viya 3.5 for Linux Deployment Guide at
http://documentation.sas.com/?softwareId=administration&softwareVersion=3.5&softwareContextId=softwareUpdates| Type: | Problem Note |
| Priority: | high |
| Date Modified: | 2022-02-03 10:41:31 |
| Date Created: | 2022-01-18 07:53:41 |