on 04-26-2018 2:12 PM
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
Hi,
To record this in case anyone else has the same issue, the solution was to start and start the xsengine.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Lars,
I checked for a relevant Note first ( that is my default "go to" for issues like this 🙂 ), but could not find anything applicable.
I will request a consistency check be run, but as this is a Production system will need to find a window where this activity will be allowed.
Thanks for your input.
Mel
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
This error message seems to relate to a SQL Script internal temp table (that's not the kind you can explicitly create or manage). For some reason, the name for this internal temp table seems to be taken already - which can be due to software bugs or catalog corruptions among other causes.
I'd try and check SAP notes for known issues with "temp_index_create_itab_ex" and also run a consistency check of the database.
If neither yields to explain or solve the issue, the next step is to open a support incident.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
101 | |
13 | |
13 | |
11 | |
11 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.