Tablestore:What do I do if the "Don't support allow update operation on table with index and ttl" error message appears when I create a secondary index?

Problem description

The following error message appears when I create a secondary index:

ErrorCode: OTSParameterInvalid, ErrorMessage: Don't support allow update operation on table with index and ttl

Cause

The TTL parameter is set to a value other than -1 but the TableOptions.AllowUpdate parameter is not set to false.

Solution

Select a solution based on your business requirements.

• If you want data in the data table to never expire, you can use the Tablestore console or Tablestore SDKs to set the TTL parameter of the data table to -1.

  • Use the Tablestore console

    Log on to the Tablestore console and go to the Basic Information tab of the data table. Click Modify Attributes. In the dialog box that appears, set Time to Live to -1 and click OK.

  • Use Tablestore SDKs

    Call the UpdateTable operation to set the TableOptions.TimeToLive parameter to -1.

• If you want to set the TTL parameter to a value other than -1, you can use the Tablestore console or Tablestore SDKs to prohibit updates to the data table.

  Important

  After you prohibit updates to a data table, you cannot call the UpdateRow operation to update data in the data table.

  • Use the Tablestore console

    Log on to the Tablestore console and go to the Basic Information tab of the data table. Click Modify Attributes. In the dialog box that appears, set Allow Updates to No, select the check box next to the risk message, and then click OK.

  • Use Tablestore SDKs

    Call the UpdateTable operation to set the TableOptions.AllowUpdate parameter to false.