.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Imran Ghani
Sohaib Khalid
Post New Web Links

The merge process was unable to access row metadata at the 'Publisher'

Posted By:      Posted Date: November 20, 2010    Points: 0   Category :Sql Server
Hi! In Merge pull subscription, I'm writing a tool that when data cannot be uploaded to the publisher, it upload unsynced changes using 'table diff' tool.

This scenario is as follows:

1-Make a copy from the subscriber db.
2-Sync (that removes changes at the subscriber)
3-Revert (That writes back changes from the copy db to the subscriber db -using 'table diff' tool)
4-Sync (that provides identical data for both publisher and the subscriber)

but for some subscribers, the final sync (step 4 that mentioned above)
was encountering with below error:

2009-02-25 15:11:29.046 Category:NULL
Source:  Merge Replication Provider
Number:  -2147200996
Message: The merge process was unable to access row metadata at the 'Publisher'. When troubleshooting, restart the synchronization with verbose history logging and specify an output file to write to, or use SQL Profiler to determine the source of the failure.
2009-02-25 15:11:29.046 Category:SQLSERVER
Source:  RDC2
Number:  3989
Message: New request is not allowed to start because it should come with valid transaction descriptor.
2009-02-25 15:11:29.062 Category:NULL
Source:  Merge Replication Provider
Number:  -2147200999
Message: The process was successfully stopped.

conditions (both publisher and subscribers):
sql server 2005 develop

View Complete Post

More Related Resource Links

Access Services is unable to process the request.


When I publsih a web database template from the Microsoft application I get the following error:

Access Services is unable to process the request.Click here to try again.

Larry Stupka

Access Services is unable to process the request.Click here to try again.


I have published an Access Web Database that is one of the templates for microsoft and I get the following error:

Access Services is unable to process the request.  Click here to try again.

Larry Stupka

access services unable to process request


after creating Issue Web Database application - all I get when ever I try to access users, issues etc is the above error message.

AccessPortal.ExecuteWebMethodHandler - An unhandled internal exception has occurred: Microsoft.Office.Excel.Server.CalculationServer.Proxy.ServerSessionException: An error has occurred. ---> System.ServiceModel.FaultException: The server was unable to process the request due to an internal error.  For more information about the error, either turn on IncludeExceptionDetailInFaults (either from ServiceBehaviorAttribute or from the <serviceDebug> configuration behavior) on the server in order to send the exception information back to the client, or turn on tracing as per the Microsoft .NET Framework 3.0 SDK documentation and inspect the server trace logs.    Server stack trace:      at System.ServiceModel.Channels.ServiceChannel.ThrowIfFaultUnderstood(Message reply, MessageFault fault, String... 1aba4a20-7b77-4cf4-b57a-a3371fadb525
10/11/2010 13:37:57.87* w3wp.exe (0x173C)                        0x039C Access Services                User Interface     &nbs

unable to access control inside webuser control



I have used calender web user control inside my project where i took textbox,button and calender.....but after dragging onto my aspx page....i am unable to access this textbox,calender and button on aspx page...Pls help me to find out the solution.

Error "The process cannot access the file ....." occurs while using function "ExportToStream"


Dear all,

   I sometimes get the following error while printing crystal report to pdf:

   System.Runtime.InteropServices.COMException (0x80004005): The process cannot access the file because
it is being used by another process. at CrystalDecisions.ReportAppServer.Controllers.ReportSourceClass.Export
(ExportOptions pExportOptions, RequestContext pRequestContext) at CrystalDecisions.ReportSource.EromReportSourceBase.ExportToStream
(ExportRequestContext reqContext) at CrystalDecisions.CrystalReports.Engine.FormatEngine.ExportToStream(ExportRequestContext reqContext)
 at CrystalDecisions.CrystalReports.Engine.ReportDocument.ExportToStream(ExportOptions options) at
 CrystalDecisions.CrystalReports.Engine.ReportDocument.ExportToStream(ExportFormatType formatType) at
 CommonWA.CommonFunc.GetPDFMemoryStream(DCMSReportDoc _dcmsreportdoc, Boolean& _DataExist) in E:\wwwroot\ASPWA\CommonWA\CommonCom.vb:line 382

  The error not occurs frequently but sometimes it will happen, can someone tell me why the error occurs and how can I solve the problem?

Thank you very much.


Merge Replication: How to give read access on snapshot share to a sql account

Hello All, I want to give read access to an sql account(not windows account). Can it be given or not. Someone please tell. Thanks saandii777

add new synchronization connection unable to process Put message

Environment is Server 2008 SP2, SQL Server 2008 CU2, Sharepoint 2010. Both Forefront services are started. I go to create the sync connection, select AD, use an account that has replication permissions. Populate containers works fine, select a container and click OK. After a bit, I get 'unable to process Put message'. Event logs, application show this error: Microsoft.ResourceManagement.Service: Microsoft.ResourceManagement.ResourceManagementException: Exception from HRESULT: 0x80230516 ---> System.Runtime.InteropServices.COMException (0x80230516): Exception from HRESULT: 0x80230516 at MIISRCW.IMMSServer.SetMVData(String pszMVDataXML) at Microsoft.ResourceManagement.SyncConfig.ModifyMVData(String mvDataXml) at Microsoft.ResourceManagement.ActionProcessor.SyncConfigActionProcessor.Update(Guid objectId, CultureInfo locale, IList`1 updateParameters, Guid cause) --- End of inner exception stack trace --- at Microsoft.ResourceManagement.ActionProcessor.SyncConfigActionProcessor.Update(Guid objectId, CultureInfo locale, IList`1 updateParameters, Guid cause) at Microsoft.ResourceManagement.ActionProcessor.SyncConfigActionProcessor.ProcessInputRequest(RequestType request) at Microsoft.ResourceManagement.ActionProcessor.ActionDispatcher.ProcessInputRequest(RequestType request) at Microsoft.ResourceManagement.WebServices.RequestDispatcher.ExecuteAction(RequestType request) at Mi

How to use metadata for permission to access Documents?

I have document library with 100-200 documents. Not all users are allowed to open all documents. So far I know that user permission can be defined by a document or library level. And permision are granted for user or groups. I wonder if it possible define permissions by metadata level. For example "Personnel department security group" have access to the documents with metadata personnel.    Kenny_I

WCF Service Unable to Access Personal Certificate Store Unless Service Account is Logged In

I created a WCF service that has a method which makes a call to a SOAP web service over the internet. In order to make a call to the SOAP web service, it requires that an X.509 certificate be sent with the HttpWebRequest. The X.509 certificates are loaded in the Personal and Trusted Certificate store of the account which the service is running under. When the service account is logged into the server, everything works just fine. However, when the service account is not physically logged onto the server, it has problems loading up the X.509 certificate and fails authentication when trying to make the HttpWebRequest. I am new to WCF services so I don't even know where to start looking. Can anyone please help? Thanks in advance.

System.Web.Services.Protocols.SoapException: Server was unable to process request. ---> Object canno

hello,i am using a web servicewrtitten in .net and i access the webservice from my wepApplication i get this error System.Web.Services.Protocols.SoapException: Server was unable to process request. ---> Object cannot be cast from DBNull to other types.my code is access webservice: protected void btnSave_Click(object sender, EventArgs e)        {            int intStatusCode;            dtProjectStatus = (DataTable)ViewState["dtProjectStatus"];            try            {                objService.Credentials = System.Net.CredentialCache.DefaultCredentials;                if(dtProjectStatus.Rows.Count>0)                {                  intStatusCode = objService.InsertTest(dtProjectStatus);                }   

Unable to access Entity in controller

 Problem is that when i do like :- Right-click the Models directory and select Add?New Item?Data?ADO.NET Entity Data Model. then generatemodel from a database, it creates OopsData.edmx. and creates entity named OopsEntity. When i try to access this entity in Homecontroller it gives me error like broken reference something. But if i do same thing by right -clicking the project (solution explorer) then i am able to access OopsEntity in HomeController. Reason for asking that is coz i was following the MVC Music Store tut and in it, its done by creating OopsData.edmx in model folder but in my case its not working. Other question is that what is that difference between creating same thing by right clicking on (using) model or solution explorer (project). 

Restoring 2008 Database with Filestream - Process cannot access file error

I'm trying to restore a copy of a database that has a filestream and am getting the error below. I've tried with move option to specify a new path and left it with default path, neither worked. Did a trace with procmon, didn't see anything. FileStream1 is a new folder that the restore process creates. I've deleted the folder, tried it with a new name, re-took the backup from the source machine, restarted SQL, rebooted the machine, drive permissions are open. I've run out of ideas on how to debug further. Looking up the error online wasn't much help either. Msg 3634, Level 16, State 1, Line 1 The operating system returned the error '32(The process cannot access the file because it is being used by another process.)' while attempting 'OpenFile' on 'X:\Data\FileStream1\4ecb2e48-0eee-4c99-a3f0-f1e6c7f00b24\f2efe374-9481-4c1b-a7f2-dcdcee350807\0000001b-0000aaa6-00f6'. Msg 3013, Level 16, State 1, Line 1 RESTORE DATABASE is terminating abnormally. ' SQL Server 2008 SP 1, MS Server 2008 R2 Server

Unable to access VM network drive in SQL during backup generated by stored procedure

I get the following error in a log file created in the osql command: Msg 3201, Level 16, State 1, Server KAC2KGS2, Procedure usp_Kaman_Full_SqlDB_Backup, Line 150Cannot open backup device 'x:\Servername_master_sqlbu_200703101930.bkf'.Device error or device off-line. See the SQL Server error log for moredetails.Msg 3013, Level 16, State 1, Server KAC2KGS2, Procedure usp_Kaman_Full_SqlDB_Backup, Line 150BACKUP DATABASE is terminating abnormally. The device is established in a CMD file right before the osql command is started that starts my stored procedure.  The CMD in this file is: for /f "tokens=15 delims=." %%i in ('ipconfig^|find "IP Address"^|find "192.168"') do set SUBNET=%%i :loopif exist x:\ net use x: /delnet use x: \\192.168.%SUBNET%.1\backup if not ERRORLEVEL 1 ( goto continue) else ( echo FAILED TO CONNECT TO BACKUP SERVER >> "%SystemDrive%\LogFiles\%Computername%.log" sleep 60 goto loop) :continue echo IP ADDRESS OBTAINED Echo delete old log file if it exists if exist %3\%computername%_kaman_full_sqldb_backup_old.log del /Q %3\%computername%_kaman_full_sqldb_backup_old.log Echo Rename log file to old.log rename %3\%computername%_kaman_full_sqldb_backup.log %computername%_kaman_full_sqldb_backup_old.log echo backup SQL Databases on server will start now osql -E -n -d %1 -i %2\kaman_full_sqldb_backup.sql -h-1 -o %3\%Co

The process cannot access the file because it is being used by another process

I have an Excel Connection using the MS OLE DB provider for Office 12 and a Data Flow task to load the data. The filename is set dynamically with an Expression and some variables. The DFT runs fine, then there are a couple of steps that do NOT reference the Excel connection, then there is a File System Task set to MOVE the file to a \Loaded folder. I keep getting the error " The process cannot access the file because it is being used by another process There are no other processes that would be access this file other than the SSIS package itself. I even put in a Script task the pauses 30 seconds (just in case the Data Flow hasn't had enough time to release the connection). Still get the error. Once the package finishes with this error and I stop the debugging, I can manually execute the one Move File task and it goes OK. How do I get the DFT to release the hold on this file?Todd C - MSCTS SQL Server 2005 - Please mark posts as answered where appropriate.

Unable to Merge columns outside Group ? Unnecessary Row height ?

HI , In a matrix tablix , I'm unable to merge columns outside the group . Heres a quick screen shot . http://img843.imageshack.us/img843/366/samplema.png The top 3 columns is what i meant [ Unable to Merge columns outside Group ]  and Row height of the first row ? Thanks in Advance !!Rajkumar Yelugu

SSIS Execute Process Task Give "Access is Denied" error but it is not related to access control.

Hello All - I have a very weired SSIS problem. I am using BIDS in two machines - Windows 7 Professional Edition x64 bit (development workstation) and Windows 2003 Standard Edition x32 bit SP2 (server) . The visual studio version on both the machines are Version 2.0.50727 SP2. I found that my package's ExecuteProcessTask fails with "Access is denied" error in Windows2003 but runs ok in Windows 7 dev box. I then tried to debug the package in the Windows 2003 environment itself. The package failed in debug mode too with the same message. After looking for a while I found that when I shorten the Argument length of the failing ExecuteProcessTask the task did seem to work. So in Windows2003 environment if my argument exceeds 1846 characters the ExecuteProcessTask fails with message "Access is Denied". If the argument string is less than 1846 it works ok. In Windows 7 environment there is no problem at all. It does not seem like access problem but I may be wrong. Has anyone seen this? I will appreciate any reply. Thanks, Niben  

Unable to access Configure Service Accounts using the Farm acount

hi all, I am new to SharePoint and have started working directly on SP2010,   I installed SP 2010 using the Domain\spadmin account. I have also added mine domain account as the administrator in the central admin(farm administrator) now m trying to start the SharePoint Server Search 14 service from "services.msc" for which the log in as user is mine domain account, for which i am getting the following error: The SharePoint Server Search 14 service failed to start due to the following error: The service did not start due to a logon failure. if I check for all the services which are running in SharePoint I get that SharePoint Search service is active. also when i try to access Central Admin --> Security --> Configure Service accounts then I get the error message as access denied signin as different user.   Please help me out as i need to configure search for my application and m not having the access.   Thanks for the help Arun Kumar
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend