Deleting of records on the Project Team via XOG / OWB / MSP throws “PRTeam not in table list” error
search cancel

Deleting of records on the Project Team via XOG / OWB / MSP throws “PRTeam not in table list” error

book

Article ID: 385883

calendar_today

Updated On:

Products

Clarity PPM On Premise Clarity PPM SaaS

Issue/Introduction

Removing any team records with process XOG or with schedulers is not working and throwing an error PRTeam not in table list. This also happens when replacing a role

  1. Create a small project in Clarity and assign one role to the team
  2. Open the project in OWB 
  3. Now delete the resource or role in OWB
  4. Try to save the project back to Clarity 
  5. XOG out the project
  6. XOG it back in with delete="true" in the Resources tag in XOG

Expected Results: The changes to be saved back to Clarity for both OWB/XOG

Actual Results: Error message is thrown:

Unable to save project CA PPM\XXXXXX. An error occurred while trying to save your project: java.lang.Exception: TableMetaInfo: PRTeam not in table list

XOG exception:

java.lang.Exception: TableMetaInfo: PRTeam not in table list
    at com.niku.schedulers.util.NikuTableInfo.getMetaInfo(NikuTableInfo.java:50)
    at com.niku.schedulers.util.NikuTableInfo.has_PK_ID(NikuTableInfo.java:66)
    at com.niku.schedulers.util.NikuTableInfo.getIDfield(NikuTableInfo.java:56)
    at com.niku.schedulers.jdbc.SIRecord.doDelete(SIRecord.java:175)
    at com.niku.schedulers.rules.NikuBaseRule.onDelete(NikuBaseRule.java:223)
    at com.niku.schedulers.rules.NikuPRJRule.onDelete(NikuPRJRule.java:342)
    at com.niku.schedulers.rules.NikuTeamRule.onDelete(NikuTeamRule.java:1164)
    at com.niku.schedulers.jdbc.SIRecord.delete(SIRecord.java:240)
    at com.niku.schedulers.server.SetProject.deleteTeam(SetProject.java:2589)
    at com.niku.schedulers.server.APISetProject.processRow(APISetProject.java:276)
    at com.niku.schedulers.server.APISetProject.process(APISetProject.java:174)
    at com.niku.schedulers.api.XOGProjectAPI.process(XOGProjectAPI.java:299)
    at com.niku.schedulers.api.XOGProjectAPI.eval(XOGProjectAPI.java:140)
    at com.niku.xql2.eval.XQLFunctionNode.eval(XQLFunctionNode.java:27)
    at com.niku.xql2.eval.XQLEvaluator.parse(XQLEvaluator.java:40)
    at com.niku.xql2.XQLVisitor.eval(XQLVisitor.java:1107)
    at com.niku.xql2.XQLVisitor.eval(XQLVisitor.java:1081)
    at com.niku.xql2.XQLVisitor.process(XQLVisitor.java:1313)
    at com.niku.xql2.XQLVisitor.process(XQLVisitor.java:1346)

Note: this can also occur on deleting assignments with error:

 <Exception><![CDATA[
java.lang.Exception: TableMetaInfo: PRAssignment not in table list
               at com.niku.schedulers.util.NikuTableInfo.getMetaInfo(NikuTableInfo.java:50)
               at com.niku.schedulers.util.NikuTableInfo.has_PK_ID(NikuTableInfo.java:66)

Environment

Clarity 16.3.0 with XOG/MSP/OWB

Cause

DE161858

Resolution

This issue is fixed in:

  • Clarity 16.3.0 Patch 1 (16.3.0.1)
  • Clarity 16.3.1 

Workaround: None

Additional Information

Note: If DE161858 is not addressed in after applying the Patch 1 for Clarity 16.3.0, ensure you download and reapply the latest 16.3.0.1 ISO from our Support Site, dated Feb 13, 2025.