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

Announcements
Qlik and ServiceNow Partner to Bring Trusted Enterprise Context into AI-Powered Workflows. Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

tMSSqlSP Ouput Truncates String

When using tMSSqlSP component to call SQL Server stored procedure, input from Talend string to a SQL varchar(MAX) works fine. But output from SQL varchar(MAX) to Talend string gets truncated to 4,000 characters. How do I work around this? Is this a bug?
Labels (2)
14 Replies
Anonymous
Not applicable
Author

Hi,
Thanks your response.
I will make a testing on MSSQL server to see if this issue repro and come back to you asap.
Best regards
Sabrina
Anonymous
Not applicable
Author

Hi Sabrina, did you get a chance to test this?
Anonymous
Not applicable
Author

Hi,
Sorry for delay.
I have made a testing on Microsoft SQL Server.
I suspect it is a bug.
Could you please open a jira issue of DI project on Talend Bug tracker. Our component developer will check it.
Best regards
Sabrina
Anonymous
Not applicable
Author

Thanks Sabrina. I've opened an issue: https://jira.talendforge.org/browse/TESB-11968#
Anonymous
Not applicable
Author

Hi,
Thanks your contribution to talend.
Best regards
Sabrina