Getting ORA-01795 when editing a DDM structure

Legacy Knowledge Base

Published Jun. 30, 2025

Getting ORA-01795 when editing a DDM structure

Written By

Sorin Pop

Legacy Article

You are viewing an article from our legacy "FastTrack" publication program, made available for informational purposes. Articles in this program were published without a requirement for independent editing or verification and are provided"as is" without guarantee.

Before using any information from this article, independently verify its suitability for your situation and project.

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

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>;