TIBCO Scribe® Online SQL Connector Timeout

TIBCO Scribe® Online SQL Connector Timeout

book

Article ID: KB0078833

calendar_today

Updated On:

Products Versions
TIBCO Cloud Integration - Connect ( Scribe ) 1.0.0.58114

Description

If you have a Microsoft SQL database with a large number of tables and stored procedures, you may get timeouts when refreshing metadata or executing a Solution. To prevent timeouts, use the Additional Parameters and Object Filters fields on the TIBCO Scribe® Online Connection dialog for the Microsoft SQL Server Connection. 


kA3320000004Rj5CAE_en_US_1_0

To modify your Microsoft SQL Connection:
  1. Log into TIBCO Scribe® Online.
  2. Select More > Connections.
  3. Select your Microsoft SQL connection to open it.
  4. In the Additional Parameters field, limit the data accessed by disabling anything that is unnecessary, such as Stored Procedures.The following parameters are supported:
    • AllowSprocs — Show or hide stored procedures, default is false.
    • AllowTables — Show or hide tables, default is true.
    • AllowViews — Show or hide views, default is true.
    • QueryTimeout — Controls the timeout value for a query of the source data, default is 600.
    • TargetTimeout — Controls the timeout value for update, insert, or delete operations on the target data, default is 30.
  5. In the Object Filter field, create filters to select specific objects from the database. For example, Tables=CUST* loads all tables that start with CUST.
  6. Select Test to make sure the Agent can still communicate with the SQL database.
  7. Select OK.
  8. On the Connections page, select the Reset Metadata option from the Gear menu for your Microsoft SQL Connection.
Refer to the TIBCO Scribe Online Connector For Microsoft SQL Server help for additional details on Connection parameters.

 

Issue/Introduction

Timeouts when refreshing metadata or executing a Solution.
Powered by Wolken Software