Scribe Online Errored Out with Message - SQL Connector: The given key was not present in the dictionary
Article ID: KB0077189
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.
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.
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.
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.
The recommendation is to disable the Debug & Trace level of logging for the Agent.
Additional Information
Feedback
Yes
No
Powered by
