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: 
carlrees123
Contributor
Contributor

"Parameter (Component List) is empty but is required"

hey

 

No documents returned on this Talend error within search or google, has it never happened before............. ? REALLY ?

 

Talend website and community search engine break a phrase down into words, not useful when searching for this error.

 

Full stop on my development . Trying to call a stored proc with parameters, but cant pass params even though defined within a tFixedFlowInput component

because I get the above error (subject line)

attached file shows component list but no walkthrough's on calling stored proc with params, help on error, no,  nothing..... any clues as to what I need to do next?

 

 

Labels (2)
16 Replies
carlrees123
Contributor
Contributor
Author

Ok got you, same in my c# code I can use the sqlConnection driver too.

 

ok so have added mySql connection and tested it "checks" ok.

 

added SubjOk link from there to tMysqlSP component, I have a Component value in the (Component list) dropdown so no more error, yeay.

 

Now how do I connect the contexts (i say variables) to the tMySQLSP component?

 

cterenzi
Specialist
Specialist

The parameters section references "Schema Columns" which means columns from the schema passed by the previous component. If your values are present in that data flow, you just add the number of parameters required by your stored procedure and select them from the drop down lists, specifying whether they're IN, OUT, IN OUT or RECORDSET parameters. It doesn't look like the SP component supports using context variables directly.
Anonymous
Not applicable

I am getting the same error.  I am not using any external procedures, just trying to read a table into a csv file.  I am not clear what you mean by SP component and connection component.

Initially, I set up the Input table by itself and it worked fine.

I then wanted to set the connection once, read in the schemas for the tables and set up queries in the repository and assign them to the database input component. I set up a connection, added two table schemas and two queries... so far so good.  When selected the existing connection in the database component configuration tab, every thing was fine except the component list pull down was empty and had no selections.  When I ran it, it failed because the component list was empty.

Any clarity on what I am missing would be appreciated.

Anonymous
Not applicable

I figured out the problem.  I did not have a database connection component in my job.  When I added it to the job, it appeared in the component list.  I selected it and it worked.

Sorry for the false alarm but it is nice to have a forum to brainstorm with.

Anonymous
Not applicable

Hi,

Great your issue has been fixed. Please mark your topic as resolved.

Best regards

Sabrina

tnewbie
Creator II
Creator II

Hi cjremley,

 

I was facing the same problem and could now solve by including a tDBConnection component...Thanks for posting.

 

Hello Moderator / Talend,

Can we please add this suggestion to the tDBCommit documentation, so that it will be helpful for people, going forward.

Anonymous
Not applicable

Hello @tnewbie 


@tnewbie wrote:

Hello Moderator / Talend,

Can we please add this suggestion to the tDBCommit documentation, so that it will be helpful for people, going forward.


With your requirement, please feel free to create a DOCT jira issue on talend bug tracker.

Best regards

Sabrina