Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
| ID | ||||||||
| 0000098 | ||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
| defect | [Openbravo ERP] A. Platform | major | always | 2008-04-24 10:02 | 2008-12-02 13:01 | |||
| Reporter | psarobe | View Status | public | |||||
| Assigned To | marvintm | |||||||
| Priority | low | Resolution | fixed | Fixed in Version | 2.40beta | |||
| Status | closed | Fix in branch | Fixed in SCM revision | |||||
| Projection | none | ETA | none | Target Version | 2.40 | |||
| OS | Windows | Database | PostgreSQL | Java version | ||||
| OS Version | Database version | 8.2 | Ant version | |||||
| Product Version | 2.40 | SCM revision | r3743 | |||||
| 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 | 0000098: Creating database from sources. | |||||||
| Description | When creating the database from sources for postgres 8.2 it shows me an error: [createdatabase] SQL Command failed with: ERROR: relation "c_invoice_v" does not exist [createdatabase] -- END C_DEBT_PAYMENT_V [createdatabase] -- ----------------------------------------------------------------------- [createdatabase] -- VIEW C_INVOICELINE_V [createdatabase] -- ----------------------------------------------------------------------- [createdatabase] -- SCRIPT OPTIONS (FORCE = TRUE) [createdatabase] CREATE VIEW C_INVOICELINE_V AS SELECT il.ad_client_id, il.ad_org_id, il.c_invoiceline_id, i.c_invoice_id, i.salesrep_id, i.c_bpartner_id, il.m_ product_id, i.documentno, i.dateinvoiced, i.dateacct, i.issotrx, i.docstatus, round(i.multiplier * il.linenetamt, 2) AS linenetamt, round(i.multiplier * il.pric elist * il.qtyinvoiced, 2) AS linelistamt, [createdatabase] CASE [createdatabase] WHEN il.pricelimit IS NULL THEN round(i.multiplier * il.linenetamt, 2) [createdatabase] ELSE round(i.multiplier * il.pricelimit * il.qtyinvoiced, 2) [createdatabase] END AS linelimitamt, round(i.multiplier * il.pricelist * il.qtyinvoiced - il.linenetamt, 2) AS linediscountamt, [createdatabase] CASE [createdatabase] WHEN il.pricelimit IS NULL THEN 0 [createdatabase] ELSE round(i.multiplier * il.linenetamt - il.pricelimit * il.qtyinvoiced, 2) [createdatabase] END AS lineoverlimitamt, il.qtyinvoiced, il.line, il.c_orderline_id, il.c_uom_id [createdatabase] FROM c_invoice_v i, c_invoiceline il [createdatabase] WHERE i.c_invoice_id = il.c_invoice_id [createdatabase] Executed 4963 SQL command(s) with 1 error(s) [createdatabase] Executed 1 forced SQL command(s) with 0 error(s) [createdatabase] Executing default postscript [createdatabase] Executed 6 SQL command(s) with 0 error(s) | |||||||
| Steps To Reproduce | Install from sources and execute the task ant create.database | |||||||
| Tags | PostgreSQL | |||||||
| Attached Files | ||||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
||||||||
|
||||||||
 Relationships |
|
Notes |
|
Issue History |
|||
| Date Modified | Username | Field | Change |
| 2008-04-24 10:02 | psarobe | New Issue | |
| 2008-04-24 10:02 | psarobe | Status | new => @50@ |
| 2008-04-24 10:02 | psarobe | Assigned To | => cromero |
| 2008-04-24 12:42 | cromero | Assigned To | cromero => user20 |
| 2008-04-24 12:42 | cromero | Status | @50@ => @40@ |
| 2008-04-24 15:16 | user20 | Resolution | open => fixed |
| 2008-04-24 15:16 | user20 | Fixed in Version | => trunk |
| 2008-04-28 10:53 | cromero | Status | @40@ => scheduled |
| 2008-04-28 12:15 | admin | Assigned To | user20 => marvintm |
| 2008-05-06 16:17 | marvintm | Status | scheduled => resolved |
| 2008-05-06 16:17 | marvintm | Fixed in Version | trunk => 2.40 |
| 2008-05-06 16:17 | marvintm | Note Added: 0000057 | |
| 2008-07-10 12:29 | plujan | Tag Attached: PostgreSQL | |
| 2008-08-20 18:21 | psarobe | Regression testing | => No |
| 2008-08-20 18:21 | psarobe | Status | resolved => closed |
| 2008-08-20 18:21 | psarobe | Fixed in Version | 2.40 => 2.40beta |
| 2008-12-02 13:01 | jaimetorre | sf_bug_id | 0 => 2377008 |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |