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
254

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

Sandra_Rossi
Active Contributor
0 Kudos
Please don't post to Questions about SAP Websites (issue with community Website, etc.) if it's a question about SAP software. Instead, ask in Technology Q&A: https://community.sap.com/t5/technology-q-a/qa-p/technology-questions.
piotr_j
Explorer
0 Kudos
Maybe you have some incosistency in AWOR (history table). Please try to clean it on test database.

Accepted Solutions (0)

Answers (1)

Answers (1)

piotr_j
Explorer
0 Kudos

Maybe you have some incosistency in AWOR (history table). You can try to empty it on test database.