Skip to Content
0
Apr 26, 2018 at 01:12 PM

How to Find and Delete a HANA Temporary Table Created in Stored Procedure

1348 Views

Hi,

I have a stored procedure scheduled as an XSJOB that periodically returns the error below, usually if there has been a system crash while the proc was running and the internal cleanup was not done.

"general error (no further information available); $function$=temp_index_create_itab_ex; $message$=unable to create itabindex XSJOB_SCHED:IT_0x00007fec619c47c0:2:0 (288230376313943604): index already existing."

I have been unable to find where the referenced object ( temporary table ?? ) exists to try and delete it. What I have had to do to work around this is create a new DB user to schedule the XSJOB and the issue goes away, presumably because it is a new user schema.

Can anyone provide guidance as to how to find this temporary object and delete it? Our HANA system is 1.00.097.

Thanks!! Mel