SAP Knowledge Base Article - Preview

2059063 - Platform Search does not index the documents in BI 4.x

Symptom

  • Unable to perform a search in BILaunchpad.
  • Error message: "An error occurred while searching: Index is not ready. Please try again later (PSS 01004). (PSS 01004)" is displayed.
  • Platform Search does not index InfoObjects or only indexes small amount of InfoObjects.
  • The Number of indexed documents stays at 0 or a low number (e.g. 20).
  • The issue cannot be solved by performing the following actions:

1. Delete CMS DB locks and restart the Server Intelligence Agent (SIA).
2. Select Platform Metadata as Level of indexing and rebuild index.
3. Back up and delete "Lucene Index Engine" and "workplace" folder and let them recreate again.
4. Stop and disable all other AdaptiveProcessingServers with Platform Search Services on, create and start a new AdaptiveProcessingServer with Platform Search Service only on a full install node.

  • The following errors are found in AdaptiveProcessingServer's trace:

Caught Exception during atomicExecute: Attribute SI_PLATFORM_SEARCH_LAST_TO_BE_EXTRACTED_ID in object Platform Search Application Status (4301) is not a integer/long value! Undergoing retry 2 Query : SELECT SI_UPDATE_TS , SI_PLATFORM_SEARCH_LAST_TO_BE_EXTRACTED_TIMESTAMP , SI_PLATFORM_SEARCH_LAST_TO_BE_EXTRACTED_ID , SI_PLATFORM_SEARCH_LAST_TO_BE_EXTRACTED_MAX_ID , SI_PLATFORM_SEARCH_UNIVERSE_EXTRACTION_TASK_COMPLETED_TIMESTAMP , SI_PLATFORM_SEARCH_LAST_TO_BE_EXTRACTED_UNIVERSE_ID , SI_PLATFORM_SEARCH_LAST_TO_BE_EXTRACTED_FOLDER_TIMESTAMP , SI_PLATFORM_SEARCH_LAST_TO_BE_EXTRACTED_MAX_FOLDER_ID , SI_PLATFORM_SEARCH_LAST_TO_BE_EXTRACTED_DAILY_MAX_OBJECT_ID , SI_PLATFORM_SEARCH_LAST_TO_BE_EXTRACTED_DAILY_OBJECT_TIMESTAMP , SI_PLATFORM_SEARCH_LAST_DAILY_REPO_CRAWL_TASK_RUN FROM CI_APPOBJECTS WHERE SI_ID = 4301

.......

java.lang.RuntimeException: Attribute SI_PLATFORM_SEARCH_LAST_TO_BE_EXTRACTED_ID in object Platform Search Application Status (4301) is not a integer/long value!


Read more...

Environment

  • SAP BusinessObjects Business Intelligence Platform 4.x

Product

SAP BusinessObjects Business Intelligence platform 4.0 ; SAP BusinessObjects Business Intelligence platform 4.1

Keywords

Platform search, number of index documents 0 20 stuck stopped broken metadata full content schedule continuous crawling cluster string integer long rebuild lock, BI 4.1, 4.0, exception, fail, schedule, SI_PLATFORM_SEARCH_LAST_TO_BE_EXTRACTED_MAX_FOLDER_ID, mayurb , KBA , BI-BIP-SCH , BI platform search , BI-BIP-ADM , BI Servers, security, Crystal Reports in Launchpad , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.