0049318: EWI generated because of ad_user organizational level

Description

If I do a return in a store B of a sale done in store A with a user related to organization store B, I get the EWI below:

org.openbravo.base.exception.OBException: Couldn't enable triggers:
...
Caused by: org.openbravo.base.exception.OBSecurityException: Entity NC XXXXXXXX/XXXXXX- 12-05-2022 - -69.95 (Invoice) with organization STORE B references an entity USER B through its property Invoice.saftStatusupdatedby but this referenced entity belongs to an organization STORE A which is not part of the natural tree of STORE B.

Attached, the complete EWI log for the case raised in Norauto.

Steps To Reproduce

-Precondition: to be able to use touchpoints from two different PT-configured stores.

-Do a simplified invoice (simple sale) into the store A
-Open the touchpoint in store B using a USER whose organization is STORE B (not higher as legal entity, * ...)
-Do a return in store B of the invoice generated in step one
-Check the 'Errors While Importing POS data' window in the backoffice

Tags

NOR

Attached Files

49318_errorLog.txt [^] (3,508 bytes) 2022-05-13 12:26 [Show Content] [Hide Content]

org.openbravo.base.exception.OBException: Couldn't enable triggers: 
	at org.openbravo.dal.core.TriggerHandler.enable(TriggerHandler.java:98)
	at com.practicsbs.saftpt.retail.hook.SaftrOrderLoaderHook.exec(SaftrOrderLoaderHook.java:140)
	at org.openbravo.retail.posterminal.OrderLoader.executeHooks(OrderLoader.java:619)
	at org.openbravo.retail.posterminal.OrderLoader.saveRecord(OrderLoader.java:530)
	at org.openbravo.mobile.core.process.DataSynchronizationProcess.saveRecord(DataSynchronizationProcess.java:201)
	at org.openbravo.mobile.core.process.DataSynchronizationProcess.exec(DataSynchronizationProcess.java:156)
	at org.openbravo.mobile.core.process.DataSynchronizationProcess.exec(DataSynchronizationProcess.java:88)
	at org.openbravo.mobile.core.process.MobileImportEntryProcessorRunnable.processEntry(MobileImportEntryProcessorRunnable.java:54)
	at org.openbravo.retail.posterminal.importprocess.OrderImportEntryProcessor$OrderLoaderRunnable.processEntry(OrderImportEntryProcessor.java:64)
	at org.openbravo.service.importprocess.ImportEntryProcessor$ImportEntryProcessRunnable.doRunCycle(ImportEntryProcessor.java:421)
	at org.openbravo.service.importprocess.ImportEntryProcessor$ImportEntryProcessRunnable.run(ImportEntryProcessor.java:338)
	at java.base/java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:515)
	at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264)
	at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128)
	at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628)
	at java.base/java.lang.Thread.run(Thread.java:834)
Caused by: org.openbravo.base.exception.OBSecurityException: Entity NC NORPT0684P71ISR/0000006 - 12-05-2022 - -69.95 (Invoice) with organization VILA NOVA DE GAIA - 0601 references an entity freixo portugal through its property Invoice.saftStatusupdatedby but this referenced entity belongs to an organization FREIXOO - 0696 which is not part of the natural tree of VILA NOVA DE GAIA - 0601
	at org.openbravo.dal.core.OBInterceptor.checkReferencedOrganizations(OBInterceptor.java:316)
	at org.openbravo.dal.core.OBInterceptor.onFlushDirty(OBInterceptor.java:189)
	at org.hibernate.event.internal.DefaultFlushEntityEventListener.invokeInterceptor(DefaultFlushEntityEventListener.java:355)
	at org.hibernate.event.internal.DefaultFlushEntityEventListener.handleInterception(DefaultFlushEntityEventListener.java:332)
	at org.hibernate.event.internal.DefaultFlushEntityEventListener.scheduleUpdate(DefaultFlushEntityEventListener.java:283)
	at org.hibernate.event.internal.DefaultFlushEntityEventListener.onFlushEntity(DefaultFlushEntityEventListener.java:154)
	at org.hibernate.event.internal.AbstractFlushingEventListener.flushEntities(AbstractFlushingEventListener.java:235)
	at org.hibernate.event.internal.AbstractFlushingEventListener.flushEverythingToExecutions(AbstractFlushingEventListener.java:94)
	at org.hibernate.event.internal.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:38)
	at org.hibernate.internal.SessionImpl.doFlush(SessionImpl.java:1484)
	at org.hibernate.internal.SessionImpl.flush(SessionImpl.java:1470)
	at org.openbravo.dal.service.OBDal.flush(OBDal.java:265)
	at org.openbravo.dal.service.OBDal.getConnection(OBDal.java:200)
	at org.openbravo.dal.service.OBDal.getConnection(OBDal.java:184)
	at org.openbravo.dal.core.TriggerHandler.enable(TriggerHandler.java:93)
	... 15 more

Relationships [ Relation Graph ] [ Dependency Graph ]

Notes
There are no notes attached to this issue.

Issue History
Date Modified	Username	Field	Change
2022-05-13 12:25	ucarrion	New Issue
2022-05-13 12:25	ucarrion	Assigned To	=> psanjuan
2022-05-13 12:25	ucarrion	Tag Attached: NOR
2022-05-13 12:26	ucarrion	File Added: 49318_errorLog.txt