Percent sign in map service breaks Search widget.

[VenusScott]

Percent sign in map service breaks Search widget. I used the "Add Data" button in ArcMap but the service still generates a % sign in the joined table name? Suggestions on how to avoid or remove it?

I hate this FB format . . .

[VenusScott · Accepted solution]

Well I guess this is a know BUG. No estimate on when fix will be included.

I ended up creating an Oracle view of all the data needed and just used the view in the map so I didn't have the "join" problem.

[TobiasFimpel1]

Another similar workaround is using arcmap query layer.

[JasonSchwartz]

This problem still exists in 10.3.1 (Desktop and Server) and Oracle Views don't always fix the problem.  I'm going to try the 'query layer' approach to see if it more consistently fixes it.

(wish me luck, then hold your breath)

[BushtelAdmin]

I don't suppose you recall the bug number?

[VenusScott]

Sorry, no I don't.

[SimonSchütte_ct · Accepted solution]

A workaround is described here: https://support.esri.com/en/Technical-Article/000001137

The bug is logged here: https://support.esri.com/bugs/nimbus/TklNMDk3MzA4