Data Generation

• App updated to 22.3
• Now uses OOTB execute stored procedure
• UX enhancements
• New Generators
• Next available primary key
• UUID
• Postgres Support
• Support generating to multiple data sources
• Updated documentation
• Added process to re-sync records after data generation

• Added more comprehensive generator errors
• Run a delete on a table without inserting data
• Fixed mariadb issue with too a table with too many columns
• Fixed re-enabling of constraints after data generation
• Issue with preview not updating

Is the schema correct? If you run the stored procedure directly with those inputs do you get any response?

Hello I've been having issues here where it cannot get the tables any idea on how to fix it? I've also added the two procedure DG_GetTableColumns and DG_GetTable

...

Do you have any suggestion on how to fix the data store issue?

To meet this use case you would order the inserts so that entity occurs first. Then on the store and product generators you select foreign key for the entityId column and point at the Entity pk column.

Those errors don't seem related to properties files issues, they seem to be due to a data store issue.

For your previous issue, when you uncommented the lines you corrupted the properties file. The only lines that should be uncommented in that file are content.<uuid>.VALUE lines like 35 and 43.

Sorry for the late reply. Yes, I've tried importing it without changing anything on the properties file and this is what happens when I inspect it before importing it.

You shouldn't be uncommenting those rows in the properties file. Did you try importing without making changes to the properties file?

Good Afternoon

I tried importing the data generation on the environment

I updated the Data Generation Application Properties file and updated the line 29, 30 and 37,38. First I remove the pound sign and change the colon (:) to equal (=).

Then I imported it like this

after that I inspected it before importing to check if there are any errors since there are no errors, I proceeded to import it.

then when I imported it, the status is failed.

Then when I checked the import log this is the error that are written

Has anyone how to solve this error? Thank you

Good afternoon! 

I have the following data structure, and I am currently having issues getting the data generator to work as I intended..

CREATE TABLE dbo.Entity
(pk_EntityId INT PRIMARY KEY IDENTITY(1,1)
, EntityTypeId INT --1 Store, 2 Product
)
CREATE TABLE dbo.Store
(pk_StoreId INT PRIMARY KEY IDENTITY(1,1) 
, fk_EntityId INT
, StoreName NVARCHAR(50)
)
CREATE TABLE dbo.Product
(pk_ProductId INT PRIMARY KEY IDENTITY(1,1) 
, fk_EntityId INT
, fk_StoreId INT
, ProductName NVARCHAR(50)
)

What I need to do is create random number of stores, which also have random number of products. The thing is, we have an Entity table that we must first create an entity for each store/product, before we can actually create the store/product. I can I make the data generator work so that it can use current identity +n whenever it is creating a new Entity for Store/Product?