Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
| ID | ||||||||
| 0010684 | ||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
| defect | [Openbravo ERP] A. Platform | minor | have not tried | 2009-09-21 14:22 | 2009-10-09 00:00 | |||
| Reporter | jpabloae | View Status | public | |||||
| Assigned To | marvintm | |||||||
| Priority | urgent | Resolution | fixed | Fixed in Version | 2.40MP10 | |||
| Status | closed | Fix in branch | Fixed in SCM revision | 512ab0a7177c | ||||
| Projection | none | ETA | none | Target Version | ||||
| OS | Linux 64 bit | Database | Oracle | Java version | 1.6.0_11 | |||
| OS Version | Gentoo - 2.6.26 | Database version | 10.2.0.4 | Ant version | 1.7.0 | |||
| Product Version | 2.40MP9 | SCM revision | f087014b660f | |||||
| 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 | 0010684: Table overwrite error in the prescript of update.database | |||||||
| Description | The update.database shows an error at the beginning of the process in the prescript: update.database: [alterdatabasedata] Executing default prescript [alterdatabasedata] SQL Command failed with: ORA-00955: name is already used by an existing object [alterdatabasedata] [alterdatabasedata] -- create temporary tables [alterdatabasedata] CREATE GLOBAL TEMPORARY TABLE C_TEMP_SELECTION [alterdatabasedata] ( [alterdatabasedata] C_TEMP_SELECTION_ID NUMBER(10) NOT NULL, [alterdatabasedata] CONSTRAINT C_TEMP_SELECTION_key PRIMARY KEY (C_TEMP_SELECTION_ID) [alterdatabasedata] ) [alterdatabasedata] ON COMMIT DELETE ROWS [alterdatabasedata] SQL Command failed with: ORA-00955: name is already used by an existing object [alterdatabasedata] [alterdatabasedata] -- END [alterdatabasedata] [alterdatabasedata] CREATE GLOBAL TEMPORARY TABLE C_TEMP_SELECTION2 [alterdatabasedata] ( [alterdatabasedata] QUERY_ID NUMBER(10) NOT NULL, [alterdatabasedata] C_TEMP_SELECTION_ID NUMBER(10) NOT NULL, [alterdatabasedata] CONSTRAINT C_TEMP_SELECTION2_key PRIMARY KEY (QUERY_ID, C_TEMP_SELECTION_ID) [alterdatabasedata] ) [alterdatabasedata] ON COMMIT PRESERVE ROWS [alterdatabasedata] Executed 3 SQL command(s) with 2 error(s) [alterdatabasedata] Reading tables... [alterdatabasedata] Reading views... [alterdatabasedata] Reading sequences... [alterdatabasedata] Reading triggers... [alterdatabasedata] Reading functions... Although they're probably inoffensive, they can be very confusing for the system integrator doing the update process. | |||||||
| Tags | No tags attached. | |||||||
| Attached Files | ||||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
|
 Relationships |
|
Notes |
|
|
(0020319) hgbot (developer) 2009-09-23 16:16 |
Repository: erp/stable/2.40 Changeset: 512ab0a7177c72e415929a0df2b8f88b96318d36 Author: Antonio Moreno <antonio.moreno <at> openbravo.com> Date: Wed Sep 23 16:14:13 2009 +0200 URL: http://code.openbravo.com/erp/stable/2.40/rev/512ab0a7177c72e415929a0df2b8f88b96318d36 [^] Fixed issue 10684. There shouldn't be more global table creation-related errors on update.database on r2.4x. --- M src-db/database/model/prescript-Oracle.sql --- |
|
(0020444) hgbot (developer) 2009-09-29 12:02 |
Repository: erp/stable/2.40_pageddatagrid Changeset: 512ab0a7177c72e415929a0df2b8f88b96318d36 Author: Antonio Moreno <antonio.moreno <at> openbravo.com> Date: Wed Sep 23 16:14:13 2009 +0200 URL: http://code.openbravo.com/erp/stable/2.40_pageddatagrid/rev/512ab0a7177c72e415929a0df2b8f88b96318d36 [^] Fixed issue 10684. There shouldn't be more global table creation-related errors on update.database on r2.4x. --- M src-db/database/model/prescript-Oracle.sql --- |
|
(0020872) arunkumar (viewer) 2009-10-08 11:21 |
This issue has been resolved.There is no table overwrite error while doing update.database. |
|
Notes |
|
Issue History |
|||
| Date Modified | Username | Field | Change |
| 2009-09-21 14:22 | jpabloae | New Issue | |
| 2009-09-21 14:22 | jpabloae | Assigned To | => marvintm |
| 2009-09-21 14:22 | jpabloae | OBNetwork customer | => No |
| 2009-09-21 14:23 | jpabloae | Summary | Errors in the prescript => Table overwrite error in the prescript of update.database |
| 2009-09-23 16:16 | hgbot | Checkin | |
| 2009-09-23 16:16 | hgbot | Note Added: 0020319 | |
| 2009-09-23 16:16 | hgbot | Status | new => resolved |
| 2009-09-23 16:16 | hgbot | Resolution | open => fixed |
| 2009-09-23 16:16 | hgbot | Fixed in SCM revision | => http://code.openbravo.com/erp/stable/2.40/rev/512ab0a7177c72e415929a0df2b8f88b96318d36 [^] |
| 2009-09-29 12:02 | hgbot | Checkin | |
| 2009-09-29 12:02 | hgbot | Note Added: 0020444 | |
| 2009-09-29 12:02 | hgbot | Fixed in SCM revision | http://code.openbravo.com/erp/stable/2.40/rev/512ab0a7177c72e415929a0df2b8f88b96318d36 [^] => http://code.openbravo.com/erp/stable/2.40_pageddatagrid/rev/512ab0a7177c72e415929a0df2b8f88b96318d36 [^] |
| 2009-10-08 11:21 | arunkumar | Status | resolved => closed |
| 2009-10-08 11:21 | arunkumar | Note Added: 0020872 | |
| 2009-10-08 11:21 | arunkumar | Fixed in Version | => 2.40MP10 |
| 2009-10-09 00:00 | anonymous | sf_bug_id | 0 => 2875126 |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |