0055135: EDL error using ReadOnly database with Business API events

Openbravo Issue Tracking System - Modules

View Issue Details

Project

Category

View Status

Date Submitted

Last Update

0055135

Modules

Openbravo Business API

public

2024-04-09 09:37

2024-04-09 10:41

Reporter

adrianromero

Assigned To

adrianromero

Priority

high

Severity

major

Reproducibility

always

Status

closed

Resolution

fixed

Platform

OS Version

Product Version

Target Version

Fixed in Version

Merge Request Status

Regression date

Regression introduced by commit

Regression level

Review Assigned To

Support ticket

OBNetwork customer

Regression introduced in release

Summary

0055135: EDL error using ReadOnly database with Business API events

Description

when EDL is configured to use the ReadOnly db:
Openbravo.properties: bbdd.readonly.url=xxxx

in the flow Send Business API Event, if the synchronization between the primary and the replica nodes is slow, an error is raised (attached the whole error trace):
ERROR org.openbravo.externaldata.integration.process.AsynchronousProcessor - Unexpected error processing item
org.openbravo.base.exception.OBException: Could not export data for record with ID A6FACEAC7AA61347420F98C6BB9A96BF
at org.openbravo.api.edl.ApiEventItemProcessor.lambda$exportItem$0(ApiEventItemProcessor.java:85) ~[classes/:?]

Executing again, the EDL works

The problem is the ticket was processed but it was not synced yet to the replica db node

Steps To Reproduce

. in local env, duplicate the db:
-> create database miDB2 template miDB;
. configure Openbravo.properties to use a readOnly:
bbdd.readonly.url=jdbc:postgresql://localhost:5432 [^]
bbdd.readonly.sid=miDB2
bbdd.readonly.user=tad
bbdd.readonly.password=tad

. configure to use Send Business API - RETAPCO_OrderCreation

. in POS -> complete a ticket
. in BO -> go to EDL -> edl record was created in error

Proposed Solution

Additional Information