Anonymous | Login
Project:
RSS
  
News | My View | View Issues | Roadmap | Summary

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0044069
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] Y. DBSourceManagermajoralways2020-05-14 17:482020-05-29 08:45
ReporterguillermogilView Statuspublic 
Assigned Toalostale 
PrioritynormalResolutionfixedFixed in VersionPR20Q3
StatusclosedFix in branchFixed in SCM revision2a5eb79c1afb
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseOracleJava version
OS VersionDatabase versionAnt version
Product Version3.0PR20Q1.1SCM revision 
Merge Request Status
Review Assigned Tocaristu
OBNetwork customerGold
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0044069: If there is a change of size of a column in a template it fails in Oracle

DescriptionIf there is a change of size of a column in a template it fails in Oracle with the following error:
ALTER TABLE C_BPARTNER_LOCATION MODIFY NAME NVARCHAR2(100) NOT NULL
Seems to be modifying the nullable property instead of only the size.

Error can be seen here:
https://builds.openbravo.com/job/mod-simple/6787/ [^]
Steps To ReproduceGenerate an Config script like the following:

<?xml version="1.0"?>
  <vector>
    <versionInfo version="3.0.35625"/>
    <columnSizeChange tablename="C_BPARTNER_LOCATION" columnname="NAME" newSize="100" oldSize="60"/>
    <columnSizeChange tablename="C_LOCATION" columnname="ADDRESS1" newSize="100" oldSize="60"/>
    <columnDataChange tablename="AD_COLUMN" columnname="FIELDLENGTH" pkRow="817">
      <oldValue><![CDATA[60]]></oldValue>
      <newValue><![CDATA[100]]></newValue>
    </columnDataChange>
    <columnDataChange tablename="AD_COLUMN" columnname="FIELDLENGTH" pkRow="2960">
      <oldValue><![CDATA[60]]></oldValue>
      <newValue><![CDATA[100]]></newValue>
    </columnDataChange>
  </vector>

Do an install.source in Oracle.
Following error raises:
[createdatabase] 209384 [main] WARN org.apache.ddlutils.platform.OracleStandardBatchEvaluator - SQL Command failed with: ORA-01442: column to be modified to NOT NULL is already NOT NULL
[createdatabase]
[createdatabase] 209384 [main] WARN org.apache.ddlutils.platform.OracleStandardBatchEvaluator - -- END
[createdatabase] ALTER TABLE C_BPARTNER_LOCATION MODIFY NAME NVARCHAR2(100) NOT NULL
TagsNo tags attached.
Attached Files

- Relationships [ Relation Graph ] [ Dependency Graph ]

-  Notes
(0119906)
alostale (viewer)
2020-05-15 09:16

 MR: https://gitlab.com/openbravo/product/dbsm/-/merge_requests/9 [^]
(0120043)
hgbot (developer)
2020-05-19 15:31

 Repository: erp/devel/pi
Changeset: 2a5eb79c1afbc677c392363c99d1cb93f23021a1
Author: Asier Lostalé <asier.lostale <at> openbravo.com>
Date: Tue May 19 15:31:03 2020 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/2a5eb79c1afbc677c392363c99d1cb93f23021a1 [^]

fixed BUG-44069: mandatory column size change in config script fails in ORA

When a config script includes a size change for a mandatory column, it
fails to be applied in Oracle. The alter statement that DBSM produces,
includes NOT NULL together with the actual modification. This is not
allowed in Oracle causing the failure.

It is fixed by using the deferNotNull option when writing the statement.

---
M src-db/database/lib/dbsourcemanager.jar
---
(0120444)
caristu (viewer)
2020-05-29 08:45

 Reviewed

- Issue History
Date Modified Username Field Change
2020-05-14 17:48 guillermogil New Issue
2020-05-14 17:48 guillermogil Assigned To => platform
2020-05-14 17:48 guillermogil OBNetwork customer => Gold
2020-05-14 17:48 guillermogil Modules => Core
2020-05-14 17:48 guillermogil Triggers an Emergency Pack => No
2020-05-15 07:13 guillermogil Resolution time => 1591221600
2020-05-15 09:16 alostale Note Added: 0119906
2020-05-15 09:16 alostale Assigned To platform => alostale
2020-05-15 09:16 alostale Status new => acknowledged
2020-05-15 09:16 alostale Review Assigned To => caristu
2020-05-19 15:31 hgbot Checkin
2020-05-19 15:31 hgbot Note Added: 0120043
2020-05-19 15:31 hgbot Status acknowledged => resolved
2020-05-19 15:31 hgbot Resolution open => fixed
2020-05-19 15:31 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/2a5eb79c1afbc677c392363c99d1cb93f23021a1 [^]
2020-05-29 08:45 caristu Note Added: 0120444
2020-05-29 08:45 caristu Status resolved => closed
2020-05-29 08:45 caristu Fixed in Version => 3.0PR20Q3

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker