Error In the Linkmanager8 Component When Modifying Content with Long Links In The Text (Doc ID 1203895.1)

Last updated on MARCH 07, 2016

Applies to:

Oracle WebCenter Content - Version 10.1.3.5.0 and later
Information in this document applies to any platform.

Symptoms

On : 10.1.3.5.0 version, Content Server- When clicking on a link to a content item that was created by the Link Manager component that is greater then 50, the following error occurs.

ERROR
-----------------------
system 08.20 12:57:38.437 index update work !csDbUnableToExecuteQuery,ImanagedLink(INSERT INTO ManagedLinks (dLkGUID\, dLkClassId\, dDocName\, dLkType\, dLkOriginalUrl\,
dLkContainerId\, dLkResource\, dLkResourceAlias\, dLkResourceType\,
dLkHasAlias\, dLkState\, dLkCreateTs\, dLkUpdateTs\, dLkCycle)
VALUES ('C597-63AB-3AFD-D0D6'\,66224\,'6139'\,'ss_link_rel'\,'[\!--$ssServerRelativeSiteRoot--]Normativa/index.htm?C1=1001&C2=2010&C3=3038&C4=4025'\,'Internet'\,'index.htm?c1=1001&c2=2010&c3=3038&c4=4025'\,''\,'doc'\,'N'\,'N'\,{ts '2010-08-20 12:57:38.409'}\,{ts '2010-08-20 12:57:38.409'}\,''))!$ORA-12899: el valor es demasiado grande para la columna "EPRDI00"."MANAGEDLINKS"."DLKRESOURCE" (real: 53\, m�ximo: 50)
-exception stack
intradoc.data.DataException: !csDbUnableToExecuteQuery,ImanagedLink(INSERT INTO ManagedLinks (dLkGUID\, dLkClassId\, dDocName\, dLkType\, dLkOriginalUrl\,
dLkContainerId\, dLkResource\, dLkResourceAlias\, dLkResourceType\,
dLkHasAlias\, dLkState\, dLkCreateTs\, dLkUpdateTs\, dLkCycle)
VALUES ('C597-63AB-3AFD-D0D6'\,66224\,'6139'\,'ss_link_rel'\,'[\!--$ssServerRelativeSiteRoot--]Normativa/index.htm?C1=1001&C2=2010&C3=3038&C4=4025'\,'Internet'\,'index.htm?c1=1001&c2=2010&c3=3038&c4=4025'\,''\,'doc'\,'N'\,'N'\,{ts '2010-08-20 12:57:38.409'}\,{ts '2010-08-20 12:57:38.409'}\,''))!$ORA-12899: el valor es demasiado grande para la columna "EPRDI00"."MANAGEDLINKS"."DLKRESOURCE" (real: 53\, m??ximo: 50)

at intradoc.jdbc.JdbcWorkspace.handleSQLException(JdbcWorkspace.java:2371)
at intradoc.jdbc.JdbcWorkspace.execute(JdbcWorkspace.java:650)
at linkmanager.LinkDecoder.storeLinksInDatabase(LinkDecoder.java:887)
at linkmanager.LinkHandler.storeLinksInDatabase(LinkHandler.java:465)
at sun.reflect.GeneratedMethodAccessor69.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585)
at intradoc.common.IdcMethodHolder.invokeMethod(ClassHelperUtils.java:617)
at intradoc.common.ClassHelperUtils.executeMethodReportStatus(ClassHelperUtils.java:293)
at intradoc.server.ServiceHandler.executeAction(ServiceHandler.java:79)
at intradoc.server.Service.doCodeEx(Service.java:490)
at intradoc.server.Service.doCode(Service.java:472)
at intradoc.server.ServiceRequestImplementor.doAction(ServiceRequestImplementor.java:1360)
at intradoc.server.Service.doAction(Service.java:452)
at intradoc.server.ServiceRequestImplementor.doActions(ServiceRequestImplementor.java:1201)
at intradoc.server.Service.doActions(Service.java:447)
at linkmanager.LinkIndexerFilter.executeService(LinkIndexerFilter.java:188)
at linkmanager.LinkIndexerFilter.addChange(LinkIndexerFilter.java:145)
at linkmanager.LinkIndexerFilter.handleWebChange(LinkIndexerFilter.java:102)
at linkmanager.LinkIndexerFilter.doFilter(LinkIndexerFilter.java:58)
at intradoc.shared.PluginFilters.filter(PluginFilters.java:94)
at intradoc.indexer.IndexerBulkLoader.createBulkLoad(IndexerBulkLoader.java:334)
at intradoc.indexer.IndexerBulkLoader.doWork(IndexerBulkLoader.java:165)
at intradoc.indexer.Indexer.doIndexing(Indexer.java:439)
at intradoc.indexer.Indexer.buildIndex(Indexer.java:348)
at intradoc.server.IndexerMonitor.doIndexing(IndexerMonitor.java:1012)
at intradoc.server.IndexerMonitor$4.run(IndexerMonitor.java:832)
Caused by: java.sql.SQLException: ORA-12899: el valor es demasiado grande para la columna "EPRDI00"."MANAGEDLINKS"."DLKRESOURCE" (real: 53, m??ximo: 50)

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