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


Top 5 Contributors of the Month
Kaviya Balasubramanian
Imran Ghani
Post New Web Links

Querying indexing catalog causes error on the word "weight"

Posted By:      Posted Date: October 08, 2010    Points: 0   Category :ASP.Net
 

Hello!

On our web server we have a search form that fires off multiple searches and combines the results into 1 page.  The main search is of the indexing catalog for our web site.  We have used this for several years and it works just fine.  The company just sponsored a weight loss program and we have discovered that the word "weight" returns an error.  The word "weigh" works fine but if we add that "t" on the end it fails.  Here is the error:

Incorrect syntax near 'weight'. Expected '!', '(', NOT, ISABOUT, FORMSOF, STRING, PREFIX_STRING. SQLSTATE=42000

This is the query at the time of execution:

Select DocTitle,URL from SCOPE() where (CONTAINS(CONTENTS, 'weight') OR CONTAINS(DocTITLE, 'weight')) order by Rank Desc

Does anyone have an idea of how to get past this problem?  I'm guessing that "weight" is probably a key word or something similar.




View Complete Post


More Related Resource Links

AdomdDataAdapter.Fill returns memory error when querying an SSAS Cube(2008)

  
For certain SQL's I will get the following error when calling the Fill method on an AdomdDataAdapter object. "Memory error: While attempting to store a string, a string was found that was larger than the page size selected. The operation cannot be completed."   Snippet of Code: DataSet ds1 = new DataSet(); AdomdCommand acmd1 = cn1.CreateCommand(); acmd1.CommandText = "SELECT ..."; AdomdDataAdapter ad1 = new AdomdDataAdapter(acmd1); ad1.Fill(ds1);   Now when we run this query in Ms Sql Studio we don't get any errors but the query returns 1 row with over 40,000 columns. I'm guessing the # of columns might be an issue but not sure.   When doing a Google search it appears that this problem was found in the 2005 and fixed in that version. Have any of you come across this problem?  

MS word error

  
Hi, I am getting this error when i try to open MS Word files   "If you want to open this file, you need to clean the file using alternative virus scanning software. Do you want to save the file to yourcomputer and try to clean it?"   Any Idea?   Lasantha

BDC model in Search Server 2010 indexing error - Error while crawling LOB contents. ( Not a valid Wi

  
I have created a .NET connector assembly that pulls data from an in-house .asmx web service.  I have successfully created an external list in a search center site that displays this data without problem.   However, I've run into an error and a warning when indexing this list in search server 2010 for which I cannot find much information.  I've configure a content source with LOB data as the content source type and select my external data source from the list. After running a full crawl, I receive this error: Error while crawling LOB contents. ( Not a valid Win32 FileTime. ) And this warning: The content for this address was excluded by the crawler because this item was marked with a no-index meta-tag. To index this item, remove the meta-tag and recrawl. My .NET connector assembly looks like this:   public static WeatherEntity ReadItem(string id) { foreach (WeatherEntity entity in GetAllEntities()) { if (entity.LocationAbbreviation == id) { return entity; } } return null; } public static IEnumerable<WeatherEntity> ReadList() { return GetAllEntities().ToArray(); } public static List<WeatherEntity> GetAllEntities() { List<WeatherEntity> weatherEntities = new List<WeatherEntity>(); WeatherService.WeatherWS service = new WeatherService.WeatherWS(); WeatherService.DsWeatherDa

Office Web Apps - View Word doc in the browser error

  
I have been trying to figure out why I keep getting this error everytime I try to view a word docx document in the brower of my SharePoint Server 2010 site. Word Web App cannot open this document for viewing due to an unexpected error.  To view this document, open it in Microsoft Word. Error Id: 855eacd0-6974-424f-b0f9-a305ab62af6d, 20100916200545 Any help or direction to resolving the problem would be greatly appreaciated.Daryl Gilbert II

Error querying SSAS cube.....permission problem???

  
I've been developing a BI solution with SQL/SSRS/SSAS 2005.  I've done all the development with an account that has full admin permissions on the server.  Now I am trying to give users access to the data without admin permissions.  When a user runs an SSRS report that queries an SSAS cube I get the following error:   An error has occurred during report processing. (rsProcessingAborted)  Query execution failed for data set 'Division'. (rsErrorExecutingCommand). Since I don't get this message when I run the report I'm thinking it's a permission thing.  I set up a domain user group, 'SQL Users', and gave them access to the SQL Server Reports database and the Report Manager but don't know if I have to grant permissions on the SSAS database.  SSAS doesn't use the same security settings that SQL uses.  I added SQL Users as a role in my database but that didn't help. I'm not sure what else to try...

InfoPath / ActiveX error when using person selector field in Word template off SharePoint document l

  
I have created an out-of-the-box document library on a SharePoint 2010 site.  I left Microsoft Word Document selected as the Document Template.  I then added a person or group column and a multiple lines of text column to the document library. I then went into Library Settings --> Advanced Settings and clicked on Edit Template, opening the template in Word.  I created my template and added the two new columns to the document.  I did this using the Quick Parts --> Document Property --> [column name] feature under the Insert tab in Word.  I then saved the template back to SharePoint. Upon opening the template or creating a new document from the template, I get the following dialog box: --------------------------- Microsoft Office InfoPath --------------------------- One or more ActiveX controls could not be displayed because either: 1) Your current security settings prohibit running ActiveX controls on this page, or 2) You have blocked a publisher of one of the controls. As a result, the page might not display correctly. --------------------------- OK   --------------------------- I've searched around (I believe fairly extensively) and have not run into anyone else with the same issue.  Some have mentioned a similar error when creating a custom document information panel in InfoPath, and suggested lowered ActiveX security setti

