Troubleshoot common Tablestore Reader issues - Tablestore

This topic describes the errors that may occur when Tablestore Reader is running and how to troubleshoot the errors.

Error message: "Input size of values not equal size of primary key. input size: xx, primary key size: xx"

Problem description

You receive the error message "Input size of values not equal size of primary key. input size: xx, primary key size: xx" when you run a Tablestore Reader job.

com.alibaba.datax.common.exception.DataXException: com.alibaba.datax.plugin.reader.otsreader.OtsReaderError@76f4b65 - IllegalArgumentException[ErrorMessage:Input size of values not equal size of primary key. input size:2, primary key size:1 .] - java.lang.IllegalArgumentException: Input size of values not equal size of primary key. input size:2, primary key size:1 .
	at com.alibaba.datax.plugin.reader.otsreader.utils.ParamChecker.checkInputPrimaryKeyAndGet(ParamChecker.java:119)
	at com.alibaba.datax.plugin.reader.otsreader.utils.ParamChecker.checkRangeAndGet(ParamChecker.java:151)
	at com.alibaba.datax.plugin.reader.otsreader.OtsReaderMasterProxy.init(OtsReaderMasterProxy.java:86)
	at com.alibaba.datax.plugin.reader.otsreader.OtsReader$Job.init(OtsReader.java:34)
	at com.alibaba.datax.core.job.JobContainer.initJobReader(JobContainer.java:1085)
	at com.alibaba.datax.core.job.JobContainer.init(JobContainer.java:497)
	at com.alibaba.datax.core.job.JobContainer.start(JobContainer.java:220)
	at com.alibaba.datax.core.Engine.start(Engine.java:100)
	at com.alibaba.datax.core.Engine.entry(Engine.java:321)
	at com.alibaba.datax.core.Engine.main(Engine.java:354)
	at com.alibaba.datax.common.exception.DataXException.asDataXException(DataXException.java:41)
	at com.alibaba.datax.plugin.reader.otsreader.OtsReader$Job.init(OtsReader.java:47)
	at com.alibaba.datax.core.job.JobContainer.initJobReader(JobContainer.java:1085)
	at com.alibaba.datax.core.job.JobContainer.init(JobContainer.java:497)
	at com.alibaba.datax.core.job.JobContainer.start(JobContainer.java:220)
	at com.alibaba.datax.core.Engine.start(Engine.java:100)
	at com.alibaba.datax.core.Engine.entry(Engine.java:321)

Possible cause

The number of primary key columns that are specified in the Tablestore Reader script is different from that in the Tablestore data table.
Solution

Check the schema of the Tablestore data table, obtain the number of primary key columns in the data table, and then set the obtained value as the number of primary key columns in the Tablestore Reader script.
For example, a Tablestore data table contains two primary key columns and you want to synchronize all data in the table. The following sample code shows how to specify the number of primary key columns in the Tablestore Reader script:
```
"range": {
  "begin": [
    {
      "type": "INF_MIN"
    },
    {
      "type": "INF_MIN"
    }
  ],
  "end": [
    {
      "type": "INF_MAX"
    },
    {
      "type": "INF_MAX"
    }
  ]
}
```

Error message: "Input type of 'range-split' not match partition key. Item of 'range-split' type:xx, Partition type:xx"

Problem description

You receive the error message "Input type of 'range-split' not match partition key. Item of 'range-split' type:xx, Partition type:xx" when you run a Tablestore Reader job.

com.alibaba.datax.common.exception.DataXException: com.alibaba.datax.plugin.reader.otsreader.OtsReaderError@22f31dec - IllegalArgumentException[ErrorMessage:Input type of 'range-split' not match partition key. Item of 'range-split' type:null, Partition type:STRING] - java.lang.IllegalArgumentException: Input type of 'range-split' not match partition key. Item of 'range-split' type:null, Partition type:STRING
	at com.alibaba.datax.plugin.reader.otsreader.utils.ParamChecker.checkInputSplitPoints(ParamChecker.java:231)
	at com.alibaba.datax.plugin.reader.otsreader.OtsReaderMasterProxy.init(OtsReaderMasterProxy.java:92)
	at com.alibaba.datax.plugin.reader.otsreader.OtsReader$Job.init(OtsReader.java:34)
	at com.alibaba.datax.core.job.JobContainer.initJobReader(JobContainer.java:1085)
	at com.alibaba.datax.core.job.JobContainer.init(JobContainer.java:497)
	at com.alibaba.datax.core.job.JobContainer.start(JobContainer.java:220)
	at com.alibaba.datax.core.Engine.start(Engine.java:100)
	at com.alibaba.datax.core.Engine.entry(Engine.java:321)
	at com.alibaba.datax.core.Engine.main(Engine.java:354)
	at com.alibaba.datax.common.exception.DataXException.asDataXException(DataXException.java:41)
	at com.alibaba.datax.plugin.reader.otsreader.OtsReader$Job.init(OtsReader.java:47)
	at com.alibaba.datax.core.job.JobContainer.initJobReader(JobContainer.java:1085)
	at com.alibaba.datax.core.job.JobContainer.init(JobContainer.java:497)
	at com.alibaba.datax.core.job.JobContainer.start(JobContainer.java:220)
	at com.alibaba.datax.core.Engine.start(Engine.java:100)
	at com.alibaba.datax.core.Engine.entry(Engine.java:321)
	at com.alibaba.datax.core.Engine.main(Engine.java:354)

Possible cause
The split point is incorrectly configured in the Tablestore Reader script. The following sample code shows how the split point is incorrectly configured:
```
"split": [
  {
    "type": "INF_MIN"
  },
  {
  "type": "INF_MAX"
  }
]
```
Solution
- Delete the split point configuration from the Tablestore Reader script.
- Configure the split point again. For more information, see Configure split points when I use Tablestore Reader to synchronize full data.

Error message: "Invalid 'column', Can not parse Object to 'OTSColumn', item of list is not a map"

Problem description

You receive the error message "Invalid 'column', Can not parse Object to 'OTSColumn', item of list is not a map" when you run a Tablestore Reader job.

com.alibaba.datax.common.exception.DataXException: com.alibaba.datax.plugin.reader.otsreader.OtsReaderError@64bce832 – IllegalArgumentException[ErrorMessage:Invalid 'column', Can not parse Object to 'OTSColumn', item of list is not a map.] – java.lang.IllegalArgumentException: Invalid 'column', Can not parse Object to 'OTSColumn', item of list is not a map.
        at com.alibaba.datax.plugin.reader.otsreader.utils.ReaderModelParser.parseOTSColumnList(ReaderModelParser.java:104)
        at com.alibaba.datax.plugin.reader.otsreader.OtsReaderMasterProxy.init(OtsReaderMasterProxy.java:80)
        at com.alibaba.datax.plugin.reader.otsreader.OtsReader$Job.init(OtsReader.java:34)
        at com.alibaba.datax.core.job.JobContainer.initJobReader(JobContainer.java:1085)
        at com.alibaba.datax.core.job.JobContainer.init(JobContainer.java:497)
        at com.alibaba.datax.core.job.JobContainer.start(JobContainer.java:220)
        at com.alibaba.datax.core.Engine.start(Engine.java:100)
        at com.alibaba.datax.core.Engine.entry(Engine.java:321)
        at com.alibaba.datax.core.Engine.main(Engine.java:354)
        at com.alibaba.datax.common.exception.DataXException.asDataXException(DataXException.java:41)
        at com.alibaba.datax.plugin.reader.otsreader.OtsReader$Job.init(OtsReader.java:47)
        at com.alibaba.datax.core.job.JobContainer.initJobReader(JobContainer.java:1085)
        at com.alibaba.datax.core.job.JobContainer.init(JobContainer.java:497)
        at com.alibaba.datax.core.job.JobContainer.start(JobContainer.java:220)
        at com.alibaba.datax.core.Engine.start(Engine.java:100)
        at com.alibaba.datax.core.Engine.entry(Engine.java:321)
        at com.alibaba.datax.core.Engine.main(Engine.java:354)

Possible cause
The column parameter is incorrectly specified in the Tablestore Reader script. The following sample code shows how the column parameter is incorrectly specified:
```
"column": [
  "id",
  "name",
  "age"
]
```
Solution
Make sure that the column parameter is correctly specified in the Tablestore Reader script. The following sample code shows how to specify the column parameter:
```
"column": [
  {
    "name": "id"
  },
  {
    "name": "name"
  },
  {
    "name": "age"
  }
]
```