Failed to create a non fast load session causing SharePoint Server to go Down (Network Steve Forum)

Failed to create a non fast load session causing SharePoint Server to go Down

Hi,

The SharePoint Server in Production does down regurarly means montly once or twice due to some issue in connecting to SQl Server. When we restart both the servers SahrePoint servers starts working.

From the logs i traced the below error messages.

fus3 Medium Transaction failed in plugin IPRA Url sts4://urasvr138:20930/siteurl=sites/help/siteid={e138251e-e994-4520-babc-ca70498a86f5}/weburl=/webid={fe7dcafd-b2ed-401f-92a1-788157b1fe9a}/listid={b3b99f8d-5a34-4329-8bb1-fc6f3ef9cc81}/folderurl=mssenduser.1033/itemid=4154 Error 0x80040d79 [gthrtrx.cxx:1054] d:\office\source\search\native\gather\gthrsvc\gthrtrx.cxx

03/08/2012 06:38:09.91 mssearch.exe (0x0A90) 0x28F0 SharePoint Foundation Search GatherSvc fus5 High Transaction failed in plugin IPRA Url sts4://urasvr138:20930/siteurl=sites/help/siteid={e138251e-e994-4520-babc-ca70498a86f5}/weburl=/webid={fe7dcafd-b2ed-401f-92a1-788157b1fe9a}/listid={b3b99f8d-5a34-4329-8bb1-fc6f3ef9cc81}/folderurl=mssenduser.1033/itemid=4154 Error 0x80040d79. This will generate a retry [gthrtrx.cxx:1062] d:\office\source\search\native\gather\gthrsvc\gthrtrx.cxx

03/08/2012 06:38:09.91 mssearch.exe (0x0A90) 0x1D80 SharePoint Foundation Search Common 0000 High Application 63979775-49fd-40e6-a67c-cde4216418c3, resource 1: pIDBInitialize->Initialize error. Failed to create a non fast load session. [resourcemanagerimpl.cpp:1070] d:\office\source\search\native\mssrch\resourcemanagerimpl.cpp

03/08/2012 06:38:09.91 mssearch.exe (0x0A90) 0x1D80 SharePoint Foundation Search Common 0000 High CResourceManager::CreateSessionEx2 Error creating non fastload session 'Provider=SQLOLEDB;Extended Properties='Server=urasvr139;Database=WSS_Search_URASVR138;Trusted_Connection=yes;App=Microsoft SharePoint Foundation;Timeout=15';'. [resourcemanagerimpl.cpp:1124] d:\office\source\search\native\mssrch\resourcemanagerimpl.cpp

03/08/2012 06:38:09.91 mssearch.exe (0x0A90) 0x1D80 SharePoint Foundation Search UtilCommon cd08 High SQL call failed (0x80004005: Unspecified error ) [atldbext.cxx:1290] d:\office\source\search\libs\utild\atldbext.cxx

03/08/2012 06:38:09.91 mssearch.exe (0x0A90) 0x1D80 SharePoint Foundation Search UtilCommon cd09 High error 0: [DBNETLIB][ConnectionOpen (Invalid Instance()).]Invalid connection. (source Microsoft OLE DB Provider for SQL Server, 0x80004005, code 14: Unspecified error ) [atldbext.cxx:1386] d:\office\source\search\libs\utild\atldbext.cxx

03/08/2012 06:38:09.91 mssearch.exe (0x0A90) 0x1D80 SharePoint Foundation Search Arpi dtc0 High Search_index_file_on_the_search_server q 000000 error getting sql session 0x80004005 [arpiqueuegroup.hxx:107] d:\office\source\search\native\gather\plugins\arpi\arpiqueuegroup.hxx

03/08/2012 06:38:09.91 mssearch.exe (0x0A90) 0x0B94 SharePoint Foundation Search Common 0000 High Application 63979775-49fd-40e6-a67c-cde4216418c3, resource 1: pIDBInitialize->Initialize error. Failed to create a non fast load session. [resourcemanagerimpl.cpp:1070] d:\office\source\search\native\mssrch\resourcemanagerimpl.cpp

03/08/2012 06:38:09.91 mssearch.exe (0x0A90) 0x0B94 SharePoint Foundation Search Common 0000 High CResourceManager::CreateSessionEx2 Error creating non fastload session 'Provider=SQLOLEDB;Extended Properties='Server=urasvr139;Database=WSS_Search_URASVR138;Trusted_Connection=yes;App=Microsoft SharePoint Foundation;Timeout=15';'. [resourcemanagerimpl.cpp:1124] d:\office\source\search\native\mssrch\resourcemanagerimpl.cpp

03/08/2012 06:38:09.91 mssearch.exe (0x0A90) 0x0B94 SharePoint Foundation Search UtilCommon cd08 High SQL call failed (0x80004005: Unspecified error ) [atldbext.cxx:1290] d:\office\source\search\libs\utild\atldbext.cxx

03/08/2012 06:38:09.91 mssearch.exe (0x0A90) 0x0B94 SharePoint Foundation Search UtilCommon cd09 High error 0: [DBNETLIB][ConnectionOpen (Invalid Instance()).]Invalid connection. (source Microsoft OLE DB Provider for SQL Server, 0x80004005, code 14: Unspecified error ) [atldbext.cxx:1386] d:\office\source\search\libs\utild\atldbext.cxx

Please suggest what is going worng and what needs to be done to resolve this issue as we cannot restart both the SQL Server and Application server of production again and again.

Thanks,

Mayank

March 8th, 2012 6:51am

Hi,

Based on my analysis, the cause can be SharePoint account services (including timer account) were locked in AD.

It's possible that simply unlocking all locked accounts in AD is enough to restore service, but all locked accounts were not identified at the beginning, so some services, such as Search SA were deleted and recreated. Also, the timer service had to be manually restarted on 1 of the servers.

Thanks,

Rock Wang

Free Windows Admin Tool Kit Click here and download it now

March 14th, 2012 6:19am

Hi Rock,

I think this is only the issue.Can you please let me know which timer service needs to be restarted.

Thanks,

Mayank Bhargava

March 14th, 2012 7:08am

Hi Mayank,

I have the same problem (same logs), my SP Server fails every day!

Did you solve your problem?

Thanks,

Sebastian

Free Windows Admin Tool Kit Click here and download it now

January 17th, 2013 5:33pm

Hi all,

I have the same problem, anyone has a solution to that problem?

Thanks

Albert

August 6th, 2013 5:09am

This topic is archived. No further replies will be accepted.