Openbravo Issue Tracking System - Openbravo ERP | |||||
| View Issue Details | |||||
| ID | Project | Category | View Status | Date Submitted | Last Update |
| 0011150 | Openbravo ERP | Y. DBSourceManager | public | 2009-10-27 16:09 | 2009-11-21 00:00 |
| Reporter | shuehner | ||||
| Assigned To | marvintm | ||||
| Priority | urgent | Severity | major | Reproducibility | have not tried |
| Status | closed | Resolution | fixed | ||
| Platform | OS | 5 | OS Version | ||
| Product Version | pi | ||||
| Target Version | Fixed in Version | ||||
| Merge Request Status | |||||
| Review Assigned To | |||||
| OBNetwork customer | No | ||||
| Web browser | |||||
| Modules | Core | ||||
| Support ticket | |||||
| 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 | ||||
| Proposed Solution | |||||
| Additional Information | |||||
| Tags | No tags attached. | ||||
| Relationships | |||||
| Attached Files | |||||
| 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 | ||
| Notes | |||||
|
|
|||||
|
|
||||
|
|
|||||
|
|
||||
|
|
|||||
|
|
||||