title: Vertica-Tableau error Multiple commands cannot be active
body: <p>We have dataset in Vertica and Tableau is querying the data (4 Billions record) from vertica for dashboard as shown below :</p>
  
  <p><img src="https://i.stack.imgur.com/8wDFf.jpg" alt="Tableau Dashboard"></p>
  
  <p>All list and graphs are separate worksheets in tableau and using same connection to Vertica DB. Each list is a column in DB and list is descending order of # count of items in dataset's respective column. Graph also same as list but calculated in slightly different manner. Start Date and End Date is date range for Data to be query like data connection filter which will restrict the query to fixed amount of data example past week, last month, etc. </p>
  
  <p>But I get this ERROR :</p>
  
  <blockquote>
    <p>Vertica][VerticaDSII] (10) An error occurred during query preparation: Multiple commands cannot be active on the same connection. Consider increasing ResultBufferSize or fetching all results before initiating another command.</p>
  </blockquote>
  
  <p>Is the any workaround this issue or any better way to do this </p>