nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

troubleshoot why a db record not included in SearchWidget results

AshleyOwens

There is a record in our database that does not get returned as part of the SearchWidget results.
In case the number of included records was limited, I increased <maxrecordcount> in the proper .cfg files and restarted the SOM Service.
I debugged SearchWidget, and there is nothing I can see in the query or how results are processed that should prevent it from being included in the results.
On the other hand, the Identify widget returns the details of this record.
I hope my description isn't too vague, but does anyone have any troubleshooting tips for this type of issue?

Vind meer berichten getagd met

Accepted answers

All comments

RobertScheitlin__GISP

Ashley,

Set up a SQL query that searches for that particular ObjectID.

AshleyOwens

OK, I can see what the OBJECTID is for that record in the database. What next?

RobertScheitlin__GISP

Ashley,

What I meant was setup a layer expression in the SearchWidget.xml that is something like OBJECTID = 1

AshleyOwens

I added this custom WHERE clause to SearchWidget.xml:

objectid in (select objectid from ITS_SUBSTATIONS where name='WEST LYONS')

and it returned the record! Any idea why the record would be returned only when explicitly adding a WHERE clause for it??

AshleyOwens

Is there a limit in ArcGIS Server version 9.3 of 1,000 records that can show in a dropdown? What is the limit in version 10?

RobertScheitlin__GISP

Ashley,

I believe it is 500 in 9.3 and has been bumped up to 1000 in 10 but both 9.3 and 10 allow that to be configurable on a individual map service basis. There are LOTS of forum posts about the 500 feature limit and what must be done to change that.

AshleyOwens

I think I know what you're talking about. We changed the <maxrecordcount> value from 2000 to 5000 in our cfg files and restarted services, but some records still don't show. We have less than 3,000 records in our database for this particular object, so I'm still not sure why not all are showing!

RobertScheitlin__GISP

Ashley,

Strange... I would run a check geometry toolbox on the data and see if you have any issues with the data itself.

AshleyOwens

Sorry for the ignorance...how do you "check geometry toolbox on the data"? What tool is used?

RobertScheitlin__GISP

Ashley,

In ArcMap or ArcCatalog open the ArcToolbox window and look for the Data Management Tools then the Features toolbox and then you will find the Check Geometry tool run that on your data.

AshleyOwens

The <maxrecordcount> change works. The widget <layer> wasn't pointing to the correct environment. Lesson learned!

Doe mee aan het gesprek

Aangemelde leden kunnen berichten plaatsen, updates volgen en meer. Nieuw hier? Registreer een gratis account.

Snelle Links

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.