on 10-23-2013 9:54 AM
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,
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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" !!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
83 | |
24 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.