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 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.