Openbravo Issue Tracking System - Retail Modules | |||||
| View Issue Details | |||||
| ID | Project | Category | View Status | Date Submitted | Last Update |
| 0047849 | Retail Modules | Web POS | public | 2021-10-14 07:37 | 2021-11-02 08:09 |
| Reporter | jetxarri | ||||
| Assigned To | Retail | ||||
| Priority | high | Severity | minor | Reproducibility | sometimes |
| Status | closed | Resolution | unable to reproduce | ||
| Platform | OS | 5 | OS Version | ||
| Product Version | |||||
| Target Version | RR20Q3.4 | Fixed in Version | |||
| Merge Request Status | |||||
| Review Assigned To | marvintm | ||||
| OBNetwork customer | Gold | ||||
| Support ticket | |||||
| Regression level | |||||
| Regression date | |||||
| Regression introduced in release | |||||
| Regression introduced by commit | |||||
| Triggers an Emergency Pack | No | ||||
| Summary | 0047849: Errors while importing POS Data with empty shipLocId | ||||
| Description | Errors while importing POS Data with empty shipLocId. Sometimes, under unknown circumstances the JSON that arrives to the back to be synchronized contains "shipLocId" with value null Caused by: org.postgresql.util.PSQLException: ERROR: insert or update on table "c_order" violates foreign key constraint "c_order_c_bpartner_location1" Detail: Key (c_bpartner_location_id)=(null) is not present in table "c_bpartner_location". at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2433) at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2178) at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:479) at org.postgresql.jdbc.PgStatement.executeBatch(PgStatement.java:835) at org.postgresql.jdbc.PgPreparedStatement.executeBatch(PgPreparedStatement.java:1556) at jdk.internal.reflect.GeneratedMethodAccessor231.invoke(Unknown Source) at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.base/java.lang.reflect.Method.invoke(Method.java:566) at org.apache.tomcat.jdbc.pool.StatementFacade$StatementProxy.invoke(StatementFacade.java:114) at com.sun.proxy.$Proxy82.executeBatch(Unknown Source) | ||||
| Steps To Reproduce | - | ||||
| Proposed Solution | |||||
| Additional Information | |||||
| Tags | NOR | ||||
| Relationships | |||||
| Attached Files | |||||
| Issue History | |||||
| Date Modified | Username | Field | Change | ||
| 2021-10-14 07:37 | jetxarri | New Issue | |||
| 2021-10-14 07:37 | jetxarri | Assigned To | => Retail | ||
| 2021-10-14 07:37 | jetxarri | OBNetwork customer | => OBPS | ||
| 2021-10-14 07:37 | jetxarri | Triggers an Emergency Pack | => No | ||
| 2021-10-14 07:37 | jetxarri | Tag Attached: NOR | |||
| 2021-10-18 08:20 | marvintm | OBNetwork customer | OBPS => Gold | ||
| 2021-11-02 08:09 | marvintm | Review Assigned To | => marvintm | ||
| 2021-11-02 08:09 | marvintm | Note Added: 0132774 | |||
| 2021-11-02 08:09 | marvintm | Status | new => closed | ||
| 2021-11-02 08:09 | marvintm | Resolution | open => unable to reproduce | ||
| Notes | |||||
|
|
|||||
|
|
||||