My Oracle Support Banner

ORA-00600 Errors when Attempting To Index Rebuild or Run Content Analyzer (Doc ID 840251.1)

Last updated on MARCH 05, 2024

Applies to:

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

Symptoms

Errors occur during a search collection rebuild and the rebuild fails showing "possible database connection failure encountered" and ORA-00600: internal error code, arguments: [kdsgrp1]. These errors also appear in other areas, such as the Content Analyzer and on certain DOC_INFO pages when working with UCM. The consistent error is the ORA-00600, a JDBC SQLException, which is often accompanied by a UCM error with the strings: csJdbcConnectionFailure and csDbUnableToCreateResultSet.

An example of the error is as follows, as seen when running the Content Analyzer:

Analyzing index...

...................(internal) 06.02 16:43:20.606 Thread-10
JdbcResultSet.next:Unable to retrieve next row. (ORA-00600: internal error
code, arguments: [kdsgrp1], [], [], [], [], [], [], [], [], [], [], []
)-exception stack
java.sql.SQLException: ORA-00600: internal error code, arguments: [kdsgrp1],
[], [], [], [], [], [], [], [], [], [], []

The error while running the search collection indexer may be more lengthy, but will include the ORA-00600 error:

Indexing aborted. Unable to create result set for query 'INDEXER-QUERY-INSERT-INFO(SELECT/*+ USE_NL (Revisions Documents DocMeta DocTypes) LEADING(Revisions)INDEX (Revisions PK_Revisions)*/ Revisions.*, Documents.*, xURLItem,xReadOnly,xInhibitUpdate,xHidden,xComments,xDescription,xDiscussionCount,xDiscussionType,xKeywords,xOriginalAuthor2,xConfidentiality,xOriginalAuthor,xCollectionID,xProductRelease,xDamCategory,xMyOProduct,xGeography,xLanguage,xPartitionId,xWebFlag,xStorageRule,xProductLine,xDocContentCategory,xCreateDate,xItemStatus,xProduct,xWebsiteObjectType,xOriginatingSourceFile,xWebsites,xDontShowInListsForWebsites,xWebsiteSection,xRegionDefinition,xDocNotes,xDocFileType,xWikiPageName,xTechnology,xApplications,xServices,xIndustry,xAudience,xRegion,xCountry,xOrganization,xPerson,xBusinessArea,xSiteURLPageName,xSiteSearch,xJobRole,xPartNumber,xADSCertified,xJobNumber,xADSContentType,xDisplay_In_Portlet,xEbizOpsTesting,xPriority_Of_Display,xTestStatus,xADSDemoRelease,xProductPillar,xLastUpdateDate,xProfileTrigger,xDisplayURL,xLegacyProduct,xPackagedConversions,xDamConversionType,xVideoRenditions,xTUGBU_ContentType,xDocRSS,xConsumptionServer,xDocGeography,xIndustryCommon,xGeographyText,xTranslationprimary,xTranslationChild, DocTypes.dGif
FROM Revisions,Documents,DocMeta,DocTypes
WHERE Revisions.dID = 149402
AND Revisions.dID = Documents.dID
AND Revisions.dID = DocMeta.dID
AND DocTypes.dDocType = Revisions.dDocType
AND Revisions.dIndexerState in ('C', 'Y'))'. ORA-00600: internal error code, arguments: [kdsgrp1], [], [], [], [], [], [], [], [], [], [], []
Unable to create result set for query 'INDEXER-QUERY-INSERT-INFO(SELECT/*+ USE_NL (Revisions Documents DocMeta DocTypes) LEADING(Revisions)INDEX (Revisions PK_Revisions)*/ Revisions.*, Documents.*, xURLItem,xReadOnly,xInhibitUpdate,xHidden,xComments,xDescription,xDiscussionCount,xDiscussionType,xKeywords,xOriginalAuthor2,xConfidentiality,xOriginalAuthor,xCollectionID,xProductRelease,xDamCategory,xMyOProduct,xGeography,xLanguage,xPartitionId,xWebFlag,xStorageRule,xProductLine,xDocContentCategory,xCreateDate,xItemStatus,xProduct,xWebsiteObjectType,xOriginatingSourceFile,xWebsites,xDontShowInListsForWebsites,xWebsiteSection,xRegionDefinition,xDocNotes,xDocFileType,xWikiPageName,xTechnology,xApplications,xServices,xIndustry,xAudience,xRegion,xCountry,xOrganization,xPerson,xBusinessArea,xSiteURLPageName,xSiteSearch,xJobRole,xPartNumber,xADSCertified,xJobNumber,xADSContentType,xDisplay_In_Portlet,xEbizOpsTesting,xPriority_Of_Display,xTestStatus,xADSDemoRelease,xProductPillar,xLastUpdateDate,xProfileTrigger,xDisplayURL,xLegacyProduct,xPackagedConversions,xDamConversionType,xVideoRenditions,xTUGBU_ContentType,xDocRSS,xConsumptionServer,xDocGeography,xIndustryCommon,xGeographyText,xTranslationprimary,xTranslationChild, DocTypes.dGif
FROM Revisions,Documents,DocMeta,DocTypes
WHERE Revisions.dID = 149402
AND Revisions.dID = Documents.dID
AND Revisions.dID = DocMeta.dID
AND DocTypes.dDocType = Revisions.dDocType
AND Revisions.dIndexerState in ('C', 'Y'))'. ORA-00600: internal error code, arguments: [kdsgrp1], [], [], [], [], [], [], [], [], [], [], []
java.sql.SQLException: ORA-00600: internal error code, arguments: [kdsgrp1], [], [], [], [], [], [], [], [], [], [], [] [ Details ]
An error has occurred. The stack trace below shows more information.

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
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.