0011150: dbsourcemanager does install the apparel module correctly (error with new fields and not null)

Description

     [java] SQL Command failed with: ORA-00904: "EM_APPAREL_CREATELINES": invalid identifier
     [java]
     [java] -- END
     [java] ALTER TABLE C_INVOICE_ MODIFY EM_APPAREL_CREATELINES CHAR(1) NULL
     [java] SQL Command failed with: ORA-00904: "EM_APPAREL_CREATELINES": invalid identifier
     [java]
     [java] -- END
     [java] ALTER TABLE C_ORDER_ MODIFY EM_APPAREL_CREATELINES CHAR(1) NULL
     [java] SQL Command failed with: ORA-00904: "EM_APPAREL_ISSIZE": invalid identifier
     [java]
     [java] -- END
     [java] ALTER TABLE M_ATTRIBUTE_ MODIFY EM_APPAREL_ISSIZE CHAR(1) NULL
     [java] SQL Command failed with: ORA-00904: "EM_APPAREL_ISCOLOR": invalid identifier
     [java]
     [java] -- END
     [java] ALTER TABLE M_ATTRIBUTE_ MODIFY EM_APPAREL_ISCOLOR CHAR(1) NULL
     [java] SQL Command failed with: ORA-00904: "EM_APPAREL_CREATELINES": invalid identifier
     [java]
     [java] -- END
     [java] ALTER TABLE M_INOUT_ MODIFY EM_APPAREL_CREATELINES CHAR(1) NULL
     [java] Executed 983 SQL command(s) with 5 error(s)
     [java] Model update complete.
     [java] Disabling foreign keys
     [java] Disabling triggers
     [java] SQL Command failed with: ORA-01451: column to be modified to NULL cannot be modified to NULL
     [java]
     [java] -- END
     [java] ALTER TABLE C_INVOICE MODIFY EM_APPAREL_CREATELINES CHAR(1) NULL
     [java] SQL Command failed with: ORA-01451: column to be modified to NULL cannot be modified to NULL
     [java]
     [java] -- END
     [java] ALTER TABLE C_ORDER MODIFY EM_APPAREL_CREATELINES CHAR(1) NULL
     [java] SQL Command failed with: ORA-01451: column to be modified to NULL cannot be modified to NULL
     [java]
     [java] -- END
     [java] ALTER TABLE M_ATTRIBUTE MODIFY EM_APPAREL_ISSIZE CHAR(1) NULL
     [java] SQL Command failed with: ORA-01451: column to be modified to NULL cannot be modified to NULL
     [java]
     [java] -- END
     [java] ALTER TABLE M_ATTRIBUTE MODIFY EM_APPAREL_ISCOLOR CHAR(1) NULL
     [java] SQL Command failed with: ORA-01451: column to be modified to NULL cannot be modified to NULL
     [java]
     [java] -- END
     [java] ALTER TABLE M_INOUT MODIFY EM_APPAREL_CREATELINES CHAR(1) NULL

....

     [java] Executing update final script (NOT NULLs and dropping temporary tables
     [java] Executed 368 SQL command(s) with 0 error(s)
     [java] Executed 131 SQL command(s) with 0 error(s)
     [java] SQL Command failed with: ORA-01442: column to be modified to NOT NULL is already NOT NULL
     [java]
     [java] -- END
     [java] ALTER TABLE C_INVOICE MODIFY EM_APPAREL_CREATELINES CHAR(1) NOT NULL
     [java] SQL Command failed with: ORA-01442: column to be modified to NOT NULL is already NOT NULL
     [java]
     [java] -- END
     [java] ALTER TABLE C_ORDER MODIFY EM_APPAREL_CREATELINES CHAR(1) NOT NULL
     [java] SQL Command failed with: ORA-01442: column to be modified to NOT NULL is already NOT NULL
     [java]
     [java] -- END
     [java] ALTER TABLE M_ATTRIBUTE MODIFY EM_APPAREL_ISSIZE CHAR(1) NOT NULL
     [java] SQL Command failed with: ORA-01442: column to be modified to NOT NULL is already NOT NULL
     [java]
     [java] -- END
     [java] ALTER TABLE M_ATTRIBUTE MODIFY EM_APPAREL_ISCOLOR CHAR(1) NOT NULL
     [java] SQL Command failed with: ORA-01442: column to be modified to NOT NULL is already NOT NULL
     [java]
     [java] -- END
     [java] ALTER TABLE M_INOUT MODIFY EM_APPAREL_CREATELINES CHAR(1) NOT NULL
     [java] Executed 56 SQL command(s) with 5 error(s)
     [java] Enabling Foreign Keys and Triggers
     [java] Executing default postscript

Steps To Reproduce

Try to install the apparel module.
Check log output

Tags

No tags attached.

Attached Files

Relationships [ Relation Graph ] [ Dependency Graph ]

Notes
(0021464) hgbot (developer) 2009-10-29 11:19	Repository: erp/devel/pi Changeset: 6612a9430a4058e68141008128c17380aabdf1c5 Author: Antonio Moreno <antonio.moreno <at> openbravo.com> Date: Thu Oct 29 11:18:44 2009 +0100 URL: http://code.openbravo.com/erp/devel/pi/rev/6612a9430a4058e68141008128c17380aabdf1c5 [^] Fixed issue 11150. New columns will not be changed to nullable on the temporary table. --- M src-db/database/lib/dbsourcemanager.jar ---

(0022049) alostale (viewer) 2009-11-20 10:09	Even though build is successful, the error messages in log still appear.

(0022061) hgbot (developer) 2009-11-20 13:16	Repository: erp/devel/pi Changeset: 6a08cb684ed5cf954a18655cdaf3d9f323bddaaa Author: Antonio Moreno <antonio.moreno <at> openbravo.com> Date: Fri Nov 20 13:16:26 2009 +0100 URL: http://code.openbravo.com/erp/devel/pi/rev/6a08cb684ed5cf954a18655cdaf3d9f323bddaaa [^] Fixed issue 11150. NOT NULL columns will not be considered when removing or enabling NOT NULL constraints if they belong to a recreated table. --- M src-db/database/lib/dbsourcemanager.jar ---

Issue History
Date Modified	Username	Field	Change
2009-10-27 16:09	shuehner	New Issue
2009-10-27 16:09	shuehner	Assigned To	=> marvintm
2009-10-27 16:09	shuehner	OBNetwork customer	=> No
2009-10-29 11:19	hgbot	Checkin
2009-10-29 11:19	hgbot	Note Added: 0021464
2009-10-29 11:19	hgbot	Status	new => resolved
2009-10-29 11:19	hgbot	Resolution	open => fixed
2009-10-29 11:19	hgbot	Fixed in SCM revision	=> http://code.openbravo.com/erp/devel/pi/rev/6612a9430a4058e68141008128c17380aabdf1c5 [^]
2009-11-20 10:09	alostale	Note Added: 0022049
2009-11-20 10:09	alostale	Status	resolved => new
2009-11-20 10:09	alostale	Resolution	fixed => open
2009-11-20 13:16	hgbot	Checkin
2009-11-20 13:16	hgbot	Note Added: 0022061
2009-11-20 13:16	hgbot	Status	new => resolved
2009-11-20 13:16	hgbot	Resolution	open => fixed
2009-11-20 13:16	hgbot	Fixed in SCM revision	http://code.openbravo.com/erp/devel/pi/rev/6612a9430a4058e68141008128c17380aabdf1c5 [^] => http://code.openbravo.com/erp/devel/pi/rev/6a08cb684ed5cf954a18655cdaf3d9f323bddaaa [^]
2009-11-20 14:00	alostale	Status	resolved => closed
2009-11-21 00:00	anonymous	sf_bug_id	0 => 2901470