Skip to Content
Former Member
Oct 23, 2013 at 08:54 AM

Unable to TRUNCATE and DROP Table in SAP HANA


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,