WhichProjectBroken.groovy

import com.atlassian.jira.component.ComponentAccessor
import groovy.sql.Sql
import org.ofbiz.core.entity.ConnectionFactory
import org.ofbiz.core.entity.DelegatorInterface

import java.sql.Connection

def projectManager = ComponentAccessor.getProjectManager()
delegator = (DelegatorInterface) ComponentAccessor.getComponent(DelegatorInterface.class)
String helperName = delegator.getGroupHelperName("default");

Connection conn = ConnectionFactory.getConnection(helperName);
Sql sql = new Sql(conn)

def sb = new StringBuffer()

try {
    sql.eachRow("select id from project") {
        if (! projectManager.getProjectObj(it.id as Long)) {
            sb << "project with id ${it.id} seems broken<br>\n"
        }
    }
}
finally {
    sql.close()
}

sb.toString()