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