Scribe Online Errored Out with Message - SQL Connector: The given key was not present in the dictionary
book
Article ID: KB0077189
calendar_today
Updated On:
Products
Versions
TIBCO Cloud Integration - Connect ( Scribe )
-
Description
When calling a stored procedure without passing in all parameters and when the Agent is configured for the debug logging level, a Record Error like the one shown below can be encountered.
Error title: Error in calling Operation Execute Error description: Operation failed. Label: Execute CreateAnalyticsDistributionNew, Name: CreateAnalyticsDistributionNewExecute2, Message: An unexpected error occurred.: Error in calling Operation Execute The following error has occurred in the SQL Connector: The given key was not present in the dictionary.
Resolution
With verbose logging (Debug & Trace enabled) all parameters are expected in stored procedure. In cases where the output is not available yet, resulting in the "given key was not present in dictionary " error.
The recommendation is to disable the Debug & Trace level of logging for the Agent.
Issue/Introduction
Error "Given key was not present in the dictionary" when calling stored procedure without passing in all parameters and when agent has debug logging enabled.