Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0013172Openbravo ERPY. DBSourceManagerpublic2010-04-30 16:112010-05-18 21:43
Reportermarvintm 
Assigned Tomarvintm 
PriorityimmediateSeveritymajorReproducibilityhave not tried
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version2.50MP14 
Target Version2.50MP17Fixed in Version2.50MP15 
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
Summary0013172: There are warnings when installing Spanish Professional Localization Pack in Oracle
DescriptionWhen installing the SPLP in Oracle, the following warnings appear in the build:


     [java] 293156 WARN - SQL Command failed with: ORA-01442: la columna que desea modificar a NOT NULL es ya NOT NULL
     [java]
     [java] 293162 WARN - -- END
     [java] ALTER TABLE C_COUNTRY MODIFY AD_CLIENT_ID VARCHAR2(32) NOT NULL
     [java] 293173 WARN - SQL Command failed with: ORA-01442: la columna que desea modificar a NOT NULL es ya NOT NULL
     [java]
     [java] 293175 WARN - -- END
     [java] ALTER TABLE C_COUNTRY MODIFY AD_ORG_ID VARCHAR2(32) NOT NULL
     [java] 293186 WARN - SQL Command failed with: ORA-01442: la columna que desea modificar a NOT NULL es ya NOT NULL
     [java]
     [java] 293190 WARN - -- END
     [java] ALTER TABLE C_COUNTRY MODIFY ISACTIVE CHAR(1) NOT NULL
     [java] 293201 WARN - SQL Command failed with: ORA-01442: la columna que desea modificar a NOT NULL es ya NOT NULL
     [java]
     [java] 293202 WARN - -- END
     [java] ALTER TABLE C_COUNTRY MODIFY CREATED DATE NOT NULL
     [java] 293213 WARN - SQL Command failed with: ORA-01442: la columna que desea modificar a NOT NULL es ya NOT NULL
     [java]
     [java] 293215 WARN - -- END
     [java] ALTER TABLE C_COUNTRY MODIFY CREATEDBY VARCHAR2(32) NOT NULL
     [java] 293226 WARN - SQL Command failed with: ORA-01442: la columna que desea modificar a NOT NULL es ya NOT NULL
     [java]
     [java] 293228 WARN - -- END
     [java] ALTER TABLE C_COUNTRY MODIFY UPDATED DATE NOT NULL
     [java] 293244 WARN - SQL Command failed with: ORA-01442: la columna que desea modificar a NOT NULL es ya NOT NULL
     [java]
     [java] 293246 WARN - -- END
     [java] ALTER TABLE C_COUNTRY MODIFY UPDATEDBY VARCHAR2(32) NOT NULL
     [java] 293256 WARN - SQL Command failed with: ORA-01442: la columna que desea modificar a NOT NULL es ya NOT NULL
     [java]
     [java] 293258 WARN - -- END
     [java] ALTER TABLE C_COUNTRY MODIFY NAME NVARCHAR2(60) NOT NULL
     [java] 293269 WARN - SQL Command failed with: ORA-01442: la columna que desea modificar a NOT NULL es ya NOT NULL
     [java]
     [java] 293271 WARN - -- END
     [java] ALTER TABLE C_COUNTRY MODIFY COUNTRYCODE CHAR(2) NOT NULL
     [java] 293282 WARN - SQL Command failed with: ORA-01442: la columna que desea modificar a NOT NULL es ya NOT NULL
     [java]
     [java] 293290 WARN - -- END
     [java] ALTER TABLE C_COUNTRY MODIFY HASREGION CHAR(1) NOT NULL
     [java] 293301 WARN - SQL Command failed with: ORA-01442: la columna que desea modificar a NOT NULL es ya NOT NULL
     [java]
     [java] 293304 WARN - -- END
     [java] ALTER TABLE C_COUNTRY MODIFY DISPLAYSEQUENCE NVARCHAR2(20) NOT NULL
     [java] 293315 WARN - SQL Command failed with: ORA-01442: la columna que desea modificar a NOT NULL es ya NOT NULL
     [java]
     [java] 293317 WARN - -- END
     [java] ALTER TABLE C_COUNTRY MODIFY HASPOSTAL_ADD CHAR(1) NOT NULL
     [java] 293328 WARN - SQL Command failed with: ORA-01442: la columna que desea modificar a NOT NULL es ya NOT NULL
     [java]
     [java] 293330 WARN - -- END
     [java] ALTER TABLE C_COUNTRY MODIFY EM_EUCNTRY_ISEUCOUNTRY CHAR(1) NOT NULL

These warnings are caused by two modules modifying the same table in the same pack.
Steps To ReproduceInstall Spanish Professional Localization Pack in Oracle.
Proposed SolutionDBSourceManager needs to be modified to fix this.
Additional Information
TagsRegression
Relationships
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2010-04-30 16:11marvintmNew Issue
2010-04-30 16:11marvintmAssigned To => marvintm
2010-04-30 16:11marvintmOBNetwork customer => No
2010-04-30 16:13hgbotCheckin
2010-04-30 16:13hgbotNote Added: 0026820
2010-04-30 16:13hgbotStatusnew => resolved
2010-04-30 16:13hgbotResolutionopen => fixed
2010-04-30 16:13hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/f25b4233f7e62a7269a3fa01511e6983ddcbf9ec [^]
2010-05-03 11:00psarobeTag Attached: Regression QA
2010-05-03 11:01psarobeTag Detached: Regression QA
2010-05-03 11:01psarobeTag Attached: Regression
2010-05-03 11:01psarobeversion => 2.50MP14
2010-05-03 18:35psarobeNote Added: 0026893
2010-05-03 18:35psarobeStatusresolved => closed
2010-05-03 18:35psarobeFixed in Version => 2.50MP15
2010-05-04 00:01anonymoussf_bug_id0 => 2996199
2010-05-18 12:12gorka_gilTarget Version2.50MP15 => 2.50MP17
2010-05-18 21:43hudsonbotCheckin
2010-05-18 21:43hudsonbotNote Added: 0027466

Notes
(0026820)
hgbot   
2010-04-30 16:13   
Repository: erp/devel/pi
Changeset: f25b4233f7e62a7269a3fa01511e6983ddcbf9ec
Author: Antonio Moreno <antonio.moreno <at> openbravo.com>
Date: Fri Apr 30 16:13:06 2010 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/f25b4233f7e62a7269a3fa01511e6983ddcbf9ec [^]

Fixed issue 13172. NOT NULL statements will no longer be issued if the table has been recreated twice, as the constraints are already activated.

---
M src-db/database/lib/dbsourcemanager.jar
---
(0026893)
psarobe   
2010-05-03 18:35   
Tested working fine
(0027466)
hudsonbot   
2010-05-18 21:43   
A changeset related to this issue has been promoted to main after passing a series of tests and an OBX has been generated:

Changeset: http://code.openbravo.com/erp/devel/main/rev/f25b4233f7e6 [^]
Merge Changeset: http://code.openbravo.com/erp/devel/main/rev/aa11838d5f80 [^]
Tests: http://builds.openbravo.com/view/devel-int/ [^]
OBX: http://builds.openbravo.com/erp/core/obx/OpenbravoERP-2.50CI.17380.obx [^]