Visual Plan Execution phase freezes

[patrickbachmann]

Hi folks,

We are experiencing a problem when trying to analyze visual plan for a particular query.  We can run the SQL query in about 10 seconds.  We then perform visual plan ESTIMATE with success.  Then we EXECUTE visual plan and the second tab never appears with the execute results.  Instead we get 50% progress window even though we can see console status at the bottom of screen clearly shows that the execution finishes in another 10 seconds. Looking at threads on server we can see no activity to indicate something is still happening.  It seems the plan is truly execute but somehow won't display.  Our sever is 82 and our studio is 82.  I tried with older studio and same problem.  Tried with multiple computers and same problem.  Tried a more simple query such as select DISTINCT BLART from MKPF and that works normal.

Anybody seen this particular behavior?

Thanks,

-Patrick

[lbreddemann · Accepted solution]

I've observed something like that before.

Never found time to dig deeper, though.

As the latest Rev.85 got out just now, I propose to retest with the current SAP HANA Studio.

If the "hanging" still occurs, I'd go further and try to see whether the roadblock is on the server or on the client side by using an JDBC trace (I'd expect to find all calls returned and the result sets completely read ... this would indicate a client side problem then.)

- Lars

[patrickbachmann · Accepted solution]

Ok thanks Lars.  I always like keeping my Studio same as db but I have a spare laptop I'm going to upgrade to 85 and give it a shot.  Will let you know how it turns out.

-Patrick

[lbreddemann · Accepted solution]

You can install multiple Studios in parallel w/o problem.

That's what I used to do... one SPS 8, then SPS 9 dev revision...

Just specify a different installation folder and import the system landscape file into the new studio.

- Lars

[patrickbachmann · Accepted solution]

I totally believe you and I have my team mates doing this but have had so many issues with Studio locking up and having to redo all my system connections and repositories that I finally got mad and wiped the entire laptop and installed just one and never had a problem since.  Maybe just lucky. 

[patrickbachmann · Accepted solution]

Hey what is this 'system landscape' file you are referring to?

[lbreddemann · Accepted solution]

The list of all the systems/logons you maintained in the systems tree.

You can export it via the export menu -> landscape and either import it in another SAP HANA Studio configuration (e.g. explained here )  or you can use a shared approach to use the same file in several SAP HANA Studio installations ()

[lbreddemann · Accepted solution]

How cool is this, he? This community reached a point where I can just search for some feature and find some blogs about them.

Awesome!

[patrickbachmann · Accepted solution]

Very cool indeed!  Thanks for this.  I wish I had this a year ago. 

[patrickbachmann · Accepted solution]

Ok I finally tried 85 and unfortunately it didn't work there either.  Maybe I will look into JDBC trace now as you suggested...