c# - windows indexing search not working with exception. 800703fa attempted on a registry key marked for deletion -


i using windows indexing service in asp.net application full text search functionality. production server in application deployed operating system windows 2008 r2.

this full text search functionality works 4-6 hours , after time following issue occurs logged application error logging system

retrieving com class factory component clsid {7d096c5f-ac08-4f1f-beb7-5c22c517ce39} failed due following error: 800703fa illegal operation attempted on registry key has been marked deletion. (exception hresult: 0x800703fa).

issue appears in following function

public dataset searchfolder(string searchquery, string strpath) {
dataset dataset = new dataset(); if (searchquery == null || searchquery.length == 0 || strpath == null || strpath.length == 0) return dataset;

    // thie uses searchapi interop assembly     csearchmanager manager = new csearchmanager();      // systemindex catalog default catalog windows uses     csearchcatalogmanager catalogmanager = manager.getcatalog("systemindex");       // isearchqueryhelper translate aqs --> sql necessary query indexer     csearchqueryhelper queryhelper = catalogmanager.getqueryhelper();     queryhelper.querycontentlocale = 2052;     //queryhelper.querymaxresults = 100;     //queryhelper.querykeywordlocale = 2052;      //queryhelper.     // set columns want,Ö»¼ìË÷ÎļþµÄÃû×ÖºÍÄÚÈÝ£¬²»È»ÊôÐÔÌ«¶àÁË£¬»á³öÏÖ¹·Æ¨²»Í¨µÄ½á¹û¡£     queryhelper.queryselectcolumns = "system.search.rank, system.itempathdisplay,system.itemnamedisplay,system.itemnamedisplay";     queryhelper.querywhererestrictions = "and scope='file:" + strpath + "' , contains(system.itemnamedisplay, '.pdf')";     queryhelper.querysorting = "system.datemodified desc ";     // queryhelper.s     queryhelper.querycontentproperties = "system.search.contents,system.itemnamedisplay";      try     {         // create oledb command object query built above , connection opened.         //oledbcommand command = new oledbcommand(sqlquery, conn);                      //sqlquery = "select \"system.search.rank\", \"system.itempathdisplay\", \"system.itemnamedisplay\", \"system.itemnamedisplay\", \"system.search.contents\", \"system.filename\" \"systemindex\" (contains(system.search.contents,'\"cn\" , \"604\" , \"1999\"',2052) rank coercion(absolute, 1000) or (system.filename '%cn%' , system.filename '%604%' , system.filename '%1999%')) , scope='file:d:\\scs' , contains(system.itemnamedisplay, '.pdf') order system.datemodified desc "; //all         //sqlquery = "select \"system.search.rank\", \"system.itempathdisplay\", \"system.itemnamedisplay\", \"system.itemnamedisplay\", \"system.search.contents\", \"system.filename\" \"systemindex\" (contains(system.search.contents,'\"cn\" or \"604\" or \"1999\"',2052) rank coercion(absolute, 1000) or (system.filename '%cn%' or system.filename '%604%' or system.filename '%1999%')) , scope='file:d:\\scs' , contains(system.itemnamedisplay, '.pdf') order system.datemodified desc "; //         //sqlquery = "select \"system.search.rank\", \"system.itempathdisplay\", \"system.itemnamedisplay\", \"system.itemnamedisplay\", \"system.search.contents\", \"system.filename\" \"systemindex\" (contains(system.search.contents,'\"cn 604 1999\"',2052) rank coercion(absolute, 1000) or system.filename '%cn 604 1999%') , scope='file:d:\\scs' , contains(system.itemnamedisplay, '.pdf') order system.datemodified desc "; //exact                          datatable dtresults = new datatable();             dtresults.columns.add("rank", typeof(system.int32));             dtresults.columns.add("path", typeof(system.object));             dtresults.columns.add("doctitle", typeof(system.object));             dtresults.columns.add("filename", typeof(system.object));             dataset.tables.clear();             dataset.tables.add(dtresults);              byte[] bytes = system.text.encoding.default.getbytes(searchquery);             string strquerystring = system.text.encoding.utf8.getstring(bytes);             string autogeneratedquery = queryhelper.generatesqlfromuserquery(strquerystring);//queryhelper.generatesqlfromuserquery(strcontent);              populateddatatable(autogeneratedquery, queryhelper.connectionstring, dtresults);     }     catch (exception ex)     {         logerror.logerrormessage(ex);     }         { }     return dataset; }

private static void populateddatatable(string sqlquery, string connectionstring, datatable dtresults) { system.data.oledb.oledbconnection conn = new oledbconnection(connectionstring);

    using (conn)     {         oledbcommand command = new oledbcommand(sqlquery, conn);         command.commandtimeout = 0;         conn.open();          oledbdatareader reader = command.executereader();          if (reader.hasrows)         {             while (reader.read())             {                 datarow dr = dtresults.newrow();                 dr["rank"] = reader.getint32(0);                 dr["path"] = reader.getstring(1);                 dr["doctitle"] = reader.getstring(2);                 dr["filename"] = reader.getstring(3);                 dtresults.rows.add(dr);             }         }         reader.close();               } }

if issue can due data reader closed not disposed?how identify exact cause of issue?


Comments

Post a Comment

Popular posts from this blog

asynchronous - C# WinSCP .NET assembly: How to upload multiple files asynchronously -

i using winscp .net assembly uploading files. want upload multiple files asynchronous way. have created method works single upload. public class uploadingdata { private sessionoptions _sessionoptions; private session _session; //connection etc private void onconnected() { foreach (var fileinfo in localfileslist) { var task = task.factory.startnew(() => uploadfilesasync(fileinfo)); } } private async task uploadfilesasync(string file) { string remotefilepath = _session.translatelocalpathtoremote(file, @"/", "/test_data_upload"); var uploading = _session.putfiles(file, remotefilepath, false); //when done await task.run(() => thread.sleep(1000)); } } please suggest me correct way. thanks you can use backgroundworker class this: string[] images = new string[50]; foreach (var path in images) { backgroundworker
Read more

aws api gateway - SerializationException in posting new Records via Dynamodb Proxy Service in API -

i getting "__type": "com.amazon.coral.service#serializationexception" as reply in postman & in test console in api gateway trying post record directly dynamodb using api proxy services.. referring aws article - https://aws.amazon.com/blogs/compute/using-amazon-api-gateway-as-a-proxy-for-dynamodb/ here's mapping { "tablename": "tablenamegoeshere", "item": { "id" : "$context.requestid" "eventname" : "$input.path('$.eventname')", "timestamp" : $input.path('$.timestamp'), "answers": "$util.parsejson($input.path('$.answers'))" } } update: did asked ... , worked if try add array of json objects gives me above same error - here's trying now. please - couldnt find on google well #set($inputroot = $input.path('$')) { "tablename": "answer", "item": {
Read more

asp.net - Problems sending emails from forum -

i have been redesigning site has message board, has been written guy looked after site. it has few problems , written in .asp , uses .mdb files database. you can see whole thing here . feel free post if helps, test thing have set using original files , new database. the basic problem when posts message, supposed email sent them, have posted it. when replies, originator supposed message, replier has been posted. i’d have thought @ point in process there should script/file in postmessage.asp? the postmessage.asp page below. <% option explicit %> <!-- #include virtual="common/adovbs.inc" --> <html> <head> <meta http-equiv="content-type" content="text/html; charset=windows-1252"> <meta name="generator" content="microsoft frontpage 4.0"> <meta name="progid" content="frontpage.editor.document"> <title>new page 2</title> <base target="_self"
Read more