tMSSqlRow has error in Talend 6.1.1

One Star

tMSSqlRow has error in Talend 6.1.1

Hi team,
I am facing an error in tMSSqlRow using Talend 6.1.1. The job executes successfully by performing the query using database selected whereas i see a error in the Talend studio. 
Error is: Parameter (Component List) has a value (XXXX) that doesnt exist anymore
Details about implementation: I have created a custom defined talend component which uses tMSsqlConnection component internally to create a MSSQL connection. I have checked Use a shared connection. The shared connection name is tClientAdminDBConn_1. Query is executed successfully. 
Can you please tell me how to resolve this error?
Community Manager

Re: tMSSqlRow has error in Talend 6.1.1

Hi 
Do you check the 'Use an existing connection' box on tMssqlRow? Can you upload a screenshot of basic settings of tMssqlRow?
Regards
Shong
----------------------------------------------------------
Talend | Data Agility for Modern Business
One Star

Re: tMSSqlRow has error in Talend 6.1.1

Hi,
Please find attached screenshots of my  job. I have created a custom component called tClientAdminDBConnection which uses tMSSqlConnection of talend. MSSql connection is successful and even query is performed successfully. Only pending issue is that Error is displayed in the Talend studio desiger view and also same error is shown in pop up message when building the job
Below is the code snippet of custom component
<%@ jet 
    imports="
        org.talend.core.model.process.INode 
        org.talend.core.model.process.ElementParameterParser 
        org.talend.core.model.metadata.IMetadataTable 
        org.talend.core.model.metadata.IMetadataColumn 
        org.talend.core.model.process.IConnection
        org.talend.core.model.process.IConnectionCategory
        org.talend.designer.codegen.config.CodeGeneratorArgument
        org.talend.core.model.metadata.types.JavaTypesManager
        org.talend.core.model.metadata.types.JavaType
        java.util.List 
        java.util.Map  
    " 
%>
<% 
    CodeGeneratorArgument codeGenArgument1 = (CodeGeneratorArgument) argument;
    INode node1 = (INode)codeGenArgument1.getArgument();
    String cid1 = node1.getUniqueName();  
    String  client_id = (String)ElementParameterParser.getObjectValue(node1, "__CLIENT_ID__");
    String shared_connection_name =  (String)ElementParameterParser.getObjectValue(node1, "__SHARED_CONNECTION_NAME__");
       
       
    node1.getElementParameter("HOST").setValue(cid1+"_host"); 
   node1.getElementParameter("PORT").setValue(cid1+"_port");
  node1.getElementParameter("USER").setValue(cid1+"_username"); 
  node1.getElementParameter("PASS").setValue(cid1+"_password"); 
  node1.getElementParameter("DBNAME").setValue(cid1+"_databasename");
  node1.getElementParameter("SHARE_IDENTITY_SETTING").setValue(false); 
  node1.getElementParameter("PROPERTIES").setValue(cid1+"_properties"); 
  node1.getElementParameter("USE_SHARED_CONNECTION").setValue("true"); 
  node1.getElementParameter("SHARED_CONNECTION_NAME").setValue(shared_connection_name); 
 
  
  node1.getElementParameter("SPECIFY_DATASOURCE_ALIAS").setValue("false"); 
  node1.getElementParameter("DATASOURCE_ALIAS").setValue(cid1+"_datasourceAlias"); 
 
    
     
%>
xxx.PropertyBaseConnectionFactory <%=cid1%>_factory = (xxx.PropertyBaseConnectionFactory)globalMap.get("InfogroupResourcesPool");
    String <%=cid1%>_host=null;
    String <%=cid1%>_port=null;
    String <%=cid1%>_username=null;
    String <%=cid1%>_password=null;
    String <%=cid1%>_databasename=null;
    String <%=cid1%>_properties=null;
    String <%=cid1%>_datasourceAlias=null;
   
     if ( <%=cid1%>_factory != null ) {    
   XXXXX con = <%=cid1%>_factory.establishClientAdminDBConnection(<%=client_id%>);
   
  <%=cid1%>_host = con.getHost();
  <%=cid1%>_port = con.getPort();
  <%=cid1%>_username = con.getUsername();
  <%=cid1%>_password = con.getPassword();
  <%=cid1%>_databasename = con.getDatabaseName();
  <%=cid1%>_properties ="";
  <%=cid1%>_datasourceAlias="";
      
 
       }
      
   <%@ include file="platform:/plugin/org.talend.designer.components.localprovider/components/tMSSqlConnection/tMSSqlConnection_begin.javajet"%> 
   
Community Manager

Re: tMSSqlRow has error in Talend 6.1.1

Hi 
It sounds just be a display issue rather than a compilation error. It is a custom component, so I don't have a clue about the display error, I would suggest you to open a jira issue on our bugtracker.
Regards
Shong
----------------------------------------------------------
Talend | Data Agility for Modern Business

15TH OCTOBER, COUNTY HALL, LONDON

Join us at the Community Lounge.

Register Now

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog

How Media Organizations Achieved Success with Data Integration

Learn how media organizations have achieved success with Data Integration

Read

6 Ways to Start Utilizing Machine Learning with Amazon We Services and Talend

Look at6 ways to start utilizing Machine Learning with Amazon We Services and Talend

Blog