OBIEE 12c: Managed Server Logs Contain the Error: Unable to open index to process push crawl event of object at path

(Doc ID 2191770.1)

Last updated on FEBRUARY 10, 2017

Applies to:

Business Intelligence Suite Enterprise Edition - Version 12.2.1.0.0 to 12.2.1.0.0 [Release 12g]
Information in this document applies to any platform.

Goal

On a new installation of OBIEE 12.2.1.0.0 with the RCU Schemas in a MS SQL Server database, the following error is observed in the Managed Server log (bi_server1.log) and the Domain log (bi.log):-

<Error> <oracle.biee.search> ... <BISearchCrawlScheduler> ... <BEA-000000> <Error while picking up scheduled job
java.sql.SQLException: Exception while executing JDBC operation
at oracle.biee.search.services.crawl.scheduler.dao.impl.SQLServerSchedulerDAOImpl.pickupScheduledJob(SQLServerSchedulerDAOImpl.java:83)
...
Caused By: java.sql.SQLException: [FMWGEN][SQLServer JDBC Driver]ResultSet is not updateable.
...

The error is resolved by setting the UseServerSideUpdatableCursors property to true for the "biplatform_datasource" WLS JDBC Data Source, but now the following warnings / errors are observed:-

<Warning> <oracle.biee.search> ... <BEA-000000> <Unable to open index to process push crawl event of object at path: /system/security/users/093>
<Error> <oracle.biee.search> ... <BEA-000000> <Failed to execute postEvent due to invalid objectKey: />

<Warning> <oracle.biee.search> ... <BEA-000000> <Unable to open index to process push crawl event of object at path: /system/security/accountids/093>
<Error> <oracle.biee.search> ... <BEA-000000> <Failed to execute postEvent due to invalid objectKey: />

<Warning> <oracle.biee.search> ... <BEA-000000> <Unable to open index to process push crawl event of object at path: /system/security/users/093/msbazcfg45nejkox6uylhqt3iwpdrv17>
<Error> <oracle.biee.search> ... <BEA-000000> <Failed to execute postEvent due to invalid objectKey: />

<Warning> <oracle.biee.search> ... <BEA-000000> <Unable to open index to process push crawl event of object at path: /system/security/accountids/093/msbazcfg45nejkox6uylhqt3iwpdrv17>
<Error> <oracle.biee.search> ... <BEA-000000> <Failed to execute postEvent due to invalid objectKey: />

<Warning> <oracle.biee.search> ... <BEA-000000> <Unable to open index to process push crawl event of object at path: /users/msbazcfg45nejkox6uylhqt3iwpdrv17>
<Error> <oracle.biee.search> ... <BEA-000000> <Failed to execute postEvent due to invalid objectKey: />

At the same time, the following message is observed in the Managed Server diagnostics log file (bi_server1-diagnostics.log):-

[NOTIFICATION] [] [oracle.biee.search] ... The postEvent was not executed because a catalog crawl has never been run

Who is the "msbazcfg45nejkox6uylhqt3iwpdrv17" user and how can these warnings / errors / messages be resolved?

Solution

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