Openbravo Issue Tracking System - Openbravo ERP |
| View Issue Details |
|
| ID | Project | Category | View Status | Date Submitted | Last Update |
| 0000913 | Openbravo ERP | 05. Production management | public | 2007-02-13 23:51 | 2008-06-12 09:43 |
|
| Reporter | user71 | |
| Assigned To | cromero | |
| Priority | normal | Severity | minor | Reproducibility | always |
| Status | closed | Resolution | fixed | |
| Platform | | OS | 5 | OS Version | |
| Product Version | | |
| Target Version | | Fixed in Version | | |
| Merge Request Status | |
| Review Assigned To | |
| OBNetwork customer | No |
| Web browser | |
| Modules | Core |
| Support ticket | |
| Regression level | |
| Regression date | |
| Regression introduced in release | |
| Regression introduced by commit | |
| Triggers an Emergency Pack | No |
|
| Summary | 0000913: postgres ProductionPlanData error zero |
| Description | While trying to insert a "Product management"/"Production" tab "Production Plan" I got an Error 0 Zero.
attached is logfile log4j_TAD_PUBLIC_RELEASE.log.
I am quite certain I am doing something wrong, openbravo is my first erp experience. But a comprehensive error message would be nice.
Unrelated problem: this logfile at location /tomcat/logs could not be written by the application. I made a symlilnk to catch te error. |
| Steps To Reproduce | |
| Proposed Solution | |
| Additional Information | |
| Tags | No tags attached. |
| Relationships | |
| Attached Files | |
|
| Issue History |
| Date Modified | Username | Field | Change |
|
Notes |
|
|
(0004502)
|
|
user71
|
2005-06-01 00:00
(edited on: 2008-06-12 09:43) |
|
|
|
|
(0000722)
|
|
cromero
|
2007-02-14 10:46
(edited on: 2008-06-12 09:17) |
|
Logged In: YES
user_id=1500614
Originator: NO
You are right.
It's a problem due to non-lazy evaluation in postgreSQL.
You can find the corrected triggers attached.
Thanks,
Carlos Romero
Openbravo Team
File Added: MProductionPlanTRG.sql |
|
|
|
(0000723)
|
|
user71
|
2007-02-15 23:27
(edited on: 2008-06-12 09:17) |
|
Logged In: YES
user_id=787035
Originator: YES
Thank you for this beautiful file, but I can not find a file with the same name on my computer. If it is in a .jar file, I can manage to replace it, but I really do not know where to look for it.
Carl van Denzen
P.S. the logfile location problem is a Tomcat problem I guess. |
|
|
|
(0000724)
|
|
user71
|
2007-02-20 22:53
(edited on: 2008-06-12 09:17) |
|
Logged In: YES
user_id=787035
Originator: YES
I figured out that I had to feed this file into postgres. Problem resolved. Thank you.
Carl. |
|