cancel
Showing results for 
Search instead for 
Did you mean: 

Unable to TRUNCATE and DROP Table in SAP HANA

Former Member
0 Kudos

Hi All,

We are uploading data using flat files in to SAP HANA Database. While upload was in process our VPN connection got disconnected and from there on wards we are no able to DROP or TRUNCATE the table. When the DROP or TRUNCATE statement is executed, in progress bar it shows

"Execute job :drop table "Table name"cascade". But nothing happens for hours due to which not able to upload data using flat file also.

Please suggest some method to check or identify what kind of error is not allowing to proceed.

Thank you,

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

Hi Kavita,

Are you using SQL statements?

Can you try from HANA Studio to locate the table in your Schema and delete the directly from the context menu(Right click menu)?

Options are present to drop(delete table) as well as truncate(delete all rows).

--

Shreepad

former_member193518
Active Participant
0 Kudos

Can you run the RepairTopology.py script as shown in this SAP note:

https://service.sap.com/sap/support/notes/1700095

Obviously leave off the running of "drop <user> cascade" !!