Skip to Content

Weird behaviour of Analysis Office workbook

There is one Analysis office workbook with 40 data sources.

4 data sources can't be refreshed by a user in his PC but same can be done from other PC using his login. Work book works fine absolutely fine in other PC!

AO 2.4

Excel 2016 32-bit

Error messages:

2018-10-16 11:42:37,374|ERROR|Log.AoPlugin|?.?|VSTA_Main|Exception happened: Object reference not set to an instance of an object.# 2018-10-16 11:42:37,377|ERROR|Log.AoPlugin|?.?|VSTA_Main|103012 Exception occurred while trying to connect to system SAP BW DDP for data source Audit Trail Report 2 - IRB [DS_2][msg.ErrorConnect]#

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

10 Answers

  • Oct 18, 2018 at 11:25 AM

    Santosh - 2.4 is very old; please consider updating to 2.6 latest SP or even 2.7

    Add comment
    10|10000 characters needed characters exceeded

  • Nov 22, 2018 at 02:53 PM

    Finally, we solved the issue. One of the data source was inserted from BI Platform whereas other Data source was inserted from SAP Logon. We replace the system by going to setting of Platform in AO, that solved issue.

    It was crazy because we didn't know any of these details via either logs or directly by looking at Data source properties in AO.

    I just got an idea unexpectedly and tried it and it worked :-)

    Add comment
    10|10000 characters needed characters exceeded

  • Oct 18, 2018 at 11:49 AM

    Hi Tammy, thanks for quick response. We can't afford to upgrade tools so easily as server also needs to be upgraded with same version.

    We have 1000s of AO reports, which needs to be tested before we roll out newer version to users!

    Add comment
    10|10000 characters needed characters exceeded

  • Oct 19, 2018 at 03:28 PM

    Are you connecting to a system via the NetWeaver log on pad? If so, check that the system exists on the users log on pad too. Sometimes even a difference in instance number can cause an issue. Try using the Replace System to connect the workbook to the system that the use has in their own log on pad.

    Hope this makes sense and helps,

    Stephen

    Add comment
    10|10000 characters needed characters exceeded

  • Oct 19, 2018 at 10:55 AM

    Hi Santhosh,

    Looking at the behavior you have described seems that the PC is not running correctly.

    So I suggest except if you did it to reinstall or repair Microsoft Office, that could be a way to solve it.

    Regards

    Eric

    Add comment
    10|10000 characters needed characters exceeded

  • Oct 19, 2018 at 11:06 AM

    Thanks Eric. We reinstalled Analysis office and tried, still facing the error.

    We will try re-install of Microsoft office and check then! But it's quite strange why all other data sources are working?

    Add comment
    10|10000 characters needed characters exceeded

  • Oct 19, 2018 at 12:33 PM

    Hi Santhosh,

    I suggest that because it's a SAP suggestion (KBA) in an other case (KBA is about "The launcher is exited with error..".).

    I agree sure it's seems weird but ...

    One question do these 4 DS have a special excel designin comparaison with the others? I mean macros, VBA coding etc.

    Add comment
    10|10000 characters needed characters exceeded

  • Oct 29, 2018 at 02:59 PM

    Hi All, thanks for the response(s). We did upgrade AO to 2.6, still issue remains same for the user. Hence, asked him to re-install office and check the issue again. I will keep you updated.

    Add comment
    10|10000 characters needed characters exceeded

  • Nov 08, 2018 at 03:10 PM

    We re-installed office completely, still user faces the same issue.

    Any help will be appreciated.

    Add comment
    10|10000 characters needed characters exceeded

  • Nov 09, 2018 at 07:38 AM

    Try AFO 2.7 SP02 Patch 1 which has released on Halloween. We faced multiple issues with AFO 2.4 & 2.6, but are now finally experiencing more stability in our reports.

    Add comment
    10|10000 characters needed characters exceeded