Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
0000172Openbravo ERP01. General setuppublic2008-04-29 17:012011-03-15 13:46
plujan 
alostale 
normalminorhave not tried
closedfixed 
5
 
2.40alpha-r2pi 
Core
No
0000172: Database error when updating a Org Access Role
When I try to update a Org Access for a Role, I get a "Database Error" message. The Catalina log shows:
29-abr-2008 16:21:59 org.apache.catalina.session.StandardManager start
GRAVE: Excepción cargando sesiones desde almacenamiento persistente
java.io.EOFException
    at java.io.ObjectInputStream$PeekInputStream.readFully(Unknown Source)
    at java.io.ObjectInputStream$BlockDataInputStream.readShort(Unknown Source)
    at java.io.ObjectInputStream.readStreamHeader(Unknown Source)
    at java.io.ObjectInputStream.<init>(Unknown Source)
    at org.apache.catalina.util.CustomObjectInputStream.<init>(CustomObjectInputStream.java:58)
    at org.apache.catalina.session.StandardManager.doLoad(StandardManager.java:362)
    at org.apache.catalina.session.StandardManager.load(StandardManager.java:321)
    at org.apache.catalina.session.StandardManager.start(StandardManager.java:637)
    at org.apache.catalina.core.ContainerBase.setManager(ContainerBase.java:433)
    at org.apache.catalina.core.StandardContext.start(StandardContext.java:4257)
    at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:761)
    at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:741)
    at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:525)
    at org.apache.catalina.startup.HostConfig.deployDirectory(HostConfig.java:920)
    at org.apache.catalina.startup.HostConfig.deployDirectories(HostConfig.java:883)
    at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:492)
    at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1138)
    at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:311)
    at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:120)
    at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1023)
    at org.apache.catalina.core.StandardHost.start(StandardHost.java:719)
    at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1015)
    at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:443)
    at org.apache.catalina.core.StandardService.start(StandardService.java:448)
    at org.apache.catalina.core.StandardServer.start(StandardServer.java:710)
    at org.apache.catalina.startup.Catalina.start(Catalina.java:552)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
    at java.lang.reflect.Method.invoke(Unknown Source)
    at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:288)
    at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:413)
1. Create a New Role
2. Check Manual
3. Choose Client + Org access
4. Click Grant Access and select Sales Management
5. Go Org Access
6. With default values, click Save.
7. Change the Organization combo and Save again. A "Database Error" message is shown.
No tags attached.
depends on backport 0003969 closed alostale Database error when updating a Org Access Role 
related to defect 0004015 closed alostale JavaNullPointer exception updating org access 
related to backport 0005291 closed alostale 'Database Error' when changing User Role 
png orgaccess.PNG (128,518) 2008-06-11 19:47
https://issues.openbravo.com/file_download.php?file_id=71&type=bug
png
Issue History
2008-04-29 17:01plujanNew Issue
2008-04-29 17:01plujanAssigned To => alostale
2008-05-05 11:26cromeroStatusnew => @40@
2008-05-05 18:01cromeroStatus@40@ => scheduled
2008-05-05 18:01cromeroNote Added: 0000046
2008-05-06 12:22alostaleStatusscheduled => resolved
2008-05-06 12:22alostaleFixed in Version => trunk
2008-05-06 12:22alostaleResolutionopen => fixed
2008-05-06 12:22alostaleNote Added: 0000052
2008-05-21 19:05cromeroTarget Version => R2.40alpha r2
2008-06-11 19:46psarobeStatusresolved => new
2008-06-11 19:46psarobeResolutionfixed => open
2008-06-11 19:46psarobeNote Added: 0000506
2008-06-11 19:47psarobeFile Added: orgaccess.PNG
2008-06-13 18:19cromeroStatusnew => scheduled
2008-06-17 11:29alostaleRelationship addedrelated to 0004015
2008-06-17 11:31alostaleStatusscheduled => resolved
2008-06-17 11:31alostalesvn_revision => 3961
2008-06-17 11:31alostaleResolutionopen => fixed
2008-06-17 11:31alostaleNote Added: 0007770
2008-07-01 17:56anonymoussf_bug_id0 => 2007864
2008-11-21 22:41anonymousStatusresolved => closed
2008-11-21 22:41anonymousNote Added: 0010531
2008-12-11 17:11alostaleRelationship addedrelated to 0005291
2011-03-04 09:48hgbotCheckin
2011-03-04 09:48hgbotNote Added: 0034545
2011-03-04 09:48hgbotStatusclosed => resolved
2011-03-04 09:48hgbotFixed in SCM revision3961 => http://code.openbravo.com/erp/pmods/org.openbravo.growthmachine/rev/c649485444f9c0544213c1cf8a2a5dcf7d11b488 [^]
2011-03-15 13:46iperdomoStatusresolved => closed

Notes
(0000046)
cromero   
2008-05-05 18:01   
For the branch exists a workaround: not to modify the org access and to create a new org access for the another organization.

Thield Organization could be set as Readonly to prevent this bug.
(0000052)
alostale   
2008-05-06 12:22   
The problem was caused because AD_Org_ID field is part of the primary key for AD_Role_OrgAccess table, and this was the field that was being modified.
(0000506)
psarobe   
2008-06-11 19:46   
can still reproduce and gives you another error. Please see the attach
(0007770)
alostale   
2008-06-17 11:31   
The described problem by psarobe is another bug: 0003969
(0010531)
anonymous   
2008-11-21 22:41   
Closed
(0034545)
hgbot   
2011-03-04 09:48   
Repository: erp/pmods/org.openbravo.growthmachine
Changeset: c649485444f9c0544213c1cf8a2a5dcf7d11b488
Author: Gorka Mauleon <gorka.mauleon <at> openbravo.com>
Date: Mon Feb 28 16:22:31 2011 +0100
URL: http://code.openbravo.com/erp/pmods/org.openbravo.growthmachine/rev/c649485444f9c0544213c1cf8a2a5dcf7d11b488 [^]

fixes issue 172 El campo Release debe ser obligatorio para Contratos OBPS o Basic.

---
M src-db/database/sourcedata/AD_COLUMN.xml
M src-db/database/sourcedata/AD_REF_TABLE.xml
M src/org/openbravo/growthmachine/manager/ContractManager.java
M src/org/openbravo/growthmachine/manager/ProfessionalSubsManager.java
---