Running that SQL gives:
Server: Msg 315, Level 16, State 1, Line 1
Index "S_STORE_COND_U1" on table "S_STORE_COND" (specified in the FROM clause) is disabled or resides in a filegroup which is not online.
If this was a general problem with this 'Index', then surely it would affect:
- Online usage.
- All Remote Clients on All Remote Servers.
Wheras the case seems to be it:
- Doesn't affect online usage at all.
- Only affects some Remote Clients on some Remote Servers..
Also, does anyone know if its a valid thing to do to get the DBA's to simply rebuild this Index? I mean, is it going to affect Siebel in some way?
& how could this really have happened, I mean, everything was working before..?
We can also turn this the other way around.
Because you see the same error when you execute the SQL directly, it's not (specifically) related to Siebel.
Your DBA has to come up with an explanation or solution for the error message.
Not all users will see the same data, so the fact that not all users see this error message still isn't proof of a bug in Siebel.
Working with the DBA we had the Index re-instated in QA, were we had the same issue.
So far it seems to have 'fixed' the problem; Database Extracts can run through again even for 'broken' remote clients.
No one seems to be able to explain what happened to our Index, which is strange to me, as it seems unlikely that someone manually disabled it.
But I'll just have to put it down as 'one of those things' I suppose.