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

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0015941
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] 00. Application dictionaryminoralways2011-02-10 16:562011-05-03 00:01
ReporterxabiermerinoView Statuspublic 
Assigned Toegoitz 
PriorityhighResolutionfixedFixed in Version
StatusclosedFix in branchFixed in SCM revision8f21eaa989d0
ProjectionnoneETAnoneTarget Version2.50MP28
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product Version2.50MP26SCM revision 
Merge Request Status
Review Assigned To
OBNetwork customerOBPS
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0015941: Error when check as identifier the column C_Calendar_ID in the table C_year

DescriptionThe window Open/Close Period Control does not work if the column C_Calendar_ID of the table C_Year is checked as identifier.

This error appears:
    
Error:
java.lang.Exception: CODE=0ERROR: column reference "c_calendar_id" is ambiguous
Steps To Reproduce- As System Administrator go to Application Dictionary || Tables and Columns
- Select C_yeear and go to column
- Select C_Calendar_ID
- Check 'Used as Record Identifier'
- Compile and restart Tomcat
- As Openbravo Admin go to Open/Close Period COntrol
- Realize that the error appears
Proposed SolutionThe problem is the validation 'C_Calendar and C_Year of an organization'.

It should be:

@C_CALENDAR_ID@ IN (SELECT DISTINCT(C_CALENDAR_ID) FROM AD_ORG WHERE AD_ORG_ID=AD_ORG_GETCALENDAROWNER(@AD_ORG_ID@))

Note: It should be better the calusule EXISTS instead of IN.
TagsNo tags attached.
Attached Files

- Relationships [ Relation Graph ] [ Dependency Graph ]
related to backport 00172812.50MP30 closedegoitz The invoice regsiter book does not work after a change on core 

-  Notes
(0036222)
hgbot (developer)
2011-04-29 13:34

 Repository: erp/stable/2.50
Changeset: 8f21eaa989d09d78995a7db49ed8979a79b661ee
Author: Egoitz Castillo <egoitz.castillo <at> openbravo.com>
Date: Fri Apr 29 11:35:42 2011 +0200
URL: http://code.openbravo.com/erp/stable/2.50/rev/8f21eaa989d09d78995a7db49ed8979a79b661ee [^]

Fixed Issue 15941. wrong validation on c_periodcontrol_log

---
M src-db/database/sourcedata/AD_VAL_RULE.xml
---
(0036252)
xabiermerino (viewer)
2011-05-02 12:04

 verified

- Issue History
Date Modified Username Field Change
2011-02-10 16:56 xabiermerino New Issue
2011-02-10 16:56 xabiermerino Assigned To => alostale
2011-02-10 16:56 xabiermerino Modules => Core
2011-02-10 16:56 xabiermerino OBNetwork customer => Yes
2011-02-14 08:22 alostale Status new => scheduled
2011-03-01 14:03 alostale Assigned To alostale => adrianromero
2011-04-26 12:32 egoitz Assigned To adrianromero => egoitz
2011-04-26 13:38 egoitz Assigned To egoitz => adrianromero
2011-04-26 16:10 dalsasua Issue Monitored: networkb
2011-04-29 09:04 egoitz Assigned To adrianromero => egoitz
2011-04-29 13:34 hgbot Checkin
2011-04-29 13:34 hgbot Note Added: 0036222
2011-04-29 13:34 hgbot Status scheduled => resolved
2011-04-29 13:34 hgbot Resolution open => fixed
2011-04-29 13:34 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/stable/2.50/rev/8f21eaa989d09d78995a7db49ed8979a79b661ee [^]
2011-05-02 12:04 xabiermerino Note Added: 0036252
2011-05-02 12:04 xabiermerino Status resolved => closed
2011-05-03 00:01 anonymous sf_bug_id 0 => 3296505
2011-05-19 17:41 dalsasua Relationship added related to 0017281

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker