Troubleshooting

"No foreign keys found"

• Your source database lacks foreign key constraints
• Solution: Define manual relationships in advanced configuration, or work with your DBA to add foreign keys

"Target database schema doesn't match source"

• The target database has a different schema than the source
• Solution: Ensure the target database has the same table structure as the source (see Create an empty target database)

Subset is larger/smaller than expected

• Desired size subsetting uses statistical sampling
• Solution: Adjust the desired size percentage or use starting tables for more precise control

Filter clause errors

• Invalid SQL syntax in your filter clause
• Solution: Review the filter clause syntax and test it directly against your database

For more detailed troubleshooting, see:

• Subsetting troubleshooting guide
• Subsetting validation errors

Related resources

→ Subsetting troubleshooting guide

→ Subsetting validation errors

← Back to Subsetting treatments overview