Article - CS374065
Could not find any index named '<INDEX_NAME>' for table '<TABLE_NAME>'.
Modified: 30-Sep-2022
Applies To
- Windchill PDMLink 12.0
Description
When executing indexes creation code below on SQL Server:
Errors below are displayed :
CREATE INDEX [ShadowBaseline$CS232546] ON [ShadowBaseline]
(
[ObjectRef] ASC,
ShadowContext
)
INCLUDE
(ShadowClass, UpdateCount)
WITH (DROP_EXISTING = ON, SORT_IN_TEMPDB = ON);
GO
CREATE INDEX [ShadowCache$CS232546] ON [ShadowCache]
(
[ObjectID] ASC
)
INCLUDE
(CacheClass, ShadowContextId)
WITH (DROP_EXISTING = ON, SORT_IN_TEMPDB = ON);
GO
(
[ObjectRef] ASC,
ShadowContext
)
INCLUDE
(ShadowClass, UpdateCount)
WITH (DROP_EXISTING = ON, SORT_IN_TEMPDB = ON);
GO
CREATE INDEX [ShadowCache$CS232546] ON [ShadowCache]
(
[ObjectID] ASC
)
INCLUDE
(CacheClass, ShadowContextId)
WITH (DROP_EXISTING = ON, SORT_IN_TEMPDB = ON);
GO
Errors below are displayed :
Msg 7999, Level 16, State 9, Line 101 Could not find any index named 'ShadowBaseline$CS232546' for table 'ShadowBaseline'. Msg 7999, Level 16, State 9, Line 111 Could not find any index named 'ShadowCache$CS232546' for table 'ShadowCache'.
This is a printer-friendly version of Article 374065 and may be out of date. For the latest version click CS374065