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

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0005214
TypeCategorySeverityReproducibilityDate SubmittedLast Update
backport[Openbravo ERP] 09. Financial managementmajoralways2008-09-23 18:042009-01-26 10:16
ReporterrafarodaView Statuspublic 
Assigned Torafaroda 
PriorityhighResolutionfixedFixed in Version2.35
StatusclosedFix in branch2.3xFixed in SCM revision7883
ProjectionnoneETAnoneTarget Version
OSLinux 32 bitDatabasePostgreSQLJava version1.5
OS VersionUbuntu 7.10Database version8.3Ant version1.7
Product VersionpiSCM revision7694 
Review Assigned To
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0005214: 'Generate Cash Flow Statement'/'Create Cash Flow Statement' does not work in PostgreSQL

Description'Generate Cash Flow Statement' (trunk) /'Create Cash Flow Statement' (branches 2.40 and 2.3x) does not work in PostgreSQL with errors:

1 - TRUNK)
17:48:39 [ajp-8009-10] ERROR org.openbravo.erpCommon.ad_process.CreateCashFlowStatementData - SQL error in query: INSERT INTO FACT_ACCT_CFS (FACT_ACCT_CFS_ID, FACT_ACCT_ID, AD_CLIENT_ID, AD_ORG_ID, ISACTIVE, CREATED, CREATEDBY, UPDATED, UPDATEDBY, ACCOUNT_ID, AMOUNT, FACT_ACCT_REF_ID) VALUES (?,?,?,?,'Y',NOW(),?,NOW(),?,?,?,?)Exception:org.postgresql.util.PSQLException: ERROR: column "amount" is of type numeric but expression is of type character varying
17:48:39 [ajp-8009-10] WARN org.openbravo.erpCommon.ad_process.CreateCashFlowStatement - Rollback in transaction

2 - BRANCHES 2.40 - 2.3x
17:50:02 [ajp-8009-10] ERROR org.openbravo.erpCommon.ad_process.CreateCashFlowStatementData - SQL error in query: INSERT INTO FACT_ACCT_CFS (FACT_ACCT_CFS_ID, FACT_ACCT_ID, AD_CLIENT_ID, AD_ORG_ID, ISACTIVE, CREATED, CREATEDBY, UPDATED, UPDATEDBY, ACCOUNT_ID, AMOUNT, FACT_ACCT_REF_ID) VALUES (?,?,?,?,'Y',NOW(),?,NOW(),?,?,?,?)Exception:org.postgresql.util.PSQLException: ERROR: column "fact_acct_cfs_id" is of type numeric but expression is of type character varying
17:50:02 [ajp-8009-10] WARN org.openbravo.erpCommon.ad_process.CreateCashFlowStatement - Rollback in transaction

Steps To Reproduce1 - TRUNK) Go to 'Financial Management || Accounting || Analysis Tools || Generate Cash Flow Statement'
2 - BRANCHES 2.40 - 2.3x) Go to 'Financial Management || Accounting || Analysis Tools || Create Cash Flow Statement'
TagsNo tags attached.
Attached Files

- Relationships [ Relation Graph ] [ Dependency Graph ]
has duplicate defect 0005456 closedcromero Create cash flow statement don't work 
blocks defect 0005212 closedrafaroda 'Generate Cash Flow Statement'/'Create Cash Flow Statement' does not work in PostgreSQL 

-  Notes
(0009189)
svnbot (reporter)
2008-09-25 11:58

 Repository: openbravo
Revision: 7883
Author: rafaroda
Date: 2008-09-25 11:58:06 +0200 (Thu, 25 Sep 2008)

Fixes bug 0005214 Added missing TO_NUMBER(?) to CreateCashFlowStatement_data.xsql.

---
U branches/r2.3x/src/org/openbravo/erpCommon/ad_process/CreateCashFlowStatement_data.xsql
---

https://dev.openbravo.com/websvn/openbravo/?rev=7883&sc=1 [^]

- Issue History
Date Modified Username Field Change
2008-09-23 18:04 rafaroda New Issue
2008-09-23 18:04 rafaroda Assigned To => rafaroda
2008-09-23 18:04 rafaroda Status new => scheduled
2008-09-25 11:58 svnbot Checkin
2008-09-25 11:58 svnbot Note Added: 0009189
2008-09-25 11:58 svnbot Status scheduled => resolved
2008-09-25 11:58 svnbot Resolution open => fixed
2008-09-25 11:58 svnbot svn_revision => 7883
2008-09-25 17:20 ewilliams Issue Monitored: ewilliams
2008-10-13 10:18 psarobe Relationship added has duplicate 0005456
2009-01-26 10:16 psarobe Regression testing => No
2009-01-26 10:16 psarobe Status resolved => closed
2009-01-26 10:16 psarobe Fixed in Version 2.35MP10 => 2.35

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker