OWB: Unable to open project 165992. An exception occured: java.lang.ClassCastException: com.abtcorp.hub.ABTErrorHub cannot be cast to com.abtcorp.hub.IABTObject.

Products

• Clarity PPM SaaS
• Clarity PPM On Premise

Issue/Introduction

Description

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.

Solution

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.

Environment

Release: NCSVCS05900-8.1-Clarity-Service Connect-for MS-SQL
Component: