Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0011442Openbravo ERP05. Production managementpublic2009-11-20 12:032012-03-05 10:27
Reporterealegre 
Assigned ToioritzCia 
PriorityurgentSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS20OS VersionCommunity Appliance
Product Version2.50MP6 
Target Version3.0MP9Fixed 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
Summary0011442: 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 Reproduce
Proposed Solution
Additional Information
TagsOB3 Documentation, OB3-Reviewed, VMA-Reviewed
Relationships
related to backport 0019940 closed ioritzCia Insertar mantenimientos: error function next_day 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2009-11-20 12:03ealegreNew Issue
2009-11-20 12:03ealegreAssigned To => rafaroda
2010-02-11 18:16rafarodaAssigned Torafaroda => adrianromero
2011-06-03 11:00dalsasuaAssigned Toadrianromero => dalsasua
2011-07-20 18:11dalsasuaAssigned Todalsasua => jonalegriaesarte
2011-09-28 13:34psarobePrioritynormal => urgent
2011-09-28 13:34psarobeStatusnew => scheduled
2011-09-28 13:34psarobeTarget Version => 3.0MP4
2011-09-30 10:45jonalegriaesarteNote Added: 0041397
2011-09-30 10:45jonalegriaesarteTarget Version3.0MP4 => 3.0MP5
2011-10-31 11:54jonalegriaesarteNote Added: 0042395
2011-10-31 11:54jonalegriaesarteTarget Version3.0MP5 => 3.0MP6
2011-11-25 17:25jonalegriaesarteNote Added: 0043356
2011-11-25 17:25jonalegriaesarteTarget Version3.0MP6 => 3.0MP7
2011-11-25 17:52jonalegriaesarteTag Attached: OB3-Reviewed
2011-12-30 10:24jonalegriaesarteTarget Version3.0MP7 => 3.0MP8
2012-01-25 09:54jonalegriaesarteNote Added: 0044538
2012-01-25 09:54jonalegriaesarteTarget Version3.0MP8 => 3.0MP9
2012-02-15 13:16jonalegriaesarteTarget Version3.0MP9 =>
2012-02-15 19:03iciordiaAssigned Tojonalegriaesarte => vmromanos
2012-02-17 09:18vmromanosTag Attached: VMA-Reviewed
2012-02-21 13:04RenateNieuwkoopIssue Monitored: RenateNieuwkoop
2012-02-21 13:05RenateNieuwkoopTag Attached: OB3 Documentation
2012-02-21 13:16jonalegriaesarteAssigned Tovmromanos => jonalegriaesarte
2012-02-21 13:17jonalegriaesarteTarget Version => 3.0MP9
2012-02-21 13:19jonalegriaesarteAssigned Tojonalegriaesarte => ioritzCia
2012-03-01 13:26hgbotCheckin
2012-03-01 13:26hgbotNote Added: 0045665
2012-03-01 13:26hgbotStatusscheduled => resolved
2012-03-01 13:26hgbotResolutionopen => fixed
2012-03-01 13:26hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/5d34da4f12fe628dcf906afb0c53f72c1a7dac63 [^]
2012-03-01 13:38ioritzCiaNote Added: 0045666
2012-03-01 16:32maiteNote Added: 0045676
2012-03-01 16:32maiteStatusresolved => closed
2012-03-02 15:40hudsonbotCheckin
2012-03-02 15:40hudsonbotNote Added: 0046011
2012-03-05 10:25ioritzCiaStatusclosed => new
2012-03-05 10:25ioritzCiaResolutionfixed => open
2012-03-05 10:25ioritzCiaStatusnew => scheduled
2012-03-05 10:27ioritzCiaIssue cloned0019940
2012-03-05 10:27ioritzCiaStatusscheduled => resolved
2012-03-05 10:27ioritzCiaResolutionopen => fixed
2012-03-05 10:27ioritzCiaStatusresolved => closed
2012-03-05 10:28ioritzCiaRelationship addedrelated to 0019940

Notes
(0041397)
jonalegriaesarte   
2011-09-30 10:45   
Due to other priorities this issue is planned to be solved in MP5
(0042395)
jonalegriaesarte   
2011-10-31 11:54   
Due to other priorities this issue is planned to be solved in MP6
(0043356)
jonalegriaesarte   
2011-11-25 17:25   
Targer version changed to MP7 due to other priorities
(0044538)
jonalegriaesarte   
2012-01-25 09:54   
Target version changed to MP9 due to other priorities
(0045665)
hgbot   
2012-03-01 13:26   
Repository: erp/devel/pi
Changeset: 5d34da4f12fe628dcf906afb0c53f72c1a7dac63
Author: Ioritz Cia <ioritz.cia <at> openbravo.com>
Date: Thu Mar 01 13:24:59 2012 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/5d34da4f12fe628dcf906afb0c53f72c1a7dac63 [^]

Fixes issue 11442: Insertar mantenimientos: error function next_day.

---
M src-db/database/model/postscript-PostgreSql.sql
---
(0045666)
ioritzCia   
2012-03-01 13:38   
Testing 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.
(0045676)
maite   
2012-03-01 16:32   
verified
(0046011)
hudsonbot   
2012-03-02 15:40   
A changeset related to this issue has been promoted main and to the
Central Repository, after passing a series of tests.

Promotion changeset: https://code.openbravo.com/erp/devel/main/rev/544d64e0c159 [^]

Maturity status: Test