API Actions: RebuildDbReplicaIndexesStatus

API Actions: RebuildDbReplicaIndexesStatus

 

Request Syntax:

XML

POST /api/RebuildDbReplicaIndexesStatus HTTP/1.1
Host: use.your.host.name:82
X-Amz-Content-Sha256: e3b0c44298fc1c149afbf4c8996fb92427ae41e4649b934ca495991b7852b855
Content-Type: application/xml
X-Amz-Date: 20171115T202130Z
Authorization: AWS4-HMAC-SHA256 Credential= UQOPWUVNBALABCABCABC/20171115/us-east-1/cloudbasic/aws4_request, SignedHeaders=content-length;content-type;host;x-amz-content-sha256;x-amz-date, Signature=995374189c189e8e68ed3de82c1764ca11971711fb5179eeab2b19edd883dd74
 
<RebuildDbReplicaIndexesStatusRequest>
	<ReplicationId>998acaec-9211-4dac-b90b-196fd1d17993</ReplicationId>
</RebuildDbReplicaIndexesStatusRequest>

JSON

POST /api/RebuildDbReplicaIndexesStatus HTTP/1.1
Host: use.your.host.name:82
X-Amz-Content-Sha256: e3b0c44298fc1c149afbf4c8996fb92427ae41e4649b934ca495991b7852b855
Content-Type: application/json
X-Amz-Date: 20171115T202130Z
Authorization: AWS4-HMAC-SHA256 Credential= UQOPWUVNBALABCABCABC/20171115/us-east-1/cloudbasic/aws4_request, SignedHeaders=content-length;content-type;host;x-amz-content-sha256;x-amz-date, Signature=995374189c189e8e68ed3de82c1764ca11971711fb5179eeab2b19edd883dd74
 
{
	"replicationId": "998acaec-9211-4dac-b90b-196fd1d17993"
}

 

Request Parameters

Parameter Description Required
ReplicationId The GUID value that uniquely identifies a Replication. Yes
Type: String
Default: None

 

Request Headers

This implementation uses only request headers that are common to all operations. For more information please see the section Common Request Headers

 

Response Syntax:

XML

HTTP/1.1 200
status: 200

<?xml version="1.0" encoding="utf-8"?>
<RebuildDbReplicaIndexesStatusResponse>
	<ReplicationId>998acaec-9211-4dac-b90b-196fd1d17993</ReplicationId>
	<Status>Running</Status>
	<Progress>10%</Progress> 
	<LastRebuildStatus>Success</LastRebuildStatus>
	<LastRebuildStartTime>Friday, February 2, 2018 1:37:31 AM</LastRebuildStartTime>
	<LastRebuildEndTime>Friday, February 2, 2018 5:23:31 AM</LastRebuildEndTime>   
	<Logs>
< ![CDATA[
2/6/2018 12:06:59 PM>>BEGIN
2/6/2018 12:07:00 PM>>Rebuilding indexes initiated for database [Voyager2_rebuildtest]. 47 indexes found.
2/6/2018 12:07:00 PM>>Parallel rebuild index limit:50
2/6/2018 12:07:00 PM>>START executing sql=ALTER INDEX [IDX_AuditEntityForeignKey] ON [dbo].[AuditLogContext] REBUILD;
period elapsed prior to completion of the operation or the server is not responding., elapsed=21 hour(s) and 26 mins 
...
2/8/2018 3:55:33 PM>>Successfully rebuild indexes for database [Voyager2_rebuildtest], Total time:21 hour(s) and 33 mins 
2/8/2018 3:55:36 PM>>END

]]>
	</Logs>	
</RebuildDbReplicaIndexesStatusResponse>

JSON

HTTP/1.1 200
status: 200

{
	"replicationId": "998acaec-9211-4dac-b90b-196fd1d17993",
	"status": "Running",
	"progress": "10%",
	"lastRebuildStatus": "Success",
	"lastRebuildStartTime": "Friday, February 2, 2018 1:37:31 AM",
	"lastRebuildEndTime": "Friday, February 2, 2018 5:23:31 AM",
	"logs": ""
}

 

Response Parameters

Parameter Description Optional
ReplicationId The requested GUID value that uniquely identifies a Replication. No
Status Possible values include:

  • Running
  • Success
  • Failed

No
Progress The progress, in percents, of the Replication. When the Status is Success, this parameter will return 100. Yes
LastRebuildStatus Possible values include:

  • Running
  • Success
  • Failed

No
LastRebuildStartTime Contains the last date and time the rebuilding of indexes was started. Yes
LastRebuildEndTime Contains the last date and time the rebuilding of indexes was completed. Yes
Logs Detailed progress logs of the RebuildDbReplicaIndexes process. Yes

 

Error Response Syntax:

XML

HTTP/1.1 400
status: 400

<?xml version="1.0" encoding="utf-8"?>
<ErrorResponse>
	<RequestId>request-id</RequestId>
	<Errors>
		<Error> <Message>Error message 1</Message> </Error>
		<Error> <Message>Error message 2</Message> </Error>
	</Errors>
</ErrorResponse>

JSON

HTTP/1.1 400
status: 400

{
	"errors": [
        "{ReplicationId}:Invalid value for ReplicationId"
	],
	"requestId": 21
}