The Snapshot For This Publication Has Become Obsolete !

Nov 21, 2006

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 4 Replies


ADVERTISEMENT

Obsolete Snapshot

Oct 17, 2002

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 1 Replies View Related

Snapshot Files Obsolete?

Jun 1, 2007

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 11 Replies View Related

The Initial Snapshot For Publication 'Publicationxxx' Is Not Yet Available

Feb 14, 2007

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 9 Replies View Related

Problem After Applying Snapshot Publication To Subscriber

Jul 13, 2006

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 1 Replies View Related

Trouble Getting Snapshot Agent To Initialize Publication

Nov 16, 2006

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 3 Replies View Related

Merge Publication - Snapshot Agent Error - Help

Apr 19, 2007

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 16 Replies View Related

Snapshot Agent Fails For Merge Replication Publication

Nov 9, 2006

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 3 Replies View Related

Snapshot Share Access Problems After Publication And Web Sync Wizard

Feb 6, 2006

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 6 Replies View Related

Unable To Re-create Snapshot Of Existing Publication Due To Missing Publisher's Identity Range Allocation Entry

Jul 21, 2006

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 2 Replies View Related

Obsolete Objects

Apr 23, 2008



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 2 Replies View Related

SQLmaint Obsolete In SQL2005!?!

Jan 7, 2005

: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 8 Replies View Related

Obsolete Table Columns

Feb 4, 2005

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 2 Replies View Related

Cube Has Been Updated By The Server, Data Is Now Obsolete

Mar 22, 2004

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 2 Replies View Related

Can Not Delet A Publication In SQL Server 2005: The Publication Does Not Exist [SQL Server Error: 20026]

Sep 21, 2007

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 6 Replies View Related

Problem When Applying A Snapshot When Tables Have Been Updated During Snapshot Generation

Jun 20, 2007

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 1 Replies View Related

Publication

Jun 20, 2006

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 5 Replies View Related

Cannot Add Publication

Oct 30, 2006

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 6 Replies View Related

Modify Publication In SQL 7.0 . Please Help !!

May 14, 2002

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 1 Replies View Related

Is DB Publication/subscription?

Jul 26, 2004

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 1 Replies View Related

How To Add New Article To Publication?

Dec 23, 2004

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 1 Replies View Related

Can Not Able To Create Publication

Feb 28, 2008

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 1 Replies View Related

Unable To Add New Publication

Jun 2, 2006

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 4 Replies View Related

Creating A Publication

May 22, 2006

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 4 Replies View Related

Can't Create New Publication

Oct 11, 2007

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 3 Replies View Related

Creating A Publication

Aug 21, 2007

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 1 Replies View Related

Modifying Publication In SQL 7.0- Urgent Help .

Jul 31, 2002

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 2 Replies View Related

Publication Cannot Drop Table.

Nov 13, 2000

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 1 Replies View Related

Merge Publication Error

Mar 7, 2001

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 1 Replies View Related

Disabling Publication Using SQL DMO. URGENT!!!!!!!!

Oct 29, 1999

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 2 Replies View Related

Msg 14013, Not Enabled For Publication.....

Apr 25, 2007

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 14 Replies View Related

How To Add A Table To An Existing Publication?

Feb 22, 2002

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 1 Replies View Related

How To Reboot A Publication Server ?

Jul 16, 2004

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 2 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved