tMSSqlRow has error in Talend 6.1.1

Anonymous — Sat, 16 Nov 2024 10:18:25 GMT

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?

Re: tMSSqlRow has error in Talend 6.1.1

Anonymous — Mon, 24 Oct 2016 07:02:01 GMT

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

Re: tMSSqlRow has error in Talend 6.1.1

Anonymous — Tue, 01 Nov 2016 17:22:44 GMT

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"%>

Re: tMSSqlRow has error in Talend 6.1.1

Anonymous — Wed, 02 Nov 2016 01:49:40 GMT

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

topic tMSSqlRow has error in Talend 6.1.1 in Talend Studio

tMSSqlRow has error in Talend 6.1.1

Re: tMSSqlRow has error in Talend 6.1.1

Re: tMSSqlRow has error in Talend 6.1.1

Re: tMSSqlRow has error in Talend 6.1.1