To resolve the issue

[DM_QUERY2_E_TOO_MANY_TYPES_IN_JOIN]error: “Your query has too many types in the FROM clause.”; ERRORCODE: 100; NEXT: null
at com.documentum.fc.client.impl.docbase.DocbaseExceptionMapper.newException(DocbaseExceptionMapper.java:57)

Create Environment Variable

DM_FROM_TYPES_MAX. and set the value to 50 or above. Default value is 20