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

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0000179
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] 09. Financial managementminorhave not tried2008-04-30 13:392011-01-20 17:31
ReporterplujanView Statuspublic 
Assigned Togorka_gil 
PrioritynormalResolutionduplicateFixed in Version2.40alpha-r2
StatusclosedFix in branchFixed in SCM revision
ProjectionnoneETAnoneTarget Version2.40alpha-r2
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product Version2.40alphaSCM revision3916 
Review Assigned To
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0000179: When searching for Debt Payments, I get an Oracle internal error on a javascript alert window

DescriptionI am paying a Purchase Invoice. When I select the Debt Payment to pay, I get an Oracle internal error on a javascript window. Although I can continue, I could not figure out if everything keeps ok or database turns into a inconsistent state.
Steps To Reproduce1. Create a Purchase Invoice with valid data and complete it. A Payment is created.
2. Move to Cash Journal and create a new Cash Journal with valid data.
3. Move to Lines and add a Line. Cash Type=Debt Payment. When selecting this Type, a debt payment selector appears.
4. Open selector and unmark Receipt checkbox. Search.
5. A javascript window appears with an error message: ORA-00600: internal code error, arguments [evapls1],[], [], [], [], []. (see attach)
6. Accept the message. The message appears again.
7. Accept the message. You can continue normally, but may be "normally" is not real and database has turned inconsistent.
TagsNo tags attached.
Attached Filesjpg file icon R240_BUG_SearchingDebtPayment.JPG [^] (96,536 bytes) 2008-04-30 13:39

- Relationships [ Relation Graph ] [ Dependency Graph ]
has duplicate defect 0004854 closedcromero ORA 00600 error when doing search in BP window 

-  Notes
(0000177)
gorka_gil (administrator)
2008-05-13 12:15

 Duplicated bug:
https://sourceforge.net/tracker/index.php?func=detail&aid=1886253&group_id=162271&atid=823129 [^]

Solution:
Is not an Openbravo bug, is an internal oracle error in the optimizer,
that is fixed in versions 10.2.0.2 and 11.1.0.6.

You can see it in the list of resolved bug for the version 10.2.0.2
(http://database.in2p3.fr/10203_buglist.htm [^]) and search for bug number
4626732.

Althougth exists a workaround that disable this part of the optimizer:
alter session set "_optimizer_filter_pred_pullup"=false;
(0009117)
gorka_gil (administrator)
2008-09-22 13:35

 Although is an oracle bug, is produce for use in a select:
1. a filter for rownum
2. a filter for key with a '%' character and
3. a filter for name (that is made with C_IGNORE_ACCENT function).

For example the business partner selector select:

SELECT * FROM ( SELECT ROWNUM AS RN1, A.* FROM (
SELECT DISTINCT bp.C_BPartner_ID, bp.value, bp.name as name,
bp.name as name_hidden,
(bp.SO_CreditLimit-bp.SO_CreditUsed) AS SO_CreditAvailable, bp.SO_CreditUsed,
COALESCE(c.name,u.name) AS Contact, COALESCE(c.ad_user_id,u.ad_user_id) as C_BPartner_Contact_ID, bpl.Phone, l.Postal AS PC,
bpl.c_bpartner_location_id as C_BPartner_Location_ID,
l.City, bp.ActualLifetimeValue AS Income,
bp.C_BPartner_ID || '#' || COALESCE(TO_CHAR(c.ad_user_id), TO_CHAR(u.ad_user_id), '') || '#' || COALESCE(TO_CHAR(bpl.c_bpartner_location_id),'') || '#' || bp.name AS rowKey
FROM C_BPARTNER bp left join C_BPARTNER_LOCATION bpl on bp.c_bpartner_id = bpl.c_bpartner_id
and bpl.IsActive = 'Y'
left join AD_USER c on bpl.c_bpartner_location_id = c.C_BPartner_Location_ID
and c.IsActive ='Y'
left join C_LOCATION l on bpl.c_location_id=l.C_Location_ID
left join C_REGION r on l.c_region_id = r.c_region_id
left join
(SELECT c_bpartner_id, ad_user_id, name from ad_user where c_bpartner_id is not null
and c_bpartner_location_id is null and isactive='Y') u on bp.c_bpartner_id = u.c_bpartner_id
WHERE bp.AD_Client_ID IN ('0','1000000')
AND bp.AD_Org_ID IN ('0','1000000','1000002','1000003','1000004','1000005','1000006','1000008','1000009','1000007')
AND bp.IsSummary='N'
AND bp.IsActive='Y'
AND UPPER(bp.Value) LIKE UPPER('%')
AND UPPER(bp.Name) LIKE C_IGNORE_ACCENT('%')
ORDER BY VALUE ASC
) A ) B
WHERE 1=1 AND RN1 BETWEEN 0 AND 51


Shows the error: ORA-00600: internal code error, arguments [evapls1],[], [], [], [], []

But if it is replaced the c_ignore_accent by upper function, the error disappear.
And, if in the filter of search key, "AND UPPER(bp.Value) LIKE UPPER('%')", is replaced the % with a character the error disappears, as well.

- Issue History
Date Modified Username Field Change
2008-04-30 13:39 plujan New Issue
2008-04-30 13:39 plujan Assigned To => cromero
2008-04-30 13:39 plujan File Added: R240_BUG_SearchingDebtPayment.JPG
2008-05-05 11:28 cromero Assigned To cromero => gorka_gil
2008-05-05 11:28 cromero Status new => @40@
2008-05-05 11:28 cromero Status @40@ => scheduled
2008-05-13 12:15 gorka_gil Status scheduled => resolved
2008-05-13 12:15 gorka_gil Resolution open => duplicate
2008-05-13 12:15 gorka_gil Note Added: 0000177
2008-05-21 18:55 cromero Target Version => R2.40alpha r2
2008-06-11 14:34 cromero Fixed in Version => 2.40alpha r2
2008-06-11 19:10 psarobe Status resolved => closed
2008-09-16 12:15 cromero Relationship added has duplicate 0004854
2008-09-22 13:35 gorka_gil Note Added: 0009117
2009-03-18 11:01 anonymous sf_bug_id 0 => 2691226
2011-01-20 17:31 rafaroda Issue Monitored: rafaroda

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker