0016-00000836

Problem description

The Range tag is set in the XML request body of a SelectObject request, but the Select Meta of the object file does not match the metadata specified in the request.

Causes

You sent a SelectObject request and set a query range for the file content using the <Range> tag in the XML request body. However, the Select Meta of the object file does not match the parameters in your request. For example, the RecordDelimiter or QuoteCharacter values do not match.

Examples

For example, you can create a Select Meta by sending a CreateSelectObjectMeta request.

POST  /samplecsv?x-oss-process=csv/meta
Date: Fri, 25 May 2018 22:11:39 GMT
Authorization: OSS qn6q**************:77Dv****************
Host: host name
<CsvMetaRequest>
    <InputSerialization>
        <CompressionType>None</CompressionType>
        <CSV>
            <RecordDelimiter>LA==</RecordDelimiter>
            <FieldDelimiter>Cg==</FieldDelimiter>
            <QuoteCharacter>Ig==</QuoteCharacter>
        </CSV>
    </InputSerialization>
    <OverwriteIfExists>true</OverwriteIfExists>
</CsvMetaRequest>

Then, you can send the following SelectObject query request.

POST /oss-select/bigcsv_normal.csv?x-oss-process=csv%2Fselect HTTP/1.1
Date: Fri, 25 May 2018 22:11:39 GMT
Authorization: OSS qn6q**************:77Dv****************
Host: host name
<?xml version="1.0"?>
<SelectRequest>
    <Expression>c2VsZWN0IGNvdW50KCopIGZyb20gb3Nzb2JqZWN0IHdoZXJlIF80ID4gNDU=
    </Expression>
    <InputSerialization>
        <CSV>
        		<Range>line-range=10-20</Range>
            <FileHeaderInfo>Ignore</FileHeaderInfo>
            <RecordDelimiter>Cg==</RecordDelimiter>
            <FieldDelimiter>LA==</FieldDelimiter>
            <QuoteCharacter>Ig==</QuoteCharacter>
        </CSV>
    </InputSerialization>
    <OutputSerialization>
        ......
    </OutputSerialization>
</SelectRequest>

The RecordDelimiter and FieldDelimiter specified in the SelectObject request do not match the parameters specified in the CreateSelectObjectMeta request. This causes the request to fail.

Solutions

• To specify a query range for the file, you can provide the Range node in the XML. When you use the Range parameter to query a file, you must include the Select Meta. The query request parameters must be the same as the corresponding parameters in the Select Meta. For more information, see CreateSelectObjectMeta.

• You can adjust the XML request body based on the values of the Select Meta parameters in the ErrorMessage.

References

• Query files

• RestoreObject