Anonymous | Login
News | My View | View Issues | Roadmap | Summary

View Issue DetailsJump to Notes ] Issue History ] Print ]
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[POS2] POSmajoralways2022-11-24 17:002022-11-24 17:00
ReporterkchoperenaView Statuspublic 
Assigned ToRetail 
PriorityhighResolutionopenFixed in Version
StatusnewFix in branchFixed in SCM revision
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionpiSCM revision 
Review Assigned To
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo

0051004: Error in a deferred payment when the marketing survey module is installed

DescriptionError in a deferred payment when the marketing survey module is installed and has configured several surveys.

For this case, we have configured 4 different surveys:
- Code Postal (mandatory) / Type of survey: text
- Comment nous avez-vous connu? (mandatory) / Type of survey: text
- Avez-vous trouvé tout ce que vous cherchiez? (mandatory) / Type of survey: List of options
- Quel produit avez-vous manqué? (optional) / Type of survey: text
Steps To Reproduce- Login into the WebPOS
- Create a order with a customer and delivery mode any other than Pick and Carry
- Pay the partial amount
- Check out
- Fill up a Marketing Survey.
- Go back to the back office to check the payment done
- Go back to the POS
- Retrieve the order
- Pay the remaining balance.
- Marketing Survey pop up appears ( Why twice for the same order ?)
- Fill out the form.
- Check out.

- Go to the EWI window. The following error appears:

org.postgresql.util.PSQLException: ERROR: duplicate key value violates unique constraint "obms_marksurveyres_un"
  Detail: Key (obms_marketing_survey_id, c_order_id)=(67B6178996E044F6B8ADB5C648D6FEBD, A870C9D994859727860D92A33B2F1FF5) already exists.
    at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(
    at org.postgresql.core.v3.QueryExecutorImpl.processResults(
    at org.postgresql.core.v3.QueryExecutorImpl.execute(
    at org.postgresql.jdbc.PgStatement.internalExecuteBatch(
    at org.postgresql.jdbc.PgStatement.executeBatch(
    at org.postgresql.jdbc.PgPreparedStatement.executeBatch(
    at jdk.internal.reflect.GeneratedMethodAccessor373.invoke(Unknown Source)
    at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(
    at java.base/java.lang.reflect.Method.invoke(
    at org.apache.tomcat.jdbc.pool.StatementFacade$StatementProxy.invoke(
    at com.sun.proxy.$Proxy80.executeBatch(Unknown Source)
    at org.hibernate.engine.jdbc.batch.internal.BatchingBatch.performExecution(
    at org.hibernate.engine.jdbc.batch.internal.BatchingBatch.doExecuteBatch(
    at org.hibernate.engine.jdbc.batch.internal.AbstractBatchImpl.execute(
    at org.hibernate.engine.jdbc.internal.JdbcCoordinatorImpl.executeBatch(
    at org.hibernate.engine.jdbc.internal.StatementPreparerImpl.prepareStatement(
    at org.hibernate.engine.jdbc.batch.internal.AbstractBatchImpl.buildBatchStatement(
    at org.hibernate.engine.jdbc.batch.internal.AbstractBatchImpl.getBatchStatement(
    at org.hibernate.engine.jdbc.batch.internal.BatchingBatch.getBatchStatement(
    at org.hibernate.persister.entity.AbstractEntityPersister.insert(
    at org.hibernate.persister.entity.AbstractEntityPersister.insert(
    at org.hibernate.action.internal.EntityInsertAction.execute(
    at org.hibernate.engine.spi.ActionQueue.executeActions(
    at org.hibernate.engine.spi.ActionQueue.lambda$executeActions$1(
    at java.base/java.util.LinkedHashMap.forEach(
    at org.hibernate.engine.spi.ActionQueue.executeActions(
    at org.hibernate.event.internal.AbstractFlushingEventListener.performExecutions(
    at org.hibernate.event.internal.DefaultFlushEventListener.onFlush(
    at org.hibernate.event.service.internal.EventListenerGroupImpl.fireEventOnEachListener(
    at org.hibernate.internal.SessionImpl.doFlush(
    at org.hibernate.internal.SessionImpl.flush(
    at org.openbravo.dal.service.OBDal.flush(
    at$Proxy$_$$_WeldClientProxy.exec(Unknown Source)
    at org.openbravo.retail.posterminal.OrderLoader.executeHooks(
    at org.openbravo.retail.posterminal.OrderLoader.saveRecord(

In the sales orders payment plant, the payment is still not processed
The webpos still shows the order as "Partially Paid"
In the Marketing Survey Result Window only the initial input is registered.

TagsNo tags attached.
Attached Files

- Relationships Relation Graph ] Dependency Graph ]

-  Notes
There are no notes attached to this issue.

- Issue History
Date Modified Username Field Change
2022-11-24 17:00 kchoperena New Issue
2022-11-24 17:00 kchoperena Assigned To => Retail
2022-11-24 17:00 kchoperena Triggers an Emergency Pack => No

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker