Skip to Content
0

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

Nov 21, 2016 at 10:51 AM

178

avatar image
Former Member

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.

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

9 Answers

Tammy Powlas
Nov 21, 2016 at 12:40 PM
0

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

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Nov 21, 2016 at 03:32 PM
0

Hi Tammy,

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

Where can I find patch 3?

Regards,
Jos.

Share
10 |10000 characters needed characters left characters exceeded
Tammy Powlas
Nov 21, 2016 at 03:46 PM
0

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

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Nov 21, 2016 at 08:45 PM
0

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.

Share
10 |10000 characters needed characters left characters exceeded
Tammy Powlas
Nov 21, 2016 at 09:02 PM
0

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.

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Nov 22, 2016 at 11:55 AM
0

Hi Tammy,

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

Regards,

Jos.

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Nov 22, 2016 at 11:55 AM
0

Hi Tammy,

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

Regards,

Jos.

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Nov 30, 2016 at 10:41 AM
0

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

Share
10 |10000 characters needed characters left characters exceeded
chaitanya hublikar Jun 18 at 06:19 AM
0

We are facing same issue. Anybody found solution?

Share
10 |10000 characters needed characters left characters exceeded