Anonymous | Login
Project:
RSS
  
News | My View | View Issues | Roadmap | Summary

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0047849
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Retail Modules] Web POSminorsometimes2021-10-14 07:372021-11-02 08:09
ReporterjetxarriView Statuspublic 
Assigned ToRetail 
PriorityhighResolutionunable to reproduceFixed in Version
StatusclosedFix in branchFixed in SCM revision
ProjectionnoneETAnoneTarget VersionRR20Q3.4
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Review Assigned Tomarvintm
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0047849: Errors while importing POS Data with empty shipLocId

DescriptionErrors 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-
TagsNOR
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
Powered by Mantis Bugtracker