Skip to Content
1

SAP BI Add-in has disconnected all data sources. (ID-111007) - HANA Data sources

Jun 30, 2017 at 04:57 AM

2k

avatar image
Former Member

Analysis Office 2.4 gives the following error when connecting to a SAP HANA data source.

  • An exception occurred in one of the data sources. SAP BI Add-in has disconnected all data sources. (ID-111007)
  • Nested exception. See inner exception below for more details:Unable to cast object of type 'System.AggregateException' to type 'bali.lang.Exception'.

Any suggestion to resolve this error is appreciated.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Tammy Powlas
Jun 30, 2017 at 09:02 AM
0

Hello - there is a Knowledge Base Article on this - see https://launchpad.support.sap.com/#/notes/2439583/E

It suggests updating to the latest version of Analysis Office http://wiki.scn.sap.com/wiki/x/j41IGQ - have you tried that?

Show 3 Share
10 |10000 characters needed characters left characters exceeded

Hi Tammy,

I have the same problem in 2.3v and when I tried to replicate the same issue in 2.4 also. it didn't work.

Basically when I am trying to filter 2 dimensions, one with Hierarchy and other with Flat value, and saving it. After when I try to open again, it says below message.

Nested exception. See inner exception below for more details:

Nested exception. See inner exception below for more details

Unable to cast object of type 'System.NullReferenceException' to type 'bali.lang.Exception'.



Same issue when I am trying to connect to BW7.5 system and replicate, there is no error. May be BW 7.5 is the solution, but I am not sure about the root cause.

0

On 2.4 are you on the latest patch? If so I would open a SAP Support incident message

0

I have tried in 2.4.3....

More over as already mentioned, our landscape is being upgraded to BW 7.5, and I tried connecting to those system, it is working fine. Does this means BW 7.5 is solution?

0