Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0004854Openbravo ERP02. Master data managementpublic2008-09-08 14:432011-01-20 17:31
ReporterRenateNieuwkoop 
Assigned Tocromero 
PrioritynormalSeveritytrivialReproducibilityalways
StatusclosedResolutionduplicate 
PlatformOS5OS Version
Product Version2.40beta 
Target VersionFixed in Version 
Merge Request Status
Review Assigned To
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0004854: ORA 00600 error when doing search in BP window
DescriptionMaster Data Management || Business Partner || Business Partner

When doing a partial search for the business partner (simp%), there is an error on the screen (see snapshot)
Steps To Reproduce
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
duplicate of defect 00001792.40alpha-r2 closed gorka_gil When searching for Debt Payments, I get an Oracle internal error on a javascript alert window 
has duplicate defect 0005617 closed shuehner Filter business partner 
Attached Filesjpg 0809errorBPsetup.jpg (139,565) 2008-09-08 14:43
https://issues.openbravo.com/file_download.php?file_id=244&type=bug
jpg
Issue History
Date ModifiedUsernameFieldChange
2008-09-08 14:43RenateNieuwkoopNew Issue
2008-09-08 14:43RenateNieuwkoopAssigned To => cromero
2008-09-08 14:43RenateNieuwkoopsf_bug_id0 => 2100121
2008-09-08 14:43RenateNieuwkoopFile Added: 0809errorBPsetup.jpg
2008-09-16 12:15cromeroRelationship addedduplicate of 0000179
2008-09-16 12:16cromeroRegression testing => No
2008-09-16 12:16cromeroStatusnew => closed
2008-09-16 12:16cromeroNote Added: 0009033
2008-09-16 12:16cromeroDuplicate ID0 => 179
2008-09-16 12:16cromeroResolutionopen => duplicate
2008-10-23 10:32shuehnerRelationship addedhas duplicate 0005617
2009-02-18 08:11thirumalaiNote Added: 0013619
2011-01-20 17:31rafarodaIssue Monitored: rafaroda

Notes
(0009033)
cromero   
2008-09-16 12:16   
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;

It exists a workaround writing this in the openbravo.properties

bbdd.sessionConfig=ALTER SESSION SET NLS_DATE_FORMAT='DD-MM-YYYY' NLS_NUMERIC_CHARACTERS='.,' "_optimizer_filter_pred_pullup"=false
(0013619)
thirumalai   
2009-02-18 08:11   
I tried this link
(http://database.in2p3.fr/10203_buglist.htm [^])
but it says
The requested URL /10203_buglist.htm) was not found on this server.