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

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0005212
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] 09. Financial managementmajoralways2008-09-23 18:032008-12-16 12:23
ReporterrafarodaView Statuspublic 
Assigned Torafaroda 
PriorityhighResolutionfixedFixed in Version
StatusclosedFix in branchpiFixed in SCM revision7885
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

0005212: '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 ]
depends on backport 0005213 closedrafaroda 'Generate Cash Flow Statement'/'Create Cash Flow Statement' does not work in PostgreSQL 
depends on backport 0005214 closedrafaroda 'Generate Cash Flow Statement'/'Create Cash Flow Statement' does not work in PostgreSQL 

-  Notes
(0009190)
svnbot (viewer)
2008-09-25 12:05

 Repository: openbravo
Revision: 7885
Author: rafaroda
Date: 2008-09-25 12:05:27 +0200 (Thu, 25 Sep 2008)

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

---
U trunk/src/org/openbravo/erpCommon/ad_process/CreateCashFlowStatement_data.xsql
---

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

- Issue History
Date Modified Username Field Change
2008-09-23 18:03 rafaroda New Issue
2008-09-23 18:03 rafaroda Assigned To => rafaroda
2008-09-23 18:03 rafaroda sf_bug_id 0 => 2124822
2008-09-23 18:03 rafaroda OBNetwork customer => No
2008-09-23 18:03 rafaroda Regression testing => No
2008-09-23 18:04 rafaroda Status new => scheduled
2008-09-23 18:04 rafaroda fix_in_branch => trunk
2008-09-25 12:05 svnbot Checkin
2008-09-25 12:05 svnbot Note Added: 0009190
2008-09-25 12:05 svnbot Status scheduled => resolved
2008-09-25 12:05 svnbot Resolution open => fixed
2008-09-25 12:05 svnbot svn_revision => 7885
2008-12-16 12:23 psarobe Status resolved => closed

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker