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

Top 5 Contributors of the Month
david stephan
Gaurav Pal
Post New Web Links

The semaphore time-out period has expired

Posted By:      Posted Date: September 01, 2010    Points: 0   Category :Sql Server
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. Best Regards, Zainu    

View Complete Post

More Related Resource Links

The semaphore timeout period has expired


For the past few days something weird is happening to our sql server box.  During running some procedures we get the following error message:

Msg 121, Level 20, State 0, Line 0
A transport-level error has occurred when receiving results from the server. (provider: TCP Provider, error: 0 - The semaphore timeout period has expired.)

It seems to happen when running large procedures or even small queries, the session where i run the query get disconnected but I can reconnect right away but it may happen again couple minutes later.

 I'm connecting to my Windows server 2003 using remote desktop and running procedures from the SQL Server installed on the Windows Server.

Anybody has an answer?  Thanks.

Sharepoint site getting time period expired



I am having a file which is contain 70,000 data. i try to upload this file into sql server table using front end sharepoint site.i am getting time out period expired error.

But i have added connection timeout=100000 property in connection string still i am facing the same problem

So please help me to solve this issue



Timeout expired. The timeout period elapsed prior to completion of the operation or the server is no



 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.

Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.


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.

Stack Trace:

[SqlException (0x80131904): Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.]

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 is 06.09.2010. As Result I have to get a report: Buy form Vendor Amount today 02.09.2010 Amount +4days 02-06.09.2010 Amount +29days 02.09-30.09.2010 A 10000 250000 333333 B 150000 222222 555555 C 666666 444444 1222222 Sincerely, 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.   Kind Regards, Dayna

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. http://social.technet.microsoft.com/Forums/en-US/sharepoint2010setup/thread/644ab342-4eaa-468c-95c1-f345a4f65f26#644ab342-4eaa-468c-95c1-f345a4f65f26 Any ideas anyone??

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 Date:        9/13/2010 Time:        9:05:03 AM User:        N/A Computer:    SP1 Description: An exception occurred in the search synchronizer. Event Type:    Error Event Source:    Service Control Manager Event Category:    None Event ID:    7023 Date:        9/13/2010 Time:        9:11:34 AM User:        N/A Computer:    SP1 Description: 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 ...

2007 VHD - Workflow Setting throws "The trial period for this product has expired"

I recently downloaded the SharePoint 2007 VHD from this link: http://www.microsoft.com/downloads/en/details.aspx?FamilyID=67f93dcb-ada8-4db5-a47b-df17e14b2c74&displaylang=en The above link shows 5/3/2010 as Date Published.  So I am assuming that this is the new version of VHD published this year. I am able to login to this VHD and also view the default SharePoint site.  But, when I goto Workflow Setting of a List and click on NEXT button, it throws "The trial period for this product has expired" error.  This error is not written in ULS LOGS. I also noticed something strange in "WIN03_MOSS_README.htm", which is part of this download.  The Program Details section in this Readme says: The evaluation period for this virtual machine image ends @ 2/22/2011.  NO EFFORT SHOULD BE MADE TO ACTIVATE THIS IMAGE.  After 2/10/2010, the evaluation period is over and the image should be discarded.  So what exactly is the expiry date of this VHD?  Is it 22-Feb-2011 or 10-Feb-2010?  Can someone from Microsoft VHD team provide a valid response. Thanks & Regards, Kamlesh | Blog | Twitter | Posting is provided "AS IS" with no warranties, and confers no rights.

The trial period for this product has expired.

Hello, I installed SharePoint Server 2010. I created my first site collection. It was working fine. Today, I deleted all old site collections, created a new one. I got this message:  Error  The trial period for this product has expired.  Troubleshoot issues with Microsoft SharePoint Foundation.  Correlation ID: d21feda0-d6c1-4824-b35d-594642631e05  Date and Time: 9/16/2010 9:13:31 AM   Go back to site  Appreciate your help, Regards

Returning Customer Count of all categories in each time period



Lets say I have the following Table:

