Getting ORA-01795 when editing a DDM structure

Issue

• I'm trying to edit an DDMStructure and I got the error :
  => Edit xxx is temporarily unavailable.

  If I look at the logs I see this error :
  Caused by: java.sql.SQLSyntaxErrorException: ORA-01795: maximum number of expressions in a list is 1000_ [Sanitized]

Environment

• 7.1

Resolution

• There are probably more than 1 000 past versions of that structure (it must have been updated so many times)
• you can double-check by getting the structure ID from the UI and running a query like this on the database:

SELECT count(*) FROM DDMSTRUCTUREVERSION WHERE STRUCTUREID =<ID>;

• see if you can remove some older versions of the structure or contact support for further options
• https://help.liferay.com/hc/en-us/articles/8619637336333-For-Oracle-Database-users-ORA-01795-appears-while-reindexing might also help (not confirmed)