KB486245: Marketo Connection Error [MicroStrategy][Marketo] (20) Error while attempting to use REST API: Access denied Unknown Error Code

Symptom

Starting in Strategy ONE Update 12, Strategy ships Marketo ODBC driver instead of the JDBC driver. Any existing Marketo JDBC connection will be converted to a ODBC connection automatically after upgrade. If you re-run a report or republish a cube, you may encounter an error:
[HY000:20: on SQLHANDLE] [Strategy][Marketo] (20) Error while attempting to use REST API: Access denied Unknown Error Code.

Cause

The error is caused by driver behavior changes from Marketo JDBC to ODBC.
The ODBC drivers needs to initialize the Columns for all the Stored Procedures upfront. Marketo ODBC driver has one Stored Procedure called

GetNamedAccountsByName()

which requires access to the endpoint:

v1/namedaccounts/describe.json

to initialize the Columns Metadata for it.
If the Marketo user doesn't have the required access, the ODBC driver will return the access denied error.

Solution

You need to grant the Marketo user the required access:

• Go to Admin > Security > Users & Roles > Roles.
• Edit the Role used for your Marketo user and grant the Read-Only Named Account and Read-Only Named Account List permissions.