pcsoft.us.windevCopyright 2026, PC SOFT29 Sep 2017 12:28:00 Z22 Sep 2017 16:27:00 ZHi guys, A customer is getting an "Unable to cancel transaction" error. I introduced the Transaction processing ages ago (over a year), so it's not a common occurrence; 1st time it's happened in fact. Looks like something out of the ordinary has happened. I've not got any feedback from the customer as of yet; I'll try to find out what was going on at the time of the problem, but in the mean time I presume it's a matter of using WDTRANS to cancel the (outstanding) transaction? ...but are there any other things I should be aware of when fixing this error on the customer's site? Cheers...30WEBDEVen_UShttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/62723-wd21-unable-cancel-transaction/read.awpmoderateur@pcsoft.fr (El moderador)webmaster@pcsoft.fr (El webmaster)guestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/62723-wd21-unable-cancel-transaction-62798/read.awp29 Sep 2017 12:28:00 ZHi Steven, I believe them when they say there wasn't a power cut, but I do suspect that they powered down the server when oth…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/62723-wd21-unable-cancel-transaction-62798/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/62723-wd21-unable-cancel-transaction-62798/read.awp[WD21] Unable to cancel transactionguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/62723-wd21-unable-cancel-transaction-62794/read.awp28 Sep 2017 19:07:00 ZHi Darren, glad to know that everything is fine now ... Now about what can cause these things: 1. Power failure or abnormal…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/62723-wd21-unable-cancel-transaction-62794/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/62723-wd21-unable-cancel-transaction-62794/read.awp[WD21] Unable to cancel transactionguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/62723-wd21-unable-cancel-transaction-62792/read.awp28 Sep 2017 15:35:00 ZHi guys, Just an update to this issue... I used WDTrans on the customer site. Attempting to Cancel the transaction gave ex…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/62723-wd21-unable-cancel-transaction-62792/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/62723-wd21-unable-cancel-transaction-62792/read.awp[WD21] Unable to cancel transactionguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/62723-wd21-unable-cancel-transaction-62733/read.awp23 Sep 2017 13:41:00 ZOk, thanks guys, I'd forgotten the actual records are also "marked". When running WDTrans I'm getting the red crosses on the …https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/62723-wd21-unable-cancel-transaction-62733/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/62723-wd21-unable-cancel-transaction-62733/read.awp[WD21] Unable to cancel transactionguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/62723-wd21-unable-cancel-transaction-62732/read.awp22 Sep 2017 21:00:00 ZDarren This is my take of it and I haven't had to clean up many of these so someone else may correct me. When a transactio…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/62723-wd21-unable-cancel-transaction-62732/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/62723-wd21-unable-cancel-transaction-62732/read.awp[WD21] Unable to cancel transactionguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/62723-wd21-unable-cancel-transaction-62731/read.awp22 Sep 2017 20:51:00 ZGenerally, you can delete it but: 1. make sure you reindex your files 2. use WDTrans to free any locked records Regards St…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/62723-wd21-unable-cancel-transaction-62731/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/62723-wd21-unable-cancel-transaction-62731/read.awp[WD21] Unable to cancel transactionguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/62723-wd21-unable-cancel-transaction-62730/read.awp22 Sep 2017 20:25:00 ZHi, Ok, I've found out a bit more info. The full error is: WL call: Process of 'Global Procedure CancelClassicTransaction…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/62723-wd21-unable-cancel-transaction-62730/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/62723-wd21-unable-cancel-transaction-62730/read.awp[WD21] Unable to cancel transactionguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/62723-wd21-unable-cancel-transaction-62729/read.awp22 Sep 2017 19:10:00 ZDarren As Steven suggests make a backup of the database and the transaction files TRS/TRX Without the TRS/TRX files there …https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/62723-wd21-unable-cancel-transaction-62729/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/62723-wd21-unable-cancel-transaction-62729/read.awp[WD21] Unable to cancel transactionguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/62723-wd21-unable-cancel-transaction-62727/read.awp22 Sep 2017 18:23:00 ZIf your transaction file is corrupt you may have to use a valid backup. It all depends on the damage ... But it could be somet…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/62723-wd21-unable-cancel-transaction-62727/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/62723-wd21-unable-cancel-transaction-62727/read.awp[WD21] Unable to cancel transactionguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/62723-wd21-unable-cancel-transaction-62726/read.awp22 Sep 2017 17:56:00 ZThanks for the info. Do you know if WDTRANS will "force" the cancel even if the transaction file is/maybe corrupt.https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/62723-wd21-unable-cancel-transaction-62726/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/62723-wd21-unable-cancel-transaction-62726/read.awp[WD21] Unable to cancel transactionguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/62723-wd21-unable-cancel-transaction-62728/read.awp22 Sep 2017 17:43:00 ZYou probably know this already but don't forget to do a backup (including the transaction file) before using WDTRANS. You may h…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/62723-wd21-unable-cancel-transaction-62728/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/62723-wd21-unable-cancel-transaction-62728/read.awp[WD21] Unable to cancel transactionguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/62723-wd21-unable-cancel-transaction-62725/read.awp22 Sep 2017 17:13:00 ZHi Steven, It's Classic.https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/62723-wd21-unable-cancel-transaction-62725/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/62723-wd21-unable-cancel-transaction-62725/read.awp[WD21] Unable to cancel transactionguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/62723-wd21-unable-cancel-transaction-62724/read.awp22 Sep 2017 17:04:00 ZHi Darren, is it a HF Classic or a C/S database? Steven Sitashttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/62723-wd21-unable-cancel-transaction-62724/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/62723-wd21-unable-cancel-transaction-62724/read.awp[WD21] Unable to cancel transaction