0007148: Installing alpha-r8 from sources fails

Description

When trying to install from sources fails. Please see the log:

[openbravo@ip-10-226-66-47 OpenbravoERP-alpha-r8]$ ant install.source
Buildfile: build.xml

init:

set.code.rev:

code.rev:

install.source:

init:

database.lib:

clean:
   [delete] Deleting directory /mnt2/OpenbravoERP-alpha-r8/src-db/build/classes
   [delete] Deleting directory /mnt2/OpenbravoERP-alpha-r8/src-db/build/lib
   [delete] Deleting directory /mnt2/OpenbravoERP-alpha-r8/src-db/docs

init:
    [mkdir] Created dir: /mnt2/OpenbravoERP-alpha-r8/src-db/build/classes
    [mkdir] Created dir: /mnt2/OpenbravoERP-alpha-r8/src-db/build/lib
    [mkdir] Created dir: /mnt2/OpenbravoERP-alpha-r8/src-db/docs

compile:
    [javac] Compiling 4 source files to /mnt2/OpenbravoERP-alpha-r8/src-db/build/classes

build.jar:
      [jar] Building jar: /mnt2/OpenbravoERP-alpha-r8/src-db/build/lib/dbmanager.jar

jar:
     [copy] Copying 1 file to /mnt2/OpenbravoERP-alpha-r8/src-db/database/lib

init:

core.lib:

clean:
   [delete] Deleting directory /mnt2/OpenbravoERP-alpha-r8/src-core/build/classes
   [delete] Deleting directory /mnt2/OpenbravoERP-alpha-r8/src-core/docs
   [delete] Deleting: /mnt2/OpenbravoERP-alpha-r8/src-core/lib/openbravo-core.jar

init:
    [mkdir] Created dir: /mnt2/OpenbravoERP-alpha-r8/src-core/build/classes
    [mkdir] Created dir: /mnt2/OpenbravoERP-alpha-r8/src-core/docs

compile:
    [javac] Compiling 113 source files to /mnt2/OpenbravoERP-alpha-r8/src-core/build/classes

doc:
  [javadoc] Generating Javadoc
  [javadoc] Javadoc execution
  [javadoc] Loading source files for package org.openbravo.base...
  [javadoc] Loading source files for package org.openbravo.data...
  [javadoc] Loading source files for package org.openbravo.database...
  [javadoc] Loading source files for package org.openbravo.exception...
  [javadoc] Loading source files for package org.openbravo.uiTranslation...
  [javadoc] Loading source files for package org.openbravo.utils...
  [javadoc] Loading source files for package org.openbravo.xmlEngine...
  [javadoc] Constructing Javadoc information...
  [javadoc] Standard Doclet version 1.6.0_11
  [javadoc] Building tree for all the packages and classes...
  [javadoc] Building index for all the packages and classes...
  [javadoc] Building index for all classes...

build.jar:
      [jar] Building jar: /mnt2/OpenbravoERP-alpha-r8/src-core/lib/openbravo-core.jar

build:
     [copy] Copying 1 file to /mnt2/OpenbravoERP-alpha-r8/lib/runtime

create.database:

clean.database.ORACLE:
      [sql] Executing commands
      [sql] 1 of 1 SQL statements executed successfully

prepare.database:

ORACLE.structure:
      [sql] Executing commands
      [sql] 1 of 1 SQL statements executed successfully
      [sql] Executing commands
      [sql] 1 of 1 SQL statements executed successfully
      [sql] Executing commands
      [sql] 8 of 8 SQL statements executed successfully

create.database.structure:
Database connection: jdbc:oracle:thin:@localhost:1521:onorcl. User: TAD_alphar8
Executing default prescript
Executed 7 SQL command(s) with 0 error(s)
Executing creation script
for the complete database
SQL Command failed with: ORA-00907: missing right parenthesis

-- END C_INVOICELINE_V2
-- -----------------------------------------------------------------------
-- VIEW C_INVOICE_CANDIDATE_V
-- -----------------------------------------------------------------------
CREATE OR REPLACE FORCE VIEW C_INVOICE_CANDIDATE_V AS SELECT o.ad_client_id, o.ad_org_id, o.c_bpartner_id, o.c_order_i
d, o.documentno, o.dateordered, o.c_doctype_id, o.totallines AS amountlines, sum((l.qtyordered - l.qtyinvoiced) * l.pr
iceactual) AS totallines
   FROM c_order o
   JOIN c_orderline l ON o.c_order_id = l.c_order_id
   JOIN c_bpartner bp ON o.c_bpartner_id = bp.c_bpartner_id
   LEFT JOIN c_invoiceschedule si ON bp.c_invoiceschedule_id = si.c_invoiceschedule_id
  WHERE (o.docstatus IN ('CO', 'CL', 'IP'][)) AND (o.c_doctype_id IN ( SELECT c_doctype.c_doctype_id
   FROM c_doctype
  WHERE c_doctype.docbasetype = 'SOO' AND (c_doctype.docsubtypeso NOT IN ('ON', 'OB', 'WR'][)))) AND l.qtyordered <> l
