Source problems

The following information includes common problems that occur with sources.

Missing data for field value

Situation    I do not see a value for a certain field in the Data Viewer when I preview the source. When I run an integration, I sometimes get errors about null values.

Solution   It is possible that null or empty values for fields exist in the source. If this is the case, the application is behaving as it should.

If you are certain that the source does not contain null values, the field may have an incorrect data type defined for it. If an incorrect data type is set for a field, the value of the field will appear to be null. For information about setting data types for columns, refer to Data types.

If the data type is correct, then data for the source field might not be valid. Date fields must be in a proper date format and numeric values must not exceed the range allowed by the specific data type. For more information about proper date formats and numeric ranges, refer to Data types.

ODBC errors

Situation    When I preview a source query or run an integration, I receive ODBC errors.

Solution    Try previewing the individual source queries to determine which query is causing the error. If all source queries generate errors, be sure that the DSN used by the source query is set up correctly in the ODBC control panel. For other ODBC problems, refer to your ODBC driver documentation.

Missing or extra rows

Situation    When I preview a source query, it returns more rows than it should, or it doesn’t return enough rows.

Solution   Check the row restrictions for the source query in the Properties window for the source. If the row restriction is not set up properly, it may be too restrictive and doesn’t return enough rows, or it may not be restrictive enough and returns too many rows.

If you are using multiple source queries for the integration, be sure the relationships between the sources are set up correctly. If the relationship type is wrong, the child source query could return an incorrect number of rows.

Be sure there aren’t any blank rows in the source files. Blank rows typically appear at the bottom when you preview the source.

Missing or extra fields

Situation    When I preview my source, a field is missing, or my source has more fields than I need.

Solution    This usually happens when the Show property for the field is incorrect. In the Source Query Properties window, choose the Columns tab and verify that the Show property is set. If you don’t want to display the field in the Data Viewer, or use the field in the Destination Mapping, then clear the Show check box. Otherwise, be sure it’s selected.

If you are missing fields, that may be a result of the grouping set for the source query. When a grouping is set for a source query, the source returns only the columns that are a part of the grouping.

Documentation Feedback