cancel
Showing results for 
Search instead for 
Did you mean: 

Queries related to XS services in SAP HANA

Former Member
0 Kudos

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

Accepted Solutions (1)

Accepted Solutions (1)

thomas_jung
Developer Advocate
Developer Advocate
0 Kudos

>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.


Former Member
0 Kudos

Thanks for your reply.

i activated project after deletion, but still they r visible under package in workspace tab.But they are not CHECK out.If i migrate package from DEV to QA, will they also move to QA?

Thanks

Former Member
0 Kudos

What about the cursor issue which i mentioned?

How to migrate XS services from DEV to QA?

Do we need to create work space and project explicitly in QA?

Thanks.

thomas_jung
Developer Advocate
Developer Advocate
0 Kudos

>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

Answers (1)

Answers (1)

Former Member
0 Kudos

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