how to know retention period of every publisher in my sql sever and can i give each publisher a retention different from the other
and how to check if the database is in no-sync ??
View Complete Post
I keep getting the following error. I also added time out parameter in the connection stirng and it still did not help. Has any one faced similar issues.
Thanks in adavance.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception Details: System.Data.SqlClient.SqlException: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.Source Error:
An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.
[SqlException (0x80131904): Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.]
System.Data.SqlCl If you have SharePoint Document Versioning Enabled, do you also use the retention settings? I am looking for stats on how many environments are out there using document versioning in there libraries but are perhaps not selecting the retention settings. (e.g. "Optionally limit the number of versions to retain" section) This as we all know in SharePoint
is a major cause of database growth.Tony Parker, MSCE . MCTP. MCITP "Anything worth doing, is worth doing right" How to prevent Propagation from subscriber to Publisher in some occations We are using merge application. We need sometimes delete some tables at subscriber and that delete command or any other command should not propagate to Publisher and other subscribers. And sometimes it should be refilled from Publisher. Is it possibe?
Second question : My publisher crashed two times. I could attach the database after restoring the OS. But at subscriber I am unable to modify some table and it gives the error invalid object name 'dbo.msmerge.......'. Replication is working fine. What is
the reason for this error and how I can get rid of it? Trying to use distrib but gets error, invalid column name 'publisher' I have a pull subscription setup between sql server standard 2005 and windows 7 sql server 2008 express. When I run the distrib exe I get the error "invalid column name 'publisher'". I have searched the internet for a solution to this problem and keep coming up empty. Can someone help me debug this error? Timeout error - The timeout period elapsed prior to completion Hi,
I'm using ASP.NET 3.5 (c#) with SQL Server 2008 server. Recently, I started getting error "Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.".
After looking at forums for solutions, I added the below common code to my application. protected DbCommand CreateCommand()
SqlCommand sqlCommand = new SqlCommand();
sqlCommand.CommandTimeout = 600; // 10 minutes
However, intermittently, I'm still getting the timeout error. I added the logging to see where error is occuring. And found that before executing one of the query, it is giving this error. Now, my assumption is that I should have received this error after runnign query for 600 seconds (10 minutes) since I set it in the above function. But the timeout error is occuring instantaneously within 1 second itself. In the log, I printed one line above & after the query to identify how much time it would take. Surprisingly, the log says that 9:00 AM "Before query execution" & at 9:01 AM "timeout expired...."
I would really appreciate if some one can help me out here!
Thanks! publisher policy in GAC I want to redirect consumers of dll v1 to dll v2. I will add a publisher policy in GAC for that. Does this
mean dll v2 itself must also reside in GAC or can the actual new dll be in /bin?http://webservices20.blogspot.com/
WCF Security, Interoperability And Performance Blog SQL Server 2005 as Distributor, Subscriber - SQL Server 2008 as Publisher Hi,
I am creating a Distributor on SQL Server 2005 the server name is Server1 and Server1 is the Subscriber as well, we are using Push Subscription
Publisher is on SQL Server 2008, Server2. When i try to create a Publications, it throws the following error.
is an Older Version of SQL Server and cannot be the Distributor for Server 'Server2'
Server1 - Distributor, Subscriber
Server2 - Publisher
Is there any way to overcome this issue..?
Fazlu. The semaphore time-out period has expired Hi,
We have a job that does use linked server to copy some data from a MS SQL 2000 database and insert it into a database which runs in MS SQL Server 2005.This job is configured in the 2005 server.
Offlate we started encountering the error
OLE DB provider "SQLNCLI" for linked server "RSSDR" returned message "Communication link failure". [SQLSTATE 01000]
Error Number::121 Error Message::TCP Provider: The semaphore time-out period has expired.
Initially thought its a network issue but network team have confirmed there were no network issue at the specified time.Is it something related to network adapters,card or some other firware.
Any help would be highly appreciated.
MDX Query Measure with time period Hi!
How to set up the period in MDX?
I need the measure what would be seted up by default 4, 29… days from today. For axample Amount from current day (02.09.2010) till 4 days from today
As Result I have to get a report:
Buy form Vendor
Milena SPD to escalate workflows over a period of time Hello,
I am hoping that you can help me, I have designed an InfoPath form that I am using for an expenses approval, but I would like to set it so if the approver has an Out of Office, the workflow is submitted to a different user. And if the workflow exceeds a specific time range then the workflow is escalated.
I am using SPD to create these workflows, rather than the in built MOSS workflows.
You're help, as always, is greatly appreciated.
Dayna Specify CLR Version When Using Al.exe to Generate Publisher Policy Files I'm trying to generate a publisher policy for for .NET 4.0 assemblies. However, I noticed that the version of mscorlib that the generated policy file references is always 2.0.0. Is there a way to specify .NET 4.0 as the CLR? Otherwise, when you install
this assembly, it gets installed into the C:\Windows\assembly folder instead of the new .NET 4.0 assembly GAC location. DROP CONSTRAINT AND ADD/MULTI TABLES PUBLISHER, PROBLEMS IN SUSCRIPC.... Sorry my terrible english, I will try
to explain my problem, I made some data changes at the publisher and I had to throw away the PK and FK cascading multiple tables.
The problem I have is
that these changes were trying to apply to the subscribers and can not do because it does
not in order which I did step by step through the Publisher.
now show me this error and does not synchronize anything, and takes 0.5 sec and gives the error infinitely
I need help, which infinitely grateful
The schema script ' if exists (select * from sysconstraints where constid = object_id(N'[FinancieroAbonos_PK]')) if object_id(N'[dbo].[FinancieroAbonos]') is not null exec('ALTER TABLE [dbo].[FinancieroAbonos] DROP CONSTRAINT [FinancieroAbonos_PK]
')' could not be propagated to the subscriber. (Source: MSSQL_REPL, Error number: MSSQL_REPL-2147201001)
Get help: http://help/MSSQL_REPL-2147201001
The constraint 'FinancieroAbonos_PK' is being referenced by table 'FinancieroAbonosContabilizacion', foreign key constraint 'FinancieroAbonos_FinancieroAbonosContabilizacion_FK1'. (Source: MSSQLServer, Error number: 3725)
Get help: http://help/3725
Could not drop constraint. See previous errors. (Source: MSSQLServer, Error number: 3727) Unable to load External list in Sharepoint Foundation - error due to trial period expired I've created an external content type and external list on Sharepoint Foundation. Everything is OK when creating and viewing these items in create mode in sharepoint designer.
When trying to view the external list in the browser I get error message "Unable to display this Web Part..."
When I opened the same list in the mobile view url I get a more descriptive error message:
"The shim execution failed unexpectedly - The trial period for this product has expired.."
I have read and followed the instruction related to this thread concerning expired trial period bug, and iisreseted the server after change but I still can't display the list.
Any ideas anyone?? set reinitialization period on Transactional replication How do you set the parameters on Standard Transactional Replication to Reinitialize after a certain period of time? Thank you. Error - The evaluation period for this version of SharePoint Portal Server has Expired I am using SharePoint Portal Server 2003 and in the app log I'm seeing this error "The evaluation period for this version of SharePoint Portal Server has Expired" which I believe is causing the search service to not work and I can no longer sign
in to the SP central admin console. While I did not perform the install myself it has been running for over a year and according to MS the SP PS 2003 eval was only 120 days so I assume the full version was installed.
Any idea's? There are a couple more errors in the event log but I assume they are symptoms and not causes.
Event Type: Error
Event Source: SharePoint Portal Administration Service
Event Category: None
Event ID: 502
Time: 9:05:03 AM
An exception occurred in the search synchronizer.
Event Type: Error
Event Source: Service Control Manager
Event Category: None
Event ID: 7023
Time: 9:11:34 AM
The Microsoft Shar the trial period for this product has expired. sharepoint foundation 2010 Hi Everyone,
I have upgraded a WSS v3 to Sharepoint Foundation 2010.
Installed search express 2010 and never got the search working as i always got internal server error when i try and add the
search core result webpart to the search center.
After i tried repairing the search express 2010 by using the wizard.
Now when i try and view sharepoint sites i get "the trial period for this product has expired.
Any ideas ... Trial period for this product is about to expire Search Server 2010 Express Hi
I know this is the Forum for SharePoint 2010 but because Search Server Express 2010 builds on SharePoint and I do not find a Search Server Express Forum I will ask
After successful install of Search Server Express I got this Error
Trial period for this product is about to expire.
But Search Server Express is Free and I do not have any Product Key!
I hope someone can help me.