Solved

Metadata query failed

Posted on 2007-04-02
7
1,081 Views
Last Modified: 2012-05-05
I am running SQL 2005 on 2 seperate servers.  I am attempting to do a Snapshot replication from Server A which is setup as a publisher and distributor.  Server A is suppose to pushe the subscription to server B.  When attempting to create the intial snapshot I recive and error that reads metadata query failed.  Any help would be appreciated.
0
Comment
Question by:Steve_Rogers
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
7 Comments
 
LVL 28

Expert Comment

by:imran_fast
ID: 18841951
Try creating two snapshots with different set of tables. and apply service pact 1 on both server if not there. also check that the user by which your sql agent is running and mssql service is running is same.
0
 

Author Comment

by:Steve_Rogers
ID: 18842945
I have tried creating a snapshot of individual tables including a few of the tables that the snapshot hsa blown up on before and it creates fine.  The server is currently running MS SQL 2005 sp2 so I am already past service pack 1.  The agent and service are both running using an SQL service account set up in AD.
0
 

Author Comment

by:Steve_Rogers
ID: 18843773
Below is an export from the error log, i am hoping that the additional detail will help.


04/03/2007 10:49:11,FS-SHAREPOINT-SCREENS-SnapShot Screens-24,Unknown,2,FS-SHAREPOINT,FS-SHAREPOINT-SCREENS-SnapShot Screens-24,Run agent.,,2007-04-03 14:49:21.41 Source: Replication<nl/>2007-04-03 14:49:21.41 Exception Type: Microsoft.SqlServer.Replication.NativeSqlConnectionException<nl/>2007-04-03 14:49:21.41 Exception Message: metadata query failed<nl/>2007-04-03 14:49:21.41 Message Code: 0<nl/>2007-04-03 14:49:21.41  <nl/>2007-04-03 14:49:21.41 [88%] The replication agent had encountered an exception.<nl/>2007-04-03 14:49:21.41 Source: Replication<nl/>2007-04-03 14:49:21.41 Exception Type: Microsoft.SqlServer.Replication.NativeSqlConnectionException<nl/>2007-04-03 14:49:21.41 Exception Message: metadata query failed<nl/>2007-04-03 14:49:21.41 Message Code: 0<nl/>2007-04-03 14:49:21.41  <nl/>2007-04-03 14:49:21.47 [88%] The replication agent had encountered an exception.<nl/>2007-04-03 14:49:21.47 Source: Replication<nl/>2007-04-03 14:49:21.47 Exception Type: Microsoft.SqlServer.Replication.NativeSqlConnectionException<nl/>2007-04-03 14:49:21.47 Exception Message: metadata query failed<nl/>2007-04-03 14:49:21.47 Message Code: 0<nl/>2007-04-03 14:49:21.47,00:00:15,0,0,,,,0
04/03/2007 10:49:11,FS-SHAREPOINT-SCREENS-SnapShot Screens-24,Unknown,2,FS-SHAREPOINT,FS-SHAREPOINT-SCREENS-SnapShot Screens-24,Run agent.,,The replication agent has been successfully started. See the Replication Monitor for more information.,00:00:00,0,0,,,,0
04/03/2007 10:49:10,FS-SHAREPOINT-SCREENS-SnapShot Screens-24,Unknown,1,FS-SHAREPOINT,FS-SHAREPOINT-SCREENS-SnapShot Screens-24,Snapshot Agent startup message.,,Executed as user: BEACHSYS\rtw. The step succeeded.,00:00:01,0,0,,,,0
0
Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

 
LVL 28

Expert Comment

by:imran_fast
ID: 18849211
Ok the user by which the services are running should be Administrator on the Machine and should have sysadmin access on sql server.
0
 

Author Comment

by:Steve_Rogers
ID: 18850497
Issue has been resolved had nothing to do with users.  Found problem to be binary data fields within fields.
0
 
LVL 1

Accepted Solution

by:
Computer101 earned 0 total points
ID: 22527512
PAQed with points refunded (125)

Computer101
EE Admin
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Why is this different from all of the other step by step guides?  Because I make a living as a DBA and not as a writer and I lived through this experience. Defining the name: When I talk to people they say different names on this subject stuff l…
Ever wondered why sometimes your SQL Server is slow or unresponsive with connections spiking up but by the time you go in, all is well? The following article will show you how to install and configure a SQL job that will send you email alerts includ…
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed

740 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question