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

View Issue DetailsJump to Notes ] Issue History ] Print ]
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

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(
    at org.postgresql.core.v3.QueryExecutorImpl.processResults(
    at org.postgresql.core.v3.QueryExecutorImpl.execute(
    at org.postgresql.jdbc.PgStatement.executeBatch(
    at org.postgresql.jdbc.PgPreparedStatement.executeBatch(
    at jdk.internal.reflect.GeneratedMethodAccessor231.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.$Proxy82.executeBatch(Unknown Source)
Steps To Reproduce-
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