DEVELOPERS FORUM - Facing 'Invalid Search Criteria' with the new installtion

ransok - Wednesday, September 16, 2015 11:08 AM:

Hi,

I have installed Aras Innovator 11 on a new server, details of the server are:

OS: Windows Server 2008 R2 Standard Service Pack 1

Type : 64-bit

SQL Server : 2012

Installation went smoothly, but when I login into InnovatorSolutions and try to open an ItemType by giving a value into search grid, I faced 'Invalid Search Criteria'.  Irrespective of the whatever the value that I put in search column I am facing this error.

The same error is being thrown all over the application across all items. 

Without having a working Search functionality we could not move forward. Please help us in solving this issue.

Thanks you.

DavidSpackman - Wednesday, September 16, 2015 9:51 PM:

Do  you have the same problem with Internet Explorer?

ransok - Thursday, September 17, 2015 8:01 AM:

Hi David, Yes I'm facing the same problem with Internet Explorer also. Could you please suggest a solution for this

Thank you.

DavidSpackman - Thursday, September 17, 2015 7:02 PM:

Sorry I haven't seen this problem before.

I would try uninstall / reinstalling Aras again

AbhishekSrivastava - Tuesday, December 1, 2015 11:28 PM:

Hello friends ,

I reinstall the aras innovator but again and again problem comes when i use search

Invalid search crieteria .

Anyone has the solution then kindly share me .

Thanks

Abhishek Srivastava

tstickel - Wednesday, December 2, 2015 8:45 AM:

Did you try clearing all search criteria (using the red-x search icon) and then entering your search criteria?  Maybe there is an existing search criteria that is not immediately visible.

AbhishekSrivastava - Saturday, December 5, 2015 4:26 AM:

Yes i tried but again facing the same issue.

tstickel - Saturday, December 5, 2015 4:35 PM:

Have you tried using % as a wildcard instead of *.  Does this problem occur if you do not use any wildcard?

I don't have an answer, but I ran a search where I set the search criteria as ~||

It results in getting the same error pop-up that you are getting, which is not surprising.  I then looked at the Innovator/Innovator/Client/javascript folder and found the search_grid.js file.

Here is a code snipet from search_grid.js, where I have added an alert statement:

 var criteria = this.inputRow.get(field, "value");
 var useWildcards = (aras.getPreferenceItemProperty("Core_GlobalLayout", null, "core_use_wildcards") == "true");
 var condition = (useWildcards ? "like" : "eq");
 var forceSearch = inputCell.forceSearch;
 inputCell.forceSearch = false;
 var propDef = searchContainer.getPropertyDefinitionByColumnIndex(columnIndex);
 var propXpath = searchContainer.getPropertyXPathByColumnIndex(columnIndex);
alert("Here" + criteria + condition);
 if (currentSearchMode.setSearchCriteria(propDef, propXpath, criteria, condition)) {
  inputCell._lastValueReported = inputCell.get("value");
 } else {
  inputCell._lastValueReported = "";
  if (aras.confirm(aras.getResource("", "search.invalid_criteria"))) {
  inputCell.focus();
  } else {
  currentSearchMode.removeSearchCriteria(propXpath);
  this.inputRow.set(field, "value", "");
  }
 }


It is the statement after the alert statement that will trigger the Invalid Search Criteria pop-up if currentSearchMode.setSearchCriteria returns a Null object.  If you are familiar with Javascript and using the Internet Explorer Developer tool (or FireFox) for client-side debugging you might be able to determine what causes setSearchCriteria to return a Null object when you do a search.

Disclaimer, I am sure that Aras would strongly recommend against modifying search_grid.js, even just temporarily for analyzing this problem.  So do this at your own risk (I would do this in a separate Testing Innovator installation).

AbhishekSrivastava - Monday, December 7, 2015 6:09 AM:

Hi tstickel,

Thank you for your reply i will try this,

Regards

Abhishek Srivastava

Harsha - Monday, December 7, 2015 8:36 AM:

Hi,

If you are facing this error irrespective of the value/wildcard that you put in search criteria, then check whether the required Roles in Server Manager are installed or not.

Once we were facing this issue, installing 'Windows Authentication' found under Security of Server Manager solved the problem. If this doesn't solve then check for ASP and ASP.NET 4.5 too.

Thank you
Harsha

Plural - Wednesday, March 23, 2016 4:08 AM:

Hello,

We are facing the same issue but unable to get through, can someone explain troubleshooting steps.

Thanks,

Jayraj

PCA33507 - Wednesday, September 7, 2016 4:12 PM:

Hello Harsha.

I'm facing this same issue, do you have any advice on how to fix this?

-John

jayrajvh - Friday, September 9, 2016 6:30 AM:

Hello John,

This error typically means that IIS was not installed with all required role services.

PCA33507 - Friday, September 9, 2016 9:40 AM:

Hello Jayraj,

This worked!  Thank you.  We had everything set up correctly and all we had to do was run the last command you mentioned and it all works now.  Thank you, it is greatly appreciated.  

-John