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 ( select srmr2.id 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 , invi.name , srmr.unique_name , srmr.last_name , srmr.first_name , srmr.email
Keywords: CLARITYKB, OWB, Unable, Open, Error, exception, occurred, java.lang.ClassCastException.
Release: NCSVCS05900-8.1-Clarity-Service Connect-for MS-SQL