Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0002760Openbravo ERPC. Securitypublic2008-03-26 10:102008-06-12 09:43
Reporteruser71 
Assigned Tomarvintm 
PrioritynormalSeverityminorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version2.40alpha-r2 
Merge Request Status
Review Assigned To
OBNetwork customerNo
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0002760: User Option
DescriptionHi
If in the application on user option i set the field "Set as default" on yes, after the task ant create.database give an error on constraint adorg_aduserdefault.
 
Steps To Reproduce
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
Attached Files
Issue History
Date ModifiedUsernameFieldChange

Notes
(0006349)
user71   
2005-06-01 00:00   
(edited on: 2008-06-12 09:43)
This bug was originally reported in SourceForge bug tracker and then migrated to Mantis.

You can see the original bug report in:
https://sourceforge.net/support/tracker.php?aid=1925926 [^]
(0003366)
cromero   
2008-03-31 09:59   
(edited on: 2008-06-12 09:25)
Logged In: YES
user_id=1500614
Originator: NO

The description of this bug is not specific enough . The information required for reproducing this bug is not in its description.
Please make sure to specify:
1) Complete problem description
2) Environment details (Openbravo version, database type and OS)
3) Specific steps on how to reproduce the problem.

For more information, pleas refer to: http://wiki.openbravo.com/wiki/index.php/Bug_Reporting_Guidelines [^]

Please, reopen this bug adding the required details.

Thank you.

The Openbravo Team
(0003367)
user71   
2008-03-31 11:43   
(edited on: 2008-06-12 09:25)
Logged In: YES
user_id=2039358
Originator: YES

We work on the branch of witholding,
the database is oracle and OS is Windows XP.
The steps are :
1) Change user and set the field "Set as default" on yes (see the attach).
2) Launch task Export.database
3) Launch task Export.database.masterdata
4) Launch task Export.database.sampledata
5) Launch the task create.database.

The error is :
database.preimport.ORACLE:
  [importdata] SQL command failed with ORA-02298: impossibile convalidare (TAD.ADROLE_ADUSERDEFAULT) - chiavi padre non trovate
  [importdata] ALTER TABLE AD_USER ENABLE CONSTRAINT ADROLE_ADUSERDEFAULT

BUILD FAILED
C:\OpenbravoITA\openbravo\build.xml:253: The following error occurred while executing this line:
C:\OpenbravoITA\openbravo\database\build.xml:99: The following error occurred while executing this line:
C:\OpenbravoITA\openbravo\database\build.xml:342: org.apache.ddlutils.DatabaseOperationException: Error while enabling foreign key


File Added: changeuser.JPG
(0003368)
cromero   
2008-03-31 12:27   
(edited on: 2008-06-12 09:25)
Logged In: YES
user_id=1500614
Originator: NO

The problem is that create.database process is trying to enable constraints for each block:
- You are encountering the problem importing masterdata because you have set as default an user defined role (present in the sample data).
This should not happen and must be fixed.

As workaround, you can do:
1) Launch task import.database.masterdata: you will get again the same error
2) Launch task import.database.sampledata: constraint will be enabled once you have inserted the needed roles.
(0003369)
marvintm   
2008-05-20 17:21   
(edited on: 2008-06-12 09:25)
Logged In: YES
user_id=1952914
Originator: NO

We have tested this bug in the subversion repository and it has just been fixed.

Note that the only supported version of the application is the one in subversion. So it is possible that this was a bug in a previous version that is already fixed.
(0003370)
marvintm   
2008-05-20 17:21   
(edited on: 2008-06-12 09:25)
Logged In: YES
user_id=1952914
Originator: NO

The problem was that before, DBSourceManager tried to enable the constraints after importing sourcedata but before importing masterdata and sampledata.

Now, when performing a create.database, the constraints are activated at the end of the whole process, and this problem, and problems like this one, should not happen again.