activeX error when starting a workflow from inside Microsoft Word

  
Hello,

I have a Word 2007 document hosted on a local intranet SharePoint 2007 Server.
When i open the document inside Word 2007 and start a Collect Signature workflow (the word document has some signature lines included), the following ActiveX error si thrown:

---------------------------
Microsoft Office InfoPath
---------------------------
One or more ActiveX controls could not be displayed because either:

1) Your current security settings prohibit running ActiveX controls on this page, or
2) You have blocked a publisher of one of the controls.

As a result, the page might not display correctly.
---------------------------
OK 
---------------------------

I managed to find out that the error is generated because of the security level regarding ActiveX controls set on the INTERNET zone.
In the internet zone, all ActiveX controls are restricted to run, but in the LOCAL INTRANET zone are allowed.
Our company security policy does not permit changing the ActiveX settings in INTERNET zone.

If i navigate to the sharepoint site in Internet Explorer, the site is seen correctly in the LOCAL INTRANET zone

Can somebody give me a solution to be able to start the workflow process, without modifing security settings on the internet zone and without upgrading to O

Word Web App cannot open this document for viewing because of an unexpected error.

  

 

We configured and enabled the Office Web Apps and we were able to open documents in browser. But since last week we are unable to open documents in browser.   

I am getting this error:

Word Web App cannot open this document for viewing because of an unexpected error.

I went through Troubleshooting steps on this document http://technet.microsoft.com/en-us/library/ff431687.aspx#bkmk_trblshoot and could not find the problem.

Word Web App cannot open this document due to an unknown error. If the problem persists, try opening

  
Word Web App cannot open this document due to an unknown error. If the problem persists, try opening the file in Microsoft Word.

Can anybody pls help me how to resolve this for which got strucked !!!!

 

Cheers !!

Praveen


Thanks in Advance !!! Cheers !!! Praveen

Word Web App cannot open this document due to an unknown error. If the problem persists, try opening

  

Word Web App cannot open this document due to an unknown error. If the problem persists, try opening the file in Microsoft Word.

Hii ,

Can anybody pls help me how to resolve the above Error am getting in Sharepoint Foundation with the use Office WebApps installed on the same development server,when Opening a word document after it got created.

 

 

 

 

 


Thanks in Advance !!! Cheers !!! Praveen Mandalapu

Error When a Word Document is displayed in WebBrowser Control

  

Hi,

We are using a WebBrowser control to display an MS Word document in a form. This was working fine for a long time, and now we tried to install this application in a new server. Now we are facing an issue. When we try to open the word document by using WebBrowserControl.Navigate method, it is asking the Open/Save dialog box, which is typically displayed when we download a file. Then if the user clicks on Open button, we are getting an error "Windows cannot find 'UsersTempFolder\1\Temp\MyDoc.DOCX'. Make sure you typed the name correctly, and then try again. To search for a file, click the Start button, and then click Search.". Please note that UsersTempFolder\1\Temp\MyDoc.DOCX is NOT the path I have given in Navigate method. Also, if I click Save in open/save dialog box, I can save to a location and open it.

I don't have direct access to this server, but if I can believe the words of support person, every configuration is set same as our old server. Here is the details.

.NET Framework 3.0

MS Office 2003

Internet Explorer 6 SP2.

Could any one please help me to solve this issue? Any help is very much appreciated. Please let me know if you need any other details.

Thanks,

Kishore


Word 2010 error when opening as content type from SP

  

Hi,

I have a document library in WSS3 with a custom content type I've created.

I just upgraded to Office 2010 and since then, each instance I'm creating from the DL, work freezes and closes.

Any thoughts?

Thanks in advance


Word Export error when orientation is Landscape in SSRS 2008

  

Hi there,

        I have created a report in SSRS 2008, In the report properties I have selected Orientation as Landscape but when i Export the report to Word it prints the report on middle of the page and cuts the rest of the report.

Urgent help is needed!!!


Error trying to upload word .doc document to Sharepoint 3.0 Exception occurred. (Exception from HRES

  
We have recently moved our shrepoint WSS 3.0 site to a new server running WSS3.0 on Server 2008 R2. Since the migration everything is as it was and working ok execpt we are now unable to upload word .doc files to the site. When we try to attach a .doc file we get :

Error - Exception occurred. (Exception from HRESULT: 0x80020009 (DISP_E_EXCEPTION))

Other file types ie .pdf .ptxt etc can be uploaded ok but .doc fails. I have checked blocked file types in Central administration but .doc isn't listed.

Any ideas.

Thanks in advance
James

Error when saving file from Word: This file cannot be saved because some properties are missing or

  

I am receiving an error when trying to save a file from Word into SharePoint: "This file cannot be saved because some properties are missing or invalid"

I have got two different Content Types for this Document Library: "Policies" and "Procedures". Both documents have got exactly the same required fields, all required fields are displayed in the Document Information Panel. If I try to save a "Policy" the saving process works fine, if I try to save a "Procedure" I get the above error.

It's as if the Procedure had an additional required field, but I cannot figure out where that would come from? If I go to manage the Content Types and check the list of fields, I can clearly see which fields are required and which aren't.

Is there something I am missing? Or could one Content Type be corrupt? If so, how do I fix it without messing up all the files that have already been posted using this Content Type?


Word Web App encountered an unexpected error. (SSL Site)

  

I have SharePoint 2010 set to https://sharepoint.domain.com as the default AAM (with the intranet one being http://ny-sp-01) and I'm running into SSL/mixed content issues when trying to use the Word editor (I'm in IE9, but that shouldn't matter).  I'm accessing the site using https://sharepoint.domain.com.

When I go to edit a document in word, I get the following error:

Word Web App encountered an unexpected error.
Digging deeper with the F12 tools, I see HTTPS errors:
  SEC7111: HTTPS security is compromised by about:/_layouts/inc/1033/WordViewer/wordbgx.png?bn=1447611000  Test.docx&Source=https%3A%2F%2Fsharepoint%2Enovotny%2Eorg%2Fmy%2Fpersonal%2Foren%2Fdefault%2Easpx&DefaultItemOpen=1
  SEC7111: HTTPS security is compromised by about:/_layouts/inc/1033/WordViewer/wordbgx.png?bn=1447611000  Test.docx&Source=https%3A%2F%2Fsharepoint%2Enovotny%2Eorg%2Fmy%2Fpersonal%2Foren%2Fdefault%2Easpx&DefaultItemOpen=1
  SEC7111: HTTPS security is compromised by about:/_layouts/inc/1033/WordViewer/wordbgx.png?bn=1447611000  Test.docx&Source=https%3A%2F%2Fsharepoint%2Enovotny%2Eorg%2Fmy%2Fpersonal%2Foren%2F

wss 3.0 error when indexing event id 10036

  

after some minutes having started the search engine against a new search database we detect the above error into the event viewer:

category: Gatherer

event id: 10036

database error occurred source: Microsoft OLE DB provider for SQL Server Code: 0 occurred 17 time(s) Descrtiptio: Unspecified error context Appplication search index file on the search engine.

Into the wss log file we have the following messages:

CSqlCrawl::ExecuteCommand fails Error 0x80004005 - file:d:\office\source\search\search\gather\server\gathersql.cxx Line:407 Dumping error record [0]:   Source: Microsoft OLE DB Provider for SQL Server   HRESULT: 0x80004005   Code: 0   Description: Unspecified error - File:d:\office\source\search\common\pkmutild\atldbext.cxx Line:1250 

Does anbody can help?


Categories: 
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