Anonymous | Login
Project:
RSS
  
News | My View | View Issues | Roadmap | Summary

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0000572
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] Z. Otherscriticalalways2008-06-07 10:152008-07-01 17:56
ReporterjpabloaeView Statuspublic 
Assigned Toiperdomo 
PriorityimmediateResolutionfixedFixed in Version2.40alpha-r3
StatusclosedFix in branchFixed in SCM revision4899
ProjectionnoneETAnoneTarget Version2.40
OSLinux 64 bitDatabaseAnyJava version1.5.0_15
OS VersionGentoo - 2.6.24Database versionAnt version1.7.0
Product VersionpiSCM revision4892 
Merge Request Status
Review Assigned To
OBNetwork customerNo
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
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 Reproduce1. Get the latest trunk (r4882 at the moment).
2. Run "ant install.source"
TagsNo tags attached.
Attached Files

- Relationships [ Relation Graph ] [ Dependency Graph ]

-  Notes
(0000454)
iperdomo (viewer)
2008-06-07 11:47

 svn log -v -r4887 --limit 1

r4887 | hennadzi | 2008-06-06 18:04:48 +0200 (Fri, 06 Jun 2008) | 1 line
Changed paths:
   M /trunk/src/org/openbravo/erpCommon/ad_actionButton/CopyFromOrder_data.xsql
   M /trunk/src/org/openbravo/erpCommon/ad_process/CreateAccountingReport_data.xsql
   M /trunk/src/org/openbravo/erpCommon/ad_process/CreateTaxReport_data.xsql
   M /trunk/src/org/openbravo/erpCommon/ad_reports/ReportCashFlow_data.xsql
   M /trunk/src/org/openbravo/erpCommon/ad_reports/ReportCashflowForecast_data.xsql
   M /trunk/src/org/openbravo/erpCommon/ad_reports/ReportInvoiceDiscount_data.xsql
   M /trunk/src/org/openbravo/erpReports/RptC_BpartnerSales_data.xsql

Bug fixed. [ 1733700 ] Old CSS classes in xsql files
(0000458)
iperdomo (viewer)
2008-06-09 09:52

 svn log -v -r4899
------------------------------------------------------------------------
r4899 | iperdomo | 2008-06-09 09:49:58 +0200 (Mon, 09 Jun 2008) | 1 line
Changed paths:
   M /trunk/src/org/openbravo/erpCommon/ad_actionButton/CopyFromOrder_data.xsql
   M /trunk/src/org/openbravo/erpCommon/ad_process/CreateAccountingReport_data.xsql
   M /trunk/src/org/openbravo/erpCommon/ad_process/CreateTaxReport_data.xsql
   M /trunk/src/org/openbravo/erpCommon/ad_reports/ReportCashFlow_data.xsql
   M /trunk/src/org/openbravo/erpCommon/ad_reports/ReportCashflowForecast_data.xsql
   M /trunk/src/org/openbravo/erpCommon/ad_reports/ReportInvoiceDiscount_data.xsql
   M /trunk/src/org/openbravo/erpReports/RptC_BpartnerSales_data.xsql

Reverted changes from commit 4887

- 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

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker