Deploying Service : org.hibernate.engine.jdbc.spi.SqlExceptionHelper: INSERT on table 'PUBLISHED_SERVICE' caused a violation of foreign key constraint 'PUBLISHED_SERVICE_FOLDER' for key

Products

• CA API Gateway

Issue/Introduction

The following error when a Service is being deployed in the Layer 7 API Gateway and am looking for a solution:

2025-09-09T16:28:19.671+0000 ERROR   1      org.hibernate.engine.jdbc.spi.SqlExceptionHelper: INSERT on table 'PUBLISHED_SERVICE' caused a violation of foreign key constraint 'PUBLISHED_SERVICE_FOLDER' for key (ae448c69479473caad95a2b2bab3fd83).  The statement has been rolled back.
2025-09-09T16:28:19.677+0000 WARNING 1      com.l7tech.server.bundling.EntityBundleImporter: Error importing bundle on processing mapping 7 of 7. Mapping: EntityHeader. Name=FolderName, id=ff181207EDITEDb99e2cc5f2d9add7686e, description=FolderName, type = SERVICE
Error attempting to save or update the PublishedService with id = 'ff181207EDITEDb99e2cc5f2d9add7686e'.  Constraint Violation: could not execute statement
2025-09-09T16:28:19.679+0000 INFO    1      com.l7tech.server.bundling.EntityBundleImporter: Error importing bundle (1/1)
2025-09-09T16:28:19.680+0000 WARNING 1      com.l7tech.external.assertions.gatewaymanagement.server.ServerRESTGatewayManagementAssertion: 9050: Error processing management request: <?xml version="1.0" encoding="UTF-8" standalone="yes"?>

Environment

CA API Gateway 11.x

Cause

The bundle used expects the folder where the policy to live in to exist (new or existing) and that the folder payload is not in the bundle or set to ignore or failed to be created

Resolution

Options :

1. Modify the bundle file to use a different folder

or

2. override the folder with manage_mappings