0000138: 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 ]

blocks

defect

0000098

2.40

closed

marvintm

Creating database from sources.

Notes
(0000058) marvintm (developer) 2008-05-06 17:11	Now dbsourcemanager will not show error messages regarding errors produced by commands that will be tried to be executed later.

Issue History
Date Modified	Username	Field	Change
2008-04-28 10:53	cromero	New Issue
2008-04-28 10:53	cromero	Status	new => @50@
2008-04-28 10:53	cromero	Assigned To	=> user20
2008-04-28 10:53	cromero	Status	@50@ => scheduled
2008-04-28 10:53	cromero	Resolution	open => fixed
2008-04-28 10:53	cromero	Fixed in Version	=> trunk
2008-04-28 12:15	admin	Assigned To	user20 => marvintm
2008-04-28 12:15	admin	Description Updated
2008-05-06 17:11	marvintm	Status	scheduled => resolved
2008-05-06 17:11	marvintm	Fixed in Version	trunk => 2.35
2008-05-06 17:11	marvintm	Note Added: 0000058
2008-05-21 19:51	cromero	Target Version	2.40 => R2.40alpha r2
2008-06-24 13:49	cromero	Target Version	2.40alpha-r2 => 2.35
2008-06-24 13:50	cromero	Fixed in Version	2.35 => 2.35MP6
2008-06-24 17:01	plujan	Tag Attached: PostgreSQL
2008-12-09 13:41	psarobe	Regression testing	=> No
2008-12-09 13:41	psarobe	Status	resolved => closed