Hi,
I am getting an error while replicating the sql 2000 database.
The error no is 20598...It stopped replicating the database...
Can any body tell me what is this pls....
Tks in advance...
Joyce
Hi,
We have few branches with individual dbs are sitting in the branches itself. Periodically all the data need to be updated to a single HQ database. At the moment, all the tables's primary key are unique and each branch will have branch ID's in the transaction tables.
e.g. Branch1 data need to be updated to HQ db. However, HQ db records which are related to Branch 1 data only need to be updated back to Branch 1. other branch records should not goto Branch1.
Similaryly other branch records need to be updated/replicated back to HQ database. And only records related to the particular branch need to be updated from HQ (if any changes made)..
At the moment, i can do simple replication from one db to another db only... Can anyone guide/give suggestions on how to go about doing this?? If possible, please give steps involved...
TX
Hi,
I changed the sa password today on my subscriber databases, and now my transactional replication fails, as it cannot connect to the subscribers. I updated the publisher's linked server logins, but it still fails. Help please!
Thanks,
Jason
With SQL Server 2005 SP1. We are working with transactional replication without problems. Now we try to create merge publications but we get this error at sync.:
{call sp_MSsetconflicttable (N'BARArticulos', N'MSmerge_conflict_prueba_BARArticulos', N'ANTFOR-MLOPEZ', N'AntforHotel', N'prueba')}
The JOB show this error:
Mensaje
2007-02-06 12:30:47.127 {call sp_MSsetconflicttable (N'BARArticulos', N'MSmerge_conflict_prueba_BARArticulos', N'ANTFOR-MLOPEZ', N'AntforHotel', N'prueba')}
2007-02-06 12:30:47.174 Category:COMMAND
Source: Error en el comando
Number: 0
Message: {call sp_MSsetconflicttable (N'BARArticulos', N'MSmerge_conflict_prueba_BARArticulos', N'ANTFOR-MLOPEZ', N'AntforHotel', N'prueba')}
2007-02-06 12:30:47.174 Category:SQLSERVER
Source: ANTFOR-MLOPEZ
Number: 102
Message: Sintaxis incorrecta cerca de 'Articulo'.
2007-02-06 12:30:47.174 Category:NULL
Source: Proveedor de rÚplica de mezcla
Number: -2147201001
Message: El proceso de mezcla no pudo entregar la instantßnea al suscriptor. Si se utiliza sincronizaci¾n Web, es posible que el proceso de mezcla no haya podido crear el archivo de mensaje o escribir en Úl. Para solucionar el problema, reinicie la sincronizaci¾n con registro de historial detallado y especifique un archivo de salida para escribir en Úl.
Help please.
can some one tell where to look for a solution to this error or what i can do to fix this ... any and all help will be welcome !!
thanks
kim
Hi colleagues!
In trying to activate a merge replication between a Win2000/SQL7 distributor/publisher and a Win2003/SQL2000 subscriber I keep getting the following error:
Process could not enumerate changes at the subscriber (error 2812)
Merge publication works fine between the distributor and another subscriber (NT4/SQL7).
When i look at the details of the merge agent history i can see the process stopped with :
call sp_MSenumeratechanges(?,?,?,?,?)
I read article 308743 on microsoft/technet, and there they advise to install SP3a for SQL2000 on the subscriber. Ive done that but the error persists.
SQLServerAgent on the subscriber starts up with a local administrator account, the (physical) server itself is not a member of the local network; (outside the DMZ). The server is declared in the Client Network Utility of the distributor/publisher and is therefore known as a potential subscriber. In fact, the snapshot agent works perfectly (or so it seems).
Can anyone give me a helpfull hint?
Thanks!
VincentJS
Hello All,
I am not sure what is going on, but ever since I installed my ASP.NET shopping cart I keep getting the following error message in my Event Viewer under Application.
If anyone out there has any idea why this is happening please let me know because it seems to be crashing my other sites on my web server.
I have a Web Server which connects to a separate SQL 2000 Server. This error message is on my Web Server.
Thank you all in advance for your help!
Error:--------------------------------------------------------------------------------------------------------------------------
Event code: 3005 Event message: An unhandled exception has occurred. Event time: 1/6/2007 1:07:17 PM Event time (UTC): 1/6/2007 6:07:17 PM Event ID: 518a9db199214e3e807dd676e85f3d5a Event sequence: 103 Event occurrence: 6 Event detail code: 0 Application information: Application domain: /LM/W3SVC/1309570491/Root-1-128125656181152736 Trust level: Full Application Virtual Path: / Application Path: C:InetpubStoreV7 Machine name: CDMLWEB Process information: Process ID: 2376 Process name: w3wp.exe Account name: NT AUTHORITYNETWORK SERVICE Exception information: Exception type: SqlException Exception message: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. Request information: Request URL: http://www.bestpricetags.com/default.aspx Request path: /default.aspx User host address: 207.38.200.139 User: c2e1ff27-e0ea-4c7f-ac61-5b1716651d3b Is authenticated: True Authentication Type: Forms Thread account name: NT AUTHORITYNETWORK SERVICE Thread information: Thread ID: 10 Thread account name: NT AUTHORITYNETWORK SERVICE Is impersonating: False Stack trace: at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParserStateObject.ReadSniError(TdsParserStateObject stateObj, UInt32 error) at System.Data.SqlClient.TdsParserStateObject.ReadSni(DbAsyncResult asyncResult, TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParserStateObject.ReadPacket(Int32 bytesExpected) at System.Data.SqlClient.TdsParserStateObject.ReadBuffer() at System.Data.SqlClient.TdsParserStateObject.ReadByte() at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlInternalConnectionTds.CompleteLogin(Boolean enlistOK) at System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance) at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance) at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection) at System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options) at System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject) at System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject) at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) at System.Data.SqlClient.SqlConnection.Open() at AspDotNetStorefrontCommon.DB.GetRS(String Sql) at AspDotNetStorefrontCommon.DB.GetSqlN(String Sql) at AspDotNetStorefrontCommon.AppLogic.IPIsRestricted(String IPAddress) at AspDotNetStorefront.Global.Application_AuthenticateRequest(Object sender, EventArgs e) in C:InetpubStoreV7App_CodeGlobal.asax.vb:line 103 at System.Web.HttpApplication.SyncEventExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) Custom event details:
For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
I launch an installatino of SQL Server 2000 on a server, upgrading the V7 original datbase but it failed with error :
"the ordinal 105 could not be located in the dynamic link library opends60.dll"
And the SQL server services cant' start.
Can someone help me ?
It's urgent.
I have been trying to get a SQL 2000 server replicated with another - and keep getting the same error:
SQL Server Enterprise Manager could not configure "Server Name" as the Distributor for "Server Name"
Error 18483: Could not connect to server "Server Name" because 'distributor_admin' is not defined as a remote log in at the server.
I found several sites that helped me to get some feedback - but I am still hitting the same error.
Any thoughts would really help now.
Thanks!
M
I have a merge replication publication that has been running for
months. This week the Snapshot started failing, reporting that an
article was not included in the publication. I checked and found
3 articles that mysteriously no longer show up as being in the
publication. When I attempt to add them it reports that it can't
add them because there is already an article by that name in the
publication. Apparently some table has lost its rows for these
articles while another table(s) still has its rows.
Has anyone had this problem? Is there a solution short of
dropping the publication and starting over - a solution that would
literally take weeks for us?
Thanks for any help.
Windows Server 2003
SQL Server 2000 on both servers
Attempting to configure replication from server A to Server B using publishing configuration wizard.
Using Enterprise Manager and we received error 2812: Could not find stored Procedure 'msdb.dbo.sp_add_jobstep_internal'.
Following the analysis of general Microsoft help which pointed to a user/rights problem I used the Query Analyser, login with 'sa' and executed sp_adddistributor . I basicly received the same error. I also executed sp_help looking for the specifice procedure - not found.
Is it possible the sp is really not there. All help is appreciated.
Thanks,
Hi.. I tried to setup MSSQL2000 trans replicatiom using push subscription method. My Publisher is also my distributor. But whenever I started the dstribution agent, I got the following error. It has problem connecting to subscriber's DB with the following error. I had tried that the login is 100% fine. But why this error appear ? Any help?
The name ' ' is not permitted in this context. Only constants, expressions, or variables allowed here. Column names are not permitted.
(Source: Subsriber (Data source); Error number: 128)
I have few databases with SAME database structure in
SQL Server 2000 in different locations. Data will be
updated in different places with different sets of
data. Basically, i need to synchronize the data
especially to the headquarters database periodically
(may be everyday at night).
DB : SQL Server 2000
OS : Both are running on Windows XP for testing
purposes.
Situation : Now i have 2 database from 2 different
estates. Now, need to be synched into 1.
Have 2 publisher namely TH1, TH2
1 subscriber : THFinal
I've created 2 individual publications using "Create
Publication" and published database namely TH1 and
TH2.
Publication type : Merge publication
Default table article properties setting are as
follows :
a. When merging from different sources : "Treate
changes to the same column as a conflict (changes to
different columns in the same row will be merged)".
Snapshot
i Choose "DELETE DATA IN THE EXISTING TABLE that
matches the ROW FILTER statement".
Resolver :
I checked "yes" for - Allow Subscribers to resolve
conflicts interactively during on-demand
synchronizations".
Now, when i sync the TH1, all the records from TH1
goes to the subscriber database "THFinal".
When i sync the TH2, all the records which was
synched earlier (from TH1) being DELETED. and all
the records from TH2 goes to the subscriber database
"THFinal".
Basically, i WANT to retain the ALL THE data from in
"THFinal" which came from TH1 database since the
primary key is different. Also, all the database
contains running no (Identity increment = 1) .
Identity : Yes (Not For Replication) (Identit seed=1)
===================================================
PROBLEM : 1ST (TH1) database can be synched. when
I try to replicate the 2nd (TH2) database, the
following ERROR displayed : The process could not
drop one or more tables because the tables are being
used by other publications.
The process could not drop one or more tables because
the tables are being used by other publications.
(Source: Merge Replication Provider (Agent); Error
number: -2147200976)
Thanks in Advance
Reagards
Ihsan
I have used skiperrors parameter for 2601,2627 and 20598 errors in my Transaction replication setup. When transactions with above error are encountered, its skipped but I€™m not getting sql command that is skipped in MSrepl_errors table. Since SQL server 2000 is not saving transaction sequence number in the MSrepl_errors we are not getting the command, which have the errors.
Is there any way to track the commands those are skipped in transactional replication.
Hi,
I am configuring replication and i started using wizard . i opened publishing and distributor wizard and click on next it is saying that "Sql manager could not complete wizard because @@sername is null and use sp_add server name to set @@ servername.
This is productionbox. Any body help me how to fix the problem and what is that meaning osf error.
Thanks
While setting up replication i get a following error..
I am using publisher + distributor on one server
and subscriber on other server
I am getting the following error
"The process could not connect to Subscriber '<Server_name>'"
Any Ideas..
Thanks in advance
VIk
Hi Guys,
We are using transactional replication, I want to add a filter on the rows.
Can Any one explain me how to add it. To do this we should stop replication and then add the filter ???.
Thanks in advance
Hi Guys,
I am having around 1000 tables, in which around 700 tables are not having primary keys on the tables, The tables which are not having primary key, i want to set up an snap shot replication, Tables with primary keys with transactional replication. can i have both transational as well as snap shot set up on the same server????
Thanks
hari
I have setup the snap shot replication on one table.It says the initial snap shot not yet available.What does it mean?How to activate the replication?
Thanks.
Hello there,
I need some urgent help on the Replication .....SQL 6.5, sce 5a, windows NT4.0
A Publication has been installed between 2 server (SQL 6.5, sce pack 5a).
The task Repl_Subs_Distribution fails with the following message:
"The last distributor job id and the last subscriber job id do not match. No jobs were available with a job id > 80"
1) with a Push Subscription, the error "no subscriber has been defined" came up, so I also did a pull subscritption for
the remote server = could it be the cause of the job id not matching?
2) although I found a document on a "sp_Mskill_job" replication stored procedure, it is not present in my DB and I cannot
use it. Is there a way to create it?
Thanks for your precious help.
Best regards,
Rachel
I was advised to Compair max job_id in MSsubscriber_status on distribution and MSlast_job_info on subscription and If not match,
to modify the id in MSlast_job_info.
There is no distribution server in this Replication....any other idea or possibility??
Hello Everybody ..
Greetings !!
I wanted information on Transactional Push replication between SQL Servers . I have one table on SQL Server 6.5 and there are certain text in the table with single quotes .
When i replicate this table to SQL Server 7.0 the text appears in double quotes on SQL Server 7.0 .
Can anyone help regarding this problem ? Has it something to do with version problem .? Where can i get more information on this issue ?
Many thanks . An early response will be highly appreciated .
Hello Mr. Paul...
Thank you so much for your prompt response . Is it possible to change the settings of the Quoted Identifiers ? How can we do it in SQL Server 6.5 and SQL Server 7.0 ? Do you have any info. on the same . ?
Thanks once again .
Yatin.
Hi Guys,
I have a database replicated to another database in a remote server.
We have a trigger in one of the tables in remote Database(replicated), which will fire as soon as there is an insert into this table. This trigger is maintaining the business logic. This trigger will insert the records into another table depending on what kind of information obtained from the new row(which was replicated).
Problem is, since we are using replication ( it uses bcp internaly), the trigger is not firing. I some how wanted to add these new records to the other table (automated). Can you guys please advice me on how to implement this.
I appreciate your help
Thanks,
Jeyam
Hi All,
I have been asked to take over the maintenance on dB servers that I have not originally 'set up'. The request came as a result of the database log files growing at such a rapid pace its taking up hard drive space. I ran sp_dboption and noticed that the log files are NOT set up to truncate on checkpoint. As in SQL 2000 I wanted to determine if the dB was set up in 'simple' or 'full' recovery mode. It appears they are set up in 'full' recovery mode (which we can modify, since this is not a transactional dB and we rarely if ever have to restore from the transaction log). Hence my question,
Is there anything I need to worry about (regarding replication)if I change the dboption to truncate on checkpoint and set dB in simple recovery mode?
And after I backup the transaction log and try to shrink it will that have any adverse affects? I feel like this is all I need to do but replication is new ground for me, any information regarding it would be greatly appreciated. Also, any advice on how to maintain the transaction logs would be helpful.
Christine
hi,
I want to setup transactional replication(PULL) between 2 servers .
can anyone guide me with the steps involved while performaing a Pull replication from server1 to server2.
Any help appreciated.
Hi,
I am setting up merge replication between 2 server located at different location on different Domain..Domins have a trusted connection .
When i run the merge agent i get the following error..in error detail.
Last action : - "xp_execresultset: unable to get a bound connection back to
server"
Last Call : - {call sp_MSmakearticleprocs (?, ?)}
Does any one have the idea
Thanks in Advance
Vik
HELP!!!
I need some urgent help. I'm managing merge replication between 12 servers. Today I had to make some changes in the database design, so I removed replication, altered the tables in question (on all servers)and created a new publication.
I choose the option that all subscribers have the data and the schema, but when I start the replication I get almost immediately an error "Invalid column name rowguidcol". But there is no column in my database with such a name. Further investigation brings up another message "xp_execresultset: unable to execute result set".
Can anyone please help me. The database should be ready by tomorrow.
TIA Markus
Hi,
Every one
I have added new column in my Publication - Article Table ,
Same column I have added in my Subscriber Table ,
I am doing Transaction replication , but now its giving me error
Insert Error - Column Name or Supplied Value doesn't Match,
If any one has any idea please suggest me
Thanks
Nirmal
Hi !!
We are using Ms SQLSERVER 6.5 on NT 4.0 service pack 3
I have joined in as a new DBA and don't know much about MS-SQLSERVER & it's replication.
What I have observed out here is that one of the databases was being replicated betnn Tokyo and
Kawasaki and suddenly after 22nd Feb stop replicatiing without giving any errors.
I have checked the max job_id in MSsubscriber_status on distribution database as well as max_job_id
in MSlast_job_info on subscription db.They seem to match.I have also tried to drop and recreate
the unique clustered index on the subscribing database.But nothing seems to work.
can anyone help me with this ?
Thanking in anticipation.
Regards,
Sapna
Hello there,
A Publication has been installed between 2 server (SQL 6.5, sce pack 5a).
The task Repl_Subs_Distribution fails with the following message:
"The last distributor job id and the last subscriber job id do not match. No jobs were available with a job id > 80"
1) with a Push Subscription, the error "no subscriber has been defined" came up, so I also did a pull subscritption for
the remote server = could it be the cause of the job id not matching?
2) although I found a document on a "sp_Mskill_job" replication stored procedure, it is not present in my DB and I cannot
use it. Is there a way to create it?
Thanks for your precious help.
Best regards,
Rachel
Hi, all..
I by mistake Overwrites distribution DB.
Server1 and Server2 replicates each other.
Applications are using Server1, and Server2 is back up purpose.
When server1 fails application redirected SErver2, using same data since there is replication.
Server2 had distribution DB.
Now there is no distribution DB.. it's messed up...
I want to restore replication between Server1 and Server2.
I tried to make replication from Server1, I got errors..
How can I do this???
By Accident One table got truncated on the subscriber which is one of the table in Published articles. Now all the Update inserts and delete are failing .
and other tables are not being replicated either. what could be done to fix this .
Publisher gets a lots of updates every hour how ever because of this problem all the tables are not getting any transactins replicated. Please help ASAP
I am trying to do transactional replication from 2000 to 2005 . But i am getting error" agent hasn't been registered .Run sql server setup program' while creating snapshot. It is production server. How do i make it work.I am doing pull subscription from 2005 server
View 1 Replies View Related