Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0007148Openbravo ERPA. Platformpublic2009-01-26 23:402009-02-17 10:38
Reporterpsarobe 
Assigned Tomarvintm 
PriorityurgentSeveritycriticalReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS30OS Version
Product Version2.50alpha-r8 
Target VersionFixed in Version 
Merge Request Status
Review Assigned To
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0007148: Installing alpha-r8 from sources fails
DescriptionWhen 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 Reproduce1. Download alpha-r8
2. Configure everything
3. ant install.source
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
depends on defect 0006915pi closed marvintm Export.database adds ][ characters to view:src-db/database/model/views/C_INVOICE_CANDIDATE_V.xml 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2009-01-26 23:40psarobeNew Issue
2009-01-26 23:40psarobeAssigned To => marvintm
2009-01-26 23:40psarobesf_bug_id0 => 2538764
2009-01-26 23:40psarobeRegression testing => No
2009-01-26 23:41psarobeStatusnew => scheduled
2009-01-26 23:41psarobefix_in_branch => trunk
2009-01-27 17:19mtaalRelationship addeddepends on 0006915
2009-01-28 17:02marvintmStatusscheduled => resolved
2009-01-28 17:02marvintmsvn_revision => 12394
2009-01-28 17:02marvintmResolutionopen => fixed
2009-01-28 17:02marvintmNote Added: 0012758
2009-02-17 10:38psarobeStatusresolved => closed

Notes
(0012758)
marvintm   
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.