Database Load Generation

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?

• Security Updates

• Security Updates

Hi Michael, I am on the latest version (1.2.1) and the issue above is still happening for me. Changing the deleteSettings value in the DG_TABLE table with the text "null" rather than null value is solving the issue for me.