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 
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

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 (viewer)
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 OBNetwork customer => No
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