Scribe Online Errored Out with Message - SQL Connector: The given key was not present in the dictionary

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.

User-added image

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.

Additional Information

SCMSSQL-3