My Oracle Support Banner

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

Last updated on AUGUST 20, 2018

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

To view full details, 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 a vibrant support community of peers and Oracle experts.