ERROR TalendRemoteServiceServlet  - Null key

Overview

In Talend Administration Center, a page displays Version: Testing...  whereas your license and your token are both valid.

The value of the Schemainformation table in the Talend Administration Center database is also correct and thus corresponds to the version of your product (v5.4.2 for example).

 

Environment

This article applies to all versions of Talend Administration Center, which is the administration console of Talend subscription products.

Symptoms/Description

  • The Database Configuration page hangs on Version: Testing...
  • Your license is valid
  • The temp folder is present in Tomcat
  • If you try to truncate the table license and try to connect again you still have the same issue
  • If you try to click the [Validate your license manually] button, you notice the following exception in the log:
2014-01-07 14:09:31 ERROR TalendRemoteServiceServlet  - Null key.
org.talend.json.JSONException: Null key.
        at org.talend.json.JSONObject.put(JSONObject.java:1052)
        at org.talend.administrator.common.util.token.TokenHttpGetter.removeTasksDetails(TokenHttpGetter.java:227)
        at org.talend.administrator.common.util.token.TokenHttpGetter.getData(TokenHttpGetter.java:165)
        at org.talend.administrator.common.util.token.TokenHttpGetter.getValidationRequest(TokenHttpGetter.java:251)
        at org.talend.gwtadministrator.server.common.LoginServiceImpl.generateValidationRequest(LoginServiceImpl.java:270)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:597)

 

Resolution

To resolve the problem, please first check the content of the table executiontask in the Talend Administration Center database by executing this query:
select id, label, applicationtype, dtype from executiontask where dtype="ExecutionTask";

Check the values in the applicationtype column.
 
For a Job created with the Job Conductor, the value should be JOB for all lines in the applicationtypecolumn.
If you have some null  values, execute the following query to update the table executiontask:
 
update executiontask set applicationtype="JOB"

Save the database parameters again in the Database configuration page to solve the problem.

 

Version History
Revision #:
1 of 1
Last update:
‎05-11-2017 09:10 PM
Updated by:
 
Labels (1)
Contributors