Openbravo Issue Tracking System - Openbravo ERP | |||||
| View Issue Details | |||||
| ID | Project | Category | View Status | Date Submitted | Last Update |
| 0000572 | Openbravo ERP | Z. Others | public | 2008-06-07 10:15 | 2008-07-01 17:56 |
| Reporter | jpabloae | ||||
| Assigned To | iperdomo | ||||
| Priority | immediate | Severity | critical | Reproducibility | always |
| Status | closed | Resolution | fixed | ||
| Platform | OS | 30 | OS Version | Gentoo - 2.6.24 | |
| Product Version | pi | ||||
| Target Version | 2.40 | Fixed in Version | 2.40alpha-r3 | ||
| Merge Request Status | |||||
| Review Assigned To | |||||
| OBNetwork customer | No | ||||
| Web browser | |||||
| Modules | Core | ||||
| Support ticket | |||||
| Regression level | |||||
| Regression date | |||||
| Regression introduced in release | |||||
| Regression introduced by commit | |||||
| Triggers an Emergency Pack | No | ||||
| Summary | 0000572: ReportCashFlow_data.xsql fails | ||||
| Description | [java] 12753 [main] INFO org.openbravo.data.Sqlc - File: ./org/openbravo/erpCommon/ad_reports/ReportCashFlow_data.xsql processed [java] 12771 [main] ERROR org.openbravo.data.Sqlc - SQL error in query: [java] [java] SELECT ? as PARENT, AR.AD_ACCOUNTINGRPT_ELEMENT_ID AS ID, AR.NAME, AR.DESCRIPTION, AR.ISSUMMARY, AR.ISSHOWN, [java] AD_TREENODE.NODE_ID, COALESCE(CASE [java] AR.ISSUMMARY WHEN 'N' THEN sum(amount) ELSE 0 END,0) AS TOTAL, AR.FILTEREDBYORGANIZATION, [java] AR.TEMPORARYFILTERTYPE, '' AS VALUE, ? AS LEVEL_ACCOUNT, 'TEXT-INDENT: '||TO_CHAR(TO_NUMBER(?)*10)||'pt' AS CLASS_STYLE, [java] '' AS PADRE [java] FROM AD_ACCOUNTINGRPT_ELEMENT AR left join (SELECT AMOUNT, C_ACCTSCHEMA_ID [java] FROM FACT_ACCT, FACT_ACCT_CFS [java] WHERE FACT_ACCT.AD_CLIENT_ID IN ('1') [java] AND FACT_ACCT.AD_ORG_ID IN ('1') [java] AND FACT_ACCT.FACT_ACCT_ID = FACT_ACCT_CFS.FACT_ACCT_ID [java] AND 1=1) A on AR.C_ACCTSCHEMA_ID = A.C_ACCTSCHEMA_ID, [java] AD_TREE, AD_TREENODE [java] WHERE AD_TREE.AD_TREE_ID = AD_TREENODE.AD_TREE_ID [java] AND AD_TREENODE.NODE_ID = AR.AD_ACCOUNTINGRPT_ELEMENT_ID [java] AND AR.AD_ACCOUNTINGRPT_ELEMENT_ID = TO_NUMBER(?) [java] AND A.C_ACCTSCHEMA_ID = TO_NUMBER(?) [java] AND AD_TREE.TREETYPE = 'AR' [java] GROUP BY REPORT_TYPE, AR.AD_ACCOUNTINGRPT_ELEMENT_ID, AR.NAME, AR.DESCRIPTION, AR.ISSUMMARY, AR.ISSHOWN, [java] AD_TREENODE.NODE_ID, [java] AR.FILTEREDBYORGANIZATION, AR.TEMPORARYFILTERTYPE [java] [java] Exception:java.sql.SQLException: Invalid column index [java] java.sql.SQLException: Invalid column index | ||||
| Steps To Reproduce | 1. Get the latest trunk (r4882 at the moment). 2. Run "ant install.source" | ||||
| Proposed Solution | |||||
| Additional Information | |||||
| Tags | No tags attached. | ||||
| Relationships | |||||
| Attached Files | |||||
| Issue History | |||||
| Date Modified | Username | Field | Change | ||
| 2008-06-07 10:15 | jpabloae | New Issue | |||
| 2008-06-07 10:15 | jpabloae | Assigned To | => cromero | ||
| 2008-06-07 10:15 | jpabloae | OBNetwork customer | => N | ||
| 2008-06-07 10:17 | jpabloae | OBNetwork customer | N => | ||
| 2008-06-07 11:47 | iperdomo | Note Added: 0000454 | |||
| 2008-06-09 09:51 | cromero | Status | new => scheduled | ||
| 2008-06-09 09:51 | cromero | Assigned To | cromero => iperdomo | ||
| 2008-06-09 09:52 | iperdomo | Note Added: 0000458 | |||
| 2008-06-09 09:52 | iperdomo | Status | scheduled => resolved | ||
| 2008-06-09 09:52 | iperdomo | Fixed in Version | => trunk | ||
| 2008-06-09 09:52 | iperdomo | svn_revision | => 4899 | ||
| 2008-06-09 09:52 | iperdomo | Resolution | open => fixed | ||
| 2008-06-11 12:46 | cromero | Target Version | => 2.40 | ||
| 2008-06-11 14:50 | cromero | Fixed in Version | trunk => 2.40alpha r3 | ||
| 2008-06-19 11:14 | plujan | Status | resolved => closed | ||
| 2008-07-01 17:56 | anonymous | sf_bug_id | 0 => 2007936 | ||
| Notes | |||||
|
|
|||||
|
|
||||
|
|
|||||
|
|
||||