Content Server Connector Troubleshooting

Issue: Table/View Does Not Exist

The database user does not have access to some of the tables used by LiveLink to retrieve information.

Solution

1. Run the Test Bench with Include Trace enabled.
2. Identify the last SQL query, which was executed before the error was thrown, and the table name for this query.
   1. Use the same database credentials as you used for LiveLink and execute the following SQL query directly against the database:
      

      SELECT * COUNT FROM ALL_OBJECTS WHERE OBJECT_TYPE IN ('TABLE','VIEW') AND OBJECT_NAME IN ('Your Table Name')

If you do not see the query result, the user does not have the necessary permissions to view this table. Ask your database administrator for these permissions.

Issue: Item Content is Not Retrieved

• LAPI/HTTP content retrieving:
  • An incorrect or not fully specified 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) parameters to LiveLink.
• Direct content retrieving:
  • Incorrect or not fully specified "Connector/LiveLink shares."

Solution

• LAPI/HTTP content retrieving:
  • Check the connection parameters directly in a Web browser.
  • You should be able to login to the LiveLink and open the item content.
• Direct content retrieving:
  • LiveLink can store data in a file system.
  • To crawl these items, click Shared Paths Mapping in the field description.

Issue: Type Loads job not run for this connection

When I open the Content page I get an error message: Type Loads job not run for this connection. This is because the Datastore Types Load job Collects the types of data from your source system. Runs on a set schedule. Requires a log level which logs information has not been executed.

Solution

1. Click on the Tasks tab.
   
2. Select the LiveLink Item.
   
3. From the Job Definitions list, select Datastore Types Load Collects the types of data from your source system. Runs on a set schedule. Requires a log level which logs information.
   
4. Click the Start Job button.
   
5. Click Refresh occasionally until the Completed TypeLoad Sync message is no longer displayed.