Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0005978Openbravo ERP09. Financial managementpublic2008-11-15 10:522009-01-09 14:11
Reporteriperdomo 
Assigned Todalsasua 
PriorityhighSeveritymajorReproducibilityalways
StatusclosedResolutionout of date 
PlatformOS20OS Version2.6.23-gentoo-r9
Product Versionpi 
Target VersionpiFixed in Version 
Merge Request Status
Review Assigned To
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0005978: Fix of issue 4448 don't work in PostgreSQL
DescriptionThe fix of issue 4448 don't work in PostgreSQL:

----
[java] 19002 [main] INFO org.openbravo.data.Sqlc - File: ./org/openbravo/erpCommon/ad_process/CashBankOperations_data.xsql processed
     [java] 19009 [main] ERROR org.openbravo.data.Sqlc - SQL error in query:
     [java]
     [java] SELECT P.AD_ORG_ID AS PADRE, C.C_BANKACCOUNT_ID AS ID, C.DISPLAYEDACCOUNT AS NAME
     [java] FROM AD_ORG O, AD_ORG P, C_BANKACCOUNT C
     [java] WHERE O.AD_ORG_ID = C.AD_ORG_ID
     [java] AND AD_ISORGINCLUDED(C.AD_ORG_ID,P.AD_ORG_ID,O.AD_CLIENT_ID) <> -1
     [java] AND (P.AD_CLIENT_ID = O.AD_CLIENT_ID OR P.AD_ORG_ID = 0)
     [java] AND O.AD_ORG_ID IN ('1')
     [java] AND O.AD_CLIENT_ID IN ('2')
     [java] ORDER BY PADRE, NAME
     [java]
     [java] Exception:org.postgresql.util.PSQLException: ERROR: operator does not exist: character varying = integer
     [java] org.postgresql.util.PSQLException: ERROR: operator does not exist: character varying = integer

Steps To Reproduce* Update your trunk's working to revision 10098
* Using PostgreSQL database, try to build the application
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
related to defect 0004448 closed dalsasua It is not possible to choose a organization within the ad_process/CashBankOperations.java 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2008-11-15 10:52iperdomoNew Issue
2008-11-15 10:52iperdomoAssigned To => dalsasua
2008-11-15 10:52iperdomosf_bug_id0 => 2290026
2008-11-15 10:52iperdomoRegression testing => No
2008-11-15 10:52iperdomoRelationship addedhas duplicate 0004448
2008-11-15 10:53iperdomoRelationship deletedhas duplicate 0004448
2008-11-15 10:53iperdomoRelationship addedrelated to 0004448
2008-11-17 10:22svnbotCheckin
2008-11-17 10:22svnbotNote Added: 0010327
2008-11-17 10:22svnbotStatusnew => resolved
2008-11-17 10:22svnbotResolutionopen => fixed
2008-11-17 10:22svnbotsvn_revision => 10116
2008-11-25 12:10psarobeNote Added: 0010625
2008-12-03 19:33psarobeStatusresolved => new
2008-12-03 19:33psarobeResolutionfixed => open
2008-12-03 19:33psarobeNote Added: 0010950
2008-12-03 19:35psarobeStatusnew => scheduled
2008-12-03 19:35psarobefix_in_branch => trunk
2008-12-09 11:05dalsasuaNote Added: 0011042
2009-01-09 14:11rafarodaStatusscheduled => closed
2009-01-09 14:11rafarodaNote Added: 0012029
2009-01-09 14:11rafarodaResolutionopen => out of date

Notes
(0010327)
svnbot   
2008-11-17 10:22   
Repository: openbravo
Revision: 10116
Author: rafaroda
Date: 2008-11-17 10:21:58 +0100 (Mon, 17 Nov 2008)

Fixes bug 0005978 Made /erpCommon/ad_process/CashBankOperations_data.xsql PostgreSQL compatible.

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

https://dev.openbravo.com/websvn/openbravo/?rev=10116&sc=1 [^]
(0010625)
psarobe   
2008-11-25 12:10   
to verify this compile the application in postgres. If it can compile, it works
(0010950)
psarobe   
2008-12-03 19:33   
It cannot be tested because the piece of code related to fill the combo boxes for cahsbook and bank account are commented. How can this happen?
(0011042)
dalsasua   
2008-12-09 11:05   
Exactly. That piece of code is not used any more, so this issue can be closed.

Regards,
(0012029)
rafaroda   
2009-01-09 14:11   
No change is required for this issue. Code is compiling properly in PostgreSQL.