Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
| ID | ||||||||
| 0011442 | ||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
| defect | [Openbravo ERP] 05. Production management | major | always | 2009-11-20 12:03 | 2012-03-05 10:27 | |||
| Reporter | ealegre | View Status | public | |||||
| Assigned To | ioritzCia | |||||||
| Priority | urgent | Resolution | fixed | Fixed in Version | ||||
| Status | closed | Fix in branch | Fixed in SCM revision | 5d34da4f12fe | ||||
| Projection | none | ETA | none | Target Version | 3.0MP9 | |||
| OS | Linux 32 bit | Database | PostgreSQL | Java version | 1.6.0_16 | |||
| OS Version | Community Appliance | Database version | 8.3.8 | Ant version | 1.7.1 | |||
| Product Version | 2.50MP6 | 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 | 0011442: Insertar mantenimientos: error function next_day | |||||||
| Description | Bon 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 | |||||||
| Tags | OB3 Documentation, OB3-Reviewed, VMA-Reviewed | |||||||
| Attached Files | ||||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
||||||||
|
||||||||
 Relationships |
|
Notes |
|
|
(0041397) jonalegriaesarte (reporter) 2011-09-30 10:45 |
Due to other priorities this issue is planned to be solved in MP5 |
|
(0042395) jonalegriaesarte (reporter) 2011-10-31 11:54 |
Due to other priorities this issue is planned to be solved in MP6 |
|
(0043356) jonalegriaesarte (reporter) 2011-11-25 17:25 |
Targer version changed to MP7 due to other priorities |
|
(0044538) jonalegriaesarte (reporter) 2012-01-25 09:54 |
Target version changed to MP9 due to other priorities |
|
(0045665) hgbot (developer) 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 (developer) 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 (developer) 2012-03-01 16:32 |
verified |
|
(0046011) hudsonbot (developer) 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 |
|
Notes |
|
Issue History |
|||
| Date Modified | Username | Field | Change |
| 2009-11-20 12:03 | ealegre | New Issue | |
| 2009-11-20 12:03 | ealegre | Assigned To | => rafaroda |
| 2010-02-11 18:16 | rafaroda | Assigned To | rafaroda => adrianromero |
| 2011-06-03 11:00 | dalsasua | Assigned To | adrianromero => dalsasua |
| 2011-07-20 18:11 | dalsasua | Assigned To | dalsasua => jonalegriaesarte |
| 2011-09-28 13:34 | psarobe | Priority | normal => urgent |
| 2011-09-28 13:34 | psarobe | Status | new => scheduled |
| 2011-09-28 13:34 | psarobe | Target Version | => 3.0MP4 |
| 2011-09-30 10:45 | jonalegriaesarte | Note Added: 0041397 | |
| 2011-09-30 10:45 | jonalegriaesarte | Target Version | 3.0MP4 => 3.0MP5 |
| 2011-10-31 11:54 | jonalegriaesarte | Note Added: 0042395 | |
| 2011-10-31 11:54 | jonalegriaesarte | Target Version | 3.0MP5 => 3.0MP6 |
| 2011-11-25 17:25 | jonalegriaesarte | Note Added: 0043356 | |
| 2011-11-25 17:25 | jonalegriaesarte | Target Version | 3.0MP6 => 3.0MP7 |
| 2011-11-25 17:52 | jonalegriaesarte | Tag Attached: OB3-Reviewed | |
| 2011-12-30 10:24 | jonalegriaesarte | Target Version | 3.0MP7 => 3.0MP8 |
| 2012-01-25 09:54 | jonalegriaesarte | Note Added: 0044538 | |
| 2012-01-25 09:54 | jonalegriaesarte | Target Version | 3.0MP8 => 3.0MP9 |
| 2012-02-15 13:16 | jonalegriaesarte | Target Version | 3.0MP9 => |
| 2012-02-15 19:03 | iciordia | Assigned To | jonalegriaesarte => vmromanos |
| 2012-02-17 09:18 | vmromanos | Tag Attached: VMA-Reviewed | |
| 2012-02-21 13:04 | RenateNieuwkoop | Issue Monitored: RenateNieuwkoop | |
| 2012-02-21 13:05 | RenateNieuwkoop | Tag Attached: OB3 Documentation | |
| 2012-02-21 13:16 | jonalegriaesarte | Assigned To | vmromanos => jonalegriaesarte |
| 2012-02-21 13:17 | jonalegriaesarte | Target Version | => 3.0MP9 |
| 2012-02-21 13:19 | jonalegriaesarte | Assigned To | jonalegriaesarte => ioritzCia |
| 2012-03-01 13:26 | hgbot | Checkin | |
| 2012-03-01 13:26 | hgbot | Note Added: 0045665 | |
| 2012-03-01 13:26 | hgbot | Status | scheduled => resolved |
| 2012-03-01 13:26 | hgbot | Resolution | open => fixed |
| 2012-03-01 13:26 | hgbot | Fixed in SCM revision | => http://code.openbravo.com/erp/devel/pi/rev/5d34da4f12fe628dcf906afb0c53f72c1a7dac63 [^] |
| 2012-03-01 13:38 | ioritzCia | Note Added: 0045666 | |
| 2012-03-01 16:32 | maite | Note Added: 0045676 | |
| 2012-03-01 16:32 | maite | Status | resolved => closed |
| 2012-03-02 15:40 | hudsonbot | Checkin | |
| 2012-03-02 15:40 | hudsonbot | Note Added: 0046011 | |
| 2012-03-05 10:25 | ioritzCia | Status | closed => new |
| 2012-03-05 10:25 | ioritzCia | Resolution | fixed => open |
| 2012-03-05 10:25 | ioritzCia | Status | new => scheduled |
| 2012-03-05 10:27 | ioritzCia | Issue cloned | 0019940 |
| 2012-03-05 10:27 | ioritzCia | Status | scheduled => resolved |
| 2012-03-05 10:27 | ioritzCia | Resolution | open => fixed |
| 2012-03-05 10:27 | ioritzCia | Status | resolved => closed |
| 2012-03-05 10:28 | ioritzCia | Relationship added | related to 0019940 |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |