Ucm Service In Production Is Intermittently Timing Out While Retrieving Meta Data And/Or Content. (Doc ID 1381682.1)

Last updated on MAY 19, 2017

Applies to:

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

Symptoms

System performance is intermittently slow.  The following error is reported.

An error has occurred. The stack trace below shows more information.

!$helperservice: data exception in INDEXERSTATE.RECORDWEBCHANGE_SUB IndexerState.UindexerState !csDbUnableToExecuteQuery,IndexerState.UindexerState(UPDATE IndexerState SET iIndexGUID='11DFFFD5-1278-B751-461D-D1BFE1BF3AE5'\,dIsPrimary=1\,dFlag1=''\,dWebExtension='html'\,dReleaseState='U'\,dDocID=11803\,dRevisionID=20\,dRendition2=''\,xStorageRule=''\,xWebFlag=''\,dRevLabel='20'\,dReleaseDate={ts '2011-11-02 08:51:17.000'}\,dIsWebFormat=0\,dDocAccount=''\,dDocType='Template'\,xWebsites=''\,xReadOnly='FALSE'\,dLocation=''\,dRevClassID=1712\,dDocName='1-61319474173360'\,xInhibitUpdate='FALSE'\,dOriginalName='temp1319567744753.html'\,dProcessingState='Y'\,dRevRank=0\,dCheckoutUser='p900su'\,dInDate={ts '2011-10-25 08:35:44.000'}\,dFormat='text/html'\,xPartitionId=''\,dPublishType=''\,dID=3940\,dPublishState=''\,xHidden='FALSE'\,dOutDate=null\,xWebsiteSection=''\,dIsCheckedOut=1\,dExtension='html'\,dDocAuthor='scmaan'\,dDocTitle='1 - 60 DAYS DELINQUENT MWU'\,dFileSize=2460\,dWorkflowState=''\,dSecurityGroup='Public'\,dMessage=''\,xDontShowInListsForWebsites=''\,dStatus='RELEASED'\,xComments=''\,dIndexerState='A'\,dRendition1=''\,dCreateDate={ts '2011-10-25 13:35:45.000'}\,xWebsiteObjectType=''\,xRegionDefinition=''\,xCheckedOutFor='scmaan'\,xLanguage='English'\,xLastReivewedBy=''\,xSubType=''\,xTopic='Default Prevention'\,xReviewDueDate=null\,xEmailAddress=''\,xLastReviewedDate=null\,xSubject=''\,xExternalApp=''\,xLastUpdatedFor='scmaan'\,xSubProcess=''\,xEncrypt='N'\,xKeywords=''\,xOriginalAuthor=''\,xRegion=''\,xSegment=''\,xClassification=''\,xInstitutionID='001657'\,xTemplateType='Letter Template' WHERE )!$DB2 SQL Error: SQLCODE=-104\, SQLSTATE=42601\, SQLERRMC=WHERE;PE='Letter Template';END-OF-STATEMENT\, DRIVER=3.53.95!syExceptionType2,com.ibm.db2.jcc.b.eo,DB2 SQL Error: SQLCODE=-104\, SQLSTATE=42601\, SQLERRMC=WHERE;PE='Letter Template';END-OF-STATEMENT\, DRIVER=3.53.95
intradoc.data.DataException: !csDbUnableToExecuteQuery,IndexerState.UindexerState(UPDATE IndexerState SET iIndexGUID='11DFFFD5-1278-B751-461D-D1BFE1BF3AE5'\,dIsPrimary=1\,dFlag1=''\,dWebExtension='html'\,dReleaseState='U'\,dDocID=11803\,dRevisionID=20\,dRendition2=''\,xStorageRule=''\,xWebFlag=''\,dRevLabel='20'\,dReleaseDate={ts '2011-11-02 08:51:17.000'}\,dIsWebFormat=0\,dDocAccount=''\,dDocType='Template'\,xWebsites=''\,xReadOnly='FALSE'\,dLocation=''\,dRevClassID=1712\,dDocName='1-61319474173360'\,xInhibitUpdate='FALSE'\,dOriginalName='temp1319567744753.html'\,dProcessingState='Y'\,dRevRank=0\,dCheckoutUser='p900su'\,dInDate={ts '2011-10-25 08:35:44.000'}\,dFormat='text/html'\,xPartitionId=''\,dPublishType=''\,dID=3940\,dPublishState=''\,xHidden='FALSE'\,dOutDate=null\,xWebsiteSection=''\,dIsCheckedOut=1\,dExtension='html'\,dDocAuthor='scmaan'\,dDocTitle='1 - 60 DAYS DELINQUENT MWU'\,dFileSize=2460\,dWorkflowState=''\,dSecurityGroup='Public'\,dMessage=''\,xDontShowInListsForWebsites=''\,dStatus='RELEASED'\,xComments=''\,dIndexerState='A'\,dRendition1=''\,dCreateDate={ts '2011-10-25 13:35:45.000'}\,xWebsiteObjectType=''\,xRegionDefinition=''\,xCheckedOutFor='scmaan'\,xLanguage='English'\,xLastReivewedBy=''\,xSubType=''\,xTopic='Default Prevention'\,xReviewDueDate=null\,xEmailAddress=''\,xLastReviewedDate=null\,xSubject=''\,xExternalApp=''\,xLastUpdatedFor='scmaan'\,xSubProcess=''\,xEncrypt='N'\,xKeywords=''\,xOriginalAuthor=''\,xRegion=''\,xSegment=''\,xClassification=''\,xInstitutionID='001657'\,xTemplateType='Letter Template' WHERE )!$DB2 SQL Error: SQLCODE=-104\, SQLSTATE=42601\, SQLERRMC=WHERE;PE='Letter Template';END-OF-STATEMENT\, DRIVER=3.53.95
at intradoc.jdbc.JdbcWorkspace.handleSQLException(JdbcWorkspace.java:2356)
at intradoc.jdbc.JdbcWorkspace.execute(JdbcWorkspace.java:650)
at helper.HelperUtils.execute(HelperUtils.java:1527)
at helper.HelperService.doAction(HelperService.java:692)
at helper.HelperService.doActions10g(HelperService.java:383)
at helper.HelperService.doActions(HelperService.java:119)
at helper.HelperUtils.executeService(HelperUtils.java:3185)
at helper.HelperUtils.executeService(HelperUtils.java:3031)
at helper.HelperUtils.executeService(HelperUtils.java:3027)
at helper.HelperUtils.executeService(HelperUtils.java:3023)
at helper.HelperFilters.doFilter(HelperFilters.java:1287)
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:438)
at intradoc.indexer.Indexer.buildIndex(Indexer.java:347)
at intradoc.server.IndexerMonitor.doIndexing(IndexerMonitor.java:1012)
at intradoc.server.IndexerMonitor$4.run(IndexerMonitor.java:832)
Caused by: com.ibm.db2.jcc.b.eo: DB2 SQL Error: SQLCODE=-104, SQLSTATE=42601, SQLERRMC=WHERE;PE='Letter Template';END-OF-STATEMENT, DRIVER=3.53.95
at com.ibm.db2.jcc.b.bd.a(bd.java:676)
at com.ibm.db2.jcc.b.bd.a(bd.java:60)
at com.ibm.db2.jcc.b.bd.a(bd.java:127)
at com.ibm.db2.jcc.b.gm.c(gm.java:2484)
at com.ibm.db2.jcc.b.gm.d(gm.java:2461)
at com.ibm.db2.jcc.b.gm.b(gm.java:1902)
at com.ibm.db2.jcc.t4.db.h(db.java:219)
at com.ibm.db2.jcc.t4.db.b(db.java:45)
at com.ibm.db2.jcc.t4.t.b(t.java:38)
at com.ibm.db2.jcc.t4.sb.g(sb.java:120)
at com.ibm.db2.jcc.b.gm.ab(gm.java:1897)
at com.ibm.db2.jcc.b.gm.a(gm.java:2830)
at com.ibm.db2.jcc.b.gm.c(gm.java:648)
at com.ibm.db2.jcc.b.gm.executeUpdate(gm.java:632)
at intradoc.jdbc.JdbcWorkspace.execute(JdbcWorkspace.java:643)

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