BIP 4.1 SP7: Unable to retrieve the dataource configuration

[Former Member]

Greetings,

• BIP 4.1 SP7, patch level 5, Windows 2008 distributed, virtualized on VMWare
• On 9/17 we recently upgraded our production environment from SP5 to SP7
• Immediately upon brining the system back up....
  • Scheduled jobs based on universe(.unx) data sources are failing intermittently
  • Error: Unable to retrieve datasource configuration
  • Users can go in and sometimes do a 'Run Now' and receive Success, or multiple Run Now's with eventual Success
  • See attached error screenshot
• Occurs against universes connections to Oracle, SQL, Hadoop (behavior independent of backend datasource)
• Doing on demand refreshes occurs as well....but extremely rare
• We scheduled 4 test reports against these universes and set recurrence to every 5 min.
  • Experienced the same error on within the first 5 attempts
  • Successful runs since...letting it run 24 hours
• SAP Support Message 314915 should any SAP Support sees this thread

Because of the intermittent nature of the behavior I am thinking it is tied to a specific WebI Proc (we have four of them).  I have not cracked the code on how you tie together Audit data to show which JobProc "Run" even ties to a specific WebIProc "Refresh" event.

Theories:

1) The connection binaries in the WebIProc's got corrupted somehow during the Support Pack upgrade.

2) Corba communication between JobProc and WebIProc is being disrupted (would not explain On Demand errors)

3) Lingering cache files of some kind

Looking for ideas.

Thanks.

-kms

Text so it shows up in search

Unable to retrieve the datasource configuration : java.lang.NullPointerException: while trying to invoke the method com.crystaldecisions.enterprise.ocaframework.IProxyHandler.invoke(java.lang.reflect.Method, java.lang.Object[], java.util.Map) of a null object loaded from field com.sap.connectivity.cs.remoting.corba.svchelpers._ConfigurationProxy.m_handler or an object loaded from local variable 'this'(Error: INF )

[Former Member · Accepted solution]

Resolved by re-applying 'View' permissions for the group Everyone for all BI Platform services.

[Former Member]

We are not at the point of doing a repair, but I assume we will soon.  SAP Support is engaged, but they have not yet advanced beyond the standard "add more memory" tactic...even considering the APS services that were all working fine prior to the upgrade.  Also, we get the random errors on webi reports that refresh in a few seconds and bring back a single column of 20 rows.  Hardly a memory concern.

Looking a network config currently since we are on a distributed VMware environment.

Will update the thread as this progresses.  Thanks for the input though.

[Former Member]

If .unx universe I'd look into the DSL-bridge server.

[Former Member]

I would like to know if repairing the installation will solve this issue as Jawahar suggested.

[former_member185603]

Looks like installation did not go well. Try to repair the install.