Return
-
Title
FindPartitionSchemeRows Error: 1480 ORA-01480: trailing null missing from STR bind value. -
Description
The following errors are seen when activating a config in horizontal partitioned environment:
Error 2015-06-22 14:21:16.289130 51778 1 Compile of "EDW_CSI_20150622.cfg" for sid o.EEDWHPR1 failed: FindPartitionSchemeRows Error: 1480 ORA-01480: trailing null missing from STR bind value.
-
Cause
A subquery with IN is used in column condition.
-
Resolution
In column condition a subquery with IN is used, something like:
employee_id in (select employee_id from owner.table_name)
Subqueries or SELECT statements are not allowed as column conditions. Substitute it with a column condition that conforms to Shareplex guidelines.
Please refer to Shareplex Administrator Guide for details on specifying column conditions.