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?
3 REPLIES
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