Jitterbit · Database connector
Database connection could not be established due to a security policy violation
Short answer
This Jitterbit error means agent 12.10 or later blocked a database connection to a loopback address or one that uses a restricted connection string parameter. On the private agent, configure the [JdbcSecurity] section of jitterbit.conf to allow the specific connection or parameter.
VerifiedLast verified
01Error text
The database connection could not be established due to a security policy violation.
JDBC connections to loopback addresses are not permitted.
JDBC connection parameter 'allowmultiqueries' cannot be enabled.02Likely causes
- Agent 12.10 and later restricts connections to localhost or 127.0.0.1, and specific connection string parameters for the MySQL, PostgreSQL, Oracle and SQL Server drivers.
- Upgrading a private agent to 12.10 can break a connection that worked before, because the
[JdbcSecurity]section is not added automatically to an existingjitterbit.conf.
03How to fix it
- On the private agent, configure the
[JdbcSecurity]section ofjitterbit.confto allow the specific connection or parameter. - Restart the agent.
04Official documentation
→Related errors
- Base64 decoding failedThis Jitterbit error in DBLookup or DBExecute means an agent earlier than 12.9 tried to Base64-decode a JDBC result that only looks like Base64, such as a JWT. For private agents, upgrade to version 12.9 or later.
- Field value too long / values were truncatedThis Jitterbit database error means a mapped source value is longer than the target column, and by default the value is rejected. In the activity configuration, enable Allow truncation of character fields.
- Could not initialize class com.microsoft.sqlserver.jdbc.KerbAuthenticationThis Jitterbit error means the Kerberos configuration files on the agent host do not have the correct file permissions. On the private agent host, set permissions to 644 on jaas.conf, krb5.conf and the Kerberos ticket cache file.
Test every fix in a non-production environment before you apply it to production. See how entries are verified.
More for Jitterbit work:Open Jitterbit jobsJitterbit rates and salaries