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

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0000172
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] 01. General setupminorhave not tried2008-04-29 17:012011-03-15 13:46
ReporterplujanView Statuspublic 
Assigned Toalostale 
PrioritynormalResolutionfixedFixed in Versionpi
StatusclosedFix in branchFixed in SCM revisionc649485444f9
ProjectionnoneETAnoneTarget Version2.40alpha-r2
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Review Assigned To
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0000172: Database error when updating a Org Access Role

DescriptionWhen 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)
Steps To Reproduce1. 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.
TagsNo tags attached.
Attached Filespng file icon orgaccess.PNG [^] (128,518 bytes) 2008-06-11 19:47

- Relationships Relation Graph ] Dependency Graph ]
depends on backport 0003969 closedalostale Database error when updating a Org Access Role 
related to defect 0004015 closedalostale JavaNullPointer exception updating org access 
related to backport 0005291 closedalostale 'Database Error' when changing User Role 

-  Notes
(0000046)
cromero (reporter)
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 (manager)
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 (manager)
2008-06-11 19:46

can still reproduce and gives you another error. Please see the attach
(0007770)
alostale (manager)
2008-06-17 11:31

The described problem by psarobe is another bug: 0003969
(0010531)
anonymous (viewer)
2008-11-21 22:41

Closed
(0034545)
hgbot (developer)
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
---

- Issue History
Date Modified Username Field Change
2008-04-29 17:01 plujan New Issue
2008-04-29 17:01 plujan Assigned To => alostale
2008-05-05 11:26 cromero Status new => @40@
2008-05-05 18:01 cromero Status @40@ => scheduled
2008-05-05 18:01 cromero Note Added: 0000046
2008-05-06 12:22 alostale Status scheduled => resolved
2008-05-06 12:22 alostale Fixed in Version => trunk
2008-05-06 12:22 alostale Resolution open => fixed
2008-05-06 12:22 alostale Note Added: 0000052
2008-05-21 19:05 cromero Target Version => R2.40alpha r2
2008-06-11 19:46 psarobe Status resolved => new
2008-06-11 19:46 psarobe Resolution fixed => open
2008-06-11 19:46 psarobe Note Added: 0000506
2008-06-11 19:47 psarobe File Added: orgaccess.PNG
2008-06-13 18:19 cromero Status new => scheduled
2008-06-17 11:29 alostale Relationship added related to 0004015
2008-06-17 11:31 alostale Status scheduled => resolved
2008-06-17 11:31 alostale svn_revision => 3961
2008-06-17 11:31 alostale Resolution open => fixed
2008-06-17 11:31 alostale Note Added: 0007770
2008-07-01 17:56 anonymous sf_bug_id 0 => 2007864
2008-11-21 22:41 anonymous Status resolved => closed
2008-11-21 22:41 anonymous Note Added: 0010531
2008-12-11 17:11 alostale Relationship added related to 0005291
2011-03-04 09:48 hgbot Checkin
2011-03-04 09:48 hgbot Note Added: 0034545
2011-03-04 09:48 hgbot Status closed => resolved
2011-03-04 09:48 hgbot Fixed in SCM revision 3961 => http://code.openbravo.com/erp/pmods/org.openbravo.growthmachine/rev/c649485444f9c0544213c1cf8a2a5dcf7d11b488 [^]
2011-03-15 13:46 iperdomo Status resolved => closed


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker