Skip to Content
avatar image
Former Member

Analysis for Office error: "specified cast is not valid"

Hi,

We receive error "specified cast is not valid" when we try to select a DataSource in Analysis for Office 2.3. (Patch: AOFFICE23SP01P_2-70001611)

We are using Office 2016 and SAPLOGON is based on XML files which are stored local.

Problem occured after we upgraded office to Windows 10 (coming from Windows 7).

See logfiles:

Launcher:

FILE_TYPE:DAAA96DE-B0FB-4c6e-AF7B-A445F5BF9BE2 RECORD_SEPARATOR:30 COLUMN_SEPARATOR:124 COLUMNS:Time|Severity|Category|Method|Thread|Text SEVERITY_MAP:DEBUG|Debug|INFO|Information|VERBOSE|Verbose|WARNING|Warning|ERROR|Error|FATAL|Fatal HEADER_END

AO log:

FILE_TYPE:DAAA96DE-B0FB-4c6e-AF7B-A445F5BF9BE2 RECORD_SEPARATOR:30 COLUMN_SEPARATOR:124 COLUMNS:Time|Severity|Category|Method|Thread|Text SEVERITY_MAP:DEBUG|Debug|INFO|Information|VERBOSE|Verbose|WARNING|Warning|ERROR|Error|FATAL|Fatal HEADER_END 2016-11-21 09:10:26,287|FATAL|Log.AoPlugin|?.?|VSTA_Main|Exception happened: Specified cast is not valid.# 2016-11-21 09:16:52,027|FATAL|Log.AoPlugin|?.?|VSTA_Main|Exception happened: Specified cast is not valid.#

Please help us to solve this issue.


Regards,

Jos.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

9 Answers

  • Nov 21, 2016 at 12:40 PM

    Jos - would you try going up to the latest patch (SP3)?

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Nov 21, 2016 at 03:32 PM

    Hi Tammy,

    Latest patch I can find is: Patch 2 for AO 2.3.

    Where can I find patch 3?

    Regards,
    Jos.

    Add comment
    10|10000 characters needed characters exceeded

  • Nov 21, 2016 at 03:46 PM

    Jos- SP2 patch 1 is the latest - my mistake. It looks like from the above you are on SP1

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Nov 21, 2016 at 08:45 PM

    Hi Tammy,

    Just patched to the latest patch of AO2.3. Unfortunately this is not the solution.

    Any other suggestions?

    We tried the same settings on a windows 8 PC there it works, but not on a windows 10 PC. It looks like the problem is there, but I can not find a fix.

    Regards,

    Jos.

    Add comment
    10|10000 characters needed characters exceeded

  • Nov 21, 2016 at 09:02 PM

    Jos - I would submit a ticket to SAP Support and reference this thread. I can't find anything unless you want to uninstall and reinstall the latest patch.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Nov 22, 2016 at 11:55 AM

    Hi Tammy,

    We created a ticket to SAP Support. I will post te solution when issue is solved.

    Regards,

    Jos.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Nov 22, 2016 at 11:55 AM

    Hi Tammy,

    We created a ticket to SAP Support. I will post te solution when issue is solved.

    Regards,

    Jos.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Nov 30, 2016 at 10:41 AM

    Unfortunatly also AO2.4 is not the solution to the problem.

    Add comment
    10|10000 characters needed characters exceeded

  • Jun 18 at 06:19 AM

    We are facing same issue. Anybody found solution?

    Add comment
    10|10000 characters needed characters exceeded