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: 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.