Unable to generate accounts report from offline catalog manager in Obiee 11.1.1.7.150120

Dennis Luqman

Hello

Im currently using obiee version 11.1.1.7.150120, i have a problem when trying to create a report which contain Account Display Name and Accounts GUID from runcat.cmd using offline method but the obiee throwing message "User accounts in catalog are being indexed and not yet available for searching. Please try later"

for user account i have 1 working LDAP authenticator and a defaultauthenticator.

runcat.cmd -cmd report -offline F:\obiee\oracle\product\fmw\instances\instance1\bifoundation\OracleBIPresentationServicesComponent\coreapplication_obips1\catalog\SampleAppLite -forceoutputFile F:\testresult\OBIEE\result.txt -type "Accounts" -fields "Account GUIDS"

BIFNDN_LABEL =BIFNDN_11.1.1.7.0BIBP_WINDOWS.X64_150113.1200

# Command : -cmd report -offline F:\obiee\oracle\product\fmw\instances\instance1\bifoundation\OracleBIPresentationServicesComponent\coreapplication_obips1\catalog\SampleAppLite -forceoutputFile F:\testresult\OBIEE\result.txt -type Accounts -fields Account GUIDS

N1      Mon May 08 15:29:52 2017        cmjniconnection.cpp     2790    saw.catalogmanager      Oracle BI CatalogManager 11.1.1.7.150120 (Build 150113.1200 64-bit) is connecting offline.

N1      Mon May 08 15:29:52 2017        userpopulation.cpp      303     saw.catalog.local.loadCatalog   Using only catalog user population

N1      Mon May 08 15:29:52 2017        cmjniconnection.cpp     483     saw.catalogmanager      Loading catalog F:\obiee\oracle\product\fmw\instances\instance1\bifoundation\OracleBIPresentationServicesComponent\coreapplication_obips1\catalog\SampleAppLite.

W1      Mon May 08 15:29:52 2017        autosearch.cpp  424     saw.catalog.autosearch.findallaccounts  User accounts in catalog are being indexed and not yet available for searching. Please try later

E31     Mon May 08 15:29:52 2017        autosearch.cpp  426     saw.catalog.autosearch.findallaccounts  User accounts in catalog are being indexed and not yet available for searching. Please try later

Running Report

java.lang.reflect.InvocationTargetException

        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)

        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

        at java.lang.reflect.Method.invoke(Method.java:597)

        at com.siebel.analytics.web.catalogmanager.commands.Command.runCmd(Command.java:597)

        at com.siebel.analytics.web.catalogmanager.commands.Command.processCmdLine(Command.java:870)

        at com.siebel.analytics.web.catalogmanager.CatalogManager.start(CatalogManager.java:34)

        at org.eclipse.equinox.internal.app.EclipseAppHandle.run(EclipseAppHandle.java:193)

        at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.runApplication(EclipseAppLauncher.java:110)

        at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.start(EclipseAppLauncher.java:79)

        at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:386)

        at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:179)

        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)

        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

        at java.lang.reflect.Method.invoke(Method.java:597)

        at org.eclipse.equinox.launcher.Main.invokeFramework(Main.java:549)

        at org.eclipse.equinox.launcher.Main.basicRun(Main.java:504)

        at org.eclipse.equinox.launcher.Main.run(Main.java:1236)

        at org.eclipse.equinox.launcher.Main.main(Main.java:1212)

Caused by: java.lang.NullPointerException

        at com.siebel.analytics.web.catalogmanager.tools.AccountReportHandler.handleFolder(AccountReportHandler.java:26)

        at com.siebel.analytics.web.catalogmanager.tools.CatalogWalkerLite.walkNodeGuts(CatalogWalkerLite.java:365)

        at com.siebel.analytics.web.catalogmanager.tools.CatalogWalkerLite.walkNode(CatalogWalkerLite.java:284)

        at com.siebel.analytics.web.catalogmanager.tools.CatalogWalkerLite.doIt(CatalogWalkerLite.java:189)

        at com.siebel.analytics.web.catalogmanager.tools.CatalogWalkerLite.doIt(CatalogWalkerLite.java:140)

        at com.siebel.analytics.web.catalogmanager.tools.CMReportHandler.createReportCmdLine(CMReportHandler.java:1891)

        at com.siebel.analytics.web.catalogmanager.commands.ReportCommand.run(ReportCommand.java:457)

is there any work around for this issue?

Thanks

Dennis