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

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

SQL 2005 Sharepoint Non yeilding scheduler error

Posted By:      Posted Date: April 10, 2011    Points: 0   Category :


Today we noticed the following non yielding error in one of our critical sharepoint database cluster server. Data and logs are on seperate drives (SAN).It is SQL 2005 SP4 (64 bit) enterprise edition server.

logical processor: 16

total memory: 32GB (25GB allocated to SQLserver)

 SQL logs:

     SQL Server has encountered 1 occurrence(s) of I/O requests taking longer than 15 seconds to complete on file [G:\xxx\xxx\xxxx.mdf] in database [xxxx] The OS file handle is 0x0000000000001278.  The offset of the latest long I/O is: 0x00001ddc9d0000
2011-04-06 10:01:23.63 Server      Using 'dbghelp.dll' version '4.0.5'
2011-04-06 10:01:23.67 Server      ***Unable to get thread context - no pss
2011-04-06 10:01:23.67 Server      * *******************************************************************************
2011-04-06 10:01:23.68 Server      *
2011-04-06 10:01:23.68 Server      * BEGIN STACK DUMP:
2011-04-06 10:01:23.68 Server      *   04/06/11 10:01:23 spid 0
2011-04-06 10:01:23.68 Server      *
2011-04-06 10:01:23.68 Server      * Non-yie

View Complete Post

More Related Resource Links

Sharepoint alert error



Something strange is happening here. I have a list whose itens alerts are not sending, but iclusion or permissions alerts for the same list are ok.

The strange is: I search for a fix, then I restarted the Windons Sharepoint services Timer, reset the alerts by stsadm tool (stsadm -o setproperty). the timer job status is ok too. and I just receive this error for this list, ONLY for this list...the other list I can receive the e-mails normally.

Can someone help me?



Problem when installing Microsoft SQL Server 2005 Reporting Services Add-in for Microsoft SharePoint


I have configured the SharePoint Production Server(Standalone) with WS 2008 64 bit version, SQL Server 2005 with SP3 , Visual Studio 2008 and MOSS 2007(SP3). I have configured SSRS 2005 in SharePoint integration mode. Everything works fine till the last step. Now, i am trying to install Microsoft SQL Server 2005 Reporting Services Add-in for Microsoft SharePoint Technologies feature and failed. I am getting below error message.

Product: Microsoft SQL Server 2005 Reporting Services Add-in for Microsoft SharePoint Technologies -- You must first install SharePoint Server before installing SQL Server 2005 Reporting Services Add-in for SharePoint Technologies

Any help will be very appreciated!


RDL Rendering (500 Internal Server) Error at Sharepoint Integrated Reporting Service


I have a serious problem that cannot be solved by googling around the keywords below:
sharepoint, moss 2007, reporting service, ssrs 2008, rendering, internal server error, ....

The error is;

"An error occurred during client rendering. The remote server returned an error: (500) Internal Server Error. "

Everything is O.K.;

