Jitterbit · Database connector (JDBC)

Base64 decoding failed

Short answer

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

VerifiedLast verified

01Error text

Jitterbit error
Base64 decoding failed. Reason: error:00000000:lib(0)::reason(0)

02Likely causes

  • Agent versions earlier than 12.9 may try to Base64-decode a JDBC result that only looks Base64-like, such as a JWT or other access token.

03How to fix it

  1. For private agents, upgrade to version 12.9 or later.
  2. If you cannot upgrade, convert the value to hexadecimal in the SQL query, then decode it in a script step with HexToString.

04Official documentation

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

The iPaaS Brief

Subscribe to The iPaaS Brief.

The iPaaS newsletter for the people who run integrations. From iPaaS Group.

Free. You finish on theipaasbrief.com and confirm by email.