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

Last updated on MARCH 08, 2017

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

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms