Aras V12SP9 Error

Hi Schauhan, 

have you fixed this one already? I sometimes see this error, mainly after customizing CUI elements in a wrong way.

Hi Angela,

I have not been able to find any fix. You might be right that this error is somehow related to customizing CUI elements. I remember one time trying to customize banner logo.

-Sam

This CBS is ultimately using method cui_init_mwh_action_menu_button

I have not been able to solve this problem.  The real problem is that the UI freezes out after error is dismissed so I can't do anything through Aras.  I need to modify the database in some way to fix it but I can't figure out how.

Does the error appear as soon as you start up Aras or only when you try to open a specific item/itemType?

When the error occours only for a specific item, a custom Action or CUI element assigned to the ItemType can cause the error. When error appears every item, try if the browser debugger shows any hint regarding the initial trigger.

Edit: Regarding database. Make a SQL view to list last modified CommandBarSectionItems. This maybe helps to identify the problematic element.

The error appears right after login.  It takes 4 clicks to finally dismiss the error message windows while the background get brighter with each click.  When the error is finally gone, the Navigation button looks grayed out (see the attached picture) and nothing in the user interface works including the user menu.  The only way out is to kill the browser window.  So it seems that this error occurs when Aras is half way through rendering the main UI.  The message says it is a client side error but it is not related to corrupted code tree.  It seems to be a problem with this particular database. 

I this really how far it loads? So just nav button and logo? This one requires a Sherlock Holmes / Miss Marple style investigation. There are many suspects. 

1. Do you still see the notification button and user button in the top right corner? This would be a very important hint!

2. Do you get a different result when login with an different user? Try Super User, Authentication Admin (has pretty no much rights regarding UI!) and one of the regular users you might have. 

3. Do you get some additional error messages in the browser console?

4. In your case it doesn´t even load the stylesheet. Did you modify any stylesheet in the codetree?

5. The top right button contains a Action and Report section (these may reference to your error message). Do you remember if you have tried to add custom Action and Reports beside your attempts to change the logo?

If a CUI element blocks the main page from being loaded, you can try this SQL query to detect modified CUI elements that are used in the main window header. Execute the query on your corrupted db and in parallel a working db to see the difference. Check if amount of rows is the same and if certain entries have changed. The modified_on date column can help.

SELECT        TOP (100) PERCENT innovator.COMMANDBARSECTIONITEM.SORT_ORDER, innovator.COMMANDBARSECTIONITEM.ACTION, COMMANDBARITEM_1.NAME, COMMANDBARITEM_1.MODIFIED_ON, 
                         COMMANDBARITEM_1.MODIFIED_BY_ID, innovator.COMMANDBARSECTIONITEM.MODIFIED_ON AS Expr1, innovator.COMMANDBARSECTIONITEM.MODIFIED_BY_ID AS Expr2
FROM            innovator.COMMANDBARSECTIONITEM INNER JOIN
                         innovator.COMMANDBARITEM AS COMMANDBARITEM_1 ON innovator.COMMANDBARSECTIONITEM.RELATED_ID = COMMANDBARITEM_1.ID
WHERE        (COMMANDBARITEM_1.NAME LIKE N'%cui_default.mwh%')
ORDER BY innovator.COMMANDBARSECTIONITEM.SORT_ORDER

In my example you can see a changed header logo, as modified_on and modified_by_id (custom admin account...) are different to the other data:

Here's the complete screenshot after dismissing the error.  Although user button on the right side is there it is non responsive along with all other UI elements.  Logging in as admin or root user does not make any difference. The problem is local to the database because the same database on different installs give the same error and a different database on the same computer works fine.  I will search the database for any custom modifications in command bar items.  Do you know which tables I should be looking closely at?

Thanks. 

Which Innovator version are you using? I am a bit confused by the white nav button. This is neither typical for 12SP9 nor Release 2023.

Do you have tested a user that is not admin or root? Admin and root are power users that display nearly everything.  As mentioned before, try "authadmin", cause this one has far less rights regarding the client interface. This user uses only a small number of CUI elements. If the UI works for authadmin it indicates that elementary CUI works and the error is located on a specific induvial ItemType.

In addition, don´t forget to check your browser debugger console (F9!) when starting innovator for any helpful error message.

To find your root cause, you can modify the above SQL query to investigate the CUI on a more general level:

E.g. following query will list all CUI elements but shows the latest modified one first.

SELECT        TOP (100) PERCENT innovator.COMMANDBARSECTIONITEM.SORT_ORDER, innovator.COMMANDBARSECTIONITEM.ACTION, COMMANDBARITEM_1.NAME, COMMANDBARITEM_1.MODIFIED_ON, 
                         COMMANDBARITEM_1.MODIFIED_BY_ID, innovator.COMMANDBARSECTIONITEM.MODIFIED_ON AS Expr1, innovator.COMMANDBARSECTIONITEM.MODIFIED_BY_ID AS Expr2
FROM            innovator.COMMANDBARSECTIONITEM INNER JOIN
                         innovator.COMMANDBARITEM AS COMMANDBARITEM_1 ON innovator.COMMANDBARSECTIONITEM.RELATED_ID = COMMANDBARITEM_1.ID
ORDER BY COMMANDBARITEM_1.MODIFIED_ON DESC

If a modified CUI element causes your problem, you maybe can identify the corrupted one with this query.