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

View Revisions: Issue #44612 Back to Issue ]
Summary 0044612: ORA fails applying changes to columns used in functional indexes
Revision 2020-08-07 12:18 by alostale
Steps To Reproduce Case 1: regular change
1.1. modify src-db/database/model/tables/C_BPARTNER.xml to set NAME length to 120
1.2. run update.database
  ERROR: ORA-30556: functional index is defined on the column to be modified

Case 2: config scrip
2.1 Modify on a template the column name of C_BPartner:
     <columnSizeChange tablename="C_BPARTNER" columnname="NAME" newSize="120" oldSize="60"/>
2.2. run update.database
  ERROR: ORA-30556
Revision 2020-08-07 12:18 by alostale
Description When updating an Oracle database having changes in a column that participates in a functional index, Oracle fails and the change is not applied.

This can occur by either a config script providing those changes or by a regular DB change.

In case a template modifies an indexed column oracle fails on compilation:
SQL Command failed with: ORA-30556: either functional or bitmap join index is defined on the column to be modified
Revision 2020-08-07 09:24 by alostale
Steps To Reproduce Modify on a template the column name of AD_User and name of C_BPartner:
    <columnSizeChange tablename="AD_USER" columnname="NAME" newSize="120" oldSize="60"/>
    <columnSizeChange tablename="C_BPARTNER" columnname="NAME" newSize="120" oldSize="60"/>

Compile with oracle and the error rises
Revision 2020-08-07 09:24 by alostale
Description In case a template modifies an indexed column oracle fails on compilation:
SQL Command failed with: ORA-30556: either functional or bitmap join index is defined on the column to be modified

Example of the config script:
  <vector>
    <versionInfo version="3.0.36908"/>
    <columnSizeChange tablename="AD_USER" columnname="NAME" newSize="120" oldSize="60"/>
    <columnSizeChange tablename="C_BPARTNER" columnname="NAME" newSize="120" oldSize="60"/>
    <columnDataChange tablename="AD_COLUMN" columnname="FIELDLENGTH" pkRow="213">
      <oldValue><![CDATA[60]]></oldValue>
      <newValue><![CDATA[120]]></newValue>
    </columnDataChange>
    <columnDataChange tablename="AD_COLUMN" columnname="FIELDLENGTH" pkRow="2902">
      <oldValue><![CDATA[60]]></oldValue>
      <newValue><![CDATA[120]]></newValue>
    </columnDataChange>
    <columnDataChange tablename="AD_FIELD" columnname="DISPLAYLENGTH" pkRow="300">
      <oldValue><![CDATA[60]]></oldValue>
      <newValue><![CDATA[120]]></newValue>
    </columnDataChange>
    <columnDataChange tablename="AD_FIELD" columnname="DISPLAYLENGTH" pkRow="2145">
      <oldValue><![CDATA[60]]></oldValue>
      <newValue><![CDATA[120]]></newValue>
    </columnDataChange>
  </vector>


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker