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

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0005213
TypeCategorySeverityReproducibilityDate SubmittedLast Update
backport[Openbravo ERP] 09. Financial managementmajoralways2008-09-23 18:042008-12-11 14:10
ReporterrafarodaView Statuspublic 
Assigned Torafaroda 
PriorityhighResolutionfixedFixed in Version
StatusclosedFix in branch2.40Fixed in SCM revision7878
ProjectionnoneETAnoneTarget Version
OSLinux 32 bitDatabasePostgreSQLJava version1.5
OS VersionUbuntu 7.10Database version8.3Ant version1.7
Product VersionpiSCM revision7694 
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

0005213: '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'
Tags2.40 MP1 candidate
Attached Files

- Relationships [ Relation Graph ] [ Dependency Graph ]
blocks defect 0005212 closedrafaroda 'Generate Cash Flow Statement'/'Create Cash Flow Statement' does not work in PostgreSQL 

-  Notes
(0009187)
svnbot (viewer)
2008-09-25 11:00

 Repository: openbravo
Revision: 7878
Author: rafaroda
Date: 2008-09-25 11:00:39 +0200 (Thu, 25 Sep 2008)

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

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

https://dev.openbravo.com/websvn/openbravo/?rev=7878&sc=1 [^]
(0011182)
psarobe (viewer)
2008-12-11 14:10

 No error comes up

- 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:00 svnbot Checkin
2008-09-25 11:00 svnbot Note Added: 0009187
2008-09-25 11:00 svnbot Status scheduled => resolved
2008-09-25 11:00 svnbot Resolution open => fixed
2008-09-25 11:00 svnbot svn_revision => 7878
2008-09-29 18:38 cromero Tag Attached: 2.40 MP1 candidate
2008-09-29 18:38 cromero Tag Detached: 2.40 MP1 candidate
2008-09-29 18:38 cromero Tag Attached: 2.40 MP1 candidate
2008-12-11 14:10 psarobe Regression testing => No
2008-12-11 14:10 psarobe Status resolved => closed
2008-12-11 14:10 psarobe Note Added: 0011182

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker