JDBC Import fails in Initiating the connection - Support and Troubleshooting

JDBC Import fails in Initiating the connection Description  Symptoms JDBC Import fails with below Error:

MID Server reported error: Failed to init the JDBC connection. Check configuration

Release All versions

Environment Set up a JDBC Data Source via MID Server with or without specific Application scope which has Application Administration as Active.

Cause Configuration issue of scope where it has Application Administration set to true on the sys_scope record and the ACL issue sys_data_source table.

Resolution Deactivate 'Application administration' on the sys_scope record.

OR

If 'Application administration' is required to be Active. We will need to ensure that the READ ACLs against the 'sys_data_source' table has the role defined - 'x_ .user' i.e. whatever is configured on the Application details so that the mid server user can access the sys_data_source table.

Additional Information Ref Doc: Access control rules in application administration apps

Check system property: glide.security.scoped_administration.honor_global_acl If no scoped ACL rules are defined, application administration apps can inherit global ACL rules. By default, this property is enabled for new and upgraded instances.