September 7, 2009 at 4:34 am
I have a Rebuild Index Maintenance Plan to rebuild indexes on all databases which fails with the following error:-
Failed:(-1073548784) Executing the query "ALTER INDEX [P08_AA_AcctPeriod_PK] ON [dbo].[P08_TAA_AcctPeriod] REBUILD WITH ( FILLFACTOR = 90, PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, SORT_IN_TEMPDB = OFF, ONLINE = OFF ) " failed with the following error: "Cannot find the object "dbo.P08_TAA_AcctPeriod" because it does not exist or you do not have permissions.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.
I have been unable to establish the presence of table/view P08_TAA_AcctPeriod in any Database, so ran the same Rebuild Index task individually on every database, without any problems; each task completed successfully.
Anybody have any ideas?
September 7, 2009 at 5:13 am
Gary Cobden (9/7/2009)
I have a Rebuild Index Maintenance Plan to rebuild indexes on all databases which fails with the following error:-Failed:(-1073548784) Executing the query "ALTER INDEX [P08_AA_AcctPeriod_PK] ON [dbo].[P08_TAA_AcctPeriod] REBUILD WITH ( FILLFACTOR = 90, PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, SORT_IN_TEMPDB = OFF, ONLINE = OFF ) " failed with the following error: "Cannot find the object "dbo.P08_TAA_AcctPeriod" because it does not exist or you do not have permissions.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.
I have been unable to establish the presence of table/view P08_TAA_AcctPeriod in any Database, so ran the same Rebuild Index task individually on every database, without any problems; each task completed successfully.
Anybody have any ideas?
Well if you cannot find the object,maybe someone has removed it, or it was a temporary object which has since disappeared.
--------------------------------------------------------------------------------------
[highlight]Recommended Articles on How to help us help you and[/highlight]
[highlight]solve commonly asked questions[/highlight]
Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
Managing Transaction Logs by Gail Shaw[/url]
How to post Performance problems by Gail Shaw[/url]
Help, my database is corrupt. Now what? by Gail Shaw[/url]
September 7, 2009 at 5:42 am
The same error happens every time it is run
September 7, 2009 at 10:12 am
Check the other scheduled processes that run during the same time. You probably have another job that is recreating that table while your maintenance plan is running. Or, more likely - you have a job that is creating the table, using it - and then dropping it when it is complete.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
September 10, 2009 at 9:12 am
Does the table that the index references have any computed columns ? If so this is a known issue.
RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply