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-10-14 07:37
ReporterjetxarriView Statuspublic 
Assigned ToRetail 
PriorityhighResolutionopenFixed in Version
StatusnewFix in branchFixed in SCM revision
ProjectionnoneETAnoneTarget VersionRR20Q3.4
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Review Assigned To
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
There are no notes attached to this issue.

- 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


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker