Skip to Content
author's profile photo Former Member
Former Member

Queries related to XS services in SAP HANA

Hi ,

I have a few queries related to XS services in SAP HANA.

1) In my project i am creating tables from eclipse wit .hdbtable extension.
These changes are moved to QA.I did some changes to those tables in DEV system after migration.

How to move only those changes to QA?
What is APPLY PATCH in team provider?

2) I created project in project explorer.I delete some unwanted files from project but those files are still available under package in workspace.

How to delete unwanted files from server or package?

3) In stored procedure i am using cursor for select statement with for update.

Ex: define cursor c_cur for select col1,
col2,
col3
from table1
where col1 = '1'
for update;

for r1 as c_cur do
v_count := v_count + 1;
end for;

In Table1, no of rows - 4
but getting v_count = 5.

For loop is running twice for first record.

How to avoid this issue?

i am using 64 bit HANA studio and client - rev 60.

Thanks.
Ramya

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • Best Answer
    Posted on Aug 14, 2013 at 05:35 PM

    >These changes are moved to QA.

    You should use Delivery Unit to move your content throughout your landscape.

    >2) I created project in project explorer.I delete some unwanted files from project but those files are still available under package in workspace.

    How to delete unwanted files from server or package?

    If you delete from the project you must commit and then activate from the higher level package (or the project root) in order to process deletions.


    Add a comment
    10|10000 characters needed characters exceeded

    • >i activated project after deletion, but still they r visible under package in workspace tab.

      Did you commit at that level before the activation. You must manually commit to process deletions.

      >If i migrate package from DEV to QA, will they also move to QA?

      If they still show in the repository on the server side, yes.

      >What about the cursor issue which i mentioned?

      I have no comment on the cursor. That's a completely separate topic and really should probably be posted as an independent thread.

      >How to migrate XS services from DEV to QA?

      You must assign the packages to a Delivery Unit. Then you can transport via a Delivery Unit.

      You use the File->Export option in the Studio and choose SAP HANA Content -> Delivery Unit. Similar process, just with File->Import to bring the content into QA. In SPS6 you can also use the HANA Application Lifecycle Management web application or the Web IDE to perform these actions as well. All of these steps are documented in the Developers' Guide on help.sap.com

  • author's profile photo Former Member
    Former Member
    Posted on Aug 31, 2015 at 06:00 AM

    Hi Thomas/Ramya,

    Can You Guys able to import it Succesfully??

    When I imported into new instance I can only able to see that Project in REPOSITORIES but not in PROJECT EXPLORER.

    Is there any method or a Way that i can get back my Projects from Repositories to Project Explorer.

    Thanks & Regards

    Nagarjuna

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.