Hello All,

Its been some time that I have been working in HANA and related areas like SLT, Lumira, Fiori and so on.

So thought of sharing some topics here, which would be handy.

Disclaimer :

1) This series is exclusively for Beginners in HANA and all those HANA experts here, please excuse me

2) These are some Solutions/observations that we have found handy in our projects and am quite sure there would be multiple ways to derive the same result.

3) These series of documents are collaborative in nature. So please feel free to edit the documents,wherever required!

4) All the points mentioned here is observed on HANA systems whose revision is >= 82.


Part 1 of this series can be found here –> Tips, Experience and Lessons Learned from multiple HANA projects(TELL @ HANA – PART 1)

Part 3 of this series can be found here –>  Tips, Experience and Lessons Learned from multiple HANA projects(TELL @ HANA – PART 3)

Part 4 of this series can be found here –>   http://scn.sap.com/docs/DOC-65343

13) Related to HANA:

Use Case: You already have a HANA system configured in Studio.

Once you log in, you could see that ‘SAP Control REQUEST HAS FAILED’ even though the services are all started.

P1.png

Solution: In most cases, remove the system from the studio and add the same system again.

It should start again without any issues.

14) Related to HANA:

Use Case: My customer had sent me a excel file (which looks like the following) and I was asked to load the same into a schema table in HANA.

Please note that there is a COUNTER Column having value 1 in each row.

P1.JPG

When we upload, we are getting an error like the following:

‘INSERT, UPDATE and UPSERT are disallowed on the generated column: Cannot insert into the generated field COUNTER’

P1.JPG

Work around: We had tried many options but nothing was working out for us.

So we deleted the ‘COUNTER’ column from the excel and then uploaded the data.

Later using an ALTER Statement, we were able to include the ‘COUNTER’ column aswell.

P1.JPG

PS: The actual reason for this error is still not clear, but could see some interesting discussions about this here in SDN.

This should be helpful –> EXPERIENCE WITH IDENTITY FEATURE IN SAP HANA

15) Related to HANA:

Use Case: My customer had sent me a excel file (which looks like the following) and I was asked to load into a schema table in HANA.

P1.JPG

We were trying to upload the data to HANA, where the Data type of the above 2 fields ‘DATEA’ and ‘LDATE’ was ‘DATE’.

Upload from Flat file was throwing the following error.

‘at.jave.sql.Date.strict_valueOf’

P1.JPG

Workaround: We had to change the data type of the fields ‘DATEA’ and ‘LDATE’ to ‘NVARCHAR’.and the data was successfully uploaded.

This was a just a workaround and am not sure if we have a permanent solution for this issue.

P1.JPG

Another Work Around for Loading Date fields from excel to HANA:

In HANA side, keep the corresponding column as date data type.

Untitled333.png

Go the CSV file and do the following modification and save the csv file.

Capture3333.JPG

Now try loading the table to HANA using Data from Local file option  and it will be successful.

PS: Even after saving the csv file, you might see the excel column in the old format, but dont worry, the loading will be successful.

This will work only in cases, where you dont have a null value under the date column.

16) Related to HANA/ ABAP Development Tools

Use Case: We had to do of a debugging a procedure in an Promotion Management System running on HANA database.

We we clicked on the particular procedure, it showed us a message ‘Please use the ABAP development tools in Eclipse’.(SE80 screen is shown below)

Untitled1.png

Solution: We had to configure ABAP perspective in Eclipse/Studio and were able to proceed with debugging.

Please see some interesting documents on the related topic here:

ABAP Managed Database Procedures – Introduction

Tutorial: How to Debug an ABAP Managed Database Procedure

Post configuring the ABAP Perspective, we will be able to log into the ABAP system using the same.

Capture11.png

The above shown screen of SE80 in ABAP perspective will look like the following in HANA Studio.

Untitled11.png

17)  Related to HANA/ ABAP Development Tools

Use Case:  We had to install ‘ABAP Development Tools’ in HANA Studio.

Solution: Please follow the steps mentioned by Senthil in the following document.

Step-by-step Guide to setup ABAP on HANA with Eclipse

When you follow the document, at one point you will have to select the required add-on’s.

Kepler.JPG

Once the steps are successfully completed, you would be able to see the following perspectives(selected ones from the previous screen) in your Studio:

Pers.JPG

18) Related to HANA Studio/Eclipse Environment

Use Case: While working in HANA studio, an error ‘Failed to create Parts Control’ occured.

Observation: This error is some how related to Eclipse environment.

The workaround we had done was to close the studio and run again.

Close and run again.png

We had observed this error in the following environment:

HANA Studio version is 1.00.82.0

HANA system version is 1.00.85.00.397590

Please find an important discussion on this topic here:

Failed to create the part’s controls

19) Related to HANA Studio/Citrix Environment

Use Case: This was observed in an Internal Citrix environment and is not expected much in customer projects.

The Studio fails to load and shows the following error message:

Capture1.JPG

Solution: This is an error related to workspace space issue.

HANA studio settings were reset and a new workspace(which has a larger space) was assigned to the new studio installation.

20) Related to HANA

Use Case: I was trying to load a flat file to HANA and I was getting Scientific notations in some columns

Solution:

Initially, I was trying to load an .xlsx file and I was getting the Scientific Notations.

EX like below:

2.JPG

Then I Changed the .xlsx to .csv (File –> Save as –> .csv) and loaded again to Hana and ioutput was coming as expected:

EX like below:

1.JPG

One more thing what I could observe was that if I change .xlsx to .csv by simply changing the extension and then load to HANA, I was getting something like below:

3.JPG

21) Related to HANA Studio/Eclipse Environment

Use Case: We had installed the plugin’s like ‘ABAP’ and was working in that perspective.

Due to some action, we were getting the message: ‘Secure Storage is Locked’.

Secure storage is locked.png

Observation: The functional part of the secure storage is documented by Rocky in his blog here:

The “not quite” secure storage HANA Studio, Reconnect your Studio to HANA Servers!

You can also find a very detailed discussion about this topic here:

“Error when connecting to system” or “Invalid Username or Password” with HANA Studio

Solution: We followed the following path and deleted the related contents and restarted again.

Pers.JPG

Hope this document would be handy


BR

Prabhith

To report this post you need to login first.

4 Comments

You must be Logged on to comment or reply to a post.

  1. Lars Breddemann

    Even as this is a bit dated by now – I just stumbled over it, so sorry for being late to the party – it still is one of the most random collection of SAP HANA notes.

    Why is there no random-I-feel-lucky-button, that shows one of these snippets at a time?

    (0) 
    1. prabhith prabhakaran Post author

      Lars Breddemann,

      Thanks a lot for joining the party.

      When I started working for HANA Projects last year, I had to lot of time solving some of the issues mentioned here.That had ignited the spark of coming up with such a

      blog series here in SDN.

      Coming back to your comment, I some how couldn’t follow the part random-I-feel-lucky-button, Could you please help me out again?

      BR

      Prabhith

      (0) 
      1. Lars Breddemann

        This was referring to the fact that this series of documents really is just a list of random information with no particular structure, order or layout.

        Each of the points stands at an arbitrary position in the list and is not related to the points before and after it.

        Therefore, having a button – similar to the Google ‘I feel lucky’ link – would be a nice way to consume one point at a time without having to make the decision which point to take.

        (0) 

Leave a Reply