0044246: OBPOS_Errors has the column Processing = "Y" forever

Description

The OBPOS_Errors has the column Processing = "Y" forever, something which as no sense, Processing should be "Y" only some milliseconds / few seconds when record is being processed but for some reason it gets freezed to "Y" forever.

Steps To Reproduce

The problem can be reproduced by "forcing" an exception inside SaveDataActionHandler, by adding the following code:

        if (1 == 1) {
          throw new OBException("boom");
        }

after this line: JSONObject result = syncProcess.exec(data, true);

Proposed Solution

In the "catch" of the main "try" in the class, we should rollbackAndClose the DAL session, then set all "processing" values of all OBPOSErrors to false, by using the setProcessNow method, and flush the connection.

Tags

No tags attached.

Attached Files

Relationships [ Relation Graph ] [ Dependency Graph ]

Notes
(0120557) hgbot (developer) 2020-06-03 07:14	Repository: erp/pmods/org.openbravo.retail.posterminal Changeset: 39d28298f9cc3d4d7404145da143efde2bcb7c57 Author: Ranjith S R <ranjith <at> qualiantech.com> Date: Wed Jun 03 10:44:35 2020 +0530 URL: http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal/rev/39d28298f9cc3d4d7404145da143efde2bcb7c57 [^] Fixed issue-44246 : Added rollback for Save OBPOSError action if any error occurs * When processing OBPOSErrors, if any error occurs, transaction should be rollbacked and OBPOSError processing should be updated as false --- M src/org/openbravo/retail/posterminal/SaveDataActionHandler.java ---

Issue History
Date Modified	Username	Field	Change
2020-06-01 12:36	guillermogil	New Issue
2020-06-01 12:36	guillermogil	Assigned To	=> Retail
2020-06-01 12:36	guillermogil	OBNetwork customer	=> Gold
2020-06-01 12:36	guillermogil	Resolution time	=> 1592517600
2020-06-01 12:36	guillermogil	Triggers an Emergency Pack	=> No
2020-06-02 09:48	ranjith_qualiantech_com	Assigned To	Retail => ranjith_qualiantech_com
2020-06-03 07:14	ranjith_qualiantech_com	Status	new => scheduled
2020-06-03 07:14	hgbot	Checkin
2020-06-03 07:14	hgbot	Note Added: 0120557
2020-06-03 07:14	hgbot	Status	scheduled => resolved
2020-06-03 07:14	hgbot	Resolution	open => fixed
2020-06-03 07:14	hgbot	Fixed in SCM revision	=> http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal/rev/39d28298f9cc3d4d7404145da143efde2bcb7c57 [^]
2020-06-03 13:04	marvintm	Review Assigned To	=> marvintm
2020-06-03 13:04	marvintm	Status	resolved => closed
2020-06-03 13:04	marvintm	Fixed in Version	=> RR20Q3