Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0012694Openbravo ERPZ. Otherspublic2010-03-16 11:312010-12-09 15:59
Reportergorkaion 
Assigned Tomtaal 
PrioritynormalSeveritycriticalReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS20OS VersionGentoo
Product Version2.50 
Target VersionFixed in Version2.50 
Merge Request Status
Review Assigned To
OBNetwork customerNo
Web browser
ModulesUser Interface Selector
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0012694: Triggers in invalid status on oracle
DescriptionHi,

I've installed the module both from the Central Repository and from code.openbravo.com and the triggers OBUISEL_ELEMENT_TRL_TRG and OBUISEL_SELECTOR_FIELD_TRG are generated in invalid status so I cannot create any new selector.
Steps To ReproduceInstall the module in an Oracle instance.
Create a new selector.
Create a new defined selector.
Create a new Defined selector field.

the last step fails with an error.
Proposed SolutionI attach a fix that solves the issue, but I'm not sure if it is correct.
Additional Information
TagsNo tags attached.
Relationships
has duplicate defect 00127072.50 closed shuehner Some triggers in the module do not compile 
Attached Filespatch triggers-fix.patch (2,064) 2010-03-16 11:31
https://issues.openbravo.com/file_download.php?file_id=2348&type=bug
Issue History
Date ModifiedUsernameFieldChange
2010-03-16 11:31gorkaionNew Issue
2010-03-16 11:31gorkaionAssigned To => mtaal
2010-03-16 11:31gorkaionFile Added: triggers-fix.patch
2010-03-16 11:31gorkaionOBNetwork customer => No
2010-03-17 17:18gorkaionRelationship addedhas duplicate 0012707
2010-03-18 10:25mtaalStatusnew => scheduled
2010-03-18 10:25mtaalNote Added: 0025586
2010-03-18 10:25mtaalfix_in_branch => pi
2010-03-18 10:25mtaalNote Added: 0025587
2010-03-18 10:25mtaalStatusscheduled => resolved
2010-03-18 10:25mtaalFixed in Version => 2.50
2010-03-18 10:25mtaalResolutionopen => fixed
2010-03-29 14:56shuehnerNote Added: 0025775
2010-03-29 14:56shuehnerStatusresolved => closed
2010-12-09 15:59anonymoussf_bug_id0 => 3133053

Notes
(0025586)
mtaal   
2010-03-18 10:25   
scheduled
(0025587)
mtaal   
2010-03-18 10:25   
Fixed in this changeset:
https://code.openbravo.com/erp/mods/org.openbravo.userinterface.selector/rev/c049da87bf86 [^]
(0025775)
shuehner   
2010-03-29 14:56   
Tested on pi, the triggers don't have compile errors on oracle and adding selector fields works fine.