Re: Prefetch objects failed Error when added more than 2 table as

Hi,

Is there any further info from Microsoft on this issue? Our production is
using transactional replication and we got similar error message:

Replication-Replication Snapshot Subsystem: agent
ServerA-myDB-myDB_MetaData-1 failed. The replication agent had encountered an
exception.
Source: Unknown
Exception Type: Microsoft.SqlServer.Management.Smo.FailedOperationException
Exception Message: Prefetch objects failed for Database 'myDB'.
Message Code: Not Applicable

This replication job failed twice in its history with the same message shown
above and succeeded for the rest of executions. I am very eager to know what
caused the error and if it's ok to ignore it if the following executions
succeed. (The Articles includes a number of tables.)

Thanks.

Claudia

"John Luo" wrote:

Hi Charles,

I appreciate your help very much. The database has been sent to Raymanod
today.

John


"Charles Wang[MSFT]" wrote:

Hi luoo,
How about this issue?
If Raymond has not contacted you, please mail me (changliw@xxxxxxxxxxxxx)
your database for further research.

Thanks!

Sincerely yours,
Charles Wang
Microsoft Online Community Support

======================================================
When responding to posts, please "Reply to Group" via
your newsreader so that others may learn and benefit
from this issue.
======================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
======================================================


.

Relevant Pages

  • RE: Concerns about exception string revealing internals/data about
    ... exceptions could return certain information as part of the error message. ... exception occurs in my program, is it possible that the exception error ... built in ADO objects in Visual Studio for Microsoft SQL Server. ... the build-in controls in SQL Server2000 or .Net winform/Asp.net controls? ...
    (microsoft.public.dotnet.framework.clr)
  • Re: Concerns about exception string revealing internals/data about
    ... Sorry in last post I meant an "unhandled" exception should never be shown to ... exceptions could return certain information as part of the error message. ... built in ADO objects in Visual Studio for Microsoft SQL Server. ... the build-in controls in SQL Server2000 or .Net winform/Asp.net controls? ...
    (microsoft.public.dotnet.framework.clr)
  • Re: Replication fails after a while
    ... Microsoft Online Support ... Microsoft Global Technical Support Center ... | For this error during Replication, ... Error message when you replicate an Active Directory-integrated ...
    (microsoft.public.windows.server.active_directory)
  • Re: Concerns about exception string revealing internals/data about
    ... exception as an inner exception depending how you are handling it later). ... helps clean up the contract from your data layer .. ... exceptions could return certain information as part of the error message. ... built in ADO objects in Visual Studio for Microsoft SQL Server. ...
    (microsoft.public.dotnet.framework.clr)
  • Re: Replication fails after a while
    ... For this error during Replication, ... Error message when you replicate an Active Directory-integrated ... Microsoft Global Technical Support Center ... | Subject: Re: Replication fails after a while ...
    (microsoft.public.windows.server.active_directory)