Import Financial Actuals Job - Insufficient rights to add/update team record

book

Article ID: 222096

calendar_today

Updated On:

Products

Clarity PPM SaaS Clarity PPM On Premise

Issue/Introduction

 
  • When running Import Financials Actuals job with non-admin account, we have this error.
  • The records are not backported to the projects and do not create the assignments on the project:
ERROR 2021-08-05 11:57:18,095 [Dispatch Import Financial Actuals : [email protected] (tenant=clarity)] xql2.xbl (clarity:XXXXXX:22754767__5543D89E-6D9F-4424-8C50-9BBA42543077:Import Financial Actuals)
****IMPORT WIP ACTUALS: Failed to create assignment for WIP record ID = 8719628ERROR 2021-08-05 11:57:18,137 [Dispatch Import Financial Actuals : [email protected] (tenant=clarity)] xql2.rule (clarity:XXXXXX:22754767__5543D89E-6D9F-4424-8C50-9BBA42543077:Import Financial Actuals) Insufficient rights to add/update team record
ERROR 2021-08-05 11:57:18,137 [Dispatch Import Financial Actuals : [email protected] (tenant=clarity)] niku.xql2 (clarity:XXXXXX:22754767__5543D89E-6D9F-4424-8C50-9BBA42543077:Import Financial Actuals) Invalid record for update.
ERROR 2021-08-05 11:57:18,137 [Dispatch Import Financial Actuals : [email protected] (tenant=clarity)] niku.xql2 (clarity:XXXXXX:22754767__5543D89E-6D9F-4424-8C50-9BBA42543077:Import Financial Actuals) com.niku.xql2.InvalidXQLObjectException: Unable to update record
at com.niku.xql2.jdbc.JDBCRecord.update(JDBCRecord.java:500) at com.niku.projmgr.xql2.functions.wipCreateAssignment.CreateTeam(wipCreateAssignment.java:140) at com.niku.projmgr.xql2.functions.wipCreateAssignment.VerifyTeam(wipCreateAssignment.java:91)
at com.niku.projmgr.xql2.functions.wipCreateAssignment.eval(wipCreateAssignment.java:48)
at com.niku.xql2.functions.BaseFunction.eval(BaseFunction.java:36)
at com.niku.xql2.eval.XQLFunctionNode.eval(XQLFunctionNode.java:27)
at com.niku.xql2.eval.XQLUnaryNode.eval(XQLUnaryNode.java:19)
at com.niku.xql2.eval.XQLEvaluator.parse(XQLEvaluator.java:40)
at com.niku.xql2.XQLVisitor.eval(XQLVisitor.java:1088) at com.niku.xql2.XQLVisitor.eval(XQLVisitor.java:1062)
at com.niku.xql2.XQLVisitor.process(XQLVisitor.java:1294) at com.niku.xql2.XQLVisitor.process(XQLVisitor.java:1342)
at com.niku.union.xml.dom.DOMWalker.preProcess(DOMWalker.java:191)
at com.niku.union.xml.dom.DOMWalker.traverseIntern(DOMWalker.java:74)
at com.niku.union.xml.dom.DOMWalker.traverse(DOMWalker.java:51)
at com.niku.xql2.handlers.LoopHandler.processObject(LoopHandler.java:388)
at com.niku.xql2.handlers.LoopHandler.processSet(LoopHandler.java:259)
at com.niku.xql2.handlers.LoopHandler.preProcess(LoopHandler.java:216)
at com.niku.xql2.XQLVisitor.preProcess(XQLVisitor.java:1387)
at com.niku.union.xml.dom.DOMWalker.preProcess(DOMWalker.java:194)
at com.niku.union.xml.dom.DOMWalker.traverseIntern(DOMWalker.java:74)
at com.niku.union.xml.dom.DOMWalker.traverseIntern(DOMWalker.java:92)
at com.niku.union.xml.dom.DOMWalker.traverseIntern(DOMWalker.java:92)
at com.niku.union.xml.dom.DOMWalker.traverseIntern(DOMWalker.java:92)
at com.niku.union.xml.dom.DOMWalker.traverse(DOMWalker.java:36)
at com.niku.xql2.XQLProcessor.process(XQLProcessor.java:257)
at com.niku.njs.xbl.XBLService.process(XBLService.java:127)
at com.niku.njs.xbl.XBLService.process(XBLService.java:75)
at com.niku.njs.listeners.XBLJob.scheduledEventFired(XBLJob.java:44)
at com.niku.njs.Dispatcher$BGTask.run(Dispatcher.java:746)
at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128)
at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628)
at java.base/java.lang.Thread.run(Thread.java:834)

Cause

Permissions need to be granted

Environment

Release : Any

Component : CLARITY FINANCIAL MANAGEMENT

Resolution

  • This job requires additional rights to post all the data
  • We recommend it to be run with user with admin rights
  • Re-run the job with admin rights and it should post all the data back to the project