Anonymous | Login
Project:
RSS
  
News | My View | View Issues | Roadmap | Summary

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0019940
TypeCategorySeverityReproducibilityDate SubmittedLast Update
backport[Openbravo ERP] 05. Production managementmajoralways2012-03-05 10:272012-05-31 13:12
ReporterioritzCiaView Statuspublic 
Assigned ToioritzCia 
PriorityurgentResolutionfixedFixed in Version
StatusclosedFix in branchFixed in SCM revision54942e07a142
ProjectionnoneETAnoneTarget Version
OSLinux 32 bitDatabasePostgreSQLJava version1.6.0_16
OS VersionCommunity ApplianceDatabase version8.3.8Ant version1.7.1
Product Version2.50MP6SCM revision 
Review Assigned To
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0019940: Insertar mantenimientos: error function next_day

DescriptionBon dia,

En Gestión de la producción || Transacciones || Insertar mantenimientos, al ejecutar el proceso para un período determinado, nos da el siguiente error:

Error: function next_day(date, numeric) does not exist

Según nuestro conocimiento se trata de una función Oracle que no existe en Postgres.

Gràcies i salut
Steps To ReproduceTesting plan:

- Go to Production Management >> Setup >> Machine Category and create a new one (Food Chain).
- Go to Production Management >> Setup >> Machine and create a new one (Packer).
- Go to Production Management >> Setup >> Maintenance Task and create a new one (Cleaning).
- Go to Production Management >> Setup >> Machine Category >> Maintenance and create a maintenance for that category with the previously created Task (FoodCleaning).
- Production Management >> Setup >> Machine Category >> Maintenance >> Periodicity and create a periodicity choosing weekly and choosinng a week day.
- Go to Production Management >> Setup >> Machine >> Maintenance and create a maintenance for that category with the previously created Task (PackCleaning).
- Production Management >> Setup >> Machine Category >> Maintenance >> Periodicity and create a periodicity choosing weekly and choosinng a week day.
- Go to Production Management >> Transactions >> Insert Maintenance. Run this process between two dates that can hold more than a week (01/03/2012 to 31/03/2012).
- Go to Production Management >> Transactions >> Maintenance Plan, see that the maintenance plan has been created.
TagsNo tags attached.
Attached Files

- Relationships [ Relation Graph ] [ Dependency Graph ]
related to defect 00114423.0MP9 closedioritzCia Insertar mantenimientos: error function next_day 

-  Notes
(0046076)
hgbot (developer)
2012-03-06 09:57

 Repository: erp/stable/2.50
Changeset: 54942e07a142dbc7b2bee5d7c46d5cd41cf405da
Author: Ioritz Cia <ioritz.cia <at> openbravo.com>
Date: Mon Mar 05 10:29:11 2012 +0100
URL: http://code.openbravo.com/erp/stable/2.50/rev/54942e07a142dbc7b2bee5d7c46d5cd41cf405da [^]

Fixes issue 19940: Insertar mantenimientos: error function next_day.

---
M src-db/database/model/postscript-PostgreSql.sql
---

- Issue History
Date Modified Username Field Change
2012-03-05 10:27 ioritzCia New Issue
2012-03-05 10:27 ioritzCia Assigned To => ioritzCia
2012-03-05 10:27 ioritzCia Modules => Core
2012-03-05 10:27 ioritzCia Issue generated from 0011442
2012-03-05 10:28 ioritzCia Relationship added related to 0011442
2012-03-06 09:57 hgbot Checkin
2012-03-06 09:57 hgbot Note Added: 0046076
2012-03-06 09:57 hgbot Status new => resolved
2012-03-06 09:57 hgbot Resolution open => fixed
2012-03-06 09:57 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/stable/2.50/rev/54942e07a142dbc7b2bee5d7c46d5cd41cf405da [^]
2012-05-31 13:12 ioritzCia Status resolved => closed

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker