Error Message: The GuidRepresentation for the reader is CSharpLegacy, which requires the binary sub type to be UuidLegacy, not UuidStandard.
Action:
While using the MongoDB Connection Manager, I received the following error message.
Error Message:
'The GuidRepresentation for the reader is CSharpLegacy, which requires the binary sub type to be UuidLegacy, not UuidStandard.'
Solution:
In some MongoDB instances, even if the "Test Connection" indicates that "Test connection succeeded", some operations in the MongoDB Source or MongoDB Destination might fail, due to the default value CSharplegacy for GuidRepresentation. To remedy this error, try specifying In the Advanced tab the option of the MongoDB Connection Manager:
replicaSet=SomeReplicaSetName&uuidRepresentation=Standard
Book a Presales Call
Are you new to COZYROC and evaluating our solutions?
Book a Presales Call with us now and get 5% off SSIS+.
Book a Presales Call with us now and get 5% off SSIS+.
Related Articles
I got an error "The GuidRepresentation for the reader is CSharpLegacy, which requires the binary sub type to be UuidLegacy, not UuidStandard."
In some MongoDB instances, even if the "Test Connection" indicates that "Test connection succeeded", some operations in the MongoDB Source or MongoDB Destination might fail, due to the default value CSharplegacy for GuidRepresentation. To remedy this ...Error Message: An existing connection was forcibly closed by the remote host
Action When making a request to a service connection, the following error message was returned. Error Message Error Message: An existing connection was forcibly closed by the remote host Solution The error message can be somewhat generic across ...Error Message: The underlying connection was closed: An unexpected error occurred on a send. (System.Web.Services)
Action: My Salesforce connections have suddenly started giving errors. Attached is the error message I am recieving on testing the connections . Please note the connections were working fine until yesterday and I am getting same issue for both ...An error occurred with the following error message: "'0000-00-00 00:00:00' default is invalid for column type TYPE_TIMESTAMP".
Action: When executing an SSIS package containing an ODBC Destination, the following error message occurred. Error Message: An error occurred with the following error message: "'0000-00-00 00:00:00' default is invalid for column type TYPE_TIMESTAMP". ...Error Message: Unable to read data from the transport connection: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond.
Action: We migrated our COZYROC connector to a new server. Since then we get a timeout when trying to retrieve a large table and the following error message. Error Message: 'Unable to read data from the transport connection: A connection attempt ...