Set error for DMS source endpoint attribute tlogAccessMode

1

Trying to set SQL Server source endpoint attribute: tlogAccessMode="PreferTlog"

Getting: "SYSTEM ERROR MESSAGE:Invalid value provided for MicrosoftSQLServerSettings source field tlogAccessMode"

I get this error for any valid value from the docs: BackupOnly | PreferBackup | PreferTlog | TlogOnly

Also, there's no default value mentioned in the docs.

  • I am having the exact same issue.

    this table shows the default and accepted values: https://docs.aws.amazon.com/dms/latest/userguide/CHAP_Source.SQLServer.html#CHAP_Source.SQLServer.ConnectionAttrib

    running dms describe-endpoint-settings --engine-name sqlserver --output json reveals the options:

    ... { "Name": "TlogAccessMode", "Type": "enum", "EnumValues": [ "BackupOnly", "PreferBackup", "PreferTlog", "TlogOnly" ], "Sensitive": false, "Applicability": "SOURCE_ONLY" }, ...

    None of these values work, via cloudformation template, or through the AWS Console.

    I've been able to set the SafeguardPolicy source endpoint setting, but not TlogAccessMode.

2 Answers
0

Hello there,

I understand that while trying to set SQL Server source endpoint attribute: tlogAccessMode="PreferTlog". You are facing below error.

-- ERROR --
Getting: "SYSTEM ERROR MESSAGE:Invalid value provided for MicrosoftSQLServerSettings source field tlogAccessMode"

As you must be aware, Endpoint settings define additional endpoint-specific connection attributes for AWS DMS. In order to use endpoint settings you need to use the DescribeEndpointSettings IAM permission which grants permission to return the possible endpoint settings available when you create an endpoint for a specific database engine.

Kindly refer the below documentation for the same:- [+] DescribeEndpointSettings:- https://docs.aws.amazon.com/dms/latest/APIReference/API_DescribeEndpointSettings.html

Further, default value of TlogAccessMode is PreferTlog and valid values are BackupOnly, PreferBackup, PreferTlog, TlogOnly

Kindly refer below documentation for the same:- [+] Endpoint settings when using SQL Server as a source for AWS DMS:- https://docs.aws.amazon.com/dms/latest/userguide/CHAP_Source.SQLServer.html#CHAP_Source.SQLServer.ConnectionAttrib

I sincerely hope above information is helpful for you. Have a great rest of your week!

AWS
answered a year ago
0

I opened a support ticket with my company's cloud advisor, and they suggested that TLogAccessMode was only available in AWS DMS versions 3.4.2 and possibly prior (not sure where they found that information). I guess it's not an option anymore in my version of DMS (3.4.7).

answered a year ago

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions