Project:
| 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 |
 |