https://community.qlik.com/t5/Talend-Studio/Salesforce-tSalesforceInput-not-able-to-get-some-fields-in-TOS-6/m-p/2277611#M53328 Hello, <BR />I'm doing an upgrade of my TOS jobs that are connecting to SFDC (since SFDC will not allow connection using TLS 1.0 from March 2017). I think that I have identify a regression on that tSalesforceInput component. <BR />I migrated my whole project from TOS 5.6.2 to TOS 6.3.0 and ran them, just to make sure everything is fine. <BR />All of them are running fine exepting 2 that are querying <B>Task</B>&nbsp;and <B>LiveAgentSession</B>&nbsp;objects. When the job is reaching the tSalesforceInput component, it crashes and throw that error message:&nbsp; <BR /> <PRE>stateMessage='InvalidBatch : Failed to process query: INVALID_FIELD: &nbsp;NumFlagLoweredAgent^ ERROR at Row:1:Column:175 No such column 'NumFlagLoweredAgent' on entity 'LiveAgentSession'</PRE> <BR />So far, I have identified that it is occuring for the following fields: <BR />&gt;&nbsp; <I>NumFlagLoweredAgent</I>&nbsp;on&nbsp; <I>LiveAgentSession</I>&nbsp;object <BR />&gt; <I>TaskSubType&nbsp;</I>on <I>Task&nbsp;</I>object <BR />That error message is usually thrown when you try to query a new standard field and you are not running on the last API version. This not the case here since I am running on API 37.0. I evidently checked the field level security on this field in SFDC, and I can see the fields. I also run the very same query both in Workbench and Force.CLI, using the bulk mode, I am able to get a file. <BR />Another proof that leads to me to a regression, is that the very same job, works fine on TOS 5.6.2 while it crashes on TOS 6.3.0.&nbsp; <BR />Here is a set of screenshot to illustrate the following. <BR />Working tSalesforceInput - TOS 5.6.2 <BR /> <span class="lia-inline-image-display-wrapper" image-alt="0683p000009MD4l.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/138191i0194B7BB290EC5AA/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009MD4l.png" alt="0683p000009MD4l.png" /></span> <BR />Crashing tSalesforceInput - TOS 6.3.0 and 6.2.1 <BR /> <span class="lia-inline-image-display-wrapper" image-alt="0683p000009MD4q.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/131745i0ACB1901D108701C/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009MD4q.png" alt="0683p000009MD4q.png" /></span> <BR />Am I the only one to face that issue? <BR />Does anyone already patched that? <BR />Thanks, <BR />Michel Sat, 16 Nov 2024 10:07:55 GMT Anonymous 2024-11-16T10:07:55Z https://community.qlik.com/t5/Talend-Studio/Salesforce-tSalesforceInput-not-able-to-get-some-fields-in-TOS-6/m-p/2277611#M53328 Hello, <BR />I'm doing an upgrade of my TOS jobs that are connecting to SFDC (since SFDC will not allow connection using TLS 1.0 from March 2017). I think that I have identify a regression on that tSalesforceInput component. <BR />I migrated my whole project from TOS 5.6.2 to TOS 6.3.0 and ran them, just to make sure everything is fine. <BR />All of them are running fine exepting 2 that are querying <B>Task</B>&nbsp;and <B>LiveAgentSession</B>&nbsp;objects. When the job is reaching the tSalesforceInput component, it crashes and throw that error message:&nbsp; <BR /> <PRE>stateMessage='InvalidBatch : Failed to process query: INVALID_FIELD: &nbsp;NumFlagLoweredAgent^ ERROR at Row:1:Column:175 No such column 'NumFlagLoweredAgent' on entity 'LiveAgentSession'</PRE> <BR />So far, I have identified that it is occuring for the following fields: <BR />&gt;&nbsp; <I>NumFlagLoweredAgent</I>&nbsp;on&nbsp; <I>LiveAgentSession</I>&nbsp;object <BR />&gt; <I>TaskSubType&nbsp;</I>on <I>Task&nbsp;</I>object <BR />That error message is usually thrown when you try to query a new standard field and you are not running on the last API version. This not the case here since I am running on API 37.0. I evidently checked the field level security on this field in SFDC, and I can see the fields. I also run the very same query both in Workbench and Force.CLI, using the bulk mode, I am able to get a file. <BR />Another proof that leads to me to a regression, is that the very same job, works fine on TOS 5.6.2 while it crashes on TOS 6.3.0.&nbsp; <BR />Here is a set of screenshot to illustrate the following. <BR />Working tSalesforceInput - TOS 5.6.2 <BR /> <span class="lia-inline-image-display-wrapper" image-alt="0683p000009MD4l.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/138191i0194B7BB290EC5AA/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009MD4l.png" alt="0683p000009MD4l.png" /></span> <BR />Crashing tSalesforceInput - TOS 6.3.0 and 6.2.1 <BR /> <span class="lia-inline-image-display-wrapper" image-alt="0683p000009MD4q.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/131745i0ACB1901D108701C/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009MD4q.png" alt="0683p000009MD4q.png" /></span> <BR />Am I the only one to face that issue? <BR />Does anyone already patched that? <BR />Thanks, <BR />Michel Sat, 16 Nov 2024 10:07:55 GMT https://community.qlik.com/t5/Talend-Studio/Salesforce-tSalesforceInput-not-able-to-get-some-fields-in-TOS-6/m-p/2277611#M53328 Anonymous 2024-11-16T10:07:55Z https://community.qlik.com/t5/Talend-Studio/Salesforce-tSalesforceInput-not-able-to-get-some-fields-in-TOS-6/m-p/2277612#M53329 Hello, <BR />Here a quick update, I have identified that following fields on&nbsp; <I>LiveAgentSession </I>object are not accessible through the tSalesforceInput: <BR /> <BR />NumFlagLoweredAgent <BR />NumFlagLoweredSupervisor <BR />NumFlagRaised <BR /> <BR />In order to not freeze the upgrade I'm performing now, I will just blank these fields. <BR />Michel Tue, 24 Jan 2017 13:44:25 GMT https://community.qlik.com/t5/Talend-Studio/Salesforce-tSalesforceInput-not-able-to-get-some-fields-in-TOS-6/m-p/2277612#M53329 Anonymous 2017-01-24T13:44:25Z