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

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0004863
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] Z. Otherscriticalalways2008-09-08 21:342008-12-14 21:11
ReporterjpabloaeView Statuspublic 
Assigned Tocromero 
PriorityimmediateResolutionfixedFixed in Version
StatusclosedFix in branchpiFixed in SCM revision7069
ProjectionnoneETAnoneTarget Version2.50
OSLinux 64 bitDatabaseOracleJava version1.5.0_16
OS VersionGentoo - 2.6.24Database version10.2.0.4Ant version1.7.0
Product VersionpiSCM revision7048 
Review Assigned To
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0004863: SL_CashJournal_Amounts_data.xsql doesn't compile

DescriptionSome database objects are in invalid state and they don't let some xsql files to be run correctly:

    [java] 5225 [main] INFO org.openbravo.data.Sqlc - File: ./org/openbravo/erpCommon/ad_callouts/SL_CashJournal_Amounts_data.xsql processed
     [java] 5295 [main] ERROR org.openbravo.data.Sqlc - SQL error in query:
     [java] SELECT C_Currency_Convert((CASE ISRECEIPT WHEN 'Y' THEN p.AMOUNT ELSE -p.AMOUNT END), p.C_Currency_ID, (SELECT b.C_CURRENCY_ID
     [java] FROM C_CASH C, C_CASHBOOK B
     [java] WHERE C.C_CASHBOOK_ID = B.C_CASHBOOK_ID
     [java] AND C.C_CASH_ID = ?),
     [java] (SELECT STATEMENTDATE FROM C_CASH WHERE C_CASH_ID = ?),null,p.AD_Client_ID,p.AD_Org_ID) as amount
     [java] FROM C_DEBT_PAYMENT p
     [java] WHERE C_DEBT_PAYMENT_ID = ?
     [java] Exception:java.sql.SQLException: ORA-06575: Package or function C_CURRENCY_CONVERT is in an invalid state
TagsNo tags attached.
Attached Files

- Relationships [ Relation Graph ] [ Dependency Graph ]
related to defect 0004862 closedmarvintm dba_recompile should be run after creating/updatng the database in Oracle 

-  Notes
(0008931)
svnbot (reporter)
2008-09-09 10:53

 Repository: openbravo
Revision: 7069
Author: cromeroherrero
Date: 2008-09-09 10:53:07 +0200 (Tue, 09 Sep 2008)

Fixed bug 4863: SL_CashJournal_Amounts_data.xsql doesn't compile

---
U trunk/src-db/database/model/functions/C_CURRENCY_RATE.xml
U trunk/src-db/database/model/functions/C_INVOICE_POST.xml
---

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

- Issue History
Date Modified Username Field Change
2008-09-08 21:34 jpabloae New Issue
2008-09-08 21:34 jpabloae Assigned To => cromero
2008-09-08 21:34 jpabloae sf_bug_id 0 => 2100800
2008-09-08 21:34 jpabloae Regression testing => No
2008-09-08 21:35 jpabloae Relationship added related to 0004862
2008-09-09 10:47 cromero Target Version => 2.50
2008-09-09 10:47 cromero Status new => scheduled
2008-09-09 10:47 cromero fix_in_branch => trunk
2008-09-09 10:53 svnbot Checkin
2008-09-09 10:53 svnbot Note Added: 0008931
2008-09-09 10:53 svnbot Status scheduled => resolved
2008-09-09 10:53 svnbot Resolution open => fixed
2008-09-09 10:53 svnbot svn_revision => 7069
2008-12-14 21:11 psarobe Status resolved => closed

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker