Tracking Forums, Newsgroups, Maling Lists
Home Scripts Tutorials Tracker Forums
  Advanced Search
  HOME    TRACKER    MS SQL Server






SuperbHosting.net & Arvixe.com have generously sponsored dedicated servers and web hosting to ensure a reliable and scalable dedicated hosting solution for BigResource.com.







The Snapshot For This Publication Has Become Obsolete !


Hi,

I am in need of some help with this error - I am seeing on my PDA units. Here is my scenario:

I have 5 PDA units that use merge replication with SQL 2005. These PDA units replicate fine. But when I try to sync a 6th or 7th PDA unit, I see the following error:

Source    : Microsoft SQL Server 2005 Mobile Edition - The snapshot for this publication has become obsolete. The snapshot agent needs to be run again before the subscription can be synchronized. -2147198698

I know that if I regenerate a new snapshot, I will be able to sync fine. But here are my concerns and questions:

What happens to the first 5 PDAs when I regenerate the a new snapshot.
Will they be able to sync without losing the data?
Does generating a new snapshot, relinitialize all the subscriptions?

Am I missing the whole picture with generating a new snapshot?

Thanks,

P

 


View Complete Forum Thread with Replies
Sponsored Links:

Related Messages:
Obsolete Snapshot
Hi everybody,

We have merge replication between two servers with Sql Server 2000 Service Pack 2, and the Merge agent display the follow message :

The snapshot for this publication has become obsolete. The snapshot agent needs to be run again before the subscription can be synchronized.

But i have changes at the suscriber, How can I do to Merge the last changes if the merge agentes is stopped.

I appreciate any help.

thanks

View Replies !   View Related
Snapshot Files Obsolete?
I recently had a problem with one of my publications that I haven't been able to figure out.  Hopefully someone can help me with it. 

 

I got this error last week:  You must rerun snapshot because current snapshot files are obsolete.  I assume this means the subscription needed to be re-initialized.  Is this correct?

 

If so, I don't understand why.   The publication was not changed.  The subscription did not expire.  The subscription was not marked for reinitialization.

 

Here are the specifics of my installation:

 

Merge publication with 1 pull subscription.

Subscriptions set to expire after 14 days.

Merge agent runs every day, every 5 minutes between 12:00:00A & 11:59:59P.

Snapshot agent was run once when publication was created and then disabled.

Publisher SQL ver: 2000 sp3

Publisher Win ver: 2003 sp1

Subscriber SQL ver: 2000 sp3

Subscriber Win ver: 2003 sp1

 

The subscription was successfully replicating every 5 minutes.  The data for 12:35 shows the first problem.  Here's the agent history at the time:

 










runstatus
start_time
comments
error_id

1
5/23/07 12:25
Initializing
0

3
5/23/07 12:25
Connecting to Publisher 'AASTAUSSQL01'
0

3
5/23/07 12:25
Uploaded 4 data changes (3 inserts, 1 updates, 0 deletes, 0 conflicts).
0

3
5/23/07 12:25
Downloaded 7 data changes (2 inserts, 5 updates, 0 deletes, 0 conflicts).
0

2
5/23/07 12:25
Merged 11 data changes (5 inserts, 6 updates, 0 deletes, 0 resolved conflicts).
0

1
5/23/07 12:30
Initializing
0

3
5/23/07 12:30
Connecting to Publisher 'AASTAUSSQL01'
0

3
5/23/07 12:30
Uploaded 4 data changes (3 inserts, 1 updates, 0 deletes, 0 conflicts).
0

3
5/23/07 12:30
Downloaded 20 data changes (14 inserts, 6 updates, 0 deletes, 0 conflicts).
0

2
5/23/07 12:30
Merged 24 data changes (17 inserts, 7 updates, 0 deletes, 0 resolved conflicts).
0

1
5/23/07 12:35
Initializing
0

3
5/23/07 12:35
Connecting to Publisher 'AASTAUSSQL01'
0

2
5/23/07 12:35
You must rerun snapshot because current snapshot files are obsolete.
2

1
5/23/07 12:40
Initializing
0

3
5/23/07 12:40
Connecting to Publisher 'AASTAUSSQL01'
0

2
5/23/07 12:40
You must rerun snapshot because current snapshot files are obsolete.
3

1
5/23/07 12:45
Initializing
0

3
5/23/07 12:45
Connecting to Publisher 'AASTAUSSQL01'
0

2
5/23/07 12:45
You must rerun snapshot because current snapshot files are obsolete.
4

 

Any help with this would be greatly appreciated.

 

Thanks!

View Replies !   View Related
The Initial Snapshot For Publication '' Is Not Yet Available.
I have a transaction replication on sql2005 sp2

pushing to 3 sql servers 1 sql2000 sp3a, 1 sp2000 sp4 and 1 sp2005 sp2

 

all the servers run fine except for the sql2000 sp4  which has

done this a least once a week,

The initial snapshot for publication 'nations' is not yet available.

 

 

The server that is having the issue has lots of locks

 

View Replies !   View Related
The Initial Snapshot For Publication 'Publicationxxx' Is Not Yet Available
When I am trying to synchronize my sql server ce database with sql server 2000, I am getting this error in the Replication Monitor and Synchronization gets fail.

