Skip to content
Go to Customer Portal
  • There are no suggestions because the search field is empty.

AE - Internal Server Error when exporting groups from AE Admin.

When attempting to export an xml file containing the datasource groups from AE Administrator, an "Internal Server Error" pops up.

Applies to Versions:
20.4 through 25.2

Resolution:

This issue is caused by orphaned entries left behind from the ae_perms table which holds data regarding group security permissions.

  1. To find the orphaned entries in the ae_perms database table, run this query:
    select * from ae_perms where appid != 0 and appid not in 
    (select appid from ae_apps)

    This will return all appids in the ae_perms table that are pointing to appplications that no longer exist in AE.
  2. Make a note of which appids are listed in the query result.  Delete them from the database.  For example:
    delete from ae_perms
    where appid in (62, 98,99)

The xml export should now complete successfully.