ETeller is not launching for everyone/one user, clear transaction queue in ETeller database

This is mainly used when everyone runs a transaction and the eteller application doesn't launch and you've confirmed that the print queue is ok on the data processors side.

Delete from transactionqueue

Or 

Use this one if it isn't launching for 1 user and you've verified that the print queue is ok with the dataprocessor.

Delete from transactionqueue

where userid= '[insert computername here.]'

Or

If you need to delete documents from the queue that are older than today run this, NOTE you must change the date to the bottom of the script to reflect the date you are running it.  It is the very last line and must be encapsulated in single quotes in this format ['mm/dd/yyyy'].  You will notice that the delete is commented out, run the select first to make sure it doesn't contain any transaction dates that are undesirable.  Once you've confirmed what you are deleting, comment out the select two dashes will do the trick and then remove the two dashes in front of the delete and run the query again. 

WITH TQ as
(SELECT
a.TransactionQueueId
,a.UserId
,a.TransactionBytes
,a.MaskedText
,b.TransactionQueueValueId
,b.[Name]
,b.[Value]
FROM
TransactionQueue AS a
INNER JOIN TransactionQueueValue AS b
ON a.TransactionQueueId = b.TransactionQueueId
WHERE(b.Name = 'DocDate'))

-- SELECT SHOULD BE USED B4 RUNNING THE DELETE
-- TO MAKE SURE YOU'RE DELETING THE RIGHT DATA
-- THEN COMMENT OUT SELECT & UNCOMMENT DELETE STATEMENT

SELECT * FROM TransactionQueue WHERE TransactionQueueId IN

-- DELETE FROM TransactionQueue WHERE TransactionQueueId IN

(select TransactionQueueId from TQ
WHERE [value]

-- CHANGE DATE BELOW
-- THIS WOULD BE THE DATE YOU'RE RUNNING THE SCRIPT --

< '09/14/2016')