Cannot maintain the organizations registered on my APIs portal (version 3.5) in CMS

book

Article ID: 196445

calendar_today

Updated On:

Products

CA API Developer Portal

Issue/Introduction

in CMS one can create a new organization, but the list remains empty. One can only see organizations on the Dashboard (http://apiportal.local/dashboard/organizations)
However, on the Dashboard there is complete management of the organization (one can only change the name and description). To delete it, one can only do it through the screen http://apiportal.local/admin?action=UA-list-organizations

 

catalina out log shows java issue : 


 Size:315b Type:text/html Total Time:3783 ms (3783,0,0)
07/27 12:03:21.774  INFO (http-nio-37080-exec-6:) - [AdminProcessor general] -- AdminProcessor - action:  UA-home
07/27 12:03:21.844  INFO (http-nio-37080-exec-6:) - [AdminXSLTHelper general] -- path=/user-admin.xsl
07/27 12:03:22.135 DEBUG (http-nio-37080-exec-6:) - [XSLTUtil general] -- XSLTUtil.translate: XSLT in:72112 out:49965 time: 22 ms.
07/27 12:03:22.469 DEBUG (http-nio-37080-exec-4:) - [SiteServlet timings] -- Served /system_images/icons/calendar.gif (PUBLISHED - en)
   Size:753b Type:image/gif Total Time:4 ms (0,4,0)
07/27 12:03:24.030  INFO (http-nio-37080-exec-5:) - [AdminProcessor general] -- AdminProcessor - action:  UA-list-organizations
07/27 12:03:24.033 ERROR (http-nio-37080-exec-5:) - [AdminProcessor general] -- java.lang.NullPointerException
 at java.base/java.util.Hashtable.put(Hashtable.java:475)
 at org.apache.ecs.ElementAttributes.addAttribute(ElementAttributes.java:279)
 at com.thelevel.cms.users.AdminProcessor.displayOrganizations(AdminProcessor.java:153)
 at com.thelevel.cms.users.AdminProcessor.processRequest(AdminProcessor.java:108)
 at com.thelevel.cms.admin.AdminServlet.processRequest(AdminServlet.java:2014)
 at com.thelevel.cms.admin.AdminServlet.instrumentRequest(AdminServlet.java:314)
 at com.thelevel.cms.admin.AdminServlet.doGet(AdminServlet.java:267)
 at javax.servlet.http.HttpServlet.service(HttpServlet.java:634)
 at javax.servlet.http.HttpServlet.service(HttpServlet.java:741)
 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:53)
 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
 at com.thelevel.cms.admin.JSONFilter.doFilter(JSONFilter.java:40)
 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
 at com.thelevel.lrs.JForumFilter.doFilter(JForumFilter.java:108)
 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
 at com.thelevel.cms.identity.AuthFilter.doFilter(AuthFilter.java:106)
 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
 at org.picocontainer.web.PicoServletContainerFilter.doFilter(PicoServletContainerFilter.java:74)
 at com.thelevel.cms.CMSBootstrapper$ServletFilter.doFilter(CMSBootstrapper.java:648)
 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:202)
 at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96)
 at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:541)
 at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:139)
 at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92)
 at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74)
 at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343)
 at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:373)
 at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65)
 at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:868)
 at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1590)
 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:835)

Environment

Release : 3.5

Component : API PORTAL

Resolution

There is an organization with a null name in the database.

go to portal DB

update lrs.cmsorganization set description = 'null' where description is null;


reboot 

 

organization list should show again 

Additional Information

I cannot maintain the organizations registered on my APIs portal (version 3.5). When clicking on the URL below the list of organizations is not displayed. 
I can still register a new organization, but I can't change / delete the existing ones

http://apiportal.local/admin?action=UA-list-organizations