In TAC, the view "Project References" cannot be displayed

Overview

After a migration of the TAC database, some views are not loaded.

 

Symptoms/Description

Some users have experienced an issue where the TAC "Project References" view cannot be displayed. When trying to display it the screen-dialog remains empty:

 

ProjectReference.jpg

 

In the TAC log files, you can see the following stack:

20YY-MM-dd 11:18:32 ERROR TalendRemoteServiceServlet  - Unexpected exception !!!
java.lang.NullPointerException
        at org.talend.gwtadministrator.server.remoterepositorymgt.services.ProjectServiceImpl.loadReferenceProjectTree(ProjectServiceImpl.java:259)
        at org.talend.gwtadministrator.server.remoterepositorymgt.services.ProjectServiceImpl.getRefProjects(ProjectServiceImpl.java:124)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
        at java.lang.reflect.Method.invoke(Method.java:606)
        at com.google.gwt.user.server.rpc.RPC.invokeAndEncodeResponse(RPC.java:561)
        at com.google.gwt.user.server.rpc.RemoteServiceServlet.processCall(RemoteServiceServlet.java:208)
        at org.talend.gwttoolkit.server.TalendRemoteServiceServlet.processCall(TalendRemoteServiceServlet.java:81)
        at org.talend.gwtadministrator.server.LoggedAndLicenseCheckRemoteServiceServlet.processCall(LoggedAndLicenseCheckRemoteServiceServlet.java:36)
        at com.google.gwt.user.server.rpc.RemoteServiceServlet.processPost(RemoteServiceServlet.java:248)
        at com.google.gwt.user.server.rpc.AbstractRemoteServiceServlet.doPost(AbstractRemoteServiceServlet.java:62)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:641)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:722)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
        at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:224)
        at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:169)
        at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:472)
        at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:168)
        at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:98)
        at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:927)
        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)
        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:407)
        at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:987)
        at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:579)
        at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:309)
        at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
        at java.lang.Thread.run(Thread.java:724)

 

Resolution

The display issue was triggered by an invalid record in the projectreference table.

 

ProjectReference2.jpg

 

SELECT * FROM projectreference     WHERE e_id=35;

For this record, the projectreference_project_e_id field is null/empty.

 

To resolve this issue, you need to update the TAC database directly, and you might need to map the projectreference_project_e_id with the project table to determine the project_id (X) to set.

 

UPDATE projectreference
SET projectreference_project_e_id= X (value to replace)
WHERE e_id = 35

This behavior can occur with the projects, users, project authorizations, and other views depending on which table contains the corrupted record(s).

 

Bookshelf references

You might find more information in our on-line documentation regarding the migration of an existing environment: Configuring session timeout for the Web User Interface.

Version History
Revision #:
7 of 7
Last update:
‎05-17-2017 02:32 AM
Updated by:
 
Labels (1)
Tags (1)