Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0000254Openbravo ERP09. Financial managementpublic2008-05-10 21:142009-03-18 11:01
Reporterplujan 
Assigned Tocromero 
PriorityurgentSeveritycriticalReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version2.35 
Target Version2.35MP4Fixed in Version2.35MP4 
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
Summary0000254: AT235mp4 - On PostgreSQL I cannot create lines for Settlements
DescriptionWhen I create a new Settlement and I try to create lines by using "Create Lines From" button I get a "ProcessRunError" error message and I cannot continue. On openbravo.log I get this:

15:59:14 [http-8080-1] ERROR org.openbravo.erpCommon.ad_actionButton.CreateFromSettlementData - SQL error in query: SELECT COUNT(*) FROM C_DEBT_PAYMENT DP WHERE DP.C_DEBT_PAYMENT_ID = ? AND C_DEBT_PAYMENT_STATUS(DP.C_Settlement_Cancel_ID, DP.Cancel_Processed, DP.Generate_Processed, DP.IsPaid, DP.IsValid, DP.C_CashLine_ID, DP.C_BankStatementLine_ID)='P' AND NOT EXISTS (SELECT * FROM C_BankStatementLine l WHERE DP.C_DEBT_Payment_ID=l.C_DEBT_PAYMENT_ID) AND NOT EXISTS (SELECT * FROM C_CashLine l WHERE DP.C_DEBT_Payment_ID=l.C_DEBT_PAYMENT_ID) Exception:org.postgresql.util.PSQLException: The column name COUNT(*) was not found in this ResultSet.
15:59:14 [http-8080-1] WARN org.openbravo.erpCommon.ad_actionButton.CreateFrom - Rollback in transaction
Steps To Reproduce# Login as userA
# Go to Financial management->Receivables and payables->Transactions->Settlement
# Click New and fill mandatory fields. Save
# Click "Create lines from"
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
depends on defect 0000256 closed cromero AT235mp4 - On PostgreSQL I cannot create lines for Settlements 
depends on defect 0000257 closed cromero AT235mp4 - On PostgreSQL I cannot create lines for Settlements 
depends on backport 0000258 closed cromero AT235mp4 - On PostgreSQL I cannot create lines for Settlements 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2008-05-10 21:14plujanNew Issue
2008-05-10 21:14plujanAssigned To => cromero
2008-05-11 18:01cromeroStatusnew => @40@
2008-05-11 18:19cromeroStatus@40@ => scheduled
2008-05-11 18:29cromeroStatusscheduled => resolved
2008-05-11 18:29cromeroResolutionopen => fixed
2008-05-11 18:29cromeroNote Added: 0000134
2008-06-11 14:12cromeroTarget Version => 2.35 MP4
2008-06-11 14:35cromeroFixed in Version => 2.35 MP4
2008-07-04 11:00plujanStatusresolved => closed
2009-03-18 11:01anonymoussf_bug_id0 => 2691251

Notes
(0000134)
cromero   
2008-05-11 18:29   
Fixed in the 235mp4 branch in revision 4112