# Error - Sorry. You can't add more items to a closed queue

**URL:** <https://matillioncommunity.discourse.group/t/error-sorry-you-cant-add-more-items-to-a-closed-queue/1786>\
**Category:** Matillion ETL\
**Created:** [April 20, 2022, 6:55pm UTC](https://matillioncommunity.discourse.group/t/error-sorry-you-cant-add-more-items-to-a-closed-queue/1786 "2022-04-20T18:55:43Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![KTP](https://avatars.discourse-cdn.com/v4/letter/k/e56c9b/32.png) [@KTP](https://matillioncommunity.discourse.group/u/KTP)\
**Post date:** [April 20, 2022, 6:55pm UTC](https://matillioncommunity.discourse.group/t/error-sorry-you-cant-add-more-items-to-a-closed-queue/1786/1 "2022-04-20T18:55:43Z")

</div>

I'm using Matillion ETL for BigQuery and the Database Query component.

My SQL query is select \* from [mydatabase].[dbo].[mytable].

&nbsp;

As I watch the the task run, it is staging 1000 records and then giving error "Sorry. You can't add more items to a closed queue."

&nbsp;

If I limit my select to top 1000 or less, it runs fine. It's only when I go above 1000 records that I receive the error.

&nbsp;

I have other orchestrations using the Database Query component, connecting to the same database, doing a similar SQL query but a different table. These are running without issues.

&nbsp;

Could someone help me troubleshoot this error? I'm a new to the forum, so please let me know what additional information I can provide that would be helpful.

---

<div class="post-metadata">

**Author:** ![KTP](https://avatars.discourse-cdn.com/v4/letter/k/e56c9b/32.png) [@KTP](https://matillioncommunity.discourse.group/u/KTP)\
**Post date:** [April 20, 2022, 9:15pm UTC](https://matillioncommunity.discourse.group/t/error-sorry-you-cant-add-more-items-to-a-closed-queue/1786/2 "2022-04-20T21:15:21Z")

</div>

My original table in SQL had more columns than my destination table in BigQuery. I was doing this on purpose, but the select \* must have been confusing something. If I select the specific columns that are in my destination table I'm good to go. Hope someone else finds this useful.

---

<div class="post-metadata">

**Author:** ![ChikaMatillionCommunityMgr](https://avatars.discourse-cdn.com/v4/letter/c/c5a1d2/32.png) [@ChikaMatillionCommunityMgr](https://matillioncommunity.discourse.group/u/ChikaMatillionCommunityMgr)\
**Post date:** [April 20, 2022, 11:23pm UTC](https://matillioncommunity.discourse.group/t/error-sorry-you-cant-add-more-items-to-a-closed-queue/1786/3 "2022-04-20T23:23:34Z")

</div>

Hi [@KTP](https://matillioncommunity.discourse.group/u/KTP)​

Hmm… that’s interesting. It does sound like you've figured it out. But, I’ve not seen a case where select \* causes a problem. I wonder if when you switched to explicitly naming the columns, if you omitted a column that was the cause of the error. Other than that, I'd call it resolved.

If you are still having an issue, I'd suggest you raise a support case so that we can look at your server log.

Thanks,

Chika