"Cannot add or update child row" error when creating role

[akaHeimdall]

My service is created however, I am now trying to create a role to use the service. I am receiving the error:

Api Error

SQLSTATE[23000]: Integrity constraint violation: 1452 
Cannot add or update a child row: a foreign key constraint fails (`bitnami_dreamfactory`.`role_service_access`, CONSTRAINT 
`role_service_access_service_id_foreign` FOREIGN KEY (`service_id`) 
REFERENCES `service` (`id`) ON DELETE CASCADE) (SQL: insert 
into `role_service_access` (`verb_mask`, `requestor_mask`, `component`, 
`service_id`, `filters`, `filter_op`, `role_id`, `last_modified_date`,
 `created_date`) values (1, 1, _table/*, 11, [], AND, 3, 2020-12-15 12:23:58, 
2020-12-15 12:23:58))

I have no foreign keys specified for the tables in the db I am connecting with.

I’ve reviewed a couple of the other issues, particularly, this one which says that it’s supposed to be fixed as of September, but I cannot seem to figure out why this is happening.

Thanks if anyone can help.

[akaHeimdall]

I couldn’t figure it out. I just created another user and gave it permissions to the appropriate table and it worked. Not sure why it wasn’t working for the other user account.