0013172: There are warnings when installing Spanish Professional Localization Pack in Oracle

Description

When 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 Reproduce

Install Spanish Professional Localization Pack in Oracle.

Proposed Solution

DBSourceManager needs to be modified to fix this.

Tags

Regression

Attached Files

Relationships [ Relation Graph ] [ Dependency Graph ]

Notes
(0026820) hgbot (developer) 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 (viewer) 2010-05-03 18:35	Tested working fine

(0027466) hudsonbot (viewer) 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 [^]

Issue History
Date Modified	Username	Field	Change
2010-04-30 16:11	marvintm	New Issue
2010-04-30 16:11	marvintm	Assigned To	=> marvintm
2010-04-30 16:11	marvintm	OBNetwork customer	=> No
2010-04-30 16:13	hgbot	Checkin
2010-04-30 16:13	hgbot	Note Added: 0026820
2010-04-30 16:13	hgbot	Status	new => resolved
2010-04-30 16:13	hgbot	Resolution	open => fixed
2010-04-30 16:13	hgbot	Fixed in SCM revision	=> http://code.openbravo.com/erp/devel/pi/rev/f25b4233f7e62a7269a3fa01511e6983ddcbf9ec [^]
2010-05-03 11:00	psarobe	Tag Attached: Regression QA
2010-05-03 11:01	psarobe	Tag Detached: Regression QA
2010-05-03 11:01	psarobe	Tag Attached: Regression
2010-05-03 11:01	psarobe	version	=> 2.50MP14
2010-05-03 18:35	psarobe	Note Added: 0026893
2010-05-03 18:35	psarobe	Status	resolved => closed
2010-05-03 18:35	psarobe	Fixed in Version	=> 2.50MP15
2010-05-04 00:01	anonymous	sf_bug_id	0 => 2996199
2010-05-18 12:12	gorka_gil	Target Version	2.50MP15 => 2.50MP17
2010-05-18 21:43	hudsonbot	Checkin
2010-05-18 21:43	hudsonbot	Note Added: 0027466