Skip to Content

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

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Dec 21, 2017 at 12:23 PM

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

    Add comment
    10|10000 characters needed characters exceeded

  • Jan 02 at 03:41 PM

    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.

    Add comment
    10|10000 characters needed characters exceeded