Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0010684Openbravo ERPA. Platformpublic2009-09-21 14:222009-10-09 00:00
Reporterjpabloae 
Assigned Tomarvintm 
PriorityurgentSeverityminorReproducibilityhave not tried
StatusclosedResolutionfixed 
PlatformOS30OS VersionGentoo - 2.6.26
Product Version2.40MP9 
Target VersionFixed in Version2.40MP10 
Merge Request Status
Review Assigned To
OBNetwork customerNo
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0010684: Table overwrite error in the prescript of update.database
DescriptionThe 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.
Steps To Reproduce
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2009-09-21 14:22jpabloaeNew Issue
2009-09-21 14:22jpabloaeAssigned To => marvintm
2009-09-21 14:22jpabloaeOBNetwork customer => No
2009-09-21 14:23jpabloaeSummaryErrors in the prescript => Table overwrite error in the prescript of update.database
2009-09-23 16:16hgbotCheckin
2009-09-23 16:16hgbotNote Added: 0020319
2009-09-23 16:16hgbotStatusnew => resolved
2009-09-23 16:16hgbotResolutionopen => fixed
2009-09-23 16:16hgbotFixed in SCM revision => http://code.openbravo.com/erp/stable/2.40/rev/512ab0a7177c72e415929a0df2b8f88b96318d36 [^]
2009-09-29 12:02hgbotCheckin
2009-09-29 12:02hgbotNote Added: 0020444
2009-09-29 12:02hgbotFixed in SCM revisionhttp://code.openbravo.com/erp/stable/2.40/rev/512ab0a7177c72e415929a0df2b8f88b96318d36 [^] => http://code.openbravo.com/erp/stable/2.40_pageddatagrid/rev/512ab0a7177c72e415929a0df2b8f88b96318d36 [^]
2009-10-08 11:21arunkumarStatusresolved => closed
2009-10-08 11:21arunkumarNote Added: 0020872
2009-10-08 11:21arunkumarFixed in Version => 2.40MP10
2009-10-09 00:00anonymoussf_bug_id0 => 2875126

Notes
(0020319)
hgbot   
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   
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   
2009-10-08 11:21   
This issue has been resolved.There is no table overwrite error while doing update.database.