Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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?
0683p000009MBOJ.png
Labels (4)
3 Replies
Anonymous
Not applicable
Author

Hi 
Do you check the 'Use an existing connection' box on tMssqlRow? Can you upload a screenshot of basic settings of tMssqlRow?
Regards
Shong
Anonymous
Not applicable
Author

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"%> 
   
0683p000009MBz7.png 0683p000009MBzC.png 0683p000009MBoB.png
Anonymous
Not applicable
Author

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