A call to SSPI failed, see inner exception / The type initializer for 'System.Net.ServicePointManager' / 'System.Net.ComNetOS threw an exception

Toad Data Point & Toad Intelligence Central
1

Hello,

We recently upgraded TDP from 5.0 to 5.1 and we're starting to receive an intermittent error for a couple of our scheduled reoccurring jobs. Any ideas on the cause and possible corrective action? The db utilizes the native MySQL connection. Error details -

The type initializer for 'System.Net.ServicePointManager' threw an exception.

-- 11/11/2019 9:09:11 AM: TOMS PTO Import from MySQL 5.0.log: toms@xxxx.com (TOMS):

The type initializer for 'System.Net.ServicePointManager' threw an exception.
-- 11/11/2019 9:09:11 AM: TOMS PTO Import from MySQL 5.0.log: Start error email

and

Exception Messages:

Import_1 - toms@xxx.com (TOMS):

A call to SSPI failed, see inner exception.

toms@xxxx.com (TOMS):

A call to SSPI failed, see inner exception.

and

Automation script "Dashboard Update Delay 5.0" had errors while executing. The exception messages are listed below and the log file is attached. Change to verbose logging and rerun script for more details.

Continue on Error Exception Messages:

Execute_1 - The type initializer for 'System.Net.ComNetOS' threw an exception.

Exception Messages:

Object reference not set to an instance of an object.

2

Hi,
can you descibe more what you were trying to do? At which point did the errors occur?

3

These are automation activities, which end in error while the schedule TDP job runs. For example, I sometimes receive the following error while importing a flat-file into MySQL table activity - A call to SSPI failed, see inner exception.

Import_1 - A call to SSPI failed, see inner exception. ("Embedded Query" into a new table CEIHRTSS.PTO_HOLIDAYS)

or

Import_1 - [toms@xxxx.com](mailto:toms@xxxx.com) (TOMS):

And sometimes when I excute a SQL query -

Preformatted textExecute_1 - Received an unexpected EOF or 0 bytes from the transport stream.

4

GM - I'm following up on this issue. Add'l information - I'm running Windows Server 2012 r2 & MySQL 5.7.20 db. The top reoccurring/intermittent issue I'm encountering is "The type initializer for 'System.Net.ServicePointManager' threw an exception."

5

I discovered the issue / solution - it was due to the MySQL connection type being set to 'TCP'. Changing type to 'SSL' resolved my issue.