After Studio-Upgrade: SAP HANA View Editor not working

[Former Member]

After updating HANA-Studio the 'normal' way of opening objects (views, procedures etc) by double click (SAP HANA View Editor) does not work anymore:

Only by using the 'Text Editor' (right click object -> 'Open With'->'Text Editor') can the objects be displayed.

How can this be fixed?

[Former Member]

I have updated HANA Studio to 2.2.9 (see below) and got a slew of new problems.

Related to this post I still cannot open said calculation view, but now get a different error message

Same thing also happens when I attmept to open ' ...analyticalview' objects, but not for ' .... attributeview' objects or procedures.

[former_member183326]

Hello,

Are you only seeing the "Unhandled event loop exception" error when you try to open the calc and analytical views? Does this happen if you try to activate or validate views?

Could you please open an incident for this. Please send me the incident number.

[Former Member]

Thanks for your answer.

I happens when I attempt to open calc or analytical views with the 'SAP HANA View Editor' (default). With the normal text editor the XML-code is displayed OK.

With colleagues having performed the same upgrade it works well.

We are all using HS in a virtual desktop (Citrix) environment.

I will open the incident ASAP.

[Former Member]

Incident 292926 / 2016 has been opened.

Thank you for your support

[Former Member]

Hi Martin

How did you manage to resolve this issue? I am experiencing exactly the same problem after SAP HAAN studio upgrade, that I cannot view the calculation views.

Regards

Pat

[Former Member]

I tried a lot of different things but nothing worked and in the end I had HS re-installed from scratch.

Now everything is working EXCEPT analytical views. Trying to create or edit analytical views result in:

"Failed to create the part's controls"

I don't know how to solve that one yet 😞

[former_member183326]

Did you search this error at all :

2295376 - "Failed to create the part's controls" HANA Studio error

?

[Former Member]

Mine is a display problem and its for calculation views only, so I have tried with your discussion of the 12th April (associated editors) as this sounds the problem, without progress.

I have reinstalled HANA Studio and I can display the Calculation Views before I add on the ABAP/BW dev tools. As soon as I add on the ABAP/BW dev tools I get the same problem again. So I might have to start installing the Mars HANA Studio and not the one I got from the servicemarketplace. Maybe that version will be compatible with the ABAP/BW dev tools.

Regards

Pat

[Former Member]

Since Monday this week analytical views are suddenly working (I do not know why and I did not change anything wittingly) BUT I just tried to create an SQL script calc view and get the same problem (note: graphical calc views are working).

I looked at note 2295376 but it is not relevant in this case.

I seem to have found a work around: if I close and re-open HANA Studio and then - before doing anything else - create the new object, then it works 🙂 ... at least for now!

[former_member184768]

Please check the following in HANA Studio:

Windows -> Preferences -> General -> Editors -> File associations -> Check for .sql and confirm that you still have SAP HANA SQL console (as default) and SQL Editors / Query builder etc in the associated editors.

If they are not there, please add them.

This is just one of the possibilities, but worth trying.

Regards,

Ravi

[Former Member]

I did as you suggested and it did not fix the issue. I have tried various editors and they all produce the XML view which is tedious to work with.

Interestingly I found that there are two entries 'SAP HANA View Editor'.

The first one (marked 'default') is the one which used to worl, but no more. The second one works like all other editors and opens an XML-view.

[former_member184768]

May be you want to try removing both of them and adding the correct one back again.

Ravi

[former_member552772]

Thanks bro. I have added the necessary editors and it worked.

[former_member183326]

Hello,

what revision did you update to?

[Former Member]

This is what you are referring to?

... or rather this?

[former_member183326]

Hello,

I am using 2.2.7 an this works fine for me.

Can you update your HANA Studio version and check does this fix it.

Michael

[Former Member]

Just tried but I ran into this:

[former_member183326]

Have you tried getting the new version from the service market place?

[Former Member]

Im not sure I understand what you mean. I simply choose 'Help'->'Check for Updates'

Are you implying to reinstall?

The version I have installed (before the update) was downloaded from the SMP.

[former_member183326]

Hello,

Well on my own HANA Studio I have multiple HAHA Studio versions. So its not reinstalling.

Trying downloading the HANA Studio version 2.2.7 or higher from the SMP and check if it fixed then