My Oracle Support Banner

Membership in Database Table Index Prevents Deletion of Metadata Field (Doc ID 760113.1)

Last updated on AUGUST 28, 2018

Applies to:

Oracle Universal Content Management - Version: 10.1.3.3.1 and later   [Release: 10gR3 and later ]
Information in this document applies to any platform.

Symptoms

You are unable to delete the xPromoField metadata field due to the following error:

Event generated by user 'DOMAIN\\user' at host 'system'. Unable to execute service
UPDATE_META_TABLE and function updateMetaTable.
(System Error: Unable to alter table 'The index
'_dta_index_DocMeta_7_290100074__K17_K1_2_3_4_5_6_7_8_9_10_11_12_13_14_15_16_18_19_20_21_22_23_24_25
_26_27_28_29_30_31_32_33_34_' is dependent on column 'xPromoCode'.'.) Unable to alter table 'The
index
'_dta_index_DocMeta_7_290100074__K17_K1_2_3_4_5_6_7_8_9_10_11_12_13_14_15_16_18_19_20_21_22_23_24_25
_26_27_28_29_30_31_32_33_34_' is dependent on column 'xPromoCode'.'. java.sql.SQLException: The
index
'_dta_index_DocMeta_7_290100074__K17_K1_2_3_4_5_6_7_8_9_10_11_12_13_14_15_16_18_19_20_21_22_23_24_25
_26_27_28_29_30_31_32_33_34_' is dependent on column 'xPromoCode'. [ Details ]
An error has occurred. The stack trace below shows more information.

!csUserEventMessage,DOMAIN\\user,system!$!csServiceDataException,UPDATE_META_TABLE,updateMetaTable!$
!csSystemError,\!csDbUnableToPerformAction_alter\,The index
'_dta_index_DocMeta_7_290100074__K17_K1_2_3_4_5_6_7_8_9_10_11_12_13_14_15_16_18_19_20_21_22_23_24_25
_26_27_28_29_30_31_32_33_34_' is dependent on column
'xPromoCode'.!csDbUnableToPerformAction_alter,The index
'_dta_index_DocMeta_7_290100074__K17_K1_2_3_4_5_6_7_8_9_10_11_12_13_14_15_16_18_19_20_21_22_23_24_25
_26_27_28_29_30_31_32_33_34_' is dependent on column
'xPromoCode'.!syExceptionType2,java.sql.SQLException,The index
'_dta_index_DocMeta_7_290100074__K17_K1_2_3_4_5_6_7_8_9_10_11_12_13_14_15_16_18_19_20_21_22_23_24_25
_26_27_28_29_30_31_32_33_34_' is dependent on column 'xPromoCode'.
intradoc.common.ServiceException:
!csServiceDataException,UPDATE_META_TABLE,updateMetaTable!$!csSystemError,\!csDbUnableToPerformActio
n_alter\,The index
'_dta_index_DocMeta_7_290100074__K17_K1_2_3_4_5_6_7_8_9_10_11_12_13_14_15_16_18_19_20_21_22_23_24_25
_26_27_28_29_30_31_32_33_34_' is dependent on column 'xPromoCode'.
at
intradoc.server.ServiceRequestImplementor.buildServiceException(ServiceRequestImplementor.java:1742)
at intradoc.server.Service.buildServiceException(Service.java:1997)
at intradoc.server.Service.createServiceExceptionEx(Service.java:1991)
at intradoc.server.Service.createServiceException(Service.java:1986)
at
intradoc.server.ServiceRequestImplementor.handleActionException(ServiceRequestImplementor.java:1453)
at intradoc.server.ServiceRequestImplementor.doAction(ServiceRequestImplementor.java:1420)
at intradoc.server.Service.doAction(Service.java:452)
at intradoc.server.ServiceRequestImplementor.doActions(ServiceRequestImplementor.java:1194)
at intradoc.server.Service.doActions(Service.java:447)
at intradoc.server.ServiceRequestImplementor.executeActions(ServiceRequestImplementor.java:1114)
at intradoc.server.Service.executeActions(Service.java:433)
at intradoc.server.ServiceRequestImplementor.doRequest(ServiceRequestImplementor.java:635)
at intradoc.server.Service.doRequest(Service.java:1707)
at intradoc.server.ServiceManager.processCommand(ServiceManager.java:357)
at intradoc.server.IdcServerThread.run(IdcServerThread.java:195)
Caused by: intradoc.data.DataException: !csDbUnableToPerformAction_alter,The index
'_dta_index_DocMeta_7_290100074__K17_K1_2_3_4_5_6_7_8_9_10_11_12_13_14_15_16_18_19_20_21_22_23_24_25
_26_27_28_29_30_31_32_33_34_' is dependent on column 'xPromoCode'.
at intradoc.jdbc.JdbcWorkspace.alterTable(JdbcWorkspace.java:1965)
at intradoc.server.MetaService.updateMetaTableDesign(MetaService.java:382)
at intradoc.server.MetaService.updateMetaTable(MetaService.java:187)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585)
at intradoc.common.IdcMethodHolder.invokeMethod(ClassHelperUtils.java:461)
at intradoc.common.ClassHelperUtils.executeMethodEx(ClassHelperUtils.java:128)
at intradoc.common.ClassHelperUtils.executeMethod(ClassHelperUtils.java:113)
at intradoc.server.Service.doCodeEx(Service.java:507)
at intradoc.server.Service.doCode(Service.java:472)
at intradoc.server.ServiceRequestImplementor.doAction(ServiceRequestImplementor.java:1353)
... 9 more
Caused by: java.sql.SQLException: The index
'_dta_index_DocMeta_7_290100074__K17_K1_2_3_4_5_6_7_8_9_10_11_12_13_14_15_16_18_19_20_21_22_23_24_25
_26_27_28_29_30_31_32_33_34_' is dependent on column 'xPromoCode'.
at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:368)
at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2816)
at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2254)
at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:631)
at net.sourceforge.jtds.jdbc.JtdsStatement.processResults(JtdsStatement.java:584)
at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQL(JtdsStatement.java:546)
at net.sourceforge.jtds.jdbc.JtdsStatement.executeImpl(JtdsStatement.java:723)
at net.sourceforge.jtds.jdbc.JtdsStatement.executeUpdate(JtdsStatement.java:1163)
at net.sourceforge.jtds.jdbc.JtdsStatement.executeUpdate(JtdsStatement.java:1116)
at intradoc.jdbc.JdbcFunctions.executeUpdateQuery(JdbcFunctions.java:1162)
at intradoc.jdbc.JdbcFunctions.dropColumns(JdbcFunctions.java:1218)
at intradoc.jdbc.JdbcWorkspace.alterTable(JdbcWorkspace.java:1913)
... 21 more

Note that similar errors can occur with any metadata field or with other databases such as Oracle, Informix, or DB2. It's not limited to SQL Server 2005 or a specific metadata field like this specific error message is related to.

.

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
  Symptoms
  Cause
  Solution

Platforms: 1-914CU;

This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.