.qtyinvoiced AND (o.invoicerule = 'I' OR o.invoicerule = 'O' OR o.invoicerule = 'N' OR o.invoicerule = 'D' AND l.qtyin
voiced <> l.qtydelivered OR o.invoicerule = 'S' AND bp.c_invoiceschedule_id IS NULL OR o.invoicerule = 'S' AND bp.c_in
voiceschedule_id IS NOT NULL AND (si.invoicefrequency IS NULL OR si.invoicefrequency = 'D' OR si.invoicefrequency = 'W
' OR si.invoicefrequency = 'T' AND trunc(o.dateordered) <= (TRUNC(now(), 'MM') + si.invoicedaycutoff - 1) AND trunc(no
w()) >= (TRUNC(o.dateordered, 'MM') + si.invoiceday - 1) OR trunc(o.dateordered) <= (TRUNC(now(), 'MM') + si.invoiceda
ycutoff + 14) AND trunc(now()) >= (TRUNC(o.dateordered, 'MM') + si.invoiceday + 14) OR si.invoicefrequency = 'M' AND t
runc(o.dateordered) <= (TRUNC(now(), 'MM') + si.invoicedaycutoff - 1) AND trunc(now()) >= (TRUNC(o.dateordered, 'MM')
+ si.invoiceday - 1)))
  GROUP BY o.ad_client_id, o.ad_org_id, o.c_bpartner_id, o.c_order_id, o.documentno, o.dateordered, o.c_doctype_id, o.
totallines
SQL Command failed with: ORA-00907: missing right parenthesis

-- END MA_SEQUENCE_MACHINE_COST
-- -----------------------------------------------------------------------
-- VIEW M_INOUT_CANDIDATE_V
-- -----------------------------------------------------------------------
CREATE OR REPLACE FORCE VIEW M_INOUT_CANDIDATE_V AS SELECT o.ad_client_id, o.ad_org_id, o.c_bpartner_id, o.c_order_id,
o.documentno, o.dateordered, o.c_doctype_id, o.totallines AS amountlines, sum((l.qtyordered - l.qtydelivered) * l.pri
ceactual) AS totallines
   FROM c_order o
   JOIN c_orderline l ON o.c_order_id = l.c_order_id
  WHERE o.docstatus = 'CO' AND o.isdelivered = 'N' AND (o.c_doctype_id IN ( SELECT c_doctype.c_doctype_id
      FROM c_doctype
     WHERE c_doctype.docbasetype = 'SOO' AND (c_doctype.docsubtypeso NOT IN ('ON', 'OB', 'WR'][)))) AND l.qtyordered <
> l.qtydelivered AND l.directship = 'N' AND l.m_product_id IS NOT NULL
  GROUP BY o.ad_client_id, o.ad_org_id, o.c_bpartner_id, o.c_order_id, o.documentno, o.dateordered, o.totallines, o.c_
doctype_id
Executed 4711 SQL command(s) with 2 error(s)
Executing default postscript
Executed 13 SQL command(s) with 0 error(s)

database.poststructure.ORACLE:
      [sql] Executing commands
      [sql] 1 of 1 SQL statements executed successfully

database.preimport.ORACLE:
Reading tables...
Reading views...
Reading sequences...
Reading triggers...
Reading functions...
Sorting foreign keys and checks...
Model loaded from database.

So at the end fails some java fails because those views are not present

Steps To Reproduce

1. Download alpha-r8
2. Configure everything
3. ant install.source

Issue History
Date Modified	Username	Field	Change
2009-01-26 23:40	psarobe	New Issue
2009-01-26 23:40	psarobe	Assigned To	=> marvintm
2009-01-26 23:40	psarobe	sf_bug_id	0 => 2538764
2009-01-26 23:40	psarobe	OBNetwork customer	=> No
2009-01-26 23:40	psarobe	Regression testing	=> No
2009-01-26 23:41	psarobe	Status	new => scheduled
2009-01-26 23:41	psarobe	fix_in_branch	=> trunk
2009-01-27 17:19	mtaal	Relationship added	depends on 0006915
2009-01-28 17:02	marvintm	Status	scheduled => resolved
2009-01-28 17:02	marvintm	svn_revision	=> 12394
2009-01-28 17:02	marvintm	Resolution	open => fixed
2009-01-28 17:02	marvintm	Note Added: 0012758
2009-02-17 10:38	psarobe	Status	resolved => closed

Notes
(0012758) marvintm (viewer) 2009-01-28 17:02	The issue that caused this problem was this one: https://issues.openbravo.com/view.php?id=6915 [^] and has since then been fixed.