Error: Data could not be saved. The INSERT statement conflicted with the CHECK constraint "CK_ITINERARYSTAFFRESOURCE_QUANTITYNEEDED_GREATERTHANZERO". The conflict occurred in database "XXXXX", table "dbo.ITINERARYSTAFFRESOURCE", column 'QUANTITYNEEDED'.

When I try to submit a group sales reservation, I am getting the following error code, and I'm not sure how to resolve it:

Error: Data could not be saved. The INSERT statement conflicted with the CHECK constraint "CK_ITINERARYSTAFFRESOURCE_QUANTITYNEEDED_GREATERTHANZERO". The conflict occurred in database "XXXXX", table "dbo.ITINERARYSTAFFRESOURCE", column 'QUANTITYNEEDED'.

Article
Number:114834

Products:

Blackbaud_Altru

Go to Events > Resources

Select the Staffing Resources tab

Click one of your staffing resources. NOTE: You may have to check through multiple staffing resources until you find one with the details listed in the following steps

Select the Group Type Requirements tab

In the list of group type requirements, look for one with 0 in the Quantity Needed column

Click the drop-down next to that group type requirement

Either click Delete or click Edit and adjust the Quantity Needed field to anything higher than 0 then Save

Was this article helpful?

Thanks for your feedback! Did this solve your issue?

Comments (optional):

Thanks for your feedback!

We're glad it was helpful but sorry it didn’t solve your issue. If you need assistance, click Chat with Support below.

We’re sorry to hear that. Please tell us why.

I don't like how this works.

The answer is confusing.

The answer didn't match what I was searching for.

Additional Comments (optional):

Thanks for your feedback! If you need assistance, click Chat with Support below.