Clearing E-Teller Queue

Sometimes data that CDP E-Teller cannot process get send to the E-Teller receiver. This can result in either:

The receipt opening up on the screen, but an error occurring when the user attempts to Accept the transaction; thus, the user will never be able to view receipts past that transaction.

Or

The receiver counter increasing when it gets data, but E-Teller never opening. (To date, this has only been seen at TTCU).

To get E-Teller back up and running, you will need to make note of the name of the PC that is having the issue then get remoted into the server to clear all the transactions in that PC's queue.

Once you are on their server and have SQL open, edit the TransactionQueue table in the CDPTeller database.

Edit the SQL statement by adding:

where userid = 'XXXX'

(where XXXX is the name of the PC with the issue)

This will display all transactions in that PC's queue.

Since you will not be able to easily determine which receipt or receipts are the "bad" ones, just delete all the transactions for that userid.

This will empty the queue and should get everything back to normal.

Queries to run:

First select everything before deleting (userid is the computer name):

select * from transactionqueue

where userid=''

---------------------------------------------------------------------------------------------------

Query for one user (userid is the computername):

delete from transactionqueue

where userID=''

or to delete everything

delete from transactionqueue