How to Create initial snapshot or is there any step by step configuration document available for Merge Replication with SQL server 2000 and sql ce.

View Replies !   View Related
Merge Publication - Snapshot Agent Error - Help
Hi all,

 

I have a merge publisher with Snapshot agent for that scheduled to run everyday morning, This was runnning till yesterday. But it is not running today and giving the below error.

 

Can anyone help me out to solve this error? This is occuring in production environment, i really need a solution as fast as possible.

 
Error messages:
·          Message: Failed to read column data
Stack:    at Microsoft.SqlServer.Replication.Snapshot.SqlServer.NativeBcpOutProvider.ThrowNativeBcpOutException(CConnection* pNativeConnectionWrapper)
   at Microsoft.SqlServer.Replication.Snapshot.SqlServer.NativeBcpOutProvider.BcpOut(String strBcpObjectName, String strBcpObjectOwner, String strBaseBcpObjectName, Boolean fUnicodeConversion, String strDataFile, String strLoadOrderingHint, String strWhereClause)
   at Microsoft.SqlServer.Replication.Snapshot.SqlServer.NativeBcpOutProvider.BcpOut(String strBcpObjectName, String strBcpObjectOwner, String strBaseBcpObjectName, Boolean fUnicodeConversion, String strDataFile, String strLoadOrderingHint)
   at Microsoft.SqlServer.Replication.Snapshot.SqlServer.NativeBcpOutProvider.BcpOut(String strBcpObjectName, String strBcpObjectOwner, String strDataFile)
   at Microsoft.SqlServer.Replication.Snapshot.MergeContentsBcpOutWorkItem.DoWork(MergeSnapshotProvider snapshotProvider, IBcpOutProvider bcpOutProvider)
   at Microsoft.SqlServer.Replication.Snapshot.MergeContentsBcpOutThreadProvider.DoWork(WorkItem workItem)
   at Microsoft.SqlServer.Replication.WorkerThread.NonExceptionBasedAgentThreadProc()
   at Microsoft.SqlServer.Replication.WorkerThread.AgentThreadProc()
   at Microsoft.SqlServer.Replication.AgentCore.BaseAgentThread.AgentThreadProcWrapper() (Source: MSSQLServer, Error number: 0)
Get help: http://help/0
·          Message: Shared Memory Provider: No process is on the other end of the pipe.
Stack:  (Source: MSSQLServer, Error number: 233)
Get help: http://help/233
·          Message: Communication link failure
Stack:  (Source: MSSQLServer, Error number: 233)
Get help: http://help/233
·          Message: Shared Memory Provider: No process is on the other end of the pipe.
Stack:  (Source: MSSQLServer, Error number: 233)
Get help: http://help/233
Message: Communication link failure
Stack:  (Source: MSSQLServer, Error number: 233)

 

Thanks,

Thams

View Replies !   View Related
Trouble Getting Snapshot Agent To Initialize Publication
I have been trying to set up transactional replication between an OLTP SQL Server 2005 Standard edition server and a BI SQL Server 2005 Enterprise edition server. I am using a pull subscription. I was able to establish the replication from the developement server to the BI server however when I tried setting up the replication between the production environment and the BI server, using the same configuration settings, I ran into a problem. The production server had been renamed after it was initially set up. I used the sp_dropserver and sp_addserver to solve this issue and was able to run the replication wizard. However once the wizard finishes the snapshot agent doesn't initialize the publication. When I look at the replication monitor it has a status of "never run". I try to run it manually and it appears to run for a few seconds then stops and still has the status of "never run". I don't get any error messages and can't find anything in the log. I am wondering if this is related to the server rename? I am hoping to find a soultion that doesn't involve uninstalling SQL Server and reinstalling since this is a production environment.

Thanks.

View Replies !   View Related
Problem After Applying Snapshot Publication To Subscriber
Hello all,

I have a unusual problem with a snapshot publication that I am having a hard time troubleshooting. The servers in question are all SQL 05 Enterprise. Here is the scenario:

Staging Server - This server acts as the publisher of the snapshot
Production Server - This server is the subscriber of the staging snapshot
Cascade Servers - These servers receive transactional updates from the production server

The staging server applies the snapshot to production successfully. From there the production server has a transactional publication which the subscribers are the cascade servers.

This model worked for a long time where we would generate the snapshot apply it to production and the updates would be sent to the cascade servers. All of a sudden there is a problem with the transactional publication from production -> cascade. There are 7-10 tables that do not receive the updates and all data in the problematic tables is truncated. The other remaining tables in the subscription receive the updates as needed. Looking at replication monitor and all other logs shows that the transactions are being replicated, but yet the 7-10 problematic tables do not contain any data. The only solution I have found for this is to recreate the entire replication model from scratch.

Any advice on how to handle this scenario? Is my model for using a transactional publication to cascade changes to a subset of servers incorrect?

 

View Replies !   View Related
Snapshot Agent Fails For Merge Replication Publication
I'm trying to setup merge replication and get the following error from the snapshot agent after I've finished the 'New Publication Wizard'. This doesn't make sense to me as it is an automatic process. Also, it looks like it is complaining about a 'dbo.MSmerge_cont...' view which is a view created automatically for the merge publication.

 ERROR MESSAGE:
The identifier that starts with '<EVENT_INSTANCE><EventType>CREATE_VIEW</EventType><PostTime>2006-11-09T09:56:48.390</PostTime><SPID>152</SPID><ServerName>XF4SWC' is too long. Maximum length is 128.

FULL DETAILS:
Message: The identifier that starts with '<EVENT_INSTANCE><EventType>CREATE_VIEW</EventType><PostTime>2006-11-09T09:56:48.390</PostTime><SPID>152</SPID><ServerName>XF4SWC' is too long. Maximum length is 128.
Command Text: IF OBJECT_ID(N'[<EVENT_INSTANCE><EventType>CREATE_VIEW</EventType><PostTime>2006-11-09T09:56:48.390</PostTime><SPID>152</SPID><ServerName>XF4SWCS464</ServerName><LoginName>NT AUTHORITYSYSTEM</LoginName><UserName>dbo</UserName><DatabaseName>liport2_gts</DatabaseName><SchemaName>dbo</SchemaName><ObjectName>MSmerge_contAE2EB588ABFA4C13825D4D44CB2D50CB_90</ObjectName><ObjectType>VIEW</ObjectType><TSQLCommand><SetOptions ANSI_NULLS="OFF" ANSI_NULL_DEFAULT="ON" ANSI_PADDING="ON" QUOTED_IDENTIFIER="ON" ENCRYPTED="FALSE" /><CommandText>create view dbo.MSmerge_contAE2EB588ABFA4C13825D4D44CB2D50CB_90 as select * from MSmerge_contents where 1 = 2</CommandText></TSQLCommand></EVENT_INSTANCE>]', 'V') IS NOT NULL DROP VIEW [<EVENT_INSTANCE><EventType>CREATE_VIEW</EventType><PostTime>2006-11-09T09:56:48.390</PostTime><SPID>152</SPID><ServerName>XF4SWCS464</ServerName><LoginName>NT AUTHORITYSYSTEM</LoginName><UserName>dbo</UserName><DatabaseName>liport2_gts</DatabaseName><SchemaName>dbo</SchemaName><ObjectName>MSmerge_contAE2EB588ABFA4C13825D4D44CB2D50CB_90</ObjectName><ObjectType>VIEW</ObjectType><TSQLCommand><SetOptions ANSI_NULLS="OFF" ANSI_NULL_DEFAULT="ON" ANSI_PADDING="ON" QUOTED_IDENTIFIER="ON" ENCRYPTED="FALSE" /><CommandText>create view dbo.MSmerge_contAE2EB588ABFA4C13825D4D44CB2D50CB_90 as select * from MSmerge_contents where 1 = 2</CommandText></TSQLCommand></EVENT_INSTANCE>]
Parameters:
Stack:    at Microsoft.SqlServer.Replication.AgentCore.ReMapSqlException(SqlException e, SqlCommand command)
   at Microsoft.SqlServer.Replication.AgentCore.AgentExecuteNonQuery(SqlCommand command, Int32 queryTimeout)
   at Microsoft.SqlServer.Replication.AgentCore.ExecuteDiscardResults(CommandSetupDelegate commandSetupDelegate, Int32 queryTimeout)
   at Microsoft.SqlServer.Replication.AgentCore.ExecuteAdHocQueryDiscardResults(String strQuery, SqlConnection connection)
   at Microsoft.SqlServer.Replication.Snapshot.MergeSnapshotProvider.GenerateSystemTableBcpFiles()
   at Microsoft.SqlServer.Replication.Snapshot.MergeSnapshotProvider.DoPostArticleFilesGenerationProcessing()
   at Microsoft.SqlServer.Replication.Snapshot.SqlServerSnapshotProvider.GenerateSnapshot()
   at Microsoft.SqlServer.Replication.SnapshotGenerationAgent.InternalRun()
   at Microsoft.SqlServer.Replication.AgentCore.Run() (Source: MSSQLServer, Error number: 103)
Get help: http://help/103
Server XF4SWCS464, Level 15, State 4, Procedure , Line 1
The identifier that starts with '<EVENT_INSTANCE><EventType>CREATE_VIEW</EventType><PostTime>2006-11-09T09:56:48.390</PostTime><SPID>152</SPID><ServerName>XF4SWC' is too long. Maximum length is 128. (Source: MSSQLServer, Error number: 103)
Get help: http://help/103

View Replies !   View Related
Snapshot Share Access Problems After Publication And Web Sync Wizard
Hi

I've big problems with my SQL Server 2005 Std. merge replication/snapshot share

I want to create a mobile application based on a ms sql 2005 mobile database running on a pocketpc 2003se.

for this task i installed iis, sql server 2005 std. and the sql server mobile tools.

i created a dedicated user for making snapshots in the new created and functionable publication, but when i start the web sync wizard, i alwas get the failurmessages

snapshot share "......" cannot be accessed, please specify a new share

the access permissions based on the share an based on the ntfs area are set right.

the user, i chose for the anonymus access (the same, as for creating snapshots), has enough rights on the folder. also when creating a new share, with different share name, and using another user for anonymus access (standard iusr_machine_name) i get the same message

 

do you have any suggestions for my problem??

 

please i need help as soon as possible

best regards

View Replies !   View Related
Unable To Re-create Snapshot Of Existing Publication Due To Missing Publisher's Identity Range Allocation Entry
I re-created a publication that was having problems and it gives this error when I start the snapshot agent from SQL Server Management Studio:  I am stuck on how to resolve - any ideas?

"The publisher's identity range allocation entry could not be found in MSmerge_identity_range table.  Transaction count after EXECUTE indicates that a commit or ROLLBACK TRANSACTION statement is missing.  Previous Count = 1, current count = 2."

select * from MSmerge_identity_range returns 19 entries but I don't know how to fix. 

I have tried deleting and re-creating but always get this error.

My other publications and subscriptions are working fine and I was able to create a new test publication that worked but can not get this one to work that worked fine up until today. 

 Any ideas?

 

View Replies !   View Related
This Publication Differs From The Publication To Which The Subscription Was Initially Created
I'm getting this error on the subsciber, what is correct,
because I removed the publication and recreated it.

But I wan't to catch this speccific error, so I can recreate the local subscription.

How should I do that?

Complete error:
-        ex    {"This publication differs from the publication to which the subscription was initially created. The original publication may have been deleted and replaced with a new publication with the same name. At the subscriber, delete the subscription and recreate it for the new publication. "}    Microsoft.SqlServer.Replication.ComErrorException

Some more info:
C# 2.0
And I'm doing Web Sync Pul subscription with
Microsoft.SqlServer.Replication;
Microsoft.SqlServer.Management.Common;

View Replies !   View Related
Obsolete Objects
 

Hello,
 
I need to find all of the SQL Server objects, (tables, procs, functions, etc.) that my application is NOT using, so they can be removed from the system. Does anyone know how to accomplish this?
 
Thank you,
 
Dave

View Replies !   View Related
SQLmaint Obsolete In SQL2005!?!
:mad: It seems that the SQLmaint is going to obsolete in SQL 2005, what happen to my "sophisticated" SQLmaint scripts!!!! Any help or comment?

View Replies !   View Related
Warning: Obsolete Page
Has anyone see this message before

Warning: Obsolete page _____, dbid _ found in page cache.

If so, what is it, and how does it happen, and how can I stop it from happening.

Thanks,

Doug

View Replies !   View Related
Obsolete Table Columns
When I find that a column should no longer be used because of design changes. ( Moved column to other table to correct design normalization etc.)

I added a check to make sure the column must be NULL.

The following list the obsolete columns

SELECT col.TABLE_NAME + '.' + col.COLUMN_NAME AS FULL_COLUMN_NAME
FROM INFORMATION_SCHEMA.COLUMNS col
JOIN INFORMATION_SCHEMA.CONSTRAINT_COLUMN_USAGE ccu
ON col.COLUMN_NAME = ccu.COLUMN_NAME AND col.TABLE_SCHEMA = ccu.TABLE_SCHEMA AND col.TABLE_NAME = ccu.TABLE_NAME
JOIN INFORMATION_SCHEMA.CHECK_CONSTRAINTS cc
ON ccu.CONSTRAINT_SCHEMA = cc.CONSTRAINT_SCHEMA AND ccu.CONSTRAINT_NAME = cc.CONSTRAINT_NAME
WHERE IS_NULLABLE = 'YES' AND cc.CHECK_CLAUSE = '([' + col.COLUMN_NAME + '] IS NULL)'
ORDER BY col.TABLE_NAME, col.COLUMN_NAME


In the past columns could not be set to null.
This script list those columns that I need to add null checks to.

SELECT col.TABLE_NAME + '.' + col.COLUMN_NAME AS FULL_COLUMN_NAME, cc.CHECK_CLAUSE
FROM INFORMATION_SCHEMA.COLUMNS col
JOIN INFORMATION_SCHEMA.CONSTRAINT_COLUMN_USAGE ccu
ON col.COLUMN_NAME = ccu.COLUMN_NAME AND col.TABLE_SCHEMA = ccu.TABLE_SCHEMA AND col.TABLE_NAME = ccu.TABLE_NAME
JOIN INFORMATION_SCHEMA.CHECK_CONSTRAINTS cc
ON ccu.CONSTRAINT_SCHEMA = cc.CONSTRAINT_SCHEMA AND ccu.CONSTRAINT_NAME = cc.CONSTRAINT_NAME
WHERE cc.CHECK_CLAUSE LIKE '([[]' + col.COLUMN_NAME + '] =%' AND
NOT cc.CHECK_CLAUSE LIKE '% OR %' AND
NOT cc.CHECK_CLAUSE LIKE '% AND %' AND
NOT cc.CHECK_CLAUSE LIKE '% IS %' AND
NOT cc.CHECK_CLAUSE LIKE '% IN %'
ORDER BY col.TABLE_NAME, col.COLUMN_NAME


Tim S

View Replies !   View Related
Can Not Delet A Publication In SQL Server 2005: The Publication Does Not Exist [SQL Server Error: 20026]
Hi, everyone,
I am new in SQL server 2005. I had setup SQL server 2005 P2P replication. Somehow it did not work one of two way replication. I tried to delete the publication. However I could not do it. have the same problem. When I tried to delete the publication, I got the publication " " does not exist.[SQL server error: 20026]. I tried to use sp_droppublication, it gave me error "the database is not enabled for publication". Nevertheless, I can see the publication in MS SQL Management Studio and Publication monitor with OK status. I could not find the distribution database either.
 