* When I render the report from the REPORTSERVER (http://localhost/ReportServer)
* When the reports are scheduled to be sent by the reporting service (planned via MOSS 2007) 

But if I open (render) the RDL file from the sharepoint REPORTS LIBRARY interface, all of the reports fail with that internal error message above. 

It is weird also that parametrized reports are displayed without errors although the parameters are queried from a sql dataset. But I got the error when rendering the report after I've chosen a parameter  and order "apply/report"...

Possible causes how I met that error may be;

After I have installed (then uninstalled) AJAX extensions
After I have re-configured IIS Web Service Extensions list items

Possible solution alternatives I've found;

I've found a solution on MSDN replying a similar issue with an ideal cause of the error but an evreka answer but no sol

Visual Studio 2005 Extension for Sharepoint Workflow.


Hi All,

I want to develop sequential workflow using visual studio 2005. I have development server with Windows Server 2003 x86 installed.

Could anyone advise will i need to install Sharepoint first to have workflow feature in visual studio.

Also what all extension component i need to install to develop Sequential Workflow for Sharepoint 2007 document library.


Many Thanks


-- Regards Sandeep

SharePoint 2007 Central Admin - blank page, isapimodule error in IIS


I've got a Windows 2008 SP2 server runing x64.

When i try to access the SharePoint Central Admin site, I just get a blank page. No errors in the Windows logs, nothing showing up in the SharePoint logs. The IIS log shows a 500 error.

I enabled Failed Request Tracing for the 500 status code, which gives me the following information:

ModuleName IsapiModule

Notification 128

HttpStatus 500

HttpReason Internal Server Error

HttpSubStatus 0

ErrorCode 2147942593


SharePoint 2007 Access Error


Hi everybody!

I´d like to verify if somebody see this scenario:

* I create a site, using te meeting site template;

* I give Full Control access to an user;

* When this user try to upload an item in a library, in this site, it was showed the message "Acces Denied".

* If the user press "back" in the Internet Explorer tool bar and press "F5" to refresh, the file is there.

* The same problem is ocurring, when he try to create a meeting.

Somebody ever see this error!?

Thanks a lot


Error by insert new item in dataview sharepoint designer



doesn't any1 know the answer of my question?

i'm trying to create a data view with the edit, delete and insert function.

the edit and delete works fine. only the insert gives me this error:

The data source control failed to execute the insert command.

plz help?

Resume SharePoint Services Web Application and returns code 1387 error


Hello everyone! Newbie here. I would like to ask how to start the SharePoint Services Web Application on (WSS3.0,internal database, stanalone users) without getting error 1387 ?

I would love to provide more information regarding this issue but what I got is error 1387 displayed in the browser.

I look forward to seeing you guys feedback from your expertise angle.



SharePoint Calendar Error: The "ListViewWebPart" Web Part appears to be causing a problem. Index was

In one specific SharePoint calendar, on one specific week in that calendar when we select the "more items" link in the monthly view (or the expand all option) we get the following error:
The "ListViewWebPart" Web Part appears to be causing a problem. Index was outside the bounds of the array.

Web Parts Maintenance Page: If you have permission, you can use this page to temporarily close Web Parts or remove personal settings. For more information, contact your site administrator.
Troubleshoot issues with Windows SharePoint Services.

If we select a different week the expand and collapse works fine in that calendar.

Sharepoint server not installed error

Hi geeks,               Actually I installed Sharepoint server ie., MOSS 2007 in system (Windows server 2003) and am using Visual studio 2010 ultimate. When am add new Sharepoint connection to my Visual studio 2010 it throws me error "A Sharepoint server is not installed on this computer. A Sharepoint must be installed to work with Sharepoint projects.".               I don't know what to do with it. Can you guys help me out to access my sharepoint site to my VS 2010.    Thanks, Karthick.

Error 2908 while installing sql server 2005 management objects collection on Win 7

I have SQL Server native client 2005 installed on Win 7 64-bit machine. While installing SQL Server XMO 2005 it gives error 2908 and aborts installation. Any suggestion on the error?

sql 2005 sp2 memory error FAIL_VIRTUAL_RESERVE

We're running SQL Server 2005 SP (9.00.4035.00) 32 bit on Windows Server 2008 SP2 Enterprise.   The server has 8gb of RAM and is only used for SQL Server.  Since Windows 2008 SP2 was installed on 8/23/2009, once every week or so the server has become unresponsive.  Early in in the course of the problem I notice the following error in the SQL Server error log:  Failed Virtual Allocate Bytes: FAIL_VIRTUAL_RESERVE 1048576 That's followed by the output of DBCC MEMORYSTATUS, which I'll include at the end of this post. After that, things work normally for several hours, except for some occurences of Downgrading backup log buffers from 1024K to 64K That appear in the SQL Server error log when our transaction log backups occur.  Some time after that, we begin to receive Event ID: 701 There is insufficient system memory to run this query. In the event logs of our server. At that point, the server becomes unresponsive.  Restarting the SQL Server Service resolves the issue. Is anyone else experiencing this? It's only been happening 1 time per week (not consistently the same time) and has only occurred since Windows Server 2008 SP2 was installed.  I don't know if that's related, but it's the only real change to that server.  Workload has been consistent on that server for months. Can someone please help? Thanks. Here's the DBCC output. Memory Manager     VM Reserved =

Anyone got the SharePoint List Adapter working with SQL 2005?

Like the authors of some other similar posts, I cannot see the SharePoint list dataflow source and destination options after installing SharePointListAdaptersSetupForSqlServer2005.msi from codeplex.  The options do not appear in the SSIS Data Flow items tab within the "Choose Toolbox Items".  Anyone manage to figure this out? If i install it on my dev laptop - I get these options and can add them to my toolbox - however I have both SQL Server 2005 and 2008 on this machine.   On my 64 bit server however I only have SQL 2005 and nothing! I would love to use this as the last time i wrote a web service extraction is was a very unpleasant few days of my life. Ritchie

The URL 'ao/AO Document/Admin Guideline/xxxxx.jpg' error on 2nd SharePoint server in farm

We just added a 2nd SP2007 server to mirror our site.  The original site is in China, the new site in the US.  They are connected via a permanent  site to site VPN.  We are hitting the errors when attempting to upload files to the US mirror.    Environment: US server site: OS: Windows Server 2008 R2 Enterprise (64 bit) APP: Windows Sharepoint Server 2007 Enterprise SP2 (64 bit) DB: Windows SQL Server 2008 Enterprise R2 (64 bit) China site: OS: Windows Server 2003 Enterprise SP2 (32 bit) APP: Windows Sharepoint Server 2007 Enterprise SP2 (32 bit) DB: Windows SQL Server 2008 Enterprise R2 (32 bit) Background: We setup two test Sharepoint farm to be syncronized with only its content database. The upload works good on SZ site. But we got the following 2 error messages randomly when uploading file to document library of SF side. Error message: 1. The URL 'ao/AO Document/Admin Guideline/xxxxx.jpg' is invalid.  It may refer to a nonexistent file or folder, or refer to a valid file or folder that is not in the current Web. 2. Cannot open file "ao/AO Document/Admin Guideline/xxxxx.jpg". -- We've tried the official hotfix, altering the schema, changing the IIS memory limit settings, and restarting the application pool. Could the issue be related to the different OSes 2008 vs 2003, or 32 vs 64bit?  

Getting the Error: 0xC001000E at : The connection "" is not found. SQL 2005

After doing some looking I noticed this was included in the SP3 for SQL 2005. We have had this service pack installed for a while now but we are still randomly getting this error. Some packages will run fine for a long time and then all of the sudden start giving this error even though the package was successful. Any ideas? Thanks, Donnie

SQL Server 2005 x64: Intermittent "Error: 18456, Severity: 14, State: 10."

Hi, We are experiencing intermittent authentication errors "Error: 18456, Severity: 14, State: 10" on a customer's production server. This is a new server that has just been rolled out in the past several months. Rebooting the server appears to make the problem go away. We are using SQL authentication from a separate server that is running IIS. The application always uses the same username and password to connect. Server info: select @@versionMicrosoft SQL Server 2005 - 9.00.2047.00 (X64) Apr 14 2006 01:11:53 Copyright (c) 1988-2005 Microsoft CorporationStandard Edition (64-bit) on Windows NT 5.2 (Build 3790: Service Pack 1) select @@versionSP1 Sample error from SQL Server errorlog: Date  7/7/2006 10:53:24 AMLog  SQL Server (Archive #2 - 7/7/2006 12:20:00 PM)Source  LogonMessageError: 18456, Severity: 14, State: 10. MSDN (http://msdn2.microsoft.com/en-us/library/ms366351.aspx) lists various states for this error message but 10 is not included, and it says "Other error states exist and signify an unexpected internal processing error." Note: This was not a case of a transient error that occurs only when SQL Server is starting up - these errors occurred at a variety of times, two months after the server was last rebooted / SQL Server last restarted. Thanks for any help you can provide. Regards,-Frank.

"None of the selected features can be installed" error on SQL 2005 Cluster

Hey All, I installed SQL 2005 on a cluster.  Everything on the primary node works fine.  However, as the documentation suggests, the SQL Management Studio (and other tools) are not installed on the standby node by default.  However, when I go to try and install on the 2nd node I get the following error: TITLE: Microsoft SQL Server Setup------------------------------ None of the selected features can be installed or upgraded. Setup cannot proceed since no effective change is being made to the machine. To continue, click Back and then select features to install. To exit SQL Server Setup, click Cancel. For help, click: http://go.microsoft.com/fwlink?LinkID=20476&ProdName=Microsoft+SQL+Server&ProdVer=9.00.1399.06&EvtSrc=setup.rll&EvtID=SQLSetup90&EvtType=28108 ------------------------------The link is referencing something about requiring a complex SA password.   I can verify that the directory structure on node 1 where the management studio and client tools exist does not exist on node 2.   I'm at wits end here, I've tried uninstalling/reinstalling/everything. Anyone have any ideas? thanks!
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