The following information includes common problems that occur with sources.
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.
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.
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.
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.