Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Accepted Solutions
Hi,
I'm the author of the initial post.
I never solved the issue, instead I took a virtual windows server on the net and installed TOS on it.
It worked perfectly fine until today.
Then today, I tried to import some jobs from a customer, and I got the same error again.
Then I tried to add a tSalesforceInput to one of my jobs, save it, close it, reopen it... it worked.
So my guess is there are several versions of the tSalesforceInput component and one of them is either buggy or not compatible with other versions.
Here is what I find in the item file :
{
"@type":"org.talend.components.salesforce.tsalesforceinput.TSalesforceInputProperties",
"__version":2,
"queryMode":{
"@type":"org.talend.daikon.properties.property.EnumProperty",
"flags":null,
"storedValue":{
"@type":"org.talend.components.salesforce.tsalesforceinput.TSalesforceInputProperties$QueryMode",
"name":"Query"
},
"storedDefaultValue":null,
"children":{
"@type":"java.util.ArrayList"
},
"taggedValues":{
"@type":"java.util.HashMap",
"SUPPORT_CONTEXT":false,
"IS_DYNAMIC":false
},
"size":-1,
"occurMinTimes":0,
"occurMaxTimes":0,
"precision":0,
"pattern":null,
"nullable":false,
"possibleValues":{
"@type":"java.util.ArrayList",
"@items":[
{
"@type":"org.talend.components.salesforce.tsalesforceinput.TSalesforceInputProperties$QueryMode",
"name":"Query"
},
{
"@type":"org.talend.components.salesforce.tsalesforceinput.TSalesforceInputProperties$QueryMode",
"name":"Bulk"
},
{
"@type":"org.talend.components.salesforce.tsalesforceinput.TSalesforceInputProperties$QueryMode",
"name":"BulkV2"
}
]
},
"currentType":"org.talend.components.salesforce.tsalesforceinput.TSalesforceInputProperties.QueryMode",
"name":"queryMode",
"tags":null
},...
and here is what I have in the working job :
{
"@type":"org.talend.components.salesforce.tsalesforceinput.TSalesforceInputProperties",
"__version":1,
"queryMode":{
"@type":"org.talend.daikon.properties.property.EnumProperty",
"flags":null,
"storedValue":{
"@type":"org.talend.components.salesforce.tsalesforceinput.TSalesforceInputProperties$QueryMode",
"name":"Query"
},
"storedDefaultValue":null,
"children":{
"@type":"java.util.ArrayList"
},
"taggedValues":{
"@type":"java.util.HashMap",
"SUPPORT_CONTEXT":true,
"IS_DYNAMIC":false,
"REPOSITORY_VALUE":null
},
"size":-1,
"occurMinTimes":0,
"occurMaxTimes":0,
"precision":0,
"pattern":null,
"nullable":false,
"possibleValues":{
"@type":"java.util.ArrayList",
"@items":[
{
"@type":"org.talend.components.salesforce.tsalesforceinput.TSalesforceInputProperties$QueryMode",
"name":"Query"
},
{
"@type":"org.talend.components.salesforce.tsalesforceinput.TSalesforceInputProperties$QueryMode",
"name":"Bulk"
}
]
},
"currentType":"org.talend.components.salesforce.tsalesforceinput.TSalesforceInputProperties.QueryMode",
"name":"queryMode",
"tags":null
},
Let's look at a diff :
I would bet on the 3rd red block, let's try to remove it...
I use git bash cause I'm on windows :
>> sed -i.bak 's/,{[^}]*BulkV2"}//g' myjob.item
Then let's reimport the job with this file instead of the original (I had to close Talend and remove the files from the workspace first because of a lock).
And let's try to reopen the job ... tadaaaaah ! it works !
To be safe I'll also set the version to 1 in the file with
>> sed -i.bak2 's/TSalesforceInputProperties"\,"__version"\:2/TSalesforceInputProperties","__version":1/g' myjob.item...
If that helps anyone to solve definitely the issue without having to hack the xml files, that would be perfect !
Note : for those who prefer to use VSCode for fix the replacements to do are :
TSalesforceInputProperties","__version":2 => TSalesforceInputProperties","__version":1
and
,\{[^}]*BulkV2"\} => empty string
