Ucm Service In Production Is Intermittently Timing Out While Retrieving Meta Data And/Or Content.
Last updated on MAY 19, 2017
Applies to:
Oracle WebCenter Content - Version 10.1.3.5.0 and laterInformation 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)
!$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