Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||||||
| ID | ||||||||||||
| 0031558 | ||||||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||||||
| defect | [Openbravo ERP] 04. Warehouse management | minor | always | 2015-11-23 10:35 | 2017-05-23 18:09 | |||||||
| Reporter | VictorVillar | View Status | public | |||||||||
| Assigned To | nonofrancisco | |||||||||||
| Priority | high | Resolution | open | Fixed in Version | ||||||||
| Status | scheduled | Fix in branch | Fixed in SCM revision | |||||||||
| Projection | none | ETA | none | Target Version | ||||||||
| OS | Any | Database | Any | Java version | ||||||||
| OS Version | Database version | Ant version | ||||||||||
| Product Version | SCM revision | |||||||||||
| Review Assigned To | ||||||||||||
| Web browser | ||||||||||||
| Modules | Core | |||||||||||
| Regression level | ||||||||||||
| Regression date | ||||||||||||
| Regression introduced in release | ||||||||||||
| Regression introduced by commit | ||||||||||||
| Triggers an Emergency Pack | No | |||||||||||
| Summary | 0031558: The Costing background process fails when you have not applied the Core dataset | |||||||||||
| Description | The Costing background process fails when you have not applied the Core dataset | |||||||||||
| Steps To Reproduce | The 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 | |||||||||||
| Tags | No tags attached. | |||||||||||
| Attached Files | ||||||||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
|
 Relationships |
|
Notes |
|
| There are no notes attached to this issue. |
|
Notes |
|
Issue History |
|||
| Date Modified | Username | Field | Change |
| 2015-11-23 10:35 | VictorVillar | New Issue | |
| 2015-11-23 10:35 | VictorVillar | Assigned To | => Triage Finance |
| 2015-11-23 10:35 | VictorVillar | Modules | => Core |
| 2015-11-23 10:35 | VictorVillar | Triggers an Emergency Pack | => No |
| 2015-11-23 10:35 | VictorVillar | Issue Monitored: networkb | |
| 2016-09-06 21:48 | nonofrancisco | Assigned To | Triage Finance => nonofrancisco |
| 2016-09-12 16:21 | nonofrancisco | Status | new => scheduled |
| 2016-12-15 05:37 | pradeepvarma | Issue Monitored: pradeepvarma | |
| 2017-05-23 17:59 | ngarcia | Issue Monitored: ngarcia | |
| 2017-05-23 18:09 | heccam | Issue Monitored: heccam | |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |