HELPERSERVICE: DATA EXCEPTION IN INDEXERSTATE.RECORDWEBCHANGE_SUB INDEXERSTATE.UINDEXERSTATE (Doc ID 1068990.1)

Last updated on MAY 19, 2017

Applies to:

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

Symptoms

After recently upgrading to Content Server version 10.1.3.5.0, When attempting to check in a document, the following error occurs in the content server logs:

ERROR
-----------------------

helperservice: data exception in INDEXERSTATE.RECORDWEBCHANGE_SUB IndexerState.UindexerState Abfrage ''IndexerState.UindexerState(UPDATE IndexerState SET iIndexGUID=N'4458CB8B-D565-2898-C117-5B47837517EE',dRevClassID=56386,dRevRank=0,xInhibitUpdate=N'FALSCH',dSecurityGroup=N'R',dWebExtension=N'pdf',dDocName=N'036201',dRendition1=N'',dDocAuthor=N'pessl$',dWorkflowState=N'',dFileSize=31232,xReadOnly=N'FALSCH',dCheckoutUser=N'',dLocation=N'',dFlag1=N'',dID=87898,dReleaseDate={ts '2009-10-12 15:06:54.000'},dDocTitle=N'Pkw-Neuzulassungen 1. bis 10. November 2009 nach Marken, Rohdaten',dPublishState=N'',dExtension=N'xls',xHidden=N'FALSCH',dIsCheckedOut=0,dIsWebFormat=0,dReleaseState=N'R',xStorageRule=N'',dDocAccount=N'',dPublishType=N'',dFormat=N'application/vnd.ms-excel',xCollectionID=0,dRevLabel=N'14',dIsPrimary=1,dStatus=N'DONE',xWebFlag=N'',dInDate={ts '2009-11-11 09:50:00.000'},dMessage=N'!$Success',dIndexerState=N'A',dOriginalName=N'036201_Stichtag_bis_10_November09.xls',xComments=N'Verkehr, Straße, Kfz-Neuzulassungen',dRevisionID=14,dDocID=318225,dOutDate=null,xPartitionId=N'',dCreateDate={ts '2009-11-11 09:51:57.000'},dProcessingState=N'Y',dDocType=N'WEBOBJ',dRendition2=N'',xCreator=N'Fischer Gerda',xLanguage=N'DE',xRssTitle=N'',xGroup=N'',xItemNo=N'',xISBN=N'',xSchnellbNo=N'',xPublish=1,xWebFormatPDF=1,xWebFormatOriginal=1,xWebFormatHTML=1,xWebInDate={ts '2009-11-11 09:50:00.000'},xWebArchive=0,xWebOutDate=null,xWebsiteObjectType=N'',xWebsites=N'',xDontShowInListsForWebsites=N'',xWebsiteSection=N'',xDataType=N'Tabelle',xSubject=N'',xWebCategories=N'458',xautoFormat=-1,xcreatePDF=-1,xkeepRowHeight=-1,xstyleRule=0,xkeepColumnWidth=-1,xuserStyleRule=N'',xexpertParameter=N'',xuserStyleRuleSystem=N'',xdoubleSide=-1,xuserStyleRuleTemp=N'1257929445763',xcreateHTML=-1,xdelLastUserStyleRule=N'',xshowMetaInformation=-1,xshowCommaGroup=-1,xWebSearchExclude=0,xWebSortOrder=N'910' WHERE )'' kann nicht ausgeführt werden. DB2 SQL Error: SQLCODE=-104, SQLSTATE=42601, SQLERRMC=WHERE;XWEBSORTORDER=N'910';END-OF-STATEMENT, DRIVER=3.53.70 com.ibm.db2.jcc.b.co: DB2 SQL Error: SQLCODE=-104, SQLSTATE=42601, SQLERRMC=WHERE;XWEBSORTORDER=N'910';END-OF-STATEMENT, DRIVER=3.53.70 [ Details ]
Ein Fehler ist aufgetreten. Die Stapelablaufverfolgung unten zeigt weitere Informationen.

!$helperservice: data exception in INDEXERSTATE.RECORDWEBCHANGE_SUB IndexerState.UindexerState !csDbUnableToExecuteQuery,IndexerState.UindexerState(UPDATE IndexerState SET iIndexGUID=N'4458CB8B-D565-2898-C117-5B47837517EE'\,dRevClassID=56386\,dRevRank=0\,xInhibitUpdate=N'FALSCH'\,dSecurityGroup=N'R'\,dWebExtension=N'pdf'\,dDocName=N'036201'\,dRendition1=N''\,dDocAuthor=N'pessl$'\,dWorkflowState=N''\,dFileSize=31232\,xReadOnly=N'FALSCH'\,dCheckoutUser=N''\,dLocation=N''\,dFlag1=N''\,dID=87898\,dReleaseDate={ts '2009-10-12 15:06:54.000'}\,dDocTitle=N'Pkw-Neuzulassungen 1. bis 10. November 2009 nach Marken\, Rohdaten'\,dPublishState=N''\,dExtension=N'xls'\,xHidden=N'FALSCH'\,dIsCheckedOut=0\,dIsWebFormat=0\,dReleaseState=N'R'\,xStorageRule=N''\,dDocAccount=N''\,dPublishType=N''\,dFormat=N'application/vnd.ms-excel'\,xCollectionID=0\,dRevLabel=N'14'\,dIsPrimary=1\,dStatus=N'DONE'\,xWebFlag=N''\,dInDate={ts '2009-11-11 09:50:00.000'}\,dMessage=N'\!$Success'\,dIndexerState=N'A'\,dOriginalName=N'036201_Stichtag_bis_10_November09.xls'\,xComments=N'Verkehr\, Straße\, Kfz-Neuzulassungen'\,dRevisionID=14\,dDocID=318225\,dOutDate=null\,xPartitionId=N''\,dCreateDate={ts '2009-11-11 09:51:57.000'}\,dProcessingState=N'Y'\,dDocType=N'WEBOBJ'\,dRendition2=N''\,xCreator=N'Fischer Gerda'\,xLanguage=N'DE'\,xRssTitle=N''\,xGroup=N''\,xItemNo=N''\,xISBN=N''\,xSchnellbNo=N''\,xPublish=1\,xWebFormatPDF=1\,xWebFormatOriginal=1\,xWebFormatHTML=1\,xWebInDate={ts '2009-11-11 09:50:00.000'}\,xWebArchive=0\,xWebOutDate=null\,xWebsiteObjectType=N''\,xWebsites=N''\,xDontShowInListsForWebsites=N''\,xWebsiteSection=N''\,xDataType=N'Tabelle'\,xSubject=N''\,xWebCategories=N'458'\,xautoFormat=-1\,xcreatePDF=-1\,xkeepRowHeight=-1\,xstyleRule=0\,xkeepColumnWidth=-1\,xuserStyleRule=N''\,xexpertParameter=N''\,xuserStyleRuleSystem=N''\,xdoubleSide=-1\,xuserStyleRuleTemp=N'1257929445763'\,xcreateHTML=-1\,xdelLastUserStyleRule=N''\,xshowMetaInformation=-1\,xshowCommaGroup=-1\,xWebSearchExclude=0\,xWebSortOrder=N'910' WHERE )!$DB2 SQL Error: SQLCODE=-104\, SQLSTATE=42601\, SQLERRMC=WHERE;XWEBSORTORDER=N'910';END-OF-STATEMENT\, DRIVER=3.53.70!syExceptionType2,com.ibm.db2.jcc.b.co,DB2 SQL Error: SQLCODE=-104\, SQLSTATE=42601\, SQLERRMC=WHERE;XWEBSORTORDER=N'910';END-OF-STATEMENT\, DRIVER=3.53.70
intradoc.data.DataException: !csDbUnableToExecuteQuery,IndexerState.UindexerState(UPDATE IndexerState SET iIndexGUID=N'4458CB8B-D565-2898-C117-5B47837517EE'\,dRevClassID=56386\,dRevRank=0\,xInhibitUpdate=N'FALSCH'\,dSecurityGroup=N'R'\,dWebExtension=N'pdf'\,dDocName=N'036201'\,dRendition1=N''\,dDocAuthor=N'pessl$'\,dWorkflowState=N''\,dFileSize=31232\,xReadOnly=N'FALSCH'\,dCheckoutUser=N''\,dLocation=N''\,dFlag1=N''\,dID=87898\,dReleaseDate={ts '2009-10-12 15:06:54.000'}\,dDocTitle=N'Pkw-Neuzulassungen 1. bis 10. November 2009 nach Marken\, Rohdaten'\,dPublishState=N''\,dExtension=N'xls'\,xHidden=N'FALSCH'\,dIsCheckedOut=0\,dIsWebFormat=0\,dReleaseState=N'R'\,xStorageRule=N''\,dDocAccount=N''\,dPublishType=N''\,dFormat=N'application/vnd.ms-excel'\,xCollectionID=0\,dRevLabel=N'14'\,dIsPrimary=1\,dStatus=N'DONE'\,xWebFlag=N''\,dInDate={ts '2009-11-11 09:50:00.000'}\,dMessage=N'\!$Success'\,dIndexerState=N'A'\,dOriginalName=N'036201_Stichtag_bis_10_November09.xls'\,xComments=N'Verkehr\, Straße\, Kfz-Neuzulassungen'\,dRevisionID=14\,dDocID=318225\,dOutDate=null\,xPartitionId=N''\,dCreateDate={ts '2009-11-11 09:51:57.000'}\,dProcessingState=N'Y'\,dDocType=N'WEBOBJ'\,dRendition2=N''\,xCreator=N'Fischer Gerda'\,xLanguage=N'DE'\,xRssTitle=N''\,xGroup=N''\,xItemNo=N''\,xISBN=N''\,xSchnellbNo=N''\,xPublish=1\,xWebFormatPDF=1\,xWebFormatOriginal=1\,xWebFormatHTML=1\,xWebInDate={ts '2009-11-11 09:50:00.000'}\,xWebArchive=0\,xWebOutDate=null\,xWebsiteObjectType=N''\,xWebsites=N''\,xDontShowInListsForWebsites=N''\,xWebsiteSection=N''\,xDataType=N'Tabelle'\,xSubject=N''\,xWebCategories=N'458'\,xautoFormat=-1\,xcreatePDF=-1\,xkeepRowHeight=-1\,xstyleRule=0\,xkeepColumnWidth=-1\,xuserStyleRule=N''\,xexpertParameter=N''\,xuserStyleRuleSystem=N''\,xdoubleSide=-1\,xuserStyleRuleTemp=N'1257929445763'\,xcreateHTML=-1\,xdelLastUserStyleRule=N''\,xshowMetaInformation=-1\,xshowCommaGroup=-1\,xWebSearchExclude=0\,xWebSortOrder=N'910' WHERE )!$DB2 SQL Error: SQLCODE=-104\, SQLSTATE=42601\, SQLERRMC=WHERE;XWEBSORTORDER=N'910';END-OF-STATEMENT\, DRIVER=3.53.70
at intradoc.jdbc.JdbcWorkspace.handleSQLException(JdbcWorkspace.java:2371)
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.co: DB2 SQL Error: SQLCODE=-104, SQLSTATE=42601, SQLERRMC=WHERE;XWEBSORTORDER=N'910';END-OF-STATEMENT, DRIVER=3.53.70
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.fm.c(fm.java:2474)
at com.ibm.db2.jcc.b.fm.d(fm.java:2451)
at com.ibm.db2.jcc.b.fm.b(fm.java:1892)
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.fm.ab(fm.java:1887)
at com.ibm.db2.jcc.b.fm.a(fm.java:2812)
at com.ibm.db2.jcc.b.fm.c(fm.java:648)
at com.ibm.db2.jcc.b.fm.executeUpdate(fm.java:632)
at intradoc.jdbc.JdbcWorkspace.execute(JdbcWorkspace.java:643)
... 16 more

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