The following issues prevent a data generation or subsetting job.
The following errors occur when you attempt to generate a subset. They do not apply if Use subsetting is turned off.
When upsert is enabled, the following issues cause the upsert job to fail.
Issue | Description | How to resolve |
---|---|---|
Issue | Description | How to resolve |
---|---|---|
Issue | Description | How to resolve |
---|---|---|
Issue | Description | How to resolve |
---|---|---|
Issue | Description | How to resolve |
---|---|---|
Issue | Description | How to resolve |
---|---|---|
Structural license expired
The current Structural license is expired.
No workspace configured
The Structural instance does not have any workspaces to generate data from.
Insufficient workspace permissions
You do not have permission to run data generation on this workspace.
Unable to connect to the source database
The source database connection is either missing or incomplete.
Edit the workspace configuration to complete the source database connection. Make sure to test the connection.
Unable to connect to the destination database
The destination database connection is either missing or incomplete.
Edit the workspace configuration to complete the destination database connection. Make sure to test the connection.
Evaluation - The source database size exceeds the maximum allowed
During a Structural evaluation, the source database size is larger than the configured maximum for that evaluation.
Reduce the size of the source database.
Scale mode - Invalid generators
A table that uses Scale mode has columns with assigned generators that are not valid for Scale mode.
Change the selected generator for the columns.
Scale mode - Passthrough generator or sub-generator for the Conditional generator
A table that uses Scale mode has columns that use the Conditional generator, and that are assigned Passthrough as a generator or sub-generator.
Change the selected generator, sub-generator, or default generator.
Preserve Destination - cannot resolve foreign key references
A table that uses Preserve Destination mode is referenced from another table.
Truncate - cannot resolve foreign key references
A table that uses Truncate mode is referenced from another table.
Cross Table Sum - incomplete generation
A column is assigned the Cross Table Sum generator, but some required configuration field values are missing.
Incremental mode - circular foreign key dependency
There is a circular foreign key dependency between tables that use Incremental mode.
AI Synthesizer configured when it is disabled
A table is configured to use the AI Synthesizer, but the AI Synthesizer is not enabled.
Set the environment setting TONIC_NN_GENERATOR_ENABLED
to true
.
OR
Remove the AI Synthesizer from the generator configuration.
Unresolved schema changes
There are detected schema changes that are not resolved.
No target tables configured
The subsetting configuration does not include any target tables.
Invalid target table configuration
A target table has an invalid percentage value or WHERE
clause.
In-subset table uses Scale mode
A table that is in the subset uses Scale table mode.
In-subset table uses Truncate mode.
A table that is in the subset uses Truncate table mode.
In-subset table uses Preserve Destination mode.
A table that is in the subset uses Preserve Destination table mode.
In-subset table uses Incremental mode.
A table that is in the subset uses Incremental table mode.
Destination database not populated
The destination database is empty.
Update the workspace to disable upsert, then run a regular data generation job to populate the destination database. You can then re-enable upsert.
Invalid table mode
A table is assigned a mode other than De-Identify or Truncate.
Change the table mode to De-Identify or Truncate.
Unable to connect to the intermediate database
The intermediate database connection is either missing or incomplete.
Edit the workspace configuration to complete the intermediate database connection.
Unresolved schema conflicts
There are schema conflicts between the source and destination databases.
Update the source or destination database schema to resolve the changes.