Project:
View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
ID | ||||||||
0047849 | ||||||||
Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
defect | [Retail Modules] Web POS | minor | sometimes | 2021-10-14 07:37 | 2021-11-02 08:09 | |||
Reporter | jetxarri | View Status | public | |||||
Assigned To | Retail | |||||||
Priority | high | Resolution | unable to reproduce | Fixed in Version | ||||
Status | closed | Fix in branch | Fixed in SCM revision | |||||
Projection | none | ETA | none | Target Version | RR20Q3.4 | |||
OS | Any | Database | Any | Java version | ||||
OS Version | Database version | Ant version | ||||||
Product Version | SCM revision | |||||||
Review Assigned To | marvintm | |||||||
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 | - | |||||||
Tags | NOR | |||||||
Attached Files | ||||||||
Relationships [ Relation Graph ] [ Dependency Graph ] | |
Notes | |
(0132774) marvintm (manager) 2021-11-02 08:09 |
It seems the order arrived without shipping address. Especially as this is coming from a customer with a customization in the business partner selection, the customization should be analysed first. In any case, we need proper steps to reproduce in the issue before we can work on it. |
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 | Triggers an Emergency Pack | => No |
2021-10-14 07:37 | jetxarri | Tag Attached: NOR | |
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 |
Copyright © 2000 - 2009 MantisBT Group |