Salesforce Connector Troubleshooting

Problem

When I click on the link Load Available in the Repository tab, I do not see a CustomSOQL repository.

Solution

An invalid SOQL Query (or empty) was entered on the Connection Connection defines the how Connectivity Hub connects to your Source System (which contains your documents, graphics, etc.,). Your Connection includes identifying elements such as: URL of the BA Insight web service connector you are using, (File Share connector, SharePoint Online connector, etc.), Authentication mode, User Accounts and Credentials, Database information (for database connectors) page.

  1. Go to the Connection Info tab.
  2. Select Custom SOQL Query and update with valid data.
  3. Click the Repository tab.
  4. Click Load Available.

Problem

When I click the link Connect or Refresh Web Service, I get error "HTTP Error 500.19 - Internal Server Error."

Solution

Invalid web.config file.

  1. Go to the folder C:\Program Files (x86)\BA Insight\BA Insight Force.com API\WebService.
  2. Open the web.config file in an editor.

  3. Delete the following code:

    Copy 
    <section name="scriptResourceHandler" 
    type="System.Web.Configuration.ScriptingScriptResourceHandlerSection, 
    System.Web.Extensions, Version=3.5.0.0, Culture=neutral, 
    PublicKeyToken=31BF3856AD364E35" requirePermission="false" 
    allowDefinition="MachineToApplication"/><sectionGroup
     name="webServices" 
    type="System.Web.Configuration.ScriptingWebServicesSectionGroup, 
    System.Web.Extensions, Version=3.5.0.0, Culture=neutral, 
    PublicKeyToken=31BF3856AD364E35"><section
     name="jsonSerialization" 
    type="System.Web.Configuration.ScriptingJsonSerializationSection, 
    System.Web.Extensions, Version=3.5.0.0, Culture=neutral, 
    PublicKeyToken=31BF3856AD364E35" requirePermission="false" 
    allowDefinition="Everywhere"/><section
     name="profileService" 
    type="System.Web.Configuration.ScriptingProfileServiceSection, 
    System.Web.Extensions, Version=3.5.0.0, Culture=neutral, 
    PublicKeyToken=31BF3856AD364E35" requirePermission="false" 
    allowDefinition="MachineToApplication"/><section
     name="authenticationService" 
    type="System.Web.Configuration.ScriptingAuthenticationServiceSection, 
    System.Web.Extensions, Version=3.5.0.0, Culture=neutral, 
    PublicKeyToken=31BF3856AD364E35" requirePermission="false" 
    allowDefinition="MachineToApplication"/><section
     name="roleService" 
    type="System.Web.Configuration.ScriptingRoleServiceSection, 
    System.Web.Extensions, Version=3.5.0.0, Culture=neutral, 
    PublicKeyToken=31BF3856AD364E35" requirePermission="false" 
    allowDefinition="MachineToApplication"/>
  4. Go to the Connection Info tab.
  5. Click Connect or Refresh Web Service.

Problem

  • When I click on the Load Available in the Repository tab, I get an Invalid login message.

  • The error is similar to the following:
    GetAvailableDatastores error:INVALID_LOGIN: Invalid username, password, security token; or user locked out.

Solution

An invalid login or password was entered on the Connection page.

  1. Go to the Connection Info tab.
  2. Select SalesForce login\password and update with valid data.
  3. Click the Repository tab.
  4. Click Load Available.