Since you said it worked the day before with no difference in system change, I am thinking more into data health.
Easiest is to trail back your last data change that you've done via MXLOADER. It may seem to be irrelevant but it really depends to rules within your Maximo. i.e. how WO location tied up with Asset's location, is there any automation script that rule any applications that use Locations. And so on.
Hope this helps in one way or another.
Original Message:
Sent: Tue January 02, 2024 01:05 PM
From: Robert Goff
Subject: Asset/Location drilldown fails to open
Deleting the browser cache was the first thing I did; also, all users are seeing this behavior. Second thing was to revert LIBRARY.XML. Brand-new installation of Firefox has the same behavior.
I also looked at the HTTP request/response and don't see anything glaringly wrong. Does anyone know what it should look like?
------------------------------
Robert Goff
Original Message:
Sent: Tue January 02, 2024 12:33 PM
From: Travis Herron
Subject: Asset/Location drilldown fails to open
Since the old-school drilldown works correctly, I don't think that your hierarchies have health issues. Since the logs aren't logging anything, it's probably not a Maximo issue either. I still say you should try a different, non-Chromium browser; and you should try to access Maximo from outside your corporate network (e.g. via smartphone). Also. . .a tried-and-true troubleshooting step: clear your browser cache.
------------------------------
Travis Herron
Original Message:
Sent: Tue January 02, 2024 11:43 AM
From: Robert Goff
Subject: Asset/Location drilldown fails to open
Nothing in SystemOut, and the vanilla LIBRARY.XML was a bust -- the one I had was fine.
I've done all I can think of to check the health of the location hierarchy; does anyone have any scripts or tips for that?
------------------------------
Robert Goff
Original Message:
Sent: Thu December 21, 2023 04:05 AM
From: Andrey Ilinskiy
Subject: Asset/Location drilldown fails to open
They work absolutely differently - different beans, different logic. External DrillDown is based on lochierachy as top-level object.
And yes, OTB it is only in library.xml.
And do u have anything in SystemOut?
------------------------------
Andrey Ilinskiy
Handz.on
https://www.on.de/
München
Original Message:
Sent: Wed December 20, 2023 05:31 PM
From: Robert Goff
Subject: Asset/Location drilldown fails to open
Out of desperation, I disabled the extended drilldown in system properties, and the old drilldown appeared fine. Still looking for a clean LIBRARY.xml.
(I've only found one drilldown dialog in LIBRARY.xml -- are they both in that one definition, with the difference handled by the bean?)
------------------------------
Robert Goff
Original Message:
Sent: Wed December 20, 2023 09:37 AM
From: Travis Herron
Subject: Asset/Location drilldown fails to open
Additional troubleshooting thoughts/questions:
- What version are you on?
- Which database is this running on?
- How many Location records? Asset records? Location Systems? Are those Location Systems "network" type?
- Is this happening for all users, or just you? (If just you, I'd check your profile and check the box to use the Default Insert Site as a display filter.)
- Try yet another browser, one that's not Chromium-based.
- Are you experiencing this error in all applications, or just, say, Work Order Tracking? I.e., can you open the drilldown on the Location field in the Asset application, or the PM application?
- When you try to open it, are you opening it with the field blank? If so, what happens if you have a value in the field and then try to drilldown? For example, assuming you have a fairly-common location hierarchy consisting of building --> floor --> room, put a valid floor value in the Location field and then try to drilldown (instead of starting at the top of the hierarchy). Or another way to test this -- go to Assets, choose an Asset that has a Location value, and try to open the drilldown on the Location field.
- Do you have the ability to directly query the database? If so, maybe we here in the community could come up with some simple error-checking queries. IMO the most likely source of the problem is bad data, as the others have said -- invalid characters, something is wrong in the LOCANCESTOR or LOCHIERARCHY tables, etc.
- Could someone have done a back-end database UPDATE, INSERT, or DELETE?
- Check your LIBRARY.XML for invalid syntax.
- We might have to also check the MAXRELATIONSHIP table to see if any of the relationships to the DRILLDOWN object have been changed or deleted.
And of course, as Juris said, if it used to work but now it doesn't, ask "what changed?"
------------------------------
Travis Herron
Original Message:
Sent: Tue December 19, 2023 12:19 PM
From: Robert Goff
Subject: Asset/Location drilldown fails to open
I'm trying to find a starting point to troubleshoot this problem. The asset/location drilldown will no longer open. There's no error message, simply a brief "busy" cursor and then nothing. This happens from the More Actions menu or from a detail menu, and I've found no relevant messages in SystemOut or SystemErr. I also checked the javascript console, but nothing at all appears there.
I restarted the Maximo server, the browser, cleared browser data, used both Chrome and Edge. Does anyone have any other ideas? Thanks.
------------------------------
Robert Goff
------------------------------