CustomerNumber | Date | MovieCategory
1 |2010-01-01|A
1 |2010-02-01|A
1 |2010-03-01|A
1 |2010-04-01|A
1 |2010-05-01|A
1 |2010-06-01|D
1 |2010-07-01|A
2 |2010-01-01|A
2 |2010-02-01|A
2 |2010-03-01|D
2 |2010-04-01|D
2 |2010-05-01|D
2 |2010-06-01|C
2 |2010-07-01|C
3 |2010-01-01|B
3 |2010-02-01|B
3 |2010-03-01|B
3 |2010-04-01|C
3 |2010-05-01|C

What I want to do is count the number of customers for each movie type in each date. Now I started with the following simple query

Select Date, MovieCategory, Count(CustomerNumber)
From AboveTable
Group By Date, MovieCategory
Order by Date, MovieCategory

which would be okay, but if no customer has a MovieCategory of say 'B' on a particular date then the results of the above query won't return a row that has

Date| B| 0     (date here could be any date).


which is really what I need. Is there a good way to

Upgraded SQLServer 2008 Enterprise Evaluation after 180 day period expired...Services start but stil



I have a SQLServer 2008 Enterprise (180 day eval) installation that had expired.

I downloaded and intalled SQLServer 2008 Enterprise (Full version) from Technet

and ran the "Version Upgrade" tool.

The Upgrade tool correctly identified the expired instance and reported that it

had successfully upgraded the expired instance.

The OS processes will start but when I attempt a connect, I get a "Evaluation Period Expired"

error message.

Is it possible to do an "upgrade in place" after the 180 day evaluation has expired or do

you have to uninstall then re-install ?

Many Thanks in Advance,

Hobson Black

How to concatenate measures over time period?



For an external tool I have to prepare Sales ([Measures].[Sales]) figures for the last 5 months like this: 12345|12343|21423|12344|12343. So basically, I need one measure that displays these values concatenated. How can I create this? (In my MDX query I would have this measure on columns and i.e. another dimension like country on rows).



This operation returned because the timeout period expired


I have creetaed OSDesign using VS 2005.Later,I have created device application and I am using emulator created from OSDesign as device for connection.When I debug it gives error as, This operation returned because the timeout period expired

AGGREGATE over a time period: how to behave like a distinct count ? (aggregate on the full period an


I would like to compute a measure "MyMeasure" over the last 12 months :

Aggregate({[Event DATE].[Calendar].CurrentMember.Lag(11):[Event DATE].[Calendar].CurrentMember},[Measures].[MyMeasure])

MyMeasure is not a distinct count, so the results returned is the SUM of the distinct count performed on each month over the last 12 month.

What I would like to have is the distinct count over a full year (all months taken together).

For example, suppose that MyMeasure is a simple measure that always returns 1.

The aggregation returns 12 (1 for each month then SUM). I would like it to return 1 (measure on the whole period).

Can somebody help me that's really a very big issue I have to fix !


NetworkStream ReadTimeOut doesn't wait for the time out period



I am using the TCPClient and the NetworkStream classes to establish a TCP connection and read the data from the network.
The NetworkStream object is set with a time out of 15 sec. The intent is, if the stream can't see any data from the network within 15 sec,
it will throw an exception and return. Something like myStream.ReadTimeOut = 15000. I set this time out once in the beginning just after the TCP connection  and the NetworkStream are created.

Though majority of the times (70%) it behaves nice and waits for the time out period to expire before throwing the System.IOException,
other 30% of the times, it just doesn't wait 15 sec before throwing the exception. It doesn't even wait for 2-3 milliseconds before throwing the exception.

I verified this using another tool, wireshark to time and detect the traffic.

Is the NetworkStream object doing some kind of optimization? Or do I have to do anything special to make it to wait for 15 sec?


Tech Crawler


The trial period for this product has expired - Still Beta release


Hi All,

I was trying to access a sharepoint development (SharePoint 2010 Beta), but I started to get the following error: The trial period for this product has expired

how can I fix the error?

I have the released version of SharePoint (I work for a MS Gold Partner and we can download the Released SharePoint)...

How can I restore the SharePoint Development??? (I have developed customization and Performance Point Dashboards...)

Any suggestion will be appreciated!




ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

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