Could you anyone has ideas to delete this publication? I am sorry I am not a programmer. Please give me more detail explanation if you can. Thanks.
 

View Replies !   View Related
User Defined Function Obsolete
Hi,


sometimes after modifying a UDF (for example adding a column to the output) the statements refer it raise an error like the function has never been modifying , than in the previous example sql server doesn't find the last added column.

If I reapply the "alter" statement script of the function all works fine.It seams there is a sort of internal cache that need to be updated ...

Nobody have never been founding a similar behavior? :confused:


Thx

View Replies !   View Related
Cube Has Been Updated By The Server, Data Is Now Obsolete
Client issues query which sends out individual requests to the 2 OLAP servers that are load balanced. The client evaluates the versions of the returned record sets to ensure the consist data being returned for one single query. Otherwise, this error will be seen:

The cube has been updated by the server the data is now obsolete.

These servers sit behind a cisco 11506 CSS with load balancing based on balance type: least busy server, also persistence based on cookies.

My developer says this worked fine for a long time then just 'started happening'.

any suggestions are appreciated.

View Replies !   View Related
Problem When Applying A Snapshot When Tables Have Been Updated During Snapshot Generation
Hi

   I seem to have a strange problem when applying a snapshot when the tables in the publication have been updated while the snapshot was being generated.

 

  Say for example there is a table called RMAReplacedItem in the publication. When the snapshot starts being applied to the subscriber, a stored procedure called sp_MSins_RMAReplacedItem_msrepl_css gets created that handles an insert if the row already exists (ie it updates the row rather than inserting it). However, after all the data has been loaded into the tables, instead of calling this procedure, it tries to call one called sp_MSins_RMAReplacedIte_msrepl_cssm - it takes the last letter of the table name and adds it to the end of the procedure name.

 

   The worst part is that this causes the application of the snapshot to fail, but it doesnt report what the error is, and instead it just tries applying the snapshot again. The only way i have managed to find which call is failing is to run profiler against the subscriber while the snapshot is being applied and see what errors.

 

   I have run sp_broswereplcmds and the data in there is what is applied to the subscriber - ie the wrong procedure name.

 

   All the servers involved are running sql 2005 service pack 2. The publisher and subscriber were both upgraded from sql 2000, but the distribution server is a fresh install of sql 2005.

View Replies !   View Related
Cannot Add Publication
Hi!

I have a strange error, when I try to create publication

Msg 3933, Level 16, State 1, Procedure sp_MSrepl_addpublication, Line 1222
Cannot promote the transaction to a distributed transaction because there is an active save point in this transaction.

What is it?

P. S. The error arise with all types of replication.

View Replies !   View Related
Publication
I have a publication on my SQL Server.

The first time my application syncs with the server it works fine.

If I try to sync again I get "Permission Denied  Number 80040E09 NativeErr: 0"

Other publications work fine, it just seems to be this one.

Any ideas?

 

View Replies !   View Related
Is DB Publication/subscription?
Because of problems trying to alter databases used
for replication my software would need to find out
if a database is a publisher or was repliated (using
T-SQL). Is this possible?

View Replies !   View Related
How To Add New Article To Publication?
Hi,
I'm use MSSQL2000 SP3 with replication.
I want to know that Can i add new article to existing publication by
Enterprice Manager ?

someone told me that we can do that in older version but not now,right? :confused:

View Replies !   View Related
Add A Table To A Publication
Hi,

Here is my Q: I already put in place a transactional replication, the subscribers are already in sync, but now a few more tables have been added to the published DB. I've managed to add the articles using sp_addarticle and sp_addsubscription, but the problem now is that I don't want to generate a full snapshot (published db has 100 GB and it takes a few hours to complete) but only the part corresponding to those I added lately...is thhat possible?
How SQL 2000 generates the .sch .idx and .bcp. files from the snapshot folder?

TIA,

S.

View Replies !   View Related
Publication Tables
Hello everyone,
Having a problem here that I hope someone can help with.

I am replicating a couple of databases to a remote MS SQL Server (6.5) from a MS SQL Server (6.5)
and need to replicate parts of the same two databases back here. I have installed publishing on both
machines and have the replication working fine to the remote site. The problem is that when I go
setup the publications no tables are listed in the "Articles for publication" area under "Database
tables." I am aware that you need primary keys w/unique values for a table to show up. I have
checked that and all the tables meet that requirement. Also of note, other databases on the same
remote server show their tables perfectly fine if I try to set up articles for them the only difference
seems to be that these other databases aren`t subscribing to any articals from any other servers.
I have tried removing the subscription to the tables in question and they still do not show up.
Any help / insight would be greatly appreciated.

Thanks
Levi Akers

View Replies !   View Related
Resetting Up A Publication
I ran through the wizard to get rid of a publication so I can redo it. When I run through the wizard to create the same publication, I receive the following error:

Could not create publication 'db1' on 'db1'
Error 14294 Supply either @job_id or @job_name to identify the job

and it won't let me create the publication. Can anyone help?

Alan

View Replies !   View Related
Modify Publication In SQL 7.0 . Please Help !!
Hello ,

I have a problem with a publication which is a transactional replication on SQL Server 7.0 .
I want to add stored procedure to the existing publication along with the tables . But the Enterprise manager does not allow to select or check the box
against the required stored procedure although it displays when i right click on the publication and select proeprties .

Can i have some help in this regard ? Does anybody knows to add a stored procedure by means of a query .

Is there any other way to modify publication in SQL Server 7.0 although it is possible in SQL Server 2000 .?

Many thanks in advance.
Sandra .

View Replies !   View Related
Error In Publication
I am trying to set up a replication scheme that can be scripted.
But, when I try to add the publication to the database, I get an error that says
"Supply either @job_id or @job_name to identify the job".

What's is the problem????

I'm hoping someone out there has already gotten past this roadblock and can offer
some help.

Thanks in advance...

View Replies !   View Related
Can Not Able To Create Publication
Hi guys.



i had configured a merge replication betwen 2 server and i was running fine. but due to network problems my network admin has changed the ip address and name of the publisher, distributor and subscriber.



what i did. i just drop the publication and now i m trying to create a new one. but i cannt' able to create. i dont' know y.. this is the error i m facing..



Msg 208, Level 16, State 1, Procedure sp_addmergepublication, Line 239

Invalid object name 'dbo.sysmergepublications'.

Msg 21040, Level 11, State 1, Procedure sp_MSaddmergepub_snapshot, Line 65

Publication 'DIS_MASTER_Merge' does not exist.

Msg 20026, Level 16, State 1, Procedure sp_grant_publication_access, Line 176

The publication 'DIS_MASTER_Merge' does not exist.

Msg 20026, Level 16, State 1, Procedure sp_grant_publication_access, Line 176

The publication 'DIS_MASTER_Merge' does not exist.

Msg 20026, Level 16, State 1, Procedure sp_grant_publication_access, Line 176

The publication 'DIS_MASTER_Merge' does not exist.

Msg 20026, Level 16, State 1, Procedure sp_grant_publication_access, Line 176

The publication 'DIS_MASTER_Merge' does not exist.

Msg 20026, Level 16, State 1, Procedure sp_grant_publication_access, Line 176

The publication 'DIS_MASTER_Merge' does not exist.

Msg 208, Level 16, State 1, Procedure sp_changemergepublication, Line 205

Invalid object name 'dbo.sysmergepublications'.

View Replies !   View Related
Can't Create New Publication
When go to set up a new publication I get the below error:


TITLE: New Publication Wizard
------------------------------

SQL Server is unable to connect to server 'LEICS-DC1'.

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.2050.00&EvtSrc=Microsoft.SqlServer.Management.UI.PubWizardErrorSR&EvtID=CantConnect&LinkId=20476

------------------------------
ADDITIONAL INFORMATION:

SQL Server replication requires the actual server name to make a connection to the server. Connections through a server alias, IP address, or any other alternate name are not supported. Specify the actual server name, ''. (Replication.Utilities)

------------------------------
BUTTONS:

OK
------------------------------

I am specfing the server name but it still brings back the same error, the message at the bottom also stats to try and connect to '' which of course is impossible.
This is a domain controller if that makes any difference, SQL 2005 SP2, Win 2003 STD.

Thanks

View Replies !   View Related
Creating A Publication
Hi,
I've come across this one before in one of the threads, unfortunately for me the author managed to figure it out for his/her self and there for no answer was posted, so can anybody help PLEASE???
 
Creating Publication

- Creating Publication 'SQLMobile' (Error)
Messages
* SQL Server could not create publication 'SQLMobile'. (New Publication Wizard)

------------------------------
ADDITIONAL INFORMATION:

An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)

------------------------------

Invalid object name 'dbo.sysmergepublications'.
Publication 'SQLMobile' does not exist.
Changed database context to 'SQLMobile'. (Microsoft SQL Server, Error: 208)

 
Its been created via UI
on SQL2005
the distributor is correctly installed
i also have not tried creating a publication on any other database.....this is the first.
 
Any Ideas?
 

View Replies !   View Related
Unable To Add New Publication
I have been wrestling with this one all day and cannot find anything on MSDN, google, etc.... I have configured replication, but cannot create a new publication either programmatically or using the wizard.
I programmatically did the following:
1.  I set up my local server as a distributor, and created a distribution database  (@distributor set to server sysname)
execute sp_adddistributor @distributor = @distributor
execute sp_adddistributiondb @database = @distributionDB,  @security_mode=1;
2. I registered my local server also as a Publisher (@publisher set to server sysname, @distribution = 'distributor')
SELECT @sql = 'sp_adddistpublisher @publisher = ''' + @publisher +
''', @distribution_db = ''' + @distributionDB +
''', @working_directory = ''' + @directory + ''', @security_mode = 1'
SELECT @sp_executesql = quotename(@distributionDB) + '..sp_executesql '
EXEC @sp_executesql @sql
3. I enabled my local database for transactional replication (@replicationDB)
exec sp_replicationdboption
@dbname = @replicationDB,
@optname = 'publish', @value = 'true
4. I added a logReaderAgent on the ReplicationDB
SELECT @sql = 'sp_addlogreader_agent @publisher_security_mode = 1'
SELECT @sp_executesql = quotename(@replicationDB) + '..sp_executesql
EXEC @sp_executesql @sql

All is well up to this point, no problems, all looks great.  When I check the status of things using sp_help repl stored procedures to check on publisher, distributor all looks healthy.  Also looks good when I use the SSMS replication interface to check on distributor, publisher, etc. . HOWEVER...... I cannot create any publications.

I tried programmatically, and also by using the wizard. 
I keep getting the same error :'Cannot insert the value NULL into column 'pubid', table'.
This is the sql I try to run:
EXEC sp_addpublication
@publication = 'test3333',
@status = N'active',
@allow_push = N'true',
@allow_pull = N'true'
This is the error:
Msg 515, Level 16, State 2, Procedure sp_MSrepl_addpublication, Line 1320
Cannot insert the value NULL into column 'pubid', table 'CypressMaster.dbo.IHpublications'; column does not allow nulls. INSERT fails.
The statement has been terminated.
Msg 14018, Level 16, State 1, Procedure sp_MSrepl_addpublication, Line 1348
Could not create the publication.
If I use the wizard instead of trying to create the publication programmatically, I get this error (just about the same content, but a little different wording):
Creating Publication
- Creating Publication 'NewPublication' (Error)
        Messages
        * SQL Server could not create publication 'NewPublication'. (New Publication Wizard)
       
        ------------------------------
        ADDITIONAL INFORMATION:
       
        An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)
       
        ------------------------------
       
        Cannot insert the value NULL into column 'pubid', table 'CypressMaster.dbo.IHpublications'; column does not allow nulls. INSERT fails.

        Could not create the publication.
        Object 'NewPublication' does not exist or is not a valid object for this operation.
        Changed database context to 'CypressMaster'.
        The statement has been terminated. (Microsoft SQL Server, Error: 515)
       
        For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.1399&EvtSrc=MSSQLServer&EvtID=515&LinkId=20476

       

- Adding articles (Stopped)

- Starting the Snapshot Agent (Stopped)

- Generating a script file (Stopped)

View Replies !   View Related
Creating A Publication
hi
I was following the walkthrough "Creating a Mobile Application with SQL Server Mobile" and when I got to the point where you create a "local publication" I couldn't find the link "Local Publication" in my Object Explorer.

I read all the help in books online however id did not tell me how to bring that link there.

I did install the replication component using the CD installation. I have SQL Server 2005 Standard Edition and Visual Studio 2005


I also found the help "Using the Publication Wizard to Create a Publication" but did not know where to locate or start the wizard.

any help will be appreciated.

View Replies !   View Related
Calling A Transactional Publication
Hello,
I need to call a transactional Publication build in sql server 2000 from my c#.net 1.0 code and pass to it a parameter to filter the result accordingly.
Regards

View Replies !   View Related
Problem Deleting Publication
Hi All,I have a problem, a user deleted some tables from a couple db's dealingwith replication. I now get this error on those db's.The process could not execute 'sp_repldone/sp_replcounters onservernameI have deleted one of the database's and neither are listed underpublications but they still show up under replication monitor.Any ideas on how to delete them would be great. When I try I getError 208: Invalid object name 'sysarticles'Invalid object name 'sysschemaarticles'Could not use view or function 'sysextendedarticlesview' because ofbinding errors.TIADave

View Replies !   View Related
How To Reboot A Publication Server ?
We have to add some hardware and I was wondering if someone could provide a stepwise tip to do it .

It is a 3 Server Environment Pub/Dist/Sub
All three running under SQL2K
Here is what I am planning.

a. Uncheck the Enable in Distributed Agent for each replication
b. Wait for all replications to complete
c. Shut down Publisher ? Or do I have to do something else before that.

Please explain a little .

Thanks

View Replies !   View Related
Problem Of Creating Publication
I created the publisher and distributor on the same instance of MS SQL SERVER on same machine and then tried to create a publication using wizard for a database on this machine. After finishing the last step, come the error, it displayed:
SQL Server Enterpise Manager could not create article 'authors' based on object 'authors'.
Do you want to continue saving other changes to the publication?
Error 50007:xp_execresultset: unable to get a bound connection back to server

Anyone has an ideal of this problem? I will greatly appreciate you help.

View Replies !   View Related
Problems With Mergre Publication.
Hi, i have configured a merge publication with two push subscription. Yesterday I try to delete the subscriptions and publication and i get this error:

error: 207 invalid column name 'enableid_for_syncmgr'.

After that, I try to disable the merge publishing in the database in enterprise manager that has the publication, and it displays the same error.

Today I found that the database is not allowed to merge publication and the snapshot and subscriptions are failed displaying this errors:

The snapshot agent:
The 'dbname' database is not published for merge replication.
(Source: dbname (SQL-DMO); Error number: 21147)

The subscriptions:
Publication 'publicationname' does not exist.
(Source: Merge Replication Provider (Agent); Error number: -2147201022)
---------------------------------------------------------------------------------------------------------------
The publication 'publicationname' does not exist.
(Source: servername (Data source); Error number: 20026)
---------------------------------------------------------------------------------------------------------------

If I try to delete the publication today it displays this error:

Error: 21776. The name 'publicationname' was not found in the mergepublications collation...

I need to delete this publication because I will not use it any more. No body could make some changes just me.

I'll appreciate a lot for your help.

Thanks a lot.

View Replies !   View Related
Disabling Publication Using SQL DMO. URGENT!!!!!!!!
Hi,
I'm using DMO (SQLOLE65.dll) to programmatically replicate selected publications. The Publication object supports a property called Enabled, which can be set to FALSE. I'm setting the enabled property to TRUE for those publications that need be replicated, and make the others FALSE. Still, all publications get replicated. [I give DoAlter to commit the changes i made.]
Any solution,Please mail me ASAP to venkateswaranb@synectics.soft.net

Thanks,
Venkat

View Replies !   View Related
Disabling Publication Programmatically
Hi,
I'm using Sql server6.5, SQL DMO and Visual Basic 5.0 to programmtically achieve replication. My requirement is:
- My program will display a list of Publications available in the Publishing
Server.
- The user will select only those publications which he wants to replicate at
that point in time.[For example, out of 10 publications available, the user
selects only 3 to be replicated in the afternoon. In the evening, he may
select some other publications for replication].Which means, at a later
point in time, he may select the other publications for replications.
- So, all publications will be configred in Sql Server at any given point in
time.
- All i want to say is that the replication is done on demand.
- This being the case, i want to DISABLE all the publications that need not
be replicated. The Publication object supports a property called Enable,
which can be set to False. But, even after setting the property to FALSE,
all publications get replicated.

Any idea as to why this is happening?? U may also mail that the solution to venkateswaranb@synectics.soft.net

Thanks in advance,

Venkat

View Replies !   View Related
Pull Subscription And Publication
Hello there,
I am trying to create a pull (anonymous) subscription and a publication in the same database. According to the manual available from SQL Server, it says it can be done. However, I am unable to do it through stored proc as well as through Enterprise Manager. Any ideas, how to go about doing it ?

Thanks for your answer in advance.

View Replies !   View Related
How To Add A Table To An Existing Publication?
Hi,
I would like to know the procedure to be followed to add a table to the existing publication. The subcriber doesn't have the object yet. I have data in the source table and I want to add this table in a existing publication for transactional replication. Any advise is appreciated.

Thanks,
Ravi

View Replies !   View Related
Msg 14013, Not Enabled For Publication.....
Hi,
I tried to run the following script from SQL2005 server A (publisher) from Database 'TestDB' to SQL2005 server B
(subscriber) database 'TestDB'
-------------------------------------------
exec sp_addsubscription @publication = N'publish_TestDB_FromCA', @subscriber = N'subscriberTest', @destination_db = N'TestDB', @subscription_type = N'Push', @sync_type = N'automatic', @article = N'all',
@update_mode = N'read only', @subscriber_type = 0

with following error:

Msg 14013, Level 16, State 1, Procedure sp_MSrepl_addsubscription, Line 252
This database is not enabled for publication.

Any idea?
Thanks
David

View Replies !   View Related
Publication Cannot Drop Table.
We have a publication from database a to database b. Database a containts table1 to be published to databasae b. Database b contains a publication of table1 to database c. When we go to rerun the publication from database a it errors saying cannot drop table1 since it is part of database b's publication. how do you do this.

Thanks in Advance,
Phillip M. Triocli

View Replies !   View Related
Merge Publication Error
Hi,
I disabled a merge publication on my server. I then ran sp_removedbreplication to clean the system tables. Thats fine. When I recreate a new publication on my server now, I still get the red x on my publisher node in my replcation monitor from the error I was getting before. Evenm though this publication is error free. Is it saving an srror flag in one of the sytem tabbles

Any ideas on this?
Thanks

View Replies !   View Related
Replication Publication Error
I am trying to create a Publication on a database for replication and all goeas well until the ;ast phase of the wizard where I get the following error :-

"SQL Server Enterprise Manager could not create the publication.
Error 14294: Supply either the @job_id or the @job_name to identify the job."

Can anyone tell me what i`ve done wrong ?. Thanks.

View Replies !   View Related
Modifying Publication In SQL 7.0- Urgent Help .
Hello ,

I want to drop a table from a publication , so that i can copy some data from another server . After the copy , i want to add the article or the table back again to the publication without making any changes to the subscribers configuration .

Is it really possible on SQL 7.0 ? Right now it does not allow me to copy the data to the published table or even drop the article (table) and it says that the article is published for replication and cannot be dropped or modified .
The table is configured for transactional replication .

I will have to drop the entire publication and create all the subcribers again .

Any help in this regard please .
Sameer

View Replies !   View Related
How Do You Add A Table To A Pre-exisiting Publication?
Hi All,

I am a newbie to MSSQL and I am trying to figure out something that should be easy, but I am missing something.

If you already have replication set up, how do you add a table to a pre-exisiting publication?

Your answers and help are very much appreciated.

Thank you!

View Replies !   View Related
Deleting Publication With No Agents Available
I have a case of SQL Server 2005 production db's publication which does not have either Log reader, snapshot or distribution agents.
I need to modify primary key in one of the tables, and existing publication does not allow this.
When I try to start snapshot job in GUI I am getting of course error:
"Could not find the regular snapshot job for the spicified publication. Supply either @job_id or @job_name to identify the job, error 20678."

Is there any way to erase it with system st procs or SQL?
Help is greatly appreciated.

View Replies !   View Related

Copyright © 2005-08 www.BigResource.com, All rights reserved