0000138: Creating database from sources. - Openbravo Issue Tracking System

Openbravo Issue Tracking System - Openbravo ERP

View Issue Details

Project

Category

View Status

Date Submitted

Last Update

0000138

Openbravo ERP

A. Platform

public

2008-04-28 10:53

2008-12-09 13:41

Reporter

psarobe

Assigned To

marvintm

Priority

low

Severity

major

Reproducibility

always

Status

closed

Resolution

fixed

Platform

OS Version

Product Version

2.40

Target Version

Fixed in Version

2.35MP10

Merge Request Status

Review Assigned To

OBNetwork customer

Web browser

Modules

Core

Support ticket

Regression level

Regression date

Regression introduced in release

Regression introduced by commit

Triggers an Emergency Pack

Summary

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

Proposed Solution

Additional Information