0027974: Year Out of Range error in Oracle calculating costs

Openbravo Issue Tracking System - Openbravo ERP

View Issue Details

Project

Category

View Status

Date Submitted

Last Update

0027974

Openbravo ERP

04. Warehouse management

public

2014-10-24 09:34

2014-12-30 23:23

Reporter

gorkaion

Assigned To

gorkaion

Priority

urgent

Severity

major

Reproducibility

always

Status

closed

Resolution

fixed

Platform

OS Version

Gentoo

Product Version

Target Version

3.0PR14Q4

Fixed in Version

Merge Request Status

Review Assigned To

umartirena

OBNetwork customer

Web browser

Modules

Core

Support ticket

Regression level

Regression date

Regression introduced in release

Regression introduced by commit

Triggers an Emergency Pack

Summary

0027974: Year Out of Range error in Oracle calculating costs

Description

On an Legal Entity where Fix Backdated Transactions is set to false and using Oracle database.

When the cost is being calculated the following exception is thrown:

57112713 [DefaultQuartzScheduler_Worker-3] ERROR org.hibernate.util.JDBCExceptionReporter - Year out of range.
57112744 [DefaultQuartzScheduler_Worker-3] ERROR org.openbravo.costing.CostingBackground - could not execute query
org.hibernate.exception.GenericJDBCException: could not execute query
    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.loader.Loader.doList(Loader.java:2536)
    at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2276)
    at org.hibernate.loader.Loader.list(Loader.java:2271)
    at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:452)
    at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:363)
    at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:196)
    at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1268)
    at org.hibernate.impl.QueryImpl.list(QueryImpl.java:102)
    at org.hibernate.impl.AbstractQueryImpl.uniqueResult(AbstractQueryImpl.java:890)
    at org.openbravo.costing.CostAdjustmentUtils.getStockOnTransactionDate(CostAdjustmentUtils.java:417)
    at org.openbravo.costing.CostingServer.checkCostAdjustments(CostingServer.java:260)
    at org.openbravo.costing.CostingServer.process(CostingServer.java:126)
    at org.openbravo.costing.CostingBackground.doExecute(CostingBackground.java:105)
    at org.openbravo.service.db.DalBaseProcess.execute(DalBaseProcess.java:80)
    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)

Steps To Reproduce

In "F&B International Group" client:

Ensure that costing rule for "F&B US, Inc." has the Fix Backdated Transactions flag unchecked. If it is checked create and process a new costing rule with the same parameters as the current one and do not check the flag.

Create a new Product named "Costing V911" for "F&B US, Inc." organization.
Go to Price tab, select "Be Soft Drinker" price list and enter a unit/list price of 15 €. Go to Costing tab and enter a new line for "F&B US, Inc." organization, Average cost type, cost 25, starting date 01-01-2014 date and ending date 31-12-9999

Go to Purchase Invoice window and create a new invoice for "F&B US, Inc." organization, product "Costing V911", business partner "Be Soft Drinker" invoice date 11-10-2014, quantity 500 and price 15.
Complete the invoice and post it. Let's say this is invoice 10000037.
Realize that the value posted to the ledger is 7,500.00 (500 units * 15 €/unit)

Go to Goods Shipment window and create a new shipment dated on 15-10-2014, product "Costing V911", quantity 400, storage bin L01. Complete. Let's say this is shipment 500024.

Navigate to Process Request window and run "Costing Background process".

Proposed Solution

Additional Information