Skip to Content
0

Analysis Office - Caught exception : exception 70002620: executor: plan operation failed

Dec 21, 2017 at 08:52 AM

197

avatar image

We have created a Calculation view with an aggregation node having TIME DIMENSION. This view is working fine in HANA Studio but while accessing data in AO we see a mesg "Cannot acces data" with error log "Caught exception : exception 70002620: executor: plan operation failed (42014)".

If we remove the time dimension AO starts reflecting data values. I have tried below things before posting this question.

1. Created a new Calc View assuming existing view got corrupted.

2. Changing position of Time Dimension Aggregate Node in Calc View.

3. Changing Aggregation Node to Projection Node and then use it further, this has solved error problem but now AO starts showing blank report with mesg no data available.

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

2 Answers

Tammy Powlas
Dec 21, 2017 at 12:23 PM
0

Hi - have you tried this using the latest version of Analysis Office, 2.6?

Share
10 |10000 characters needed characters left characters exceeded
Sachin Mishra
Jan 02 at 03:41 PM
0

Hello,

The condition on which I was doing the join i.e. Derived date with SAP date, was the root cause of this issue. HANA studio is smart enough to overlook my joining condition and return correct date but AO was throwing error.

This was fixed after performing conversion on date field before Join.

Share
10 |10000 characters needed characters left characters exceeded