E-mail messages sent to MainBoss Service are being returned with the message shown below. What's going on?

With this problem, MainBoss Service sends the following message to users when they try to submit requests by e-mail:

Your request was denied for the reasons outlined below

Cannot insert the value NULL into column 'ReceiveAcknowledgement',
table 'MainBoss.dbo.Requestor'; column does not allow nulls. INSERT fails.

The statement has been terminated.
                Database table Requestor

The problem arises because the default setting for Receive Acknowledgements in the Requestors table has somehow been set to NULL, not true or false. To correct the problem:

1. In MainBoss, go to Coding Definitions -> Requests -> Requestors.
2. Go to the Defaults for Requestors section.
3. Click the Edit Defaults button.
4. Click the checkbox for Receive Acknowledgements until it is either a checkmark or blank. If you make it a checkmark, the default for new requestors will be that they receive acknowledgement messages from MainBoss Service. (This is the setting we recommend.) If you make the checkbox blank, the default will be that new requestors do not receive such messages. Note that the checkbox allows a third setting (something that isn't either a checkmark or blank); do not use this third setting.
5. Click Save Defaults & Close to close the defaults window.

Back to FAQ index