Salesforce table listing - SOP 330011 - Error while executing the method 'sfdcTableList' of service nms:extAccount

[Ravi4]

When clicked on "Salesforce CRM Configuration wizard", we see below error in logs:

<faultString xsi:type='xsd:string'> SOP 330011 - Error while executing the method 'sfdcTableList' of service 'nms:extAccount' </faultString><detail xsi:type='xsiLstring'> -60 </detail>.

Did anyone come across this error in the past? Any suggestions for further debug are most welcome. Thanks.

[Jonathon_wodnicki]

Hi,

Does the extAccount's sfdc user have permission to list and read tables?

Thanks,

-Jon

[Ravi4]

Yes. The same user is being used in other environment and is working fine.

[Jonathon_wodnicki]

AFAIK sfdcTableList is after authentication so wouldn't be a connectivity issue. Both Campaign environments are sharing the same sfdc user and environment?

[Ravi4]

Yes, in the logs I can see authentication is successful. Then the above said error is printed. Yes both the environments are sharing same user and sfdc environment.

[Ravi4]

Hi Jon,

[Ravi4]

Hi Jon, Any further advise on troubleshooting this issue?

[Jonathon_wodnicki]

It could be something corrupted with the local sfdc schema library. Try creating a new external account with a different name?

[Ravi4]

Created a new external account and tested for connectivity. No change in the error. Started web server in debug mode and can see soap call for login succeeded. Session Id is obtained from salesforce. Error is thrown while fetching the list of tables from SFDC.

[Ravi4 · Accepted solution]

Hi all,

The issue was found to be with SFDC connection URL. sfdcConnector.js uses URL returned in serverURL property of response to first SOAP call made for login. When verified there was connectivity issue for the host name in serverURL. After working with network team, issue got resolved. Thanks.