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 an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Create New...