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

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0000257
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] 09. Financial managementcriticalalways2008-05-11 18:192008-08-14 16:15
ReporterplujanView Statuspublic 
Assigned Tocromero 
PriorityurgentResolutionfixedFixed in Version2.40alpha
StatusclosedFix in branch2.40alphaFixed in SCM revision
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava versiondon't know
OS VersionDatabase version8.2.7Ant versiondon't know
Product Version2.35SCM revisionmp4 Community 
Review Assigned To
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0000257: 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"
TagsNo tags attached.
Attached Files

- Relationships Relation Graph ] Dependency Graph ]
blocks defect 00002542.35MP4 closedcromero AT235mp4 - On PostgreSQL I cannot create lines for Settlements 

-  Notes
(0000132)
cromero (reporter)
2008-05-11 18:25

Fixed in the 2.40 pre alpha branch in revision 4110

- Issue History
Date Modified Username Field Change
2008-05-11 18:19 cromero New Issue
2008-05-11 18:19 cromero Assigned To => cromero
2008-05-11 18:19 cromero Status new => scheduled
2008-05-11 18:25 cromero Status scheduled => resolved
2008-05-11 18:25 cromero Fixed in Version => 2.40 pre alpha
2008-05-11 18:25 cromero Resolution open => fixed
2008-05-11 18:25 cromero Note Added: 0000132
2008-07-04 18:02 psarobe Status resolved => closed
2008-08-14 16:15 jaimetorre sf_bug_id 0 => 2051541


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker