0002760: User Option - Openbravo Issue Tracking System

Notes
(0003366) cromero (reporter) 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 (reporter) 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 (developer) 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 (developer) 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.

(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 [^]

Issue History
Date Modified	Username	Field	Change

Relationships [ Relation Graph ] [ Dependency Graph ]