Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
| ID | ||||||||
| 0007148 | ||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
| defect | [Openbravo ERP] A. Platform | critical | always | 2009-01-26 23:40 | 2009-02-17 10:38 | |||
| Reporter | psarobe | View Status | public | |||||
| Assigned To | marvintm | |||||||
| Priority | urgent | Resolution | fixed | Fixed in Version | ||||
| Status | closed | Fix in branch | pi | Fixed in SCM revision | 12394 | |||
| Projection | none | ETA | none | Target Version | ||||
| OS | Linux 64 bit | Database | Oracle | Java version | ||||
| OS Version | Database version | Ant version | ||||||
| Product Version | 2.50alpha-r8 | SCM revision | ||||||
| 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 | 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 | |||||||
| Tags | No tags attached. | |||||||
| Attached Files | ||||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
||||||||
|
||||||||
 Relationships |
|
Notes |
|
|
(0012758) marvintm (developer) 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. |
|
Notes |
|
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 | 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 |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |