Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
| ID | ||||||||
| 0011150 | ||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
| defect | [Openbravo ERP] Y. DBSourceManager | major | have not tried | 2009-10-27 16:09 | 2009-11-21 00:00 | |||
| Reporter | shuehner | View Status | public | |||||
| Assigned To | marvintm | |||||||
| Priority | urgent | Resolution | fixed | Fixed in Version | ||||
| Status | closed | Fix in branch | Fixed in SCM revision | 6a08cb684ed5 | ||||
| Projection | none | ETA | none | Target Version | ||||
| OS | Any | Database | Any | Java version | ||||
| OS Version | Database version | Ant version | ||||||
| Product Version | pi | SCM revision | ||||||
| Review Assigned To | ||||||||
| Web browser | ||||||||
| Modules | Core | |||||||
| Regression level | ||||||||
| Regression date | ||||||||
| Regression introduced in release | ||||||||
| Regression introduced by commit | ||||||||
| Triggers an Emergency Pack | No | |||||||
| Summary | 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 ]
|
|
 Relationships |
|
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 (manager) 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 --- |
|
Notes |
|
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-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 |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |