The resource is already being used in a parent transaction.

Error Message: com.wm.pkg.art.error.DetailedServiceException: [ART.117.4002] Adapter Runtime (Adapter Service): Unable to invoke adapter service ‘StatusXX’.
[ART.117.4011] Adapter Runtime (Adapter Service): Unable to connect to resource ‘SQLDBConnectionLocal’. The resource is already being used in a parent transaction.

Can you share your adapter serivce code snippet (also the JDBC connection type for each adapter service) to check if the start, commit and rollback transaction are handled correctly. For more details refer to Built-In Transaction Management Services

http://techcommunity.softwareag.com/ecosystem/documentation/webmethods/adapters_estandards/Adapters/JDBC/JDBC_10-3/10-3_Adapter_for_JDBC_Install_and_Users_Guide.pdf