Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0015941Openbravo ERP00. Application dictionarypublic2011-02-10 16:562011-05-03 00:01
Reporterxabiermerino 
Assigned Toegoitz 
PriorityhighSeverityminorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version2.50MP26 
Target Version2.50MP28Fixed in Version 
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
Summary0015941: 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.
Additional Information
TagsNo tags attached.
Relationships
related to backport 00172812.50MP30 closed egoitz The invoice regsiter book does not work after a change on core 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2011-02-10 16:56xabiermerinoNew Issue
2011-02-10 16:56xabiermerinoAssigned To => alostale
2011-02-10 16:56xabiermerinoModules => Core
2011-02-10 16:56xabiermerinoOBNetwork customer => Yes
2011-02-14 08:22alostaleStatusnew => scheduled
2011-03-01 14:03alostaleAssigned Toalostale => adrianromero
2011-04-26 12:32egoitzAssigned Toadrianromero => egoitz
2011-04-26 13:38egoitzAssigned Toegoitz => adrianromero
2011-04-26 16:10dalsasuaIssue Monitored: networkb
2011-04-29 09:04egoitzAssigned Toadrianromero => egoitz
2011-04-29 13:34hgbotCheckin
2011-04-29 13:34hgbotNote Added: 0036222
2011-04-29 13:34hgbotStatusscheduled => resolved
2011-04-29 13:34hgbotResolutionopen => fixed
2011-04-29 13:34hgbotFixed in SCM revision => http://code.openbravo.com/erp/stable/2.50/rev/8f21eaa989d09d78995a7db49ed8979a79b661ee [^]
2011-05-02 12:04xabiermerinoNote Added: 0036252
2011-05-02 12:04xabiermerinoStatusresolved => closed
2011-05-03 00:01anonymoussf_bug_id0 => 3296505
2011-05-19 17:41dalsasuaRelationship addedrelated to 0017281

Notes
(0036222)
hgbot   
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   
2011-05-02 12:04   
verified