Solved

Metadata query failed

Posted on 2007-04-02
7
1,058 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
  • 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
Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

 
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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Oracle DB monitor SW 21 48
sql 2014,  lock limit 5 32
Help in Bulk Insert 9 33
T-SQL: New to using transactions 9 25
JSON is being used more and more, besides XML, and you surely wanted to parse the data out into SQL instead of doing it in some Javascript. The below function in SQL Server can do the job for you, returning a quick table with the parsed data.
Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function

770 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