OWB: Unable to open project 165992. An exception occured: java.lang.ClassCastException: com.abtcorp.hub.ABTErrorHub cannot be cast to com.abtcorp.hub.IABTObject.
One or more resources have been removed from the project, but still have assignments.
Run the following query to find the resources, then add them back on the team through Clarity.
select invi.code as project_id
, invi.name as project_name
, srmr.unique_name as resource_id
, srmr.last_name as resource_last_name
, srmr.first_name as resource_first_name
, srmr.email as resource_email
from inv_investments invi
join prtask prta on prta.prprojectid = invi.id
join prassignment pras on pras.PRTASKID = prta.prid
join prteam prte on prte.PRPROJECTID = invi.id
join srm_resources srmr on srmr.id = pras.PRRESOURCEID
and srmr.id not in
from inv_investments invi2
join prtask prta2 on prta2.prprojectid = invi2.id
join prassignment pras2 on pras2.PRTASKID = prta2.prid
join prteam prte2 on prte2.PRPROJECTID = invi2.id
join srm_resources srmr2 on srmr2.id = prte2.PRRESOURCEID
where invi.code = invi2.code
group by invi.code
Keywords: CLARITYKB, OWB, Unable, Open, Error, exception, occurred, java.lang.ClassCastException.