Skip to main content

Data Profiling–Troubleshooting

Failed or < 100% Success

Data Profiling executes multiple queries on the database to calculate metrics, gather values, etc.

Image title

Some of the queries might occasionally fail or timeout. Prior to Dataedo 10.2, when one of the queries failed, the whole column or table profiling failed. Starting from Dataedo 10.2, in such cases, instead of the FAILED or 100% indicator, you will see x% SUCCESS where x is the calculated percentage of finished queries.

You can try to rerun profiling.

Error Log

To find out which queries fail, run Dataedo with the /errorlog option.

Image title

You can change the shortcut to Dataedo and add a parameter in the "Target" input.

Image title

Alternatively, you can run Dataedo from the command line, adding the parameter. By default, the log file will be located in your documents, but you can change that with the elp parameter.

Known Problems

Minimum Date

File repository does not support the datetime2 type, so the minimum date is the year 1753. The problem has been fixed in Server Repository with version 10.2.