Troubleshooting
This section contains solutions to errors that you might encounter when you create an intelligent structure.
- Error: You can only include output fields from one hierarchy level.
- If the input data contains a table-like structure with rows of data, Intelligent Structure Discovery creates a group element with child elements to represent the table in the model. For example, the input data might contain seven rows of data, and each row contains a name, address, and country. Intelligent Structure Discovery creates a person group element with elements named name, address, and country.
- If you have multiple groups of data in the input, Intelligent Structure Discovery creates group elements with child elements for each grouping in the input. For example, the input data contains three rows of data, and each row contains a name, address, and country. The input data also contains six rows of data, and each row contains a name and telephone number. The model contains a person1 group element with elements named name, address, and country. The model also contains a person2 group element with elements named name and telephone.
- Although the model can contain more than one group, you cannot map the output fields for more than one group element. If the model has more than one group element, select one and exclude the others from the model so that you can use it in a mapping.
- Error: The intelligent structure had more than one output field with the same name. Provide a unique name to each output field.
- You can only map output fields with unique names to the target transformation. If the model contains more than one element with the same name, even if they are at different levels of the model hierarchy, you must rename the elements with unique names. For example, the input data might contain rows of data, and each row contains multiple dates. Intelligent Structure Discovery creates elements named name, date, date, date, and country. You can rename the fields with the same name to be date1, date2, and date3 to ensure that the output fields have unique names.
This section contains a solution to errors that you might encounter when you try to run a mapping in which you run a Structure Parser.
Mapping Validation Error: Field [Data] cannot be mapped to Field [Data]
To correct this error, select the Structure Parser transformation Field Mapping tab and verify that Field mapping options is set to automatic. Then select the Structure Parser tab to ensure the setting is updated; there is no need for further changes on this tab.
Runtime Error: java.lang.ClassCastException: [B cannot be cast to java.lang.String]
To correct this error, select the Structure Parser transformation Structure Parser tab to ensure the setting is updated; there is no need for further changes on this tab.
Mapping Validation Error: Field [Data] cannot be mapped to Field [Data]
To correct this error, select the Structure Parser transformation Field Mapping tab and verify that Field mapping options is set to automatic.
Unable to Run Mapping with Structure Parser and Complex File Connector
Before you run a mapping with a Complex File Connector as the source transformation to the Structure Parser, verify that you defined the Field Mapping fields. The Complex File Connector output fields and the Structure Parser incoming fields have the same names so you can select to automatically map the fields. For configuration information, see
Processing Input from a Complex File Connecter.
Unable to Run Mapping with Structure Parser and Complex File Connector
Before you run a mapping with a Complex File Connector as the source transformation to the Structure Parser, verify that you defined the Field Mapping fields. The Complex File Connector output fields and the Structure Parser incoming fields have the same names so you can select to automatically map the fields. For configuration information, see
Processing Input from a Complex File Connecter.
Unable to Run Mapping with Structure Parser and Flat File Source
Before you run a mapping with a Flat File as the source transformation to the Structure Parser, verify that the source transformation uses a reference file that contains a list of paths to the files you want the Structure parser to process. When you configure the source transformation, do not select the file itself that you want to process.
Ensure that the source transformation has one output field. Ensure that the Structure Parser accesses the source transformation one output field in the Field Mapping tab.