This content has been marked as final. Show 13 replies
Not aware of any tool that reads the transaction queue, but you can try to delete the first transaction in the queue and then check if the other transaction details are passing through to the DB.
This particular scenario will not suffice in cases where there are multiple failures due to the first transaction.
In that case you'll have to completely delete all the transaction from the queue option, or you can delete the transaction queue file from the directory structure itself.
What kind of technical object is this queue? Is it an Oracle Advanced Queue? Is it a JMS Queue or Topic? Is it a proprietary 'queue'?
The transaction_queue is executed by a Java file.
were you able to look in to the contents of the transaction queue? If yes could you share it with us too
What I found on is that there is a Java that actually looks into the defaulthardtotals.dat file to see how many transactions have build up. The java file is called = LookupTransactionSite.java
This file runs at the "end of day" process and tells you how many transactions are in the queue.
What I'm trying to find out now is how to run it at anytime you want to, so that you can see the build up transactions during the middle of the day or anytime of the day.
If anyone figures it out, please let me know.
Hi !! I assume you only wanted to know the status or how many transactions are piled up in queue and there details. If so, there is a option in orpos from main menu login as Admin(f4) -> "Admin Options" Screen -> Manager(F5), "Manager Options" screen -> Reports(F2), "Report Options" screen -> Queue Trans(F6). Will print all transaction number available in queue along with details like sale,postvoid etc.
Edited by: user10873624 on Dec 28, 2009 8:52 PM
Edited by: user10873624 on Jan 27, 2010 9:16 PM
the corrupted TransactionQueue.queue, DBJournalQueue.queue and JMSJournalQueue.queue are currently being researched by Oracle....They did gave me a tool to fix the corrupted file and it seems to be working.
The real question is why is it corrupting these files....I've heard other retail companies are also having the same problem. One possibility is that if your POS system has been modify from the base code this could introduce the problem. Have anyone else had these issues?
can u provide the tool details provided by the Oracle to fix same issue
It's not a fix but it's a tool to repairs the corrupted or bad Transactionqueue, DBjournal.queue and
Can you please share that tool/utility provided by oracle to fix corrupted queues (at firstname.lastname@example.org). We have the same issue in production.
Oracle does not provide any such utility but we can write a utility to remove erroneous entry in transaction queue and after which we can consume the queue file
We've had these issues as well. The utility we were provided from Oracle does nto work. We have learned we need to delete the corrupt transaction out of the queue and the rest will flow behind it The corrupt transactions are all credit card transactions where the customer name that is read from the magstripe of the card on our sig cap device comes in as 50+ characters that looks like an encryption code. We have determined it is not a bad card as the same card has been scanned in other transacitons and it came across fine. I understand that pulling the name from the card into OPOS is customer code but we areunable to figure out where the corruption is takning place. Any ideas for us???
We are having similar issues. What did you do to resolve the issue "where the customer name that is read from the magstripe of the card on our sig cap device comes in as 50+ characters that looks like an encryption code"?
Were you able to figure out what causes the issue?
When this happens we are having to use the "F5 Queue -> F2 Delete entry" function at the register to get the transactions behind it to flow to the BackOffice and CentralOffice Database.
Please help. Thanks.
Edited by: user10133807 on Feb 12, 2013 6:20 AM