Introducing the all-new TIBCO Community site!

For current users, please click "Sign In" to reset your password and access the enhanced features. If you're a first-time visitor, we extend a warm welcome—click "Sign Up" to become a part of the TIBCO Community!

If you're seeking alternative community sites, explore ibi, Jaspersoft, and Spotfire.

Jump to content

SQL connector Execute block error


Erica Weldon

Recommended Posts

Hi all,

Using Tibco Scribe OnlineIntegrations with a SQL Connector. We have an Execute block in Scribe that calls a stored procedure that is producing the error "a trigger returned a result set and/or was running with set nocount off". There are triggers in the database that have the text "set nocount off" but thistext is always the last line of the trigger. The stored procedure called by the Execute block has the text "set nocount on" as the first line of the stored procedure. When the stored procedure is run in SQL there are no errors. Has anyone else received this error

Link to comment
Share on other sites

This was fixed (mostly) by turning offDebug & Trace logging for the Agent as advised here:https://support.tibco.com/s/article/The-given-key-was-not-present-in-the-dictionary. Sometimes this error still occurs with no obvious reason. Retrying record will succeed sometimes and fail other times. Will update if another solution is provided by support.
Link to comment
Share on other sites

×
×
  • Create New...