Clarity PPM: Unable to Create Requisitions - System Error. Contact System Administrator

Products

• Clarity PPM SaaS

Issue/Introduction

When creating requisitions from the Project > Team > Actions > Create Requisitions

The following error appears:

System error. Contact System administrator.

Cause

There is a sequencing issue per the APP logs:

ERROR 2020-06-15 08:21:14,054 [http-nio-14001-exec-14] niku.xql2 (clarity:claritysupport:<session>:resource.teamCreateRequisitionsSubmitAndClose) Internal Processing exception
java.lang.Exception: Failure while evaluating "getAutoNumber('requisition')" in expression "{getAutoNumber('requisition')}" error: Invalid expression getAutoNumber('requisition'): SCHEME_EXHAUSTED
 at com.niku.xql2.XQLVisitor.process(XQLVisitor.java:1295)
 at com.niku.xql2.XQLVisitor.process(XQLVisitor.java:1338)
 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.MatchHandler.preProcess(MatchHandler.java:129)
 at com.niku.xql2.XQLVisitor.preProcess(XQLVisitor.java:1383)
 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.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:1383)
 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.traverse(DOMWalker.java:36)
 at com.niku.xql2.XQLProcessor.process(XQLProcessor.java:257)
 at com.niku.xql2.XQLProcessor.process(XQLProcessor.java:283)
 at com.niku.xql2.binding.ServiceControlBindingXql.processFile(ServiceControlBindingXql.java:390)
 at com.niku.xql2.binding.ServiceControlBindingXql.getDocument(ServiceControlBindingXql.java:273)
 at com.niku.xql2.binding.ServiceControlBindingXql.processRequest(ServiceControlBindingXql.java:157)
 at com.niku.union.service.ServiceControlImpl.processRequest(ServiceControlImpl.java:914)
 at com.niku.union.service.ServiceControlImpl.processRequest(ServiceControlImpl.java:212)
 at com.niku.union.web.WebServiceAdapter.processRequest(WebServiceAdapter.java:219)
 at com.niku.union.web.PortletController.processServiceRequest(PortletController.java:1431)
 at com.niku.union.web.PortletController.processProcessActionRequest(PortletController.java:235)
 at com.niku.union.web.PortletController.processRequest(PortletController.java:162)
 at com.niku.union.web.WebActionController.processAction(WebActionController.java:1460)
 at com.niku.union.web.WebActionController.processRequest(WebActionController.java:189)
 at com.ca.clarity.uif.service.vxml.VXMLService.processRequest(VXMLService.java:453)
 at com.ca.clarity.uif.UIServlet.service(UIServlet.java:78)
 at javax.servlet.http.HttpServlet.service(HttpServlet.java:742)
 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231)
 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
 at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
 at com.niku.union.web.filter.ResponseHeaders.doFilter(ResponseHeaders.java:73)
 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
 at com.niku.union.web.filter.ResponseSecurityHeaders.doFilter(ResponseSecurityHeaders.java:158)
 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
 at com.niku.union.web.filter.ClarityContentFilter.doFilter(ClarityContentFilter.java:153)
 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
 at com.niku.union.web.filter.XSSFilter.doFilter(XSSFilter.java:88)
 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
 at com.niku.union.web.filter.GZIPResponseFilter.doFilter(GZIPResponseFilter.java:138)
 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
 at com.niku.union.web.filter.TenantSetupFilter.doFilter(TenantSetupFilter.java:55)
 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
 at com.niku.union.web.filter.CharsetFilter.doFilter(CharsetFilter.java:45)
 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
 at org.apache.catalina.filters.AddDefaultCharsetFilter.doFilter(AddDefaultCharsetFilter.java:89)
 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
 at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:198)
 at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96)
 at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:493)
 at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:140)
 at com.niku.union.web.valves.ErrorPageRedirectValve.invoke(ErrorPageRedirectValve.java:63)
 at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:650)
 at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87)
 at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:342)
 at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:800)
 at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66)
 at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:806)
 at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1498)
 at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
 at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128)
 at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628)
 at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
 at java.base/java.lang.Thread.run(Thread.java:834)
Caused by: java.lang.Exception: Invalid expression getAutoNumber('requisition'): SCHEME_EXHAUSTED
 at com.niku.xql2.XQLVisitor.eval(XQLVisitor.java:1132)
 at com.niku.xql2.XQLVisitor.eval(XQLVisitor.java:1058)
 at com.niku.xql2.XQLVisitor.process(XQLVisitor.java:1290)
 ... 80 more
Caused by: com.niku.odf.object.autonumbering.AutoNumberLimitReachedException: SCHEME_EXHAUSTED
 at com.niku.odf.object.autonumbering.AutoNumberGenerator.getNextNumber(AutoNumberGenerator.java:328)
 at com.niku.odf.object.autonumbering.AutoNumberGenerator.getNextNumber(AutoNumberGenerator.java:435)
 at com.niku.odf.object.autonumbering.AutoNumberGenerator.getNextNumber(AutoNumberGenerator.java:412)
 at com.niku.odf.object.xbl.GetAutoNumber.eval(GetAutoNumber.java:76)
 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:1084)
 ... 82 more

Resolution

The auto-numbering will need to be modified/auto-extended.