cancel
Showing results for 
Search instead for 
Did you mean: 

Could not commit transaction: Error -1 detected during transaction '' (AWOR)

kenan_jaddeny
Contributor
0 Kudos
170

Hello,

We developed an addon that automate the production order posting process by fetch the [Released] POs and show them as a form, and has a button to select all/dissellect in order to release and receive and complete production process in batch.

But the case is that; after installing this addon, we became unable to perform any action on the Production Order doctype, whenever try to post, duplicate PO or change the status for existing ones, we're getting this error:

Could not commit transaction: Error -1 detected during transaction '' (AWOR)

In order to troubleshoot this issue, we tried the following but got no solution:

  1. Delete the addon file from Extension Manager, SAP B1 Client, related addon file in Windows Explorer
  2. The Transaction Notification SP has no code or modifications
  3. The PO screen has no FMS
  4. As the addon was installed on a sub Database Server from the main database server, we deleted that Database Server from Control Center in SLD, deleted all related databases include SBO-COMMON, deleted the SQL instance itself and all other related files and temp files in the machine
  5. Reinstall brandnew SQL instance, SLD Database Server
  6. Compared the stored procedures in the SLD databases between 2 different versions one before installing the addon and another after installing it but there was no any difference
  7. Compared the storoed procedures in the SBO-COMMON database between 2 different versions one before installing the addon and another after installing it but there was no any difference

What would be solution for this case?

Regards

Accepted Solutions (0)

Answers (0)