Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0031558Openbravo ERP04. Warehouse managementpublic2015-11-23 10:352017-05-23 18:09
ReporterVictorVillar 
Assigned Tononofrancisco 
PriorityhighSeverityminorReproducibilityalways
StatusscheduledResolutionopen 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version 
Merge Request Status
Review Assigned To
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0031558: The Costing background process fails when you have not applied the Core dataset
DescriptionThe Costing background process fails when you have not applied the Core dataset
Steps To ReproduceThe Costing background process fails when you have not applied the Core dataset.

error: "2015-11-20 04:15:44.146 - Could not execute JDBC batch update"


openbravo@febe3:~$ 8a2ee31a 2015-11-20 10:31:09,714 [DefaultQuartzScheduler_Worker-2] ERROR
org.hibernate.util.JDBCExceptionReporter - Batch entry 0 insert into M_CostAdjustment (AD_Client_ID, AD_Org_ID, Isactive,
Created, Createdby, Updated, Updatedby, Documentno, ReferenceDate, Source_Process, Processed, Process, Docstatus,
Cancel, Posted, Processing, M_CostAdjustment_ID) values ('6A6716944CF2479CA1999B8F1644AA34',
'0D3210A4A81047A0A646A14D605F6A62', 'Y', '2015-11-20 10:31:09.354000 -06:00:00', '100', '2015-11-20 10:31:09.354000
-06:00:00', '100', '', '2015-11-20 10:31:09.354000 -06:00:00', 'BDT', 'N', 'N', 'DR', 'N', 'N', 'N',
'C32BF75FC31B48D6B5E8C731431A6CB3') was aborted. Call getNextException to see the cause.
8a2ee31a 2015-11-20 10:31:09,726 [DefaultQuartzScheduler_Worker-2] ERROR org.hibernate.util.JDBCExceptionReporter -
ERROR: null value in column "c_doctype_id" violates not-null constraint
Detail: Failing row contains (C32BF75FC31B48D6B5E8C731431A6CB3, 6A6716944CF2479CA1999B8F1644AA34,
0D3210A4A81047A0A646A14D605F6A62, Y, 2015-11-20 10:31:09.354, 100, 2015-11-20 10:31:09.354, 100, null, , 2015-11-
20 10:31:09.354, BDT, N, N, DR, N, null, N, N).
8a2ee31a 2015-11-20 10:31:09,770 [DefaultQuartzScheduler_Worker-2] ERROR org.hibernate.util.JDBCExceptionReporter -
Batch entry 0 insert into M_CostAdjustment (AD_Client_ID, AD_Org_ID, Isactive, Created, Createdby, Updated, Updatedby,
Documentno, ReferenceDate, Source_Process, Processed, Process, Docstatus, Cancel, Posted, Processing,
M_CostAdjustment_ID) values ('6A6716944CF2479CA1999B8F1644AA34', '0D3210A4A81047A0A646A14D605F6A62', 'Y',
'2015-11-20 10:31:09.354000 -06:00:00', '100', '2015-11-20 10:31:09.354000 -06:00:00', '100', '', '2015-11-20
10:31:09.354000 -06:00:00', 'BDT', 'N', 'N', 'DR', 'N', 'N', 'N', 'C32BF75FC31B48D6B5E8C731431A6CB3') was aborted. Call
getNextException to see the cause.
8a2ee31a 2015-11-20 10:31:09,770 [DefaultQuartzScheduler_Worker-2] ERROR org.hibernate.util.JDBCExceptionReporter -
ERROR: current transaction is aborted, commands ignored until end of transaction block
8a2ee31a 2015-11-20 10:31:12,250 [DefaultQuartzScheduler_Worker-2] ERROR org.hibernate.util.JDBCExceptionReporter -
Batch entry 0 insert into M_CostAdjustment (AD_Client_ID, AD_Org_ID, Isactive, Created, Createdby, Updated, Updatedby,
Documentno, ReferenceDate, Source_Process, Processed, Process, Docstatus, Cancel, Posted, Processing,
M_CostAdjustment_ID) values ('6A6716944CF2479CA1999B8F1644AA34', '0D3210A4A81047A0A646A14D605F6A62', 'Y',
'2015-11-20 10:31:12.222000 -06:00:00', '100', '2015-11-20 10:31:12.222000 -06:00:00', '100', '', '2015-11-20
10:31:12.222000 -06:00:00', 'BDT', 'N', 'N', 'DR', 'N', 'N', 'N', '1AD25B92E47E41019F2A5822BF4A3519') was aborted. Call
getNextException to see the cause.
8a2ee31a 2015-11-20 10:31:12,250 [DefaultQuartzScheduler_Worker-2] ERROR org.hibernate.util.JDBCExceptionReporter -
ERROR: null value in column "c_doctype_id" violates not-null constraint
Detail: Failing row contains (1AD25B92E47E41019F2A5822BF4A3519, 6A6716944CF2479CA1999B8F1644AA34,
0D3210A4A81047A0A646A14D605F6A62, Y, 2015-11-20 10:31:12.222, 100, 2015-11-20 10:31:12.222, 100, null, , 2015-11-
20 10:31:12.222, BDT, N, N, DR, N, null, N, N).
8a2ee31a 2015-11-20 10:31:12,274 [DefaultQuartzScheduler_Worker-2] ERROR org.hibernate.util.JDBCExceptionReporter -
Batch entry 0 insert into M_CostAdjustment (AD_Client_ID, AD_Org_ID, Isactive, Created, Createdby, Updated, Updatedby,
Documentno, ReferenceDate, Source_Process, Processed, Process, Docstatus, Cancel, Posted, Processing,
M_CostAdjustment_ID) values ('6A6716944CF2479CA1999B8F1644AA34', '0D3210A4A81047A0A646A14D605F6A62', 'Y',
'2015-11-20 10:31:12.222000 -06:00:00', '100', '2015-11-20 10:31:12.222000 -06:00:00', '100', '', '2015-11-20
10:31:12.222000 -06:00:00', 'BDT', 'N', 'N', 'DR', 'N', 'N', 'N', '1AD25B92E47E41019F2A5822BF4A3519') was aborted. Call
getNextException to see the cause.
8a2ee31a 2015-11-20 10:31:12,274 [DefaultQuartzScheduler_Worker-2] ERROR org.hibernate.util.JDBCExceptionReporter -
ERROR: current transaction is aborted, commands ignored until end of transaction block
8a2ee31a 2015-11-20 10:31:12,274 [DefaultQuartzScheduler_Worker-2] INFO
org.openbravo.erpCommon.utility.ErrorTextParserPOSTGRE - did not find constraint name for error message: Could not
execute JDBC batch update
8a2ee31a 2015-11-20 10:31:12,282 [DefaultQuartzScheduler_Worker-2] ERROR org.openbravo.costing.CostingBackground
- Could not execute JDBC batch update
org.hibernate.exception.GenericJDBCException: Could not execute JDBC batch update
at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:140)
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:128)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:275)
at org.hibernate.jdbc.AbstractBatcher.prepareStatement(AbstractBatcher.java:114)
at org.hibernate.jdbc.AbstractBatcher.prepareStatement(AbstractBatcher.java:109)
at org.hibernate.jdbc.AbstractBatcher.prepareBatchStatement(AbstractBatcher.java:244)
at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2411)
at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2868)
at org.hibernate.action.EntityInsertAction.execute(EntityInsertAction.java:79)
at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:273)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:265)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:184)
at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:321)
at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:51)
at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1216)
at org.openbravo.dal.service.OBDal.flush(OBDal.java:205)
at org.openbravo.costing.CostingServer.process(CostingServer.java:136)
at org.openbravo.costing.CostingBackground.doExecute(CostingBackground.java:115)
at org.openbravo.service.db.DalBaseProcess.execute(DalBaseProcess.java:82)
at org.openbravo.scheduling.DefaultJob.execute(DefaultJob.java:58)
at org.quartz.core.JobRunShell.run(JobRunShell.java:202)
at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:525)
Caused by: java.sql.BatchUpdateException: Batch entry 0 insert into M_CostAdjustment (AD_Client_ID, AD_Org_ID, Isactive,
Created, Createdby, Updated, Updatedby, Documentno, ReferenceDate, Source_Process, Processed, Process, Docstatus,
Cancel, Posted, Processing, M_CostAdjustment_ID) values ('6A6716944CF2479CA1999B8F1644AA34',
'0D3210A4A81047A0A646A14D605F6A62', 'Y', '2015-11-20 10:31:09.354000 -06:00:00', '100', '2015-11-20 10:31:09.354000
-06:00:00', '100', '', '2015-11-20 10:31:09.354000 -06:00:00', 'BDT', 'N', 'N', 'DR', 'N', 'N', 'N',
'C32BF75FC31B48D6B5E8C731431A6CB3') was aborted. Call getNextException to see the cause.
at org.postgresql.jdbc2.AbstractJdbc2Statement$BatchResultHandler.handleError(AbstractJdbc2Statement.java:2598)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1836)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:407)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeBatch(AbstractJdbc2Statement.java:2737)
at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:70)
at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:268)
... 19 more
^C
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2015-11-23 10:35VictorVillarNew Issue
2015-11-23 10:35VictorVillarAssigned To => Triage Finance
2015-11-23 10:35VictorVillarModules => Core
2015-11-23 10:35VictorVillarTriggers an Emergency Pack => No
2015-11-23 10:35VictorVillarIssue Monitored: networkb
2016-09-06 21:48nonofranciscoAssigned ToTriage Finance => nonofrancisco
2016-09-12 16:21nonofranciscoStatusnew => scheduled
2016-12-15 05:37pradeepvarmaIssue Monitored: pradeepvarma
2017-05-23 17:59ngarciaIssue Monitored: ngarcia
2017-05-23 18:09heccamIssue Monitored: heccam

There are no notes attached to this issue.