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 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
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Cause |
